Quote:
Originally Posted by Autumn Corvus
Please please please create a simple option to export annotations as a text file of some sort, this is really essential for students and researchers!
Autumn
|
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.