Thread: Export list of books from KoboReader.sqlite
View Single Post
Old 06-30-2022, 08:50 PM   #10
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 mortimer7 View Post
Hello, someone knows what is the column of readed books? In percentage column there isn't 100%, maybe because after read percentage returns to 0%
As clearly stated above, the percent read is stored in the column "___PercentRead". Please, believe me on that. That is where my Kobo Utilities plugin is fetching the percent read.

But, there is also a reading status column. This is "ReadStatus". It has values of "0" for unread, "1" for reading and "2" for finished. Under some circumstances, the book can be marked as read, but the reading percent is not set to 100. That can happen mainly for epubs but probably also happens when you mark the book as finished on the device rather than page past the end when reading.

And, my Kobo Utilities plugin takes this into account when is fetching the reading status, or when you restore the reading status to the device.
davidfor is offline   Reply With Quote