Quote:
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:
Code:
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.