MobileRead Forums - View Single Post - Request to export data from the sqlite file

davidfor · 01-27-2020, 05:52 PM

The following SQL statement is what I would use:

Code:

SELECT Title, Attribution, DateLastRead, ReadStatus, LastTimeStartedReading, LastTimeFinishedReading, TimeSpentReading
FROM content
WHERE contentType = 6
AND ReadStatus > 0

That finds all the book records that have been started ("ReadStatus >0", 1 means reading, 2 is finished). It has the title author. I think the rest of the columns are descriptive. The "DateLastRead" will always have a value if "ReadStatus >0". The rest might not. If you use the "Mark as read", they will not. If you read the book on another device/app, these columns are not synced from there. "TimeSpentReading" is in seconds.

To run it, you can use an SQLite database management program. There are several out there, pick the one you like.

01-27-2020, 05:52 PM	#2
davidfor Grand Sorcerer Posts: 24,905 Karma: 47303824 Join Date: Jul 2011 Location: Sydney, Australia Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos	The following SQL statement is what I would use: Code: SELECT Title, Attribution, DateLastRead, ReadStatus, LastTimeStartedReading, LastTimeFinishedReading, TimeSpentReading FROM content WHERE contentType = 6 AND ReadStatus > 0 That finds all the book records that have been started ("ReadStatus >0", 1 means reading, 2 is finished). It has the title author. I think the rest of the columns are descriptive. The "DateLastRead" will always have a value if "ReadStatus >0". The rest might not. If you use the "Mark as read", they will not. If you read the book on another device/app, these columns are not synced from there. "TimeSpentReading" is in seconds. To run it, you can use an SQLite database management program. There are several out there, pick the one you like.