Register Guidelines E-Books Today's Posts Search

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management

Notices

Reply
 
Thread Tools Search this Thread
Old 06-13-2022, 09:55 AM   #1
MoreEbooks
Member
MoreEbooks began at the beginning.
 
Posts: 11
Karma: 10
Join Date: Jun 2022
Device: Kindle 10th gen
Question Exporting highlights

I make heavy use of the 'highlight' feature on my Kindle and recently discovered that calibre can download these annotations and export them to a text file. Is there a similar way to export the highlighting I do within calibre itself? The only way to see them seems to be in calibre's own reader - they do not even show up if I print the document. Maybe buried in the database somewhere...
MoreEbooks is offline   Reply With Quote
Old 06-13-2022, 10:58 AM   #2
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 45,323
Karma: 27111242
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
There's an export button right on the highlights panel in the viewer. And you can export them from the tool in calinbre used to browse annotations for all books as well. https://manual.calibre-ebook.com/vie...hlighting-text
kovidgoyal is offline   Reply With Quote
Advert
Old 06-13-2022, 01:30 PM   #3
MoreEbooks
Member
MoreEbooks began at the beginning.
 
Posts: 11
Karma: 10
Join Date: Jun 2022
Device: Kindle 10th gen
Ah, that gets me almost there - I can get a JSON file of all the annotations. However, it looks to be a dump of just the 'annotations' table in the database and lacks the actual book titles that are over in the 'books' table. The 'title' field in a 'bookmark' annotation is not the book title, but the selected text. Maybe this is a bug. I see that if I request the output in markdown format, the book title is included.

For now, I will write a short lua program to query the database directly doing the JOIN between the two tables.

Last edited by MoreEbooks; 06-13-2022 at 01:33 PM.
MoreEbooks is offline   Reply With Quote
Old 06-13-2022, 10:23 PM   #4
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 45,323
Karma: 27111242
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
The JSON includes information about annotations, not the rest of the book metadata, you get that separately and there is no reason to write a program to query the database for it. You can simply use the calibredb command line tool.
kovidgoyal is offline   Reply With Quote
Reply


Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Exporting Notes / Highlights RamonR Kobo Reader 15 04-02-2023 07:45 AM
Exporting highlights into text ilyasson Onyx Boox 4 04-18-2019 10:15 AM
Exporting highlights from an epub? archz2 Android Devices 1 11-03-2018 02:08 PM
PRS-T1 rooting for better exporting of highlights?? glukkon Sony Reader Dev Corner 2 04-09-2012 05:25 PM
Exporting notes/highlights thetaoofrecovery Kindle Fire 2 03-03-2012 11:32 AM


All times are GMT -4. The time now is 12:56 PM.


MobileRead.com is a privately owned, operated and funded community.