|
|
Thread Tools | Search this Thread |
08-24-2010, 12:13 AM | #16 | |
himself
Posts: 576
Karma: 11226
Join Date: May 2010
Device: Kobo
|
Quote:
way I could manage it without db of all books, but make temporary one for the book I read. Which suits me, does not the rest of the forum. Something similar was used for cowon music players. My d2 makes db of all albums/artists and shows them regarding the query. Db is made pretty fast. Just as for books, I use directory search and follow directory tree to find what I like to listen to. Instances are too distinct to have mutual code for usage in our task. At least, let Kobo people do something themself and enjoy the reading. |
|
08-24-2010, 12:27 AM | #17 |
Member
Posts: 10
Karma: 28
Join Date: Aug 2010
Device: kobo
|
My interest was in removing Preloaded books I have read or stumbled over from the Books list when the "My Books" [only] option is selected. It appears that such books have ReadStatus = "2" in the content table. Thus, the SQL commands to sqlite to list such entries and to reset them to "unread" are respectively:
Code:
select Title, ReadStatus, FirstTimeReading from content where ReadStatus = "2"; update content set ReadStatus = '0', FirstTimeReading = 'true' where ReadStatus = "2"; |
08-27-2010, 03:17 AM | #18 | |
Enthusiast
Posts: 36
Karma: 12
Join Date: Aug 2010
Device: Kobo eReader
|
Quote:
I currently have one book in my database with ReadStatus = '2' and FirstTimeReading = 'true'. It's one of the internal books. I'll let you know if I receive any enlightenment about how exactly ReadStatus = '2' behaves. |
|
09-07-2010, 10:20 PM | #19 |
Addict
Posts: 305
Karma: 78651
Join Date: May 2010
Location: New Brunswick, Canada
Device: Kobo, Kobo Wifi, Kobo Touch
|
Just posting some additional info here:
As above, setting ReadStatus = '0' and FirstTimeReading = 'true' will remove the book from the I'm Reading list However, to add a book to the I'm Reading list it must have a DateLastRead as in: update content set ReadStatus=1, FirstTimeReading='false', DateLastRead='2010-09-08T23:10:10' where BookID is Null and ContentID = 'ENTER YOUR CONTENT ID HERE' That being said, I have successfully modified the I'm Reading list using Calibre for the first time. I have a bit of work to do but a future version of Calibre should support editing the I'm Reading list. Tim |
09-07-2010, 10:29 PM | #20 |
Zealot
Posts: 107
Karma: 250
Join Date: Jul 2010
Location: Brisbane, Australia
Device: Kobo, Sony PRS650
|
You are a legend Tim. Can't wait for this feature in calibre.
|
09-08-2010, 01:29 PM | #21 |
Connoisseur
Posts: 99
Karma: 94636
Join Date: Jun 2010
Device: kobo
|
sounds simple, and the setting should be easily added in the Kobo firmware...
|
09-08-2010, 01:50 PM | #22 | |
Addict
Posts: 305
Karma: 78651
Join Date: May 2010
Location: New Brunswick, Canada
Device: Kobo, Kobo Wifi, Kobo Touch
|
Quote:
I would lot rather have some options on the device to sort by some of the metadata like author for instance. |
|
09-09-2010, 06:34 AM | #23 | |
Enthusiast
Posts: 36
Karma: 12
Join Date: Aug 2010
Device: Kobo eReader
|
Quote:
|
|
09-09-2010, 07:09 AM | #24 | |
Addict
Posts: 305
Karma: 78651
Join Date: May 2010
Location: New Brunswick, Canada
Device: Kobo, Kobo Wifi, Kobo Touch
|
Quote:
It will be part of the stock Calibre driver. Its features should include:
Apparently much of Calibre can be used from the command line but I have never looked into it. A simple command-line script to clear the reading list would be fairly easy in theory but calibre looks after a lot of the complexities like which directory the device is mounted as etc. Anyone is welcome to use my code (once it is released) under the terms of the GPL but my time is pretty limited. Tim |
|
09-10-2010, 03:15 AM | #25 | ||
Enthusiast
Posts: 36
Karma: 12
Join Date: Aug 2010
Device: Kobo eReader
|
Quote:
Quote:
I don't expect you to go to the effort of coding this yourself, and the work you're already putting in is great. |
||
09-10-2010, 04:07 AM | #26 | |
himself
Posts: 576
Karma: 11226
Join Date: May 2010
Device: Kobo
|
Quote:
and complaints. There is a lot of them, of course, since it was started from the ground. A lot of code has to be remade, but the overall usage is pretty decent. Some new features should be added in a matter of weeks, to support device handling. Kovid does not put something in if nobody wants it. So, new thread on Calibre forum with question when it would be ready is what is needed for him to take into account. Some versions are better then others. 0.7.1 was stable as a rock. |
|
09-10-2010, 07:14 AM | #27 |
I make fjords.
Posts: 304
Karma: 11192
Join Date: Jul 2010
Location: Colorado
Device: kobo 1 (retired), kobo 2, iPad, G2, Galaxy Tab 7+
|
Huh? What are you loading EPUBs with? Only time books ever appear in "I'm Reading" on my 1.4 kobo is after I open them. New EPUBS should just be listed in "Books" after load.
|
09-10-2010, 07:30 AM | #28 | |
Addict
Posts: 305
Karma: 78651
Join Date: May 2010
Location: New Brunswick, Canada
Device: Kobo, Kobo Wifi, Kobo Touch
|
Quote:
However because of the way new books are processed I will not be able to update the database since the the row does not exist in the database until after the kobo processes the content. Tim |
|
09-10-2010, 10:49 AM | #29 |
Junior Member
Posts: 3
Karma: 10
Join Date: Aug 2010
Device: Android
|
One of the things that should be seriously looked at for the next firmware release is being able to skip to a particular page rather than being forced to use the chapter scheme.
|
09-10-2010, 05:47 PM | #30 |
I make fjords.
Posts: 304
Karma: 11192
Join Date: Jul 2010
Location: Colorado
Device: kobo 1 (retired), kobo 2, iPad, G2, Galaxy Tab 7+
|
I humbly stand corrected. I never noticed that freshly loaded books appeared in "I'm Reading" - even with a little 'new' symbol on 'em - until next plugin when they disappear. That's actually rather clever...
|
Tags |
i'm reading, kobo, sqlite |
Thread Tools | Search this Thread |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
how to remove Table of Contents at the end of news feed | TonytheBookworm | Calibre | 4 | 09-21-2010 10:19 AM |
Remove Books - Restoring Confirm to remove books | Caffey | Calibre | 6 | 09-20-2010 09:23 AM |
Anyone here remove books from sd card after reading? | clerky96 | Ectaco jetBook | 5 | 05-30-2010 11:34 PM |
How to remove a reader from Sony's list | Tdew | Sony Reader | 5 | 10-20-2009 09:10 AM |
Better reading experience - remove cover | ksri99 | Sony Reader | 4 | 02-11-2009 04:54 PM |