10-06-2023, 06:08 AM
I am a new user and very impressed by the program. But in my experimenting I created a problem that I am unable to solve.
My question summarized: Can I delete a specific song from the database, in case deleting it from the Songs listing does not get rid of it?
The situation is: I have MobileSheets running on both iPad and Mac mini M2. I use the sync feature between them with Dropbox.
I have created a set of over 100 songs so far. I added audio files to almost all of them. I also created annotations on all of the image files. These annotations I did on the iPad, the other work on the Mac, always taking care to sync back and forth. So far so good.
For one of the files I wanted to repeat some pages, to account for some repeats. I tried to add this as an extra song to the program, and edit that version, also keeping the original.
There something must have gone wrong - after synching I got multiple copies of the song, plus the extended version. Uninstalling and reinstalling the program did not help, not on the iPad and not on the Mac. I deleted the songs in the Songs listing. I also deleted the folder ~/Library/Containers/MobileSheet, and that made the program start empty again. I also removed the offending songs (i.e., their folders) from Dropbox. But after sync theses songs reappeared, but they were not working (error messages that the pdf's could not be found), and the mp3's would not play.
I think the problem is that I accidentally broke the connection between the database and the song folders.
My question is not what I did wrong, which cannot be answered I think, but how to fix the database to get rid of the problem songs. Of course I could remove the Dropbox files and recreate all the songs from their pdf and mp3 files, but that would be a lot of work in itself, and worse, I would lose all my annotations.
My question boils down to: Is there a way to delete all information about a specific song from the database, so that I can sync all other songs to their original state without introducing ghost songs with errors? Thanks a lot!
My question summarized: Can I delete a specific song from the database, in case deleting it from the Songs listing does not get rid of it?
The situation is: I have MobileSheets running on both iPad and Mac mini M2. I use the sync feature between them with Dropbox.
I have created a set of over 100 songs so far. I added audio files to almost all of them. I also created annotations on all of the image files. These annotations I did on the iPad, the other work on the Mac, always taking care to sync back and forth. So far so good.
For one of the files I wanted to repeat some pages, to account for some repeats. I tried to add this as an extra song to the program, and edit that version, also keeping the original.
There something must have gone wrong - after synching I got multiple copies of the song, plus the extended version. Uninstalling and reinstalling the program did not help, not on the iPad and not on the Mac. I deleted the songs in the Songs listing. I also deleted the folder ~/Library/Containers/MobileSheet, and that made the program start empty again. I also removed the offending songs (i.e., their folders) from Dropbox. But after sync theses songs reappeared, but they were not working (error messages that the pdf's could not be found), and the mp3's would not play.
I think the problem is that I accidentally broke the connection between the database and the song folders.
My question is not what I did wrong, which cannot be answered I think, but how to fix the database to get rid of the problem songs. Of course I could remove the Dropbox files and recreate all the songs from their pdf and mp3 files, but that would be a lot of work in itself, and worse, I would lose all my annotations.
My question boils down to: Is there a way to delete all information about a specific song from the database, so that I can sync all other songs to their original state without introducing ghost songs with errors? Thanks a lot!