02-27-2020, 10:46 AM
Hello Taxel,
All of the data for MobileSheets is stored in a SQLite database. On Android, you normally can't access the file as it's in the private application data directory. If you go to Settings->Storage and enable "Expose Database", the database will be copied to the storage location so long as the storage location is on the internal storage. If an SD card is used for the storage location, the database is copied to /storage/emulated/0/Android/data/com.zubersoft.mobilesheetspro/files. On Windows 10, the database file (mobilesheets.db) is stored in the default storage location which is C:\Users\<your username>\AppData\Local\Packages\41730Zubersoft.MobileSheets_ys1c8ct2g6ypr\LocalState.
If you want to edit song names, artists, other metadata, you would have to use SQL queries to modify the database and then copy that SQLite database file back to the tablet. If you want to add files, you'd have to add all the new entries to the database to create songs for those files, and then copy the files to the tablet (or use a file synchronization application to automatically pull down files into a specified directory). So to implement the kinds of features you've described, you'll have to start by getting familiar with all of the database tables and fields that are used (along with the relationship between them). It's mostly straightforward if you just look at the table names.
Mike
All of the data for MobileSheets is stored in a SQLite database. On Android, you normally can't access the file as it's in the private application data directory. If you go to Settings->Storage and enable "Expose Database", the database will be copied to the storage location so long as the storage location is on the internal storage. If an SD card is used for the storage location, the database is copied to /storage/emulated/0/Android/data/com.zubersoft.mobilesheetspro/files. On Windows 10, the database file (mobilesheets.db) is stored in the default storage location which is C:\Users\<your username>\AppData\Local\Packages\41730Zubersoft.MobileSheets_ys1c8ct2g6ypr\LocalState.
If you want to edit song names, artists, other metadata, you would have to use SQL queries to modify the database and then copy that SQLite database file back to the tablet. If you want to add files, you'd have to add all the new entries to the database to create songs for those files, and then copy the files to the tablet (or use a file synchronization application to automatically pull down files into a specified directory). So to implement the kinds of features you've described, you'll have to start by getting familiar with all of the database tables and fields that are used (along with the relationship between them). It's mostly straightforward if you just look at the table names.
Mike