Posts: 14
Threads: 5
Joined: Jun 2019
Reputation:
0
Recently the import local file function started hanging up after a file is selected and the import dialog starts, with the swirling hourglass going for minutes (indefinitely) instead of just seconds. The Cancel function is inactive so I have to close the database to quit the process. I tried restoring a previous backup database and Import works fine. The current copy has about 25 additional songs vs the backup copy.
Is there some way to fix a "corrupted" database that won't allow import, and/or is there a way to export a simple text list of songs with an associated last update date so I can compare old vs. new databases to ID the new songs that would need to be recreated or those to be updated?
This problem has been occurring on a MS Surface Book running Win 10 Pro #1809 and MS Version 2.6.5 for a week now.
Posts: 13,204
Threads: 299
Joined: Apr 2012
Reputation:
233
06-27-2019, 10:34 AM
(This post was last modified: 06-27-2019, 10:50 AM by Zubersoft.)
Can you update to version 2.6.8 and verify that problem is still occurring with the latest update? I just want to rule out issues that may have been fixed. To update, open the Microsoft Store, search for MobileSheets and tap the button to update.
If it is a database problem, then fixing a corrupted database would depend upon the nature of the problem. You can go to the Songs tab and sort by "Date Created" to see when the songs were added to the library. That might allow you to figure out which songs are the most recent ones. If you want to generate a list of songs with the update date displayed, you'll need to do a few things:
1) Add all of the songs to a setlist. This can be done by creating a new setlist and tapping the icon with two arrows.
2) Go to Settings->Library Settings->Generate Song Title Format and add %CREATION_DATE% where you want it to show up next to the title.
3) Long press the setlist on the setlists tab, tap the three dots at the top right and then tap on "Generate Song List".
If you go to C:\Users\<your username>\AppData\Local\Packages\41730Zubersoft.MobileSheets_ys1c8ct2g6ypr\LocalState and send mobilesheets.db to mike@zubersoft.com, I can try testing with your database file.
Thanks,
Mike
Posts: 14
Threads: 5
Joined: Jun 2019
Reputation:
0
Thanks for the quick response Mike!
I updated to 2.6.8 via the MS Store but still have the same negative results.
I will upload db file and an msb file of the database giving me problems.
Best Regards
Posts: 14
Threads: 5
Joined: Jun 2019
Reputation:
0
Mike - one follow up question on generating a song list once I've completed steps 1 & 2.
In step 3 as listed, do I select the Setlist Tab to display all setlists, then select the ALL SONGS setlist?
Long pressing the Setlist Tab doesn't do anything apparent.
Tapping on the 3 dots under the Setlist tab, I don't find any "Generate Song List" option.
Only Import, Add Songs, Remove Songs, or Create Setlist or Collection.
Under Settings/Library Settings I see "Generate Song List Format" but that's it.
So what am I missing?
Posts: 14
Threads: 5
Joined: Jun 2019
Reputation:
0
Mike -
My bad - I see now I long press the - ALL SONGS setlist - and it becomes highlighted and a new menu appears.
Got it.
Thanks
Posts: 13,204
Threads: 299
Joined: Apr 2012
Reputation:
233
04-27-2020, 04:52 PM
(This post was last modified: 04-27-2020, 04:52 PM by Zubersoft.)
Hello John,
Can you please send one of the files that isn't importing correctly to mike@zubersoft.com? I can run some tests - if I'm able to reproduce the problem, I'll get a fix in place ASAP. It would also help to have either your backup file or all of the xml files from the directoy I mentioned before. That way I can run with the same settings as you.
Thanks,
Mike