11-25-2012, 11:06 PM
Hi, this is either a new feature request, or a "tell me how to do it".
I use MobileSheets primarily for church choir, and have over 500 songs entered. When I added these songs, I chose the "Choral" genre, since that was the closest match, but now there is a "Worship" genre available. Is there a way to mass-change the genre of a bunch of existing songs to a new genre? Or to make other bulk changes? I've hunted around in the PC Companion program and don't see a way there.
As a side note: I was looking at the backup file created by the program, and I noticed that it has a SQL Lite segment. Perhaps it's possible for an "enterprising person" to do their own SQL updates to a copy of a backup file and then do a restore? (I am guessing that this is essentially what the PC Companion does). I understand that this sort of thing is fraught with peril and the author might not want people mucking around in the database and then complain when something breaks... but I would be willing to take the risk (especially since I make frequent backups).
Thanks in advance for any help/suggestions.
I use MobileSheets primarily for church choir, and have over 500 songs entered. When I added these songs, I chose the "Choral" genre, since that was the closest match, but now there is a "Worship" genre available. Is there a way to mass-change the genre of a bunch of existing songs to a new genre? Or to make other bulk changes? I've hunted around in the PC Companion program and don't see a way there.
As a side note: I was looking at the backup file created by the program, and I noticed that it has a SQL Lite segment. Perhaps it's possible for an "enterprising person" to do their own SQL updates to a copy of a backup file and then do a restore? (I am guessing that this is essentially what the PC Companion does). I understand that this sort of thing is fraught with peril and the author might not want people mucking around in the database and then complain when something breaks... but I would be willing to take the risk (especially since I make frequent backups).
Thanks in advance for any help/suggestions.