Store Kobo Stats on Calibre using databases

[1ily]

Hello!

I spoke to customer service about database corruptions, and they suggested holding the power button and the upper page turn button at the same time to perform a manual reset.

The resets through the dialogue normally retain my side-loaded books & info, so I thought this would be the same case, but this deleted my side-loaded books, stats, and annotations

I have Kobo Utilities and Kobo Touch Extended installed, and I have the databases. I've tried replacing the database with the backup, but Calibre doesn't recognize that there are fields that need to be updated..

Is there a way to store my annotations and book progress into calibre only using databases? I had several books in progress and I don't remember where I was at

I'm using a Kobo Libra 2

[DNSB]

If you have the Kobo Utilities plugin installed, you can click on it to bring up the customization dialog. I've attached images of how I have that configured with the 4 custom columns.

If you are copying the databases back to the Kobo, you will need to copy the books back first and then copy the 2 databases since if the books are not found, they will be removed from the database.

When I do a factory reset, I copy the books back to the Kobo and then use Kobo Utilities to update the metadata and restore the bookmarks. I don't do anything with annotations at this time since most of annotations are errors in ebooks that I am correcting. After this is done, I will copy the databases back into place and do a reboot from NickelMenu.

And yes, the manual factory reset does the same as the factory reset from the Developer Options menu and wipes your Kobo back to how it came from the factory. The standard factory reset wipes the books but downgrade the firmware.

[ownedbycats]

After semi-recently needing to soft-reset to fix a glitch, I found that it's also possible to restore the Kobo stats such as time spent read (More > Activity) by taking the last database backup and transplanting the Event table into the newly-initialized database. This is fairly advanced though and I wouldn't recommend it unless you're somewhat familiar with working with SQLite databases.

[JSWolf]

Originally Posted by ownedbycats

After semi-recently needing to soft-reset to fix a glitch, I found that it's also possible to restore the Kobo stats such as time spent read (More > Activity) by taking the last database backup and transplanting the Event table into the newly-initialized database. This is fairly advanced though and I wouldn't recommend it unless you're somewhat familiar with working with SQLite databases.

Why not just restore the latest database backup?

[ownedbycats]

Originally Posted by JSWolf

Why not just restore the latest database backup?

Because I'd already tried it and it failed to fix the glitch.

[JSWolf]

Originally Posted by ownedbycats

Because I'd already tried it and it failed to fix the glitch.

Have you looked at the database to see what might be wrong with it? Structurally, it is correct because Kobo Utilities would not back it up.

The last time I restored a database was when I went from my H2O to the Libra 2.

[ownedbycats]

Originally Posted by JSWolf

Have you looked at the database to see what might be wrong with it? Structurally, it is correct because Kobo Utilities would not back it up.

The last time I restored a database was when I went from my H2O to the Libra 2.

The glitch was described in this thread. The issue was present in every backup I tested and I couldn't identify anything unusual when inspecting in SQLiteStudio.

Since re-initializing the database fixed it, I just restored my bookmarks with Kobo Utilities and copied over the Events table to get my reading hours back.