[Steinsk73]

I have a quite huge library (8000 files, 11 GB) that MobileSheets handles with absolutely no problem.  Syncing through OneDrive, though, is completely hopeless. I have never managed to upload the full library, it always crashes less than half way.

Today I set MS on Windows to place the library file directly on OneDrive, or a local folder that automatically syncs with OneDrive. 

Would it be possible to make MS on Android to read the library from an "always on device" synced OneDrive folder on the Android device, so the library would automatically sync that way?

EDIT:  It seems like it isn't possible to "find" the offline OneDrive files in the Android file system. But if MobileSheets stores the library directly in a OneDrive folder, why isn't it possible on an Android device to sync from that OneDrive folder to that device? I tried, but it says that there is no library in that folder. Is that because that folder doesn't contain the database file itself?

[Zubersoft]

You would need to enable Settings->Storage->Expose Database, set the storage location to the OneDrive folder and then be careful not to make changes to files in the cloud while you are actively using the app on one of the devices, otherwise the databases on each device would be overwriting each other.

As far as the sync feature itself, yes, a copy of the database file has to be in that directory, and it has to be the database file that MobileSheets created as part of the sync (you can't just copy the database file into that directory, as that's now how the sync feature works). The sync feature is designed to merge libraries together that may not be identical - it's not like the file sync you use with OneDrive, Dropbox, etc that just tries to ensure the files are identical across devices. It does this by comparing database files (the one stored in the cloud vs the one stored on the device). So you would not want to mix trying to use the sync library feature with letting OneDrive automatically synchronize files.

Mike

[Muscobaldi]

Can I ask a related question.....

I'm new to MobileSheets and just gradually integrating items from my vast pdf collection (300GB+). I've already realised that I need to keep my database size within the capacity of the least available storage device I'm using (an iPad Pro with only 128GB storage), unless I can utilise cloud storage from the outset.

From a PC or Mac with local access to my whole pdf collection can I start to import the files into MobileSheets, having the database stored on OneDrive or do I just upload all the pdf's to OneDrive then just import a reference to the OneDrive file location as opposed to actually importing the file into MobileSheets?  What's the route I need to take if OneDrive is a practical and workable solution?  Is the background read ahead caching that MobileSheets utilises sufficient to make everything as seamless as it is with local storage? My internet connection is superb at 900Mbit up and down so there won't be a bottleneck there.

Any advice would be greatly appreciated.

[Zubersoft]

MobileSheets always requires local access to files. While you can import files from the cloud, they are downloaded to the device and stored in the MobileSheets storage location. If you changed the storage location to use the OneDrive folder (which I generally would not recommend as it can cause MobileSheets to be unable to access files if OneDrive locks them), then you would still be using local files, but the OneDrive automatic synchronization would just be downloading the files to the device for you in the background. Due to the limitations with the SQLite library for UWP applications (the database library), the MobileSheets database (mobilesheets.db) has to be stored in the default application directory, which is C:\Users\<your username>\AppData\Local\Packages\41730Zubersoft.MobileSheets_ys1c8ct2g6ypr\LocalState. So that file would not be synchronized by OneDrive (I just wanted to mention this in case you do try to leverage the Windows OneDrive application).

Mike

[Muscobaldi]

Thanks for info Mike.

Do all your comments/concerns/vetos still apply if the default OneDrive syncing is switched off entirely meaning it effectively becomes a (cloud) storage medium only?
I have (in addition to various PCs/Macs) a 1TB 3rd Gen iPad Pro and a 128GB iPad Pro. I'm assuming that the lesser iPad is going to dictate my maximum database size or does that not apply (if it can be configured as a slave (always the 2nd screen)) device only, without a local copy of the files.
If currently it is not possible to do the latter, could it not become a feature in that there is always going to be a time difference (interval) between the musician starting to read the left hand page (master) and needing to read the right hand page (slave). Surely there would be ample time to transfer the right hand page during that interval/time difference?
My apologies if this is already covered elsewhere and my question answered.

If I am aware of the risks associated with OneDrive but have an adequate backup strategy in place, is it still workable to use it as the sole storage medium for all devices, especially as I will be the only user at any time?

[Zubersoft]

MobileSheets will not link to files in the cloud - it's designed for offline usage at its core. That's not going to change, as it would require drastic changes to the architecture. With multiple devices, each device needs a copy of the songs and setlists you are going to want to load. MobileSheets handles it like this to support bluetooth connections so that it's not trying to send large files over bluetooth (as bluetooth is quite bad for sending lots of data like that). If I ever did support a mode where the second device would receive files from the primary device to load, I would probably limit it to only WiFi connections.

Mike

[itsme]

@Muscobaldi
I handle a pretty similar scenario. I manage files myself and don't use MobileSheets' sync features as I started long before sync has been added to Mobile Sheets.
I set up the same files and folders structure on all devices within the MobileSheets Storage Location. The local folder of my GoogleDrive is within the MobileSheets Storage Location, so the GoogleDrive app takes care for syncing that part to all Windows devices. A part of my huge library is outside the GoogleDrive folder because it's too much, but inside the MobileSheets Storage Location, so that MobileSheets can access everything. On Android devices I use Folder Sync Pro https://play.google.com/store/apps/detai...rsync.full to sync the local folder structure with GoogleDrive.
I use several MobileSheets databases, a relatively small "active" database with songs that I use on stage and that I carry around to sessions and rehearsals. And a big one to maintain a bigger part of my collection. I copy the MobileSheets databases manually to the devices where I want to use them. This allows me to have a smaller subset of songs on devices that I carry around and the big collection just on these devices where enough storage space is available.