create a way to edit keywords in a spreadsheet format, or possibly on a MAC or PC to enable easier populating of keyword data.
Currently, the only way I see to use keyword data is to edit those individually for each PDF in UnRealBook. I have over 300 songs in my UnRealBook and going through and adding all that data on a PDF by PDF basis is too time consuming, so I haven't done it. This means I'm not really making as much use out of this feature as I could.
If there was a way to edit this in a spreadsheet format, or possibly on another device such as a MAC laptop, and then import the keyword data into unRealbook, that would make this much more usable.
Sharing keyword data for slaves would also be extremely cool. OR Being able to export just keyword data to share with another device with UnRealBook installed, (i.e. my band members all have the same songs. would be great to just set up the keywords once and improt that data into their iPads so they could search on our library as well.
-
Base sql editor will allow you to do this. It’s what I used: https://itunes.apple.com/us/app/base-sqlite-editor/id402383384
-
Art commented
I have 29000 songs in 420 books in the unreal book and want to import keywords by way of csv files.
-
I can help you out via email. There are only a few people that want this and it's less than a handful. But I can try and dig up the information that they used.
Just use the send a message command in the Action menu to email me. -
Doug Galuzny commented
I posted that too soon. I was going to add it would be helpful to have the field names already there when you export. You could populate the data in the .csv and import it. I get that it's a DB and there has to be some eidting of that which is possibly too difficult to make UnRealBook do natively.
my thought however is you could include and export and import function of Keywords in the DO menu that would save to dropbox or other supported remote storage, where it could be edited. The import function could then be used to bulk edit this sqlite DB.
In the meantime, maybe you could just provide some more detailed instructions?
-
Doug Galuzny commented
I was more hoping this could be a feature in the app, and not require developer tools to do it.
I was able to use IExplorer on Mac OS to mount the iPad to MacOS. I found the keywords.sqlite db file you mentioned. I bought BASE. I was able to export the contents which are already there (currently 5 titles with a little data, but am not having any luck importing a longer list of song specific info about my library. I also tried Datum as well as it was free.
The field names in the database are just named Field 1, 2, 3 etc. There doesn't seem to be a correlation to the field names in DB when accessed from the app itself.
Admittedly, I'm no software developer, so I've now spent about 2 hours playing with this and still don't have any more data in to show for it. If you can make this easier, I do think this would be something a lot of people would find helpful.
-
You can. It's a SQLite database named: keywords.sqlite
You can use something like Base on the Mac to edit it. Also, Base takes a .csv file and you can populate the sqlite database if you wanted to.