Thread: Aura H2O Start and end date for read books
View Single Post
Old 03-24-2018, 10:39 PM   #7
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 24,905
Karma: 47303824
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
Quote:
Originally Posted by Terisa de morgan View Post
Which is the field? The only thing I've found that it could be is "LastTimeStartedReading", and it looks like something for Sync. There is "DateAdded" and "DateCreated" but nothing I think it can be for starting.
The content table has the following dates/timestamps:
  • DateCreated - Date book added to your account. Should only be set for purchased kepub
  • DateLastRead - Last time you were reading the books
  • ___SyncTime - When the book was put on the device. For purchased books, this is when the file was synced from the server.
  • WishlistedDate - Not used.
  • DateAdded - Use for Pocket articles. I don't know if it is when the article was added to Pocket, or put on the device.
  • LastTimeStartedReading - Last time the ReadStatus was changed to 1. That means the book was opened from either the Unread or Finished states. But, only for purchased kepubs.
  • LastTimeFinishedReading - Last time the book was finished and ReadStatus was changed to 2. Again, only for purchased kepubs.
  • AdobeLoanExpiration - I assume this is when a library book borrowed and sideloaded through ADE will expire. I don't have any like this, so I'm not sure.

You seem to be right about LastTimeStartedReading. It looks like it is only populated if there is a sync. I'm reading a purchased kepub on my Aura H2O. Both LastTimeStartedReading and LastTimeFinishedReading are null. But, on my Glo HD, LastTimeStartedReading has a timestamp which would be about when I started it. It looks like these only get populated if you have multiple devices. I just tested this by opening the book on the Glo HD and syncing it and the Aura H2O. The LastTimeStartedReading on the Aura H2O now has a value. I don't see the point of doing it this way. Just set the value on the device the book is first opened on and then sync to the others.

Anyway, this all means that that field isn't that useful to extract. The newish field that I probably should be getting is probably "TimeSpentReading". This is the time in seconds spent reading and is populated for sideloaded books (at least when other elements of the stats recording is working).
davidfor is offline   Reply With Quote