[pakoe]

Originally Posted by howyoudoin

I'm very much interested in your method. Please do share. I've been recently looking for a way to streamline the vocabulary building process on Kobo myself.

First of all you need sqlite3 (sqlite3.exe for Windows), a free command line tool. Here is the most simple .bat file for Windows:

c:\xyz\SQLite3.exe "E:\.kobo\KoboReader.sqlite" "select text from bookmark" > "C:\Dokumente und Einstellungen\user\Desktop\annot.txt"

Replace E: by the drive letter of your Kobo!
Here is a more sophisticated .bat file producing a formatted, double sorted HTML file:

c:\xyz\SQLite3.exe "E:\.kobo\KoboReader.sqlite" "select (case when datecreated=maxdate then ('<b><i><u>' || replace(volumeid,'file:///mnt/onboard/','') || '</u></i></b><br />') else '' end), max(datecreated, coalesce(datemodified, 0)), text, coalesce(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"

Here is a .bat file to delete all annotations:

c:\xyz\SQLite3.exe "E:\.kobo\KoboReader.sqlite" "delete from bookmark"
del E:\Digital Editions\Annotations\* /Q/S

I HAVE NOT tested this with books with any kind of copy protection, since all the books on my Kobo are free. So deleting annotations this way is on your own risk. Be sure always to have a backup of KoboReader.sqlite. Using sqlite3 just to read ("select") from KoboReader.sqlite is of course safe.
(I myself use a Linux script and it runs on my Kobo itself, but that's more complicated.)