07-12-2013, 12:13 PM | #181 |
Addict
Posts: 384
Karma: 1567
Join Date: Jul 2008
Location: UK
Device: Sony:505, 600, 350, 650, Kindle 3 & PW, Kobo Mini & Aura HD
|
I have to say a massive thank you for this plugin. I got my new aura last week and am totally loving this plugin. Makes life so much easier to keep track of everything and back it all up in case of emergency. I'm using it with my epubs converted using the kobo extended plugin to kepubs sideloaded onto an SD card and it all works great for me. Thank you so much, karma coming your way !
Last edited by babyd; 07-12-2013 at 12:16 PM. |
07-13-2013, 11:36 AM | #182 | |
Member
Posts: 10
Karma: 478472
Join Date: Jul 2013
Device: Kobo Glo
|
I use this plugin mainly to add the Reading Status to my library. But it doesn't work so good at the moment. I followed the instruction from PeterT and added the column #readstatus. But I don't get all states from my kobo. A lot of books are listed as #read, but after I used the "Store Bookmark" option, I don't get the finished status in my library. But after I open the book on my kobo again and use the option to mark the book as read, I got the finished status in my library. Does anyone know why I can't get the status without to remark the book as read?
Thank you Quote:
|
|
Advert | |
|
07-13-2013, 11:51 PM | #183 | |
Grand Sorcerer
Posts: 24,906
Karma: 47303822
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
|
Quote:
Looking at the template, it is reading the column #koboreadpct to determine if the book is read or not. Is this the column you are populating with the percent read when you store the reading status? And does it get updated correctly? |
|
07-14-2013, 02:54 PM | #184 | |
Member
Posts: 10
Karma: 478472
Join Date: Jul 2013
Device: Kobo Glo
|
Quote:
Thanks |
|
07-14-2013, 11:41 PM | #185 | ||
Grand Sorcerer
Posts: 24,906
Karma: 47303822
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
|
Quote:
- In the device list, do these books have "Read" as one of the collections? The driver is reading this information and calculating the collections. If it has "Read", then there is something happening in the plugin. - Could you run calibre in debug mode and post the log? Or PM me directly. This is done by ight clicking the preferences button and selecting "Restart in debug mode". Calibre will close and reopen with a message about the debug mode. Try a store for the books you are having trouble with. Then close calibre. It will open the debug log. I need to see the contents of that. Quote:
Code:
SELECT c1.ContentID, c1.ChapterIDBookmarked, c2.adobe_location, c1.ReadStatus, c1.___PercentRead, c1.Attribution, c1.DateLastRead, c1.Title, c1.MimeType, r.rating FROM content c1 LEFT OUTER JOIN content c2 ON c1.ChapterIDBookmarked = c2.ContentID LEFT OUTER JOIN ratings r ON c1.ContentID = r.ContentID WHERE c1.ContentType = 6 Note: I originally posted an old version of the SQL code above. I fixed that, but then I found an error. The above is the final version. Last edited by davidfor; 07-18-2013 at 03:44 AM. Reason: Wrong version of SQL code. |
||
Advert | |
|
07-15-2013, 11:28 AM | #186 | ||
Member
Posts: 10
Karma: 478472
Join Date: Jul 2013
Device: Kobo Glo
|
Quote:
Quote:
Thanks for the info about the DB, I will rummage through it and maybe I could ask you if I find somthing that looks strange to me |
||
07-15-2013, 11:31 PM | #187 | |
Grand Sorcerer
Posts: 24,906
Karma: 47303822
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
|
Quote:
Your made a comment in the PM about seeing books with 99% in the device database. The device doesn't always set the this to 100 when a book is finished. 99% probably means you actually finished the book. If you select it in the library list and mark it as finished, the ReadStatus will be set to 2, but the percent read won't be changed. The store code handles this. If the book is unread (ReadStatus=0), it stores null as the percent read. If it is finished (ReadStatus=2), it always stores 100. For books being read (ReadStatus=1), the percent read is copied from the database. For the 26 books that are "Read" in the device list, are they all in the calibre library? Looking at the log, there are 21 books that are on the device in the library. 1 is unread. 8 are being read with different percentage read starting with zero. The other 12 are finished. I don't see anything that would get to 18 books set to finished. Are you looking a the percent read column or another column that uses this value? |
|
07-16-2013, 12:40 AM | #188 |
Wizard
Posts: 4,812
Karma: 26912940
Join Date: Apr 2010
Device: sony PRS-T1 and T3, Kobo Mini and Aura HD, Tablet
|
I ma running the plugin on 1000 books which seems to take quite a while.
Not complaining mind you, but was wondering if there was a way to implement a checkbox that would just update the books that have the imreading or read flags set? Or the ability to run it from the device view where you could select the books with this info in the collection column. Helen |
07-16-2013, 01:11 AM | #189 |
Grand Sorcerer
Posts: 24,906
Karma: 47303822
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
|
Helen,
Are you using one of the beta builds I posted? I added a background option for the store and changed something (that was really stupid) in the SQL that improved the speed a lot. I'll look at the other options. I can't remember if from the device list is impossible, or that I was just lazy working out how to do it. |
07-16-2013, 01:20 AM | #190 | |
Wizard
Posts: 4,812
Karma: 26912940
Join Date: Apr 2010
Device: sony PRS-T1 and T3, Kobo Mini and Aura HD, Tablet
|
Quote:
I just assumed that it has been a while and that the beta would have made it into the mainstream. Generally I update my plugins on Fridays Helen |
|
07-16-2013, 01:33 AM | #191 |
Grand Sorcerer
Posts: 24,906
Karma: 47303822
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
|
|
07-16-2013, 01:40 AM | #192 |
Wizard
Posts: 4,812
Karma: 26912940
Join Date: Apr 2010
Device: sony PRS-T1 and T3, Kobo Mini and Aura HD, Tablet
|
I downloaded a beta and it is a zillion times faster. Disregard what I said before.
Helen |
07-16-2013, 01:44 AM | #193 |
Grand Sorcerer
Posts: 24,906
Karma: 47303822
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
|
Version 1.2.0
I have just uploaded Version 1.2.0. This has the following changes:
The last change is the only function difference from the last beta. The update will appear through calibre soon. As always, tell me about any problems or suggestions you have. |
07-16-2013, 01:56 AM | #194 | |
Grand Sorcerer
Posts: 24,906
Karma: 47303822
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
|
Quote:
I will still have a look at starting the store from the device list. From there you can easily select all the books in the "Read" or "Im_Reading" collections to do the store. I think that would be a useful thing to be able to do. |
|
07-16-2013, 10:48 AM | #195 | |
Member
Posts: 10
Karma: 478472
Join Date: Jul 2013
Device: Kobo Glo
|
Quote:
|
|
Tags |
calibre, kobo, kobo utilities, kobo-utilities, plugins |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
[GUI Plugin] Manga plugin | mastertea | Plugins | 6 | 01-06-2022 02:43 AM |
[GUI Plugin] Save Virtual Libraries To Column (GUI) | chaley | Plugins | 14 | 04-04-2021 05:25 AM |
Kobo Utilities Plugin Question | nikev | Kobo Reader | 10 | 09-25-2018 11:55 PM |
[GUI Plugin] Plugin Updater **Deprecated** | kiwidude | Plugins | 159 | 06-19-2011 12:27 PM |