01-27-2020, 09:23 AM | #1 |
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 |
Grand Sorcerer
Posts: 24,907
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 To run it, you can use an SQLite database management program. There are several out there, pick the one you like. |
01-28-2020, 05:04 AM | #3 |
Junior Member
Posts: 8
Karma: 10
Join Date: Jan 2020
Device: Kobo Libra H20
|
Thank you davidfor.
It's ok. Have a good day. |
|
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 |