Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Readers > Kobo Reader > Kobo Tablets

Notices

Reply
 
Thread Tools Search this Thread
Old 01-27-2020, 09:23 AM   #1
acrobat
Junior Member
acrobat began at the beginning.
 
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.
acrobat is offline   Reply With Quote
Old 01-27-2020, 05:52 PM   #2
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,908
Karma: 47303748
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.
davidfor is offline   Reply With Quote
Advert
Old 01-28-2020, 05:04 AM   #3
acrobat
Junior Member
acrobat began at the beginning.
 
Posts: 8
Karma: 10
Join Date: Jan 2020
Device: Kobo Libra H20
Thank you davidfor.
It's ok.

Have a good day.
acrobat is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

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


All times are GMT -4. The time now is 07:21 PM.


MobileRead.com is a privately owned, operated and funded community.