+- MobileSheets Forums (https://www.zubersoft.com/mobilesheets/forum)
+-- Forum: Support (https://www.zubersoft.com/mobilesheets/forum/forum-1.html)
+--- Forum: MobileSheets (Android) (https://www.zubersoft.com/mobilesheets/forum/forum-23.html)
+--- Thread: Restoring on Android (a power user issue) (/thread-13243.html)
Restoring on Android (a power user issue) - itsme - 04-23-2025
I manage my files myself and I'm trying two things:
1. I changed the subfolder structure of my MobileSheets directory from
d:\HerbertsGoogleDrive\ with fakebooks in d:\HerbertsGoogleDrive\_MobileSheets\Fkbk0\
to
d:\_MSP\ with fakebooks in d:\_MSP\HerbertsGoogleDrive\_MobileSheets\Fkbk0\
2. To copy my data from a Win10 device to an Android device:
instead of synchronizing the subfolder structure with FolderSyncPro and copying the database files manually I'm trying the standard method "backup on Win10 and restore on Android"
for 1. I used db_reloc.pl from Sciurius' MSProTools
This seems to work fine. The new folder structure works as expected, all song files are stored with relative paths as before, see database metadata in mobilesheets_reloc.zip (exported with get_meta.pl from Sciurius' MSProTools)
2. backup & restore shows a strange issue:
After restoring a backup created on a Win10 device on my Boox Tab Ultra C most of the files were restored correctly as expected into the subfolders where they are on the Win10 device, missing subfolders were created correctly. MobileSheets works fine, "Find Missing Files" reports "No files are missing in the library".
But: only most of the files were restored correctly. Some fakebooks are stored in the root of the MobileSheets directory instead of in the subfolder where they were before the backup. This happened only for 3 fakebooks out of about 15, all others are correct.
Here's one of them as an example:
557 Standards_Bb.PDF worked fine, 557 Standards.PDF shows the issue.
Deleting the files on the Boox Tab and restoring the backup again did not help, same behaviour as before.
This is not necessarily a bug in MobileSheets, maybe something's wrong with my workflow. I won't mind changing something or applying a one-time-fix. I'm just clueless as I couldn't understand the difference between files that are stored correctly and files that are in the wrong place.
RE: Restoring on Android (a power user issue) - e.k. - 04-23-2025
Hi itsme,
did you first import "557 Standards_Bb.csv" following thereafter "557 Standards.csv" into Mobilesheets?
Are you sure, there´s not the same album name in the different csv?
e.k.
RE: Restoring on Android (a power user issue) - itsme - 04-24-2025
Sure, the Bb and C version have the same album name. That's how I handle all my fakebooks that have versions for several instruments. And that's definitely not a problem. Many other fakebooks with more than one PDF in the same album are restored correctly and the other fakebooks that show the issue are single ones.
RE: Restoring on Android (a power user issue) - itsme - 04-25-2025
I created a new backup on the Win10 device and restored it on a second tablet - same result.
I opened the database from the Win10 device with SQLiteStudio and could not find any difference between more than 2000 files that are restored correctly into subfolders and those 3 files (marked in red) that are restored to the root of the MobileSheets storage location.
RE: Restoring on Android (a power user issue) - itsme - 04-25-2025
I used "Swap File" to replace HLJPA-028 - Big Band Era.pdf with the same file as before and retried backup & restore - same result.
d:\_MSP\HerbertsGoogleDrive\_MobileSheets\HLJPA\HLJPA-028 - Big Band Era\HLJPA-028 - Big Band Era.pdf
was restored to
/storage/emulated/0/_MSP/HLJPA-028 - Big Band Era.pdf
(instead of /storage/emulated/0/_MSP/HerbertsGoogleDrive/_MobileSheets/HLJPA/HLJPA-028 - Big Band Era.pdf as expected)
I noticed that the audio files that it had attached were restored correctly,
d:\_MSP\HerbertsGoogleDrive\_MobileSheets\HLJPA\HLJPA-028 - Big Band Era\Audio\Christopher Columbus (backing) Bb.mp3
was restored to
/storage/emulated/0/_MSP/HerbertsGoogleDrive/_MobileSheets/HLJPA/HLJPA-028 - Big Band Era/Audio/Christopher Columbus (backing) Bb.mp3
as expected.
RE: Restoring on Android (a power user issue) - Zubersoft - 04-26-2025
I'll have to find some time to try to set up a test to match what you are doing (or if you want me to use your backup, that could save some time).
Mike
RE: Restoring on Android (a power user issue) - itsme - 04-26-2025
I just sent you an e-mail. Thank you very much for your phantastic support.
RE: Restoring on Android (a power user issue) - Zubersoft - 04-30-2025
So the reason for this is because MobileSheets first converts the Windows path to an Android one, and then if it detects that the relative path starts with <song title>/file.pdf but "Create Subdirectory per Song" is disabled (which it is by default), it then eliminates the directory. This is to solve a problem where one device might have had that setting on but the other device does not, so MobileSheets has to figure out how to fix the paths to remove the unnecessary directories. This is also true if you change the setting and then restore the backup to get rid of subdirectories (which is a feature I recommend to users that want to get rid of all the subdirectories that were created in the past).
So in your backup, the path is 557 Standards/557 Standards.pdf, which is exactly the path MobileSheets would have used if "Create Subdirectory per Song" was used, so it removes that directory as "Create Subdirectory per Song" is disabled in the backup file settings. If you use directory names not tied to the song title, then you won't run into that issue.
Mike
RE: Restoring on Android (a power user issue) - itsme - 04-30-2025
I assume you restored my backup. Could you reproduce the issue that I reported?
The files that showed the issue are "557 Standards.PDF", "HLJPA-028 – Big Band Era.pdf" and "Liedler.pdf"
Songs named "557 Standards", "HLJPA-028 – Big Band Era" and "Liedler" do NOT exist in my library. These files are fakebooks containing songs with completely different names. The most similar song names are e.g. "~557 Standards C – TOC", "~557 Standards C (complete)". But that's my naming scheme for all my fakebooks, not only for the three affected ones. The one and only song using "HLJPA-028 – Big Band Era.pdf" is "Christopher Columbus". I don't see any case where "the relative path starts with <song title>/file.pdf".
What's identical is the filename and the foldername, but that's also the case for many other fakebooks e.g. RealBookOfBlues.pdf, BluegrassFakebook.pdf, BuskItCountry.pdf and many others.
So your explanation doesn't match the issue I'm facing. Nevertheless I'll pick up your hint and experiment with changing the foldernames for the affected fakebook files and see what happens.
RE: Restoring on Android (a power user issue) - RutgerDOW - 04-30-2025
Don't know if this is the right topic, but I've created a backup on android tablet, and stored this file (name.msb) on google drive.
Then did import on my android phone and I can see all songs, but a lot of songs give error that file [storage location] does not exist.
RE: Restoring on Android (a power user issue) - Zubersoft - 05-01-2025
I would suggest the following:
1) Create backup file one more time to rule out some kind of unusual problem
2) Try downloading the file from Google Drive first to the tablet, then restore it using the "Local File" option
If the problem still persists, then I may need you to share the backup file with mike@zubersoft.com in order for me to get you more information about what is happening. Did you change any of the storage settings in MobileSheets?
Mike