Are the Bookmark fields in the KoboReader.sqlite standardized across book formats?

[Legoless]

Hi folks,

Are annotations stored in the KoboReader.sqlite file (Bookmark table data) in a consistent format? I am unable to verify myself because I currently have 27 books on my Kobo, which are all from the same publisher in EPUB format so I cannot determine whathow annotations are stored for kepubs, PDFs, EPUBs from other publishers etc.

Is the format of various fields of the Bookmarks (ex. ContentID, StartContainerPath) consistent?

Thanks,

[geek1011]

Originally Posted by Legoless

Hi folks,

Are annotations stored in the KoboReader.sqlite file (Bookmark table data) in a consistent format? I am unable to verify myself because I currently have 27 books on my Kobo, which are all from the same publisher in EPUB format so I cannot determine whathow annotations are stored for kepubs, PDFs, EPUBs from other publishers etc.

Is the format of various fields of the Bookmarks (ex. ContentID, StartContainerPath) consistent?

Thanks,

They are all different, other than the contentid of the base file.

[qkqw]

Originally Posted by Legoless

Is the format of various fields of the Bookmarks (ex. ContentID, StartContainerPath) consistent?

The hard thing is to get the correct BookID, VolumeID and ContentID based on the format. Once you get that, extracting an annotation, dogear or highlight is quite easy. Have a look into this script: https://www.mobileread.com/forums/sh...d.php?t=349637

[LuisNeto]

Hi, Legoless. I have been working on the development of a program for importing from Kobo e-readers to calibre, and I have realised yesterday that there are differences in the format of those values between the EPUB and KEPUB formats.
The values of StartContainerPath and EndContainerPath look very different.
Example:

• EPUB: epub/text/endnotes-2.xhtml#point(/1/4/2/4/38/1:6)
• KEPUB: span#kobo\.153\.1

For items purchased in the Kobo store, there is an additional difference: the VolumeID is not a file path like file:///mnt/onboard/filename.epub but a UUID. By extension, the ContentID is also different.