Quote:
Originally Posted by tshering
In case somebody is still interested in this question. This is one way to export annotations/highlights from KT to a text file. From the description it might seem a little tiresome, but as soon as you did the preparing steps once, the usage is very easy.
Download the sqlite3 programm from http://www.sqlite.org/download.html and unzip it into C:\kobotest\.
Create a file "work.bat" with the following content:
(begin of content)
sqlite3 KoboReader.sqlite < extr_annotations.txt
(end of content)
Create another file "extr_annotations.txt" with the following content:
(begin of content)
.output annotations.txt
SELECT Text, Annotation
FROM Bookmark
WHERE VolumeID LIKE "%%pg37873-images.epub";
.exit
(end of content)
Do not type "(begin of content)" and "(end of content)". I put them here just for clarification. Replace "pg37873-images.epub" with the filename of the epub you want to extract the annotations from.
Connect the KT to the computer and copy the file "KoboReader.sqlite" from KT (e.g. "G:\.kobo\KoboReader.sqlite", in my case) to "C:\kobotest\".
In "C:\kobotest\", there should now be the following files:
sqlite3.exe
KoboReader.sqlite
work.bat
extr_annotations.txt
Double click on "work.bat". After some split seconds you will find in the same folder a file named "annotations.txt". Open it with MSWord or WordPad. The Editor does not show the file nicely. The text file is encoded in utf8, so you can use it for instance for Chinese and Japanese too. |
Can you post a link to the result file extr_annotations.txt or post how the file looks like?