Highlighting Kobo Glo compared to PW?

[tshering]

Originally Posted by paola

are there any "structural" changes with respect to your previous version?

There is only one new thing. The tool can try to fix those highlights/annotations in kepub.epubs that are recorded in the database (and listed in the annotation list) but do not appear as marked in the text. There is however a drawback: The fixed highlights/annotations may not any longer be listed under the correct chapter headings. The sequence however will remain intact.

[paola]

Originally Posted by tshering

There is only one new thing. The tool can try to fix those highlights/annotations in kepub.epubs that are recorded in the database (and listed in the annotation list) but do not appear as marked in the text. There is however a drawback: The fixed highlights/annotations may not any longer be listed under the correct chapter headings. The sequence however will remain intact.

ah, great, thanks for the clarification!

[pakoe]

Originally Posted by tshering

Some time ago, I started writing a windows tool for extracting annotations and highlights from the database (cf. this post).

I am using the following annotations extractor:

C:\Programme\sqlite3.exe "E:\.kobo\KoboReader.sqlite" "select (case when datecreated=maxdate then ('<b><i><u>' || replace(volumeid,'file:///mnt/onboard/','') || '</u></i></b><br />' || char(10)) else '' end), datecreated, text, annotation, '<br />' from ( select *, (select max(datecreated) from bookmark where volumeid=bm.volumeid and (text<>'' or annotation<>'')) maxdate from bookmark bm where (text<>'' or annotation<>'') order by maxdate desc, volumeid, datecreated desc )" > "C:\Dokumente und Einstellungen\user\Desktop\annot.html"
pause

I can edit the resulting annot.html and write the changes back to KoboReader.sqlite by another script, which however is written in AutoHotkey. I don't like the XML annotation files and prevent them from being created by one write protected file.

[Gergely]

Originally Posted by tshering

Some time ago, I started writing a windows tool for extracting annotations and highlights from the database (cf. this post). Since I learned later that annotations are also available in xml files I did not continue this project. The tool is therefore in a raw state, but working. Feel free to use it at your own risk.
Edit: new version uploaded (22.03.2013)
Edit: new version uploaded (27.05.2013)

"Since I learned later that annotations are also available in xml files I did not continue this project."

Where are these xml files in a Kobo Aura device and how can I process them with python?

[davidfor]

Originally Posted by Gergely

"Since I learned later that annotations are also available in xml files I did not continue this project."

Where are these xml files in a Kobo Aura device and how can I process them with python?

They are in "Digitial Editions/Annotations". There will be one file for each epub and PDF in the main memory of the device that is has been opened. The file type is .annot.

This file is maintained by the Adobe RMSDK library as annotations are made. It is also used by other ADE and other RMSDK readers. I have, as an experiment, copied the file between a Kobo device and ADE with a couple of modifications (mainly in ids). This let me see the annotations from one system in the other.

For the Kobo device, these files are sort of useful, but they have problems. One of them is that they are only changed when reading a book. If you open the annotations list from the library list on the device, and edit an annotation it will update the database, but not the file. When the book is opened, the annotations in the file are merged with those in the database and the database is updated. They get written back the the file at some point. I've never looked at exactly when that happens, but at the latest it will be when an annotation is updated or added while reading.

As you are interested in annotations, they have been discussed here plenty of times. I'd suggest some more searching as the points above, and where these files are, has been discussed. I do tend to get involved in the discussions, so a search for posts by me with "annotation" in them will probably find most threads.

[Gergely]

Thanks, davidfor.

[RobertJSawyer]

@tshering, thank you for KT Annotation Extractor! I realize it hasn't been updated for a while, but I'm wondering if you can shed some light on this error message:

Listenindex überschreitet das Maximum (143)

That's German for "List index exceeds the maximum (143)," but is the index too many books in my sqlite database, or two many highlights in a given book? Many thanks!

[tshering]

Originally Posted by RobertJSawyer

@tshering, thank you for KT Annotation Extractor! I realize it hasn't been updated for a while, but I'm wondering if you can shed some light on this error message:

Listenindex überschreitet das Maximum (143)

That's German for "List index exceeds the maximum (143)," but is the index too many books in my sqlite database, or two many highlights in a given book? Many thanks!

Thank you for telling. I just tried it myself. The error occurs when I try to extract the notes of the very last book in the authors list. I can still extract the notes from the same book, when I access it from the book titles list or the file names list. I think this should work for you too (until I have fixed this bug).
Strangely, this bug seems only to occur with those of my databases that were created in 2018, but does not occur with older ones. I will look into it!

Edit: I think I fixed it. Please find it here.