[GUI Plugin] Kobo Utilities - Page 41

recook · 09-06-2026, 02:12 PM

Hi,

thank you very much for the explanation. It seems now more complicated than before, but also working much better!

JSWolf · 09-06-2026, 02:41 PM

Quote:

Originally Posted by recook

Hi,

thank you very much for the explanation. It seems now more complicated than before, but also working much better!

That's how it's always worked. It's no more or less complicated then it's ever been.

Quality · 09-18-2026, 01:18 PM

Hello, I have the Kobo Clara BW with the early access firmware version 5.18.270971.
When I try to copy the annotations or highlights from the books using KoboUtilities I only the following information for each book.

(Title, Author, Last read, Percentage read)
"
Fight Club · Der Roman zum Film by Palahniuk, Chuck

Zuletzt gelesenes Buch: 2026-09-11 02:28:12
Prozent gelesen: 100%
"

The Kobo database KoboReader.sqlite does contain the annotations. I want to back them up with KoboUtilities so I can downgrade to the 4.x firmware and copy the books back and add the annotations back, if that is possible?

JSWolf · 09-18-2026, 02:55 PM

Quote:

Originally Posted by Quality

Hello, I have the Kobo Clara BW with the early access firmware version 5.18.270971.
When I try to copy the annotations or highlights from the books using KoboUtilities I only the following information for each book.

(Title, Author, Last read, Percentage read)
"
Fight Club · Der Roman zum Film by Palahniuk, Chuck

Zuletzt gelesenes Buch: 2026-09-11 02:28:12
Prozent gelesen: 100%
"

The Kobo database KoboReader.sqlite does contain the annotations. I want to back them up with KoboUtilities so I can downgrade to the 4.x firmware and copy the books back and add the annotations back, if that is possible?

Do you know what happens to the database when you downgrade? Maybe the annotations get kept. I don't know as I've never downgraded or read what happens to the data in the database when you do downgrade.

PeterT · 09-18-2026, 04:01 PM

I believe this is during the downgrade ftom 5.x to 4.x

Sent from my SM-X238U using Tapatalk

Quality · 09-19-2026, 12:39 PM

If I'm not mistaken, when you downgrade everything gets deleted, the books and everything.

rantanplan · 09-19-2026, 01:20 PM

Quote:

Originally Posted by Quality

If I'm not mistaken, when you downgrade everything gets deleted, the books and everything.

I can confirm, I lost all settings and read stats when I upgraded and the same when I downgraded.

JSWolf · 09-19-2026, 02:17 PM

Quote:

Originally Posted by Quality

If I'm not mistaken, when you downgrade everything gets deleted, the books and everything.

Too bad. I was hoping that wasn't the case.

Quality · 09-22-2026, 07:18 AM

When I upgraded I didn't lose the books or highlights, but all the books were missing the Table of Contents and I couldn't fix it using KoboUtilities. New added books would have their ToC.

The Tolino 5.x Firmware had also a ton of bugs that is why I installed the Kobo FW. I thought for this early release, that they had fixed most of the bugs, but it seems they haven't.

Even though the Tolino 5.x FW is already out for more than 2 years. Really disappointed in Kobo how they can still have these bugs, and normal Tolino users are basically forced to use that Firmware.

Majutsushi · 09-23-2026, 02:09 AM

There is currently no way to restore annotations to a device with the plugin since I don't think there is a way to guarantee this to be reliable. Any small difference between the version of the book that the annotations were made in and the version that is on the device when the annotations are restored can cause them to be completely off. This is particularly relevant when automatically converting books to kepub on transfer. It's something that I would like to investigate more deeply but I probably won't have time for it soon.

As for why the annotations feature doesn't seem to show any actual annotations I'm not sure, it's possible that the database structure has changed. I don't currently have a device that's running the beta firmware so if someone has more information about this I would be interested in hearing it.

JSWolf · 09-23-2026, 06:31 AM

Quote:

Originally Posted by Majutsushi

There is currently no way to restore annotations to a device with the plugin since I don't think there is a way to guarantee this to be reliable. Any small difference between the version of the book that the annotations were made in and the version that is on the device when the annotations are restored can cause them to be completely off. This is particularly relevant when automatically converting books to kepub on transfer. It's something that I would like to investigate more deeply but I probably won't have time for it soon.

As for why the annotations feature doesn't seem to show any actual annotations I'm not sure, it's possible that the database structure has changed. I don't currently have a device that's running the beta firmware so if someone has more information about this I would be interested in hearing it.

Get someone to send you the database from a v6.x firmware. Then you can have a look and see what's different.

rantanplan · 09-23-2026, 06:34 AM

Quote:

Originally Posted by JSWolf

Get someone to send you the database from a v6.x firmware. Then you can have a look and see what's different.

The database includes account information as well as all registered library cards. So, maybe don't do that.

JSWolf · 09-23-2026, 06:57 AM

Quote:

Originally Posted by rantanplan

The database includes account information as well as all registered library cards. So, maybe don't do that.

Whoever donates the database can go in and remove their account info and library info (if there is such). They can do this with the copy of the database.

Artexie · 09-23-2026, 01:52 PM

Hi,
I don't know whether this is the right place to submit the issue I am facing but I would like to know what to do if device database check says:

wrong # of entries in index content_bookid_index
wrong # of entries in index sqlite_autoindex_content_1
row 4 missing from index content_bookid_index
row 4 missing from index sqlite_autoindex_content_1

I have seen a post from like five years ago where the person already had a backup and was able to do something with it, but this is my first time using KoboUtilites and I wanted to create the initial backup in the first place. I think something might be wrong with this file: KoboReader.sqlite

I have already tried compresing the database. I have also tried to log out whilst saving the old KoboReader.sqlite file and afterwards I could make a backup but it also deleted all my reading progress and removed my books from my collections. The books stayed in the device though. Because it worked fine before, I replaced the new KoboReader.sqlite file with the old one, which returned all the reading data, but it again fails to backup.

The problem is that I do not understand the reason for it to fail to do so, because it works fine, runs fast and all the data is working correctly. I want the backup though, because I may lose the device and it would be handy.

Also, in calibre even with the backup issue I can see my data like reading time and so on, however when I close it the data dissappear from calibre and show only when I connect kobo again.

I am wondering if I could somehow keep only the Kobo % read and Kobo time spent reading and then log out, get new KoboReader.sqlite and just add the old Kobo % read and Kobo time spent reading to the book columns that had them initally. I do not really need any of the other data.

Thank you.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
[GUI Plugin] Kobo Utilities	davidfor	Plugins	3216	02-08-2025 04:23 AM
[GUI Plugin] Noosfere_util, a companion plugin to noosfere DB	lrpirlet	Plugins	2	08-18-2022 03:15 PM
[GUI Plugin] Save Virtual Libraries To Column (GUI)	chaley	Plugins	14	04-04-2021 05:25 AM
Kobo Utilities Plugin Question	nikev	Kobo Reader	10	09-25-2018 11:55 PM

09-06-2026, 02:12 PM	#601
recook Connoisseur Posts: 55 Karma: 10 Join Date: Aug 2018 Device: kobo Nia	Hi, thank you very much for the explanation. It seems now more complicated than before, but also working much better!

09-18-2026, 01:18 PM	#603
Quality Member Posts: 23 Karma: 10 Join Date: Dec 2024 Device: Tolino Shine 5	Hello, I have the Kobo Clara BW with the early access firmware version 5.18.270971. When I try to copy the annotations or highlights from the books using KoboUtilities I only the following information for each book. (Title, Author, Last read, Percentage read) " Fight Club · Der Roman zum Film by Palahniuk, Chuck Zuletzt gelesenes Buch: 2026-09-11 02:28:12 Prozent gelesen: 100% " The Kobo database KoboReader.sqlite does contain the annotations. I want to back them up with KoboUtilities so I can downgrade to the 4.x firmware and copy the books back and add the annotations back, if that is possible?

09-18-2026, 04:01 PM	#605
PeterT Grand Sorcerer Posts: 14,141 Karma: 83479096 Join Date: Nov 2007 Location: Toronto Device: Libra H2O, Libra Colour	I believe this is during the downgrade ftom 5.x to 4.x Sent from my SM-X238U using Tapatalk

09-19-2026, 12:39 PM	#606
Quality Member Posts: 23 Karma: 10 Join Date: Dec 2024 Device: Tolino Shine 5	If I'm not mistaken, when you downgrade everything gets deleted, the books and everything.

09-22-2026, 07:18 AM	#609
Quality Member Posts: 23 Karma: 10 Join Date: Dec 2024 Device: Tolino Shine 5	When I upgraded I didn't lose the books or highlights, but all the books were missing the Table of Contents and I couldn't fix it using KoboUtilities. New added books would have their ToC. The Tolino 5.x Firmware had also a ton of bugs that is why I installed the Kobo FW. I thought for this early release, that they had fixed most of the bugs, but it seems they haven't. Even though the Tolino 5.x FW is already out for more than 2 years. Really disappointed in Kobo how they can still have these bugs, and normal Tolino users are basically forced to use that Firmware.

09-23-2026, 02:09 AM	#610
Majutsushi Zealot Posts: 149 Karma: 11778 Join Date: Aug 2023 Location: New Zealand Device: Kobo Clara HD, Kobo Libra Colour	There is currently no way to restore annotations to a device with the plugin since I don't think there is a way to guarantee this to be reliable. Any small difference between the version of the book that the annotations were made in and the version that is on the device when the annotations are restored can cause them to be completely off. This is particularly relevant when automatically converting books to kepub on transfer. It's something that I would like to investigate more deeply but I probably won't have time for it soon. As for why the annotations feature doesn't seem to show any actual annotations I'm not sure, it's possible that the database structure has changed. I don't currently have a device that's running the beta firmware so if someone has more information about this I would be interested in hearing it.

09-23-2026, 01:52 PM	#614
Artexie Junior Member Posts: 1 Karma: 10 Join Date: Sep 2026 Device: Kobo Clara BW	Hi, I don't know whether this is the right place to submit the issue I am facing but I would like to know what to do if device database check says: wrong # of entries in index content_bookid_index wrong # of entries in index sqlite_autoindex_content_1 row 4 missing from index content_bookid_index row 4 missing from index sqlite_autoindex_content_1 I have seen a post from like five years ago where the person already had a backup and was able to do something with it, but this is my first time using KoboUtilites and I wanted to create the initial backup in the first place. I think something might be wrong with this file: KoboReader.sqlite I have already tried compresing the database. I have also tried to log out whilst saving the old KoboReader.sqlite file and afterwards I could make a backup but it also deleted all my reading progress and removed my books from my collections. The books stayed in the device though. Because it worked fine before, I replaced the new KoboReader.sqlite file with the old one, which returned all the reading data, but it again fails to backup. The problem is that I do not understand the reason for it to fail to do so, because it works fine, runs fast and all the data is working correctly. I want the backup though, because I may lose the device and it would be handy. Also, in calibre even with the backup issue I can see my data like reading time and so on, however when I close it the data dissappear from calibre and show only when I connect kobo again. I am wondering if I could somehow keep only the Kobo % read and Kobo time spent reading and then log out, get new KoboReader.sqlite and just add the old Kobo % read and Kobo time spent reading to the book columns that had them initally. I do not really need any of the other data. Thank you.