On Win10 restoring a backup fails badly:
All the files are copied directly to the MSP storage location, all the subfolders of the stored folder structure are lost!
I manage my song files myself. All files are stored in a folder structure within the MSP storage location:
So all paths are stored as relative paths in the MSP database. This works really great. Using the same subfolder structure on Win10 and Android (with the Win10 rootfolder d:\HerbertsGoogleDrive\_MobileSheets\ replaced by /storage/emulated/0/_MobileSheets as MSP storage location on Android) I can easily copy the MSP database from one device to the other and everything works like a charm.
When a backup is restored there's a small difference depending on "Restore settings (if found in backup file)", but the paths are gone anyway.
For the test I used a new empty database with the MSP storage location set to d:\_MSPTest.
"Restore settings (if found in backup file)": ON
=> MSP folder is changed
from d:\_MSPTest (previous setting)
to d:\HerbertsGoogleDrive\_MobileSheets\ (from backup file)
=> database names from the backup are preserved: PathTest / pathtest.db
=> relative Paths are lost
d:\HerbertsGoogleDrive\_MobileSheets\Songs\A\AdeZurGutenNacht_D_MSCZ.pdf
becomes
d:\HerbertsGoogleDrive\_MobileSheets\AdeZurGutenNacht_D_MSCZ.pdf
d:\HerbertsGoogleDrive\_MobileSheets\Fkbk0\KinderWollenSingen\_kinder-wollen-singen-A4.pdf
becomes
d:\HerbertsGoogleDrive\_MobileSheets\_kinder-wollen-singen-A4.pdf
"Restore settings (if found in backup file)": OFF
=> MSP folder is NOT changed, d:\_MSPTest is preserved
=> database names from the backup are preserved: PathTest / pathtest.db
=> relative Paths are lost
d:\HerbertsGoogleDrive\_MobileSheets\Songs\A\AdeZurGutenNacht_D_MSCZ.pdf
becomes
d:\_MSPTest\AdeZurGutenNacht_D_MSCZ.pdf
d:\HerbertsGoogleDrive\_MobileSheets\Fkbk0\KinderWollenSingen\_kinder-wollen-singen-A4.pdf
becomes
d:\_MSPTest\_kinder-wollen-singen-A4.pdf
Relative paths seem to be available in the backup file because restoring the same backup file to an Android device works nicely, the relative paths are taken over correctly
There are some small gaps caused by differences of the file system (and the according differences of the MSP versions), but they can be accepted:
In case of "Restore Settings (if found in backup file): ON"
=> relative Paths persist (adapted to Android)
=> MSP storage location stays unchanged
=> original base folder is NOT taken into account
Settings "Let MobileSheets manage my files" and "Expose database file" keep their default values and have to be set manually as they are not available in Win10.
My test database is available in my GoogleDrive. Even after reducing it to only a few files it is more than 5 MB so that I cannot attach it to this post.
All the files are copied directly to the MSP storage location, all the subfolders of the stored folder structure are lost!
I manage my song files myself. All files are stored in a folder structure within the MSP storage location:
Code:
D:.
...
+---HerbertsGoogleDrive
...
| +---_MobileSheets <= this is my MSP storage location
| | +---Fkbk0 Fakebooks, one folder per book, on Android in the local storage SD0
...
| | | +---KinderWollenSingen
| | | | kinder-wollen-singen.txt
| | | | kinder-wollen-singen.xls
| | | | _kinder-wollen-singen-A4.csv
| | | | _kinder-wollen-singen-A4.pdf
| | | |
...
| | +---Fkbk1 Fakebooks, one folder per book, on Android in the local storage SD1, will be copied during import
...
| | | +---VanillaBook
| | | +---VanillaBook
| | | | VanillaBook.txt
| | | | VanillaBook_RalphPatt.csv
| | | | VanillaBook_RalphPatt.pdf
| | | | VanillaBook_RalphPatt.xls
| | | |
...
| | \---Songs one file per song, mostly .PRO .PDF, original files in the same folder
| | +---#
| | +---A
| | | | AdeZurGutenNacht.mscz
| | | | AdeZurGutenNacht.mxl
| | | | AdeZurGutenNacht_D_MSCZ.pdf
| | | | AllForMeGrog_TA.pro
| | +---B
| | | | BeaumontRag.pro
| | +---C
| | | | CarelessLove.pro
| | +---D
...
So all paths are stored as relative paths in the MSP database. This works really great. Using the same subfolder structure on Win10 and Android (with the Win10 rootfolder d:\HerbertsGoogleDrive\_MobileSheets\ replaced by /storage/emulated/0/_MobileSheets as MSP storage location on Android) I can easily copy the MSP database from one device to the other and everything works like a charm.
When a backup is restored there's a small difference depending on "Restore settings (if found in backup file)", but the paths are gone anyway.
For the test I used a new empty database with the MSP storage location set to d:\_MSPTest.
"Restore settings (if found in backup file)": ON
=> MSP folder is changed
from d:\_MSPTest (previous setting)
to d:\HerbertsGoogleDrive\_MobileSheets\ (from backup file)
=> database names from the backup are preserved: PathTest / pathtest.db
=> relative Paths are lost
d:\HerbertsGoogleDrive\_MobileSheets\Songs\A\AdeZurGutenNacht_D_MSCZ.pdf
becomes
d:\HerbertsGoogleDrive\_MobileSheets\AdeZurGutenNacht_D_MSCZ.pdf
d:\HerbertsGoogleDrive\_MobileSheets\Fkbk0\KinderWollenSingen\_kinder-wollen-singen-A4.pdf
becomes
d:\HerbertsGoogleDrive\_MobileSheets\_kinder-wollen-singen-A4.pdf
"Restore settings (if found in backup file)": OFF
=> MSP folder is NOT changed, d:\_MSPTest is preserved
=> database names from the backup are preserved: PathTest / pathtest.db
=> relative Paths are lost
d:\HerbertsGoogleDrive\_MobileSheets\Songs\A\AdeZurGutenNacht_D_MSCZ.pdf
becomes
d:\_MSPTest\AdeZurGutenNacht_D_MSCZ.pdf
d:\HerbertsGoogleDrive\_MobileSheets\Fkbk0\KinderWollenSingen\_kinder-wollen-singen-A4.pdf
becomes
d:\_MSPTest\_kinder-wollen-singen-A4.pdf
Relative paths seem to be available in the backup file because restoring the same backup file to an Android device works nicely, the relative paths are taken over correctly
There are some small gaps caused by differences of the file system (and the according differences of the MSP versions), but they can be accepted:
In case of "Restore Settings (if found in backup file): ON"
=> relative Paths persist (adapted to Android)
=> MSP storage location stays unchanged
=> original base folder is NOT taken into account
Settings "Let MobileSheets manage my files" and "Expose database file" keep their default values and have to be set manually as they are not available in Win10.
My test database is available in my GoogleDrive. Even after reducing it to only a few files it is more than 5 MB so that I cannot attach it to this post.
first language: German
Acer A1-830, Android 4.4.2 - HP x2 210 G2 Detachable, Win 10 22H2 - Huawei Media Pad T5, Android 8.0 - Boox Tab Ultra C, Android 11
www.moonlightcrisis.de - www.basdjo.de - www.frankenbaend.de
Acer A1-830, Android 4.4.2 - HP x2 210 G2 Detachable, Win 10 22H2 - Huawei Media Pad T5, Android 8.0 - Boox Tab Ultra C, Android 11
www.moonlightcrisis.de - www.basdjo.de - www.frankenbaend.de