Metadata transfer *from* device to calibre?

[ilovejedd]

Originally Posted by DNSB

@ilovejedd: Not sure if this is going of much help but one friend of mine used to use the Firefox SQLite Manager plugin to export data into a csv format, massage that data in Excel and then import the massaged data using the Import List plugin for calibre. When Firefox went to their Quantum releases, that broke SQLite Manager and he never bothered to go to the effort of reworking his setup to use another program to export csv. SQLiteStudio does have the capability of exporting to csv (freebie with Linux, OSX and Windows support).

Thanks. I actually do have SQLiteBrowser installed (for tag extraction and making some direct changes to the Calibre database, yeah my bad ).

For my purposes (pre-existing Calibre library), all I really need are annotations and I don't think the Import List plugin would be much help there.

*Marvin stores annotations in a separate table with one row/entry per annotation. It uses the epub file's md5 hash as the "link".

[ilovejedd]

Originally Posted by lamerc

I could set up a content server version... (I'm *pretty* sure. I know enough to know that I'm gonna have to look up a few things to do it, but if that would work...

Here are some screenshots taken on an iPad mini of the Calibre content server.

Do note, Marvin ignores custom columns so you'll need to use the built-in Tags column for fandoms, pairings, completion status, etc.

[davidfor]

Originally Posted by ilovejedd

Thanks. I actually do have SQLiteBrowser installed (for tag extraction and making some direct changes to the Calibre database, yeah my bad ).

For my purposes (pre-existing Calibre library), all I really need are annotations and I don't think the Import List plugin would be much help there.

*Marvin stores annotations in a separate table with one row/entry per annotation. It uses the epub file's md5 hash as the "link".

The Annotations plugin had support for fetching annotations from Marvin before it was moved to the MarvinXD plugin. The code is still there, and it can probably be changed to let you select a database file if there is a way to get it from the iPad. Alternatively, the plugin supports reading from other files, if there is a way to export the annotations that is suitable to read. The code has to be written for the format. How hard that is depends on the file format.

[ilovejedd]

Originally Posted by davidfor

The Annotations plugin had support for fetching annotations from Marvin before it was moved to the MarvinXD plugin. The code is still there, and it can probably be changed to let you select a database file if there is a way to get it from the iPad. Alternatively, the plugin supports reading from other files, if there is a way to export the annotations that is suitable to read. The code has to be written for the format. How hard that is depends on the file format.

Yeah, I looked into the template for the Annotations plugin. I'm not really a programmer though and am very unfamiliar with Python so transferring annotations to Calibre would have to wait until I have more time to devote to it. I'd probably need to create the batch file to run Calibre Portable from source, too.

Honestly, I'm quite undecided on how I want to store annotations in Calibre. Considering two options: as custom column (may become unmanageable) or in ebook format that I never use but is supported by ebook-viewer.exe.

[BlankEyes]

How did you manage to make a connection between the two?
Or is it just photos taken from iPad?

[theducks]

Originally Posted by BlankEyes

How did you manage to make a connection between the two?
Or is it just photos taken from iPad?

I am not sure what you real question is about.
Thos screen captures were of a standard Browser viewing the users Calibre Content server << Keyword
You run the content server FROM calibre (the Globe icon with 3 squares)
When that is running, the Icon menu will show what yo need next to Stop... (don't)
On any network device with a browser (like your i-Won't ),
Enter that in the address bar eg

http://10.0.0.21:8083/#library_id=MainLib&panel=book_list

<the green is user options for thos with more than 1 Library... >

Click on a book, and you get the details (similar to those images)