Request to export data from the sqlite file

acrobat · 01-27-2020, 09:23 AM

Hello,

I hope not to make a duplicate with this post.
I would like to export from the sqlite file, the following data: book read, start date, end date and total reading time for make excel sheet.
Anyone know how to do this?
Thank you for your help.

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.

acrobat · 01-28-2020, 05:04 AM

Thank you davidfor.
It's ok.

Have a good day.

01-27-2020, 09:23 AM	#1
acrobat Junior Member Posts: 8 Karma: 10 Join Date: Jan 2020 Device: Kobo Libra H20	Request to export data from the sqlite file Hello, I hope not to make a duplicate with this post. I would like to export from the sqlite file, the following data: book read, start date, end date and total reading time for make excel sheet. Anyone know how to do this? Thank you for your help.

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Cannot modify selected data within Export Calibre data	Pholipe	Library Management	1	09-05-2019 11:34 AM
Question about the db file in SQlite	Rellwood	Calibre	6	08-01-2017 10:25 PM
KoboReader.sqlite: export and reimport annotations or edit	gabryele	Kobo Reader	1	05-25-2017 12:15 AM
Glo koboreader.sqlite File	LaLaLia	Kobo Reader	3	10-05-2014 08:05 PM
request to update SQLite.dll	At_Libitum	Calibre	6	10-13-2013 04:14 PM

01-28-2020, 05:04 AM	#3
acrobat Junior Member Posts: 8 Karma: 10 Join Date: Jan 2020 Device: Kobo Libra H20	Thank you davidfor. It's ok. Have a good day.

Advert