Answers.Body: <p>The simplest way (still not simple one) is to connect your reader into linux machine and manually edit <em>KoboReader.sqlite</em> file via <em>sqlite3</em>. 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.  </p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-02-18T10:04:00.250Z
Answers.Text: 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.
Answers.UserDisplayName: Michal Przybylowicz
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-02-18T13:21:13.333Z
Answers.Text: Do you know the type of this checksum? Maybe this [What is chcecksum](http://www.geeksengine.com/article/checksum.html) will help?
Answers.UserDisplayName: Glorifind
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-02-18T15:14:01.307Z
Answers.Text: I have updated my question with a row from Event table.
Answers.UserDisplayName: Michal Przybylowicz
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-04-18T07:04:33.780Z
Answers.Text: The Calibre plugin [Kobo Utilities](http://www.mobileread.com/forums/showthread.php?t=215339) makes changes to the database.  If you're fluent in Python you might look at the sources and find out about the checksum.
Answers.UserDisplayName: lcd047
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-02-17T12:41:08.657Z
Answers.LastActivityDate: 2015-05-20T12:03:38.270Z
Answers.LastEditDate: 2015-05-20T12:03:38.270Z
Answers.UserDisplayName: Glorifind
Body: <p>I did a factory reset on my <strong>Kobo Aura HD</strong> ( but I did not backup <em>KoboReader.sqlite</em> file ). Now I do not have my previous reading stats.</p>
  
  <p>I don't care about per book statistics but I want to manually enter "total Hours Read", how do I do that ?</p>
  
  <p>UPDATE:</p>
  
  <p>Following is a one row from my <em>KoboReader.sqlite</em> file <em>Event</em> table:</p>
  
  <pre><code>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
  </code></pre>
  
Tags: <kobo>
Title: How can I manually enter number of "Hours Read" in Kobo Aura HD?
UserDisplayName: Michal Przybylowicz
ThreadText: # How can I manually enter number of "Hours Read" in Kobo Aura HD?
  
  (Asked by: username_0 on 2015-02-17)
  
  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
  
  **Tags:** kobo
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2015-02-17. Score: 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.
  
  > **Comments:**
  > **username_0**: 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.  
  > **username_1**: Do you know the type of this checksum? Maybe this [What is chcecksum](http://www.geeksengine.com/article/checksum.html) will help?  
  > **username_0**: I have updated my question with a row from Event table.  
  > **username_2**: The Calibre plugin [Kobo Utilities](http://www.mobileread.com/forums/showthread.php?t=215339) makes changes to the database.  If you're fluent in Python you might look at the sources and find out about the checksum.  
  
  ---
  
  