4

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
Improve this question

1 Answer 1

Reset to default
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.

Improve this answer
4
  • 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, 2015 at 10:04
  • Do you know the type of this checksum? Maybe this What is chcecksum will help?
    – Glorifind
    Feb 18, 2015 at 13:21
  • I have updated my question with a row from Event table.
    – Michal Przybylowicz
    Feb 18, 2015 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, 2015 at 7:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.