How can I manually enter number of "Hours Read" in Kobo Aura HD?

Question

I did a factory reset on my Kobo Aura HD ( but I did not backup KoboReader.sqlite file ). Now I do not have my previous reading stats.

I don't care about per book statistics but I want to manually enter "total Hours Read", how do I do that ?

UPDATE:

Following is a one row from my KoboReader.sqlite file Event table:

id:             11
EventType:      1021
FirstOccurence: 2015-02-17T12:20:34.000
LastOccurrence: 2015-02-17T12:21:13.000
EventCount:     2
ContentId:      file:///mnt/onboard/ebooks/Kościotrzep - Cherie Priest.epub
ExtraData:
Checksum:       ebbab9da762b1381853b5999319bed04

Glorifind · Answer 1 · 2015-05-20T12:03:38.270

1

The simplest way (still not simple one) is to connect your reader into linux machine and manually edit KoboReader.sqlite file via sqlite3. Now you need to know the structure of this database and try to find place where total hours read are stored. I don't have any Kobo reader so can't help you more.

edited May 20 '15 at 12:03

answered Feb 17 '15 at 12:41

Glorifind

350
1
10

Yes, You are right. There is a file KoboReader.sqlite and there is a table Event when all reading events are stored... but I can't change values there because there is also a checksum table and I don't know how to calculate it. – Michal Przybylowicz Feb 18 '15 at 10:04
Do you know the type of this checksum? Maybe this What is chcecksum will help? – Glorifind Feb 18 '15 at 13:21
I have updated my question with a row from Event table. – Michal Przybylowicz Feb 18 '15 at 15:14
The Calibre plugin Kobo Utilities makes changes to the database. If you're fluent in Python you might look at the sources and find out about the checksum. – lcd047 Apr 18 '15 at 07:04

How can I manually enter number of "Hours Read" in Kobo Aura HD?

1 Answers1