[itsme]

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.

[e.k.]

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.

[itsme]

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.

[itsme]

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.
           

[itsme]

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.

[Zubersoft]

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

[itsme]

I just sent you an e-mail. Thank you very much for your phantastic support.