MobileSheets Forums

Full Version: Adding a piece directly to mobilesheets.db
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Greetings,

Looking at mobilesheets.db I see there are many tables and a few show reference to data from an individual song/piece.  The question is if I wish to access the DB programmatically, in my case from C, and add a single song with a SQL statement, which tables need to be written to?  Perhaps there is a document describing the schema of mobilesheets.db and the steps to process a single entry that I have overlooked?

Thanks,
Al
There is no documentation for the steps required to create a song in the database. You will have to add entries to the songs table, the zoom table, the crop table, the metronome beats per page table, metronome settings table, the auto scroll settings table, the text display settings table if you are importing a text or chord pro file, and the tempos table if you specified any tempos for the song. If you are adding MIDI commands, you'd have to insert into those tables as well.

Mike