Posts: 79
Threads: 22
Joined: Oct 2023
Reputation:
0
Hi Mike, thanks for considering adding some importt function to allow for importing data into Mobile Sheets going forward. I think a generic import function would be most useful so it can be used to do import into various tables in the metadata. What I mean is if the import function can just allow for the selection of which metadata the import is for, ie. Tempo BPM, Key, MIDI commands, Artist etc. and then use the title of the song as the matching criteria. This way a text or csv file with the first value being the song title and the next being the data to be populated for that song can be setup by the user for the batch import. Hope this make sense.
Posts: 1,900
Threads: 296
Joined: Sep 2014
Reputation:
33
MobileSheets already supports batch import with the ability to populate meta data according to the folder structure where the song files are stored and CSV import where you can specify almost any meta data in a CSV file. Does neither of these allow you to do what you want?
Posts: 13,476
Threads: 302
Joined: Apr 2012
Reputation:
240
I can provide more information tomorrow (it's very late here), but there isn't an option at the moment to import MIDI commands in a batch fashion. The only way to do that would be to manipulate the database directly using SQLite queries yourself. If you know how to write database queries, then I can give you the relevant information, but otherwise you'll have to wait until I have time to implement a feature that supports what you are trying to do. When I support updating metadata through CSV files, I may add support for MIDI commands at that point in time, but it's still not the best format for certain times of MIDI messages, and the syntax is going to be somewhat complex in order to support everything.
Mike
Posts: 79
Threads: 22
Joined: Oct 2023
Reputation:
0
Thanks Mike for the response. I found the information on how to use csv file to upload some of the other information to the song metadata. The one thing I'm not totally clear on is you need the range pf pages used from the source file in the csv. Does that mean the songs being updated with the metadata are all in one single pdf file in the Mobile Sheets storage as when I try it it ask me for the pdf file. I was trying to see whether I can use the csv file to update the tempo of the songs I already imported to Mobile Sheets. You are right, the MIDI commands are a bit more complex than the other metadata like artists, albums, genres, keys, tempos etc. that you already have a solution for importing. I'm not an expert programmer so will have to leave that to the experts like yourself and will just wait until you have time to tackle my wish list down the road.
Thanks again.
Posts: 13,476
Threads: 302
Joined: Apr 2012
Reputation:
240
No, you can't use a CSV to update existing metadata at this time. That's on my list of things to support.
Mike
Posts: 935
Threads: 84
Joined: Feb 2017
Reputation:
28
The ranges for pages in a .csv is specified as the page number or, if more than one page, a list of numbers separated by commas. Consecutive numbers an be separated by a hyphen
Examples are 1 or 4-6 or 12-20,3,5
For windows (I only use the companion to manipulate my android tablet), I expect you can use common window operations to select multiple songs so that they can all be given the same meta data value e.g. Collection, Composer etc. Not so useful for Tempo!
You should also be able to click on the metadata column headers to sort them ascending/descending order (you might have to enable the display of that metadata column first).
This is useful to identify songs that don't have that particular metadata field filled in i.e. ones to address.
Geoff
Samsung Galaxy Tab A6