Glo Annotations support and export

[Shohreh]

I happened on this thread from 2013 while looking for infos on how to export notes from a Kobo Clara to the computer through USB — ideally through just a text file, without having to bother with Calibre, or having to connect to the Net, upload them (to the "cloud"), and then downloading them to the computer.

I found that each .epub file has a corresponding file in "\Digital Editions\Annotations\blah.epub.annot", but that XML file only contains links to annotions, not the annotations themselves:

<annotation>
	<dc:identifier>urn:uuid:de120535-d147-4f21-bbb6-3da9ba9dc7a9</dc:identifier>
	<dc:date>2026-01-11T02:58:19Z</dc:date>
	<dc:creator>urn:uuid:374c8101-17fe-41c5-b9c7-0f4d8a6833f5</dc:creator>
	<target>
		<fragment start="OEBPS/ch01.html#point(/1/2/1/18/9/1:260)" end="OEBPS/ch01.html#point(/1/2/1/18/9/1:260)" progress="0.0922619" color="0"/>
	</target>
</annotation>

Also, under \.kobo, the following SQLite files can be found:

• BookReader.sqlite
• fonts.sqlite
• KoboReader.sqlite

Before I look further, does someone know of a script (for Windows) that would 1) open the EPUB file, 2) jump to the given location in the file, and 3) copy/append the annotation to a TXT file?

I currently use the medieval solution of… shooting screenshots with my smartphone and copy/pasting the PNGs to my computer before possibly grabbing the actual text from the EPUB after searching the file through CTRL+F and pasting it to a TXT if I need to :-/