[melchimm]

Is it possible to pull the song titles from the PDF metadata (i.e., when importing PDF files that consist of one song per file).

I'm a new user of MobileSheets, and before starting to import my music files, I wrote a batch script to parse the filenames (e.g., to pull the song title "Jersey Bounce" from a filename like"043-Jersey Bounce - Tenor1.pdf") and added them (along with other information) to the PDF metadata.

I figured this would make it easy for MobileSheets to find the titles when doing a batch import, but I couldn't figure out a way to make MobileSheets use the PDF metadata when importing the files. Am I missing something? Is there an easy way (or any way) to get MobileSheets to pull information from the PDF metadata?

[Zubersoft]

This has certainly come up before (https://zubersoft.com/mobilesheets/forum...-8020.html) so it's absolutely on my list of things to do. Now that the iOS version is released, I can start working off many of the feature requests on the backlog. I know this doesn't help you in the short term, but it will be added in the near future.

Mike

[melchimm]

This has certainly come up before (https://zubersoft.com/mobilesheets/forum...-8020.html) so it's absolutely on my list of things to do. Now that the iOS version is released, I can start working off many of the feature requests on the backlog. I know this doesn't help you in the short term, but it will be added in the near future.

Mike

Sorry, I must have missed that thread. Thanks for the incredibly prompt reply!

Is there some other way to do batch updating of the metadata (e.g., via a CSV file, or some hidden API perhaps)?

[Zubersoft]

You'd have to run SQL queries against the database file (mobilesheets.db). It's a SQLite database. Let me know if you want more information about this. Other than that, I do also plan on adding support for updating metadata through CSV, as I know that's been asked for as well. 

Mike

[melchimm]

You'd have to run SQL queries against the database file (mobilesheets.db). It's a SQLite database. Let me know if you want more information about this. Other than that, I do also plan on adding support for updating metadata through CSV, as I know that's been asked for as well. 

Mike

Sure, thanks, that sounds doable. I would be interested in more information.

Melchi

[Zubersoft]

Are you using the Android or Windows version? On Android, the database file is under /storage/emulated/0/Android/data/com.zubersoft.mobilesheetspro/files by default. On Windows, it's under C:\Users\<your username>\AppData\Local\Packages\41730Zubersoft.MobileSheets_ys1c8ct2g6ypr\LocalState if you purchased the Microsoft Store version. Open the database file up using a SQLite editor like SQL Studio (which is free). Take a look at all the database fields and familiarize yourself with them. It's not too complicated in terms of the metadata for things like artists, albums. I can provide more information once you've studied it a bit.

Mike

[itsme]

are you talking about this: https://sqlitestudio.pl/ ?

[Zubersoft]

Yes, that is the program that I personally use as it seems to work well.

[melchimm]

Are you using the Android or Windows version? On Android, the database file is under /storage/emulated/0/Android/data/com.zubersoft.mobilesheetspro/files by default. On Windows, it's under C:\Users\<your username>\AppData\Local\Packages\41730Zubersoft.MobileSheets_ys1c8ct2g6ypr\LocalState if you purchased the Microsoft Store version. Open the database file up using a SQLite editor like SQL Studio (which is free). Take a look at all the database fields and familiarize yourself with them. It's not too complicated in terms of the metadata for things like artists, albums. I can provide more information once you've studied it a bit.

Mike

Thanks, i'll give it a shot. I'm using the Android (e-ink version).