MobileRead Forums - View Single Post - Aura ONE How do I combine multiple Kobo annotation tables?

pl8o · 11-27-2018, 10:34 PM

Hello all,

I currently read on a Kobo Aura ONE. I’ve had it replaced under warranty three times: once due to dud front-light, screen failure, and once after it went insane when I plugged it into a Samsung USB charger.

Each time I had an up-to-date backup of my annotations, though, and now I’d like to combine the annotations from my three devices so that I can have all my annotations available on my current reader, and can export them using this (sadly unmaintained) Python script.

(I didn’t want my current reader to inherit the various psychological ailments my previous readers had suffered from, which is why I didn’t load SD card backup from the last reader onto the new one each time I got a replacement.)

As I understand it, the annotations are all stored in the Bookmark table of the KoboReader.sqlite database. So:

Would it be it reasonably safe to combine the bookmarks tables from the different devices?
Is there anything else I would need from other tables of the database in order for the annotations to work?
Has anyone come up with a simple, safe way to combine annotations — or do I need to hack around with SQLite on my own?

Thanks for your help!

P.S. I’m new to the forum, and I’m not sure whether this belongs here or in the developer corner. Feel free to move it if it would fit better there.

11-27-2018, 10:34 PM	#1
pl8o Junior Member Posts: 8 Karma: 10 Join Date: Nov 2018 Device: Kobo Sage (prev, Nook, Nook Simple Touch, Kindle 7, Kobo Touch, KA1	How do I combine multiple Kobo annotation tables? Hello all, I currently read on a Kobo Aura ONE. I’ve had it replaced under warranty three times: once due to dud front-light, screen failure, and once after it went insane when I plugged it into a Samsung USB charger. Each time I had an up-to-date backup of my annotations, though, and now I’d like to combine the annotations from my three devices so that I can have all my annotations available on my current reader, and can export them using this (sadly unmaintained) Python script. (I didn’t want my current reader to inherit the various psychological ailments my previous readers had suffered from, which is why I didn’t load SD card backup from the last reader onto the new one each time I got a replacement.) As I understand it, the annotations are all stored in the Bookmark table of the KoboReader.sqlite database. So: Would it be it reasonably safe to combine the bookmarks tables from the different devices? Is there anything else I would need from other tables of the database in order for the annotations to work? Has anyone come up with a simple, safe way to combine annotations — or do I need to hack around with SQLite on my own? Thanks for your help! P.S. I’m new to the forum, and I’m not sure whether this belongs here or in the developer corner. Feel free to move it if it would fit better there.