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

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

Notices

Reply
 
Thread Tools Search this Thread
Old 10-11-2017, 10:55 PM   #511
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,906
Karma: 47303822
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
Quote:
Originally Posted by vjjustin View Post
A quick question; is there any way to delete all the collections ONLY in Kobo? I know we can delete collections individually from kobo by long pressing each collection, but is there anyway to do it for all at once either through device or through calibre?

I have automatic collection management enabled in calibre but was trying some automatic folder management while sending books to kobo. So, now I have many collections with wrong book count. This is not getting fixed during regular calibre connect.

The only way I know to fix this is to delete all the collections in kobo and next time when I connect calibre/metadata will create all collections for me with correct book count, this has worked in the past. But I have around 100 collections and it will take a lot of time.
The count shown in the collections list is done when the collections list is built. If you are seeing anything other than the correct number of books, it means that some data in the database are inconsistent and that means something bad happened. My first thought, as compurandom suggested, is a corrupt database. You can check that with any SQLite database management tool, or my Kobo Utilities plugin in calibre. If it is corrupt, you will need to restore a backup or sign out of the Kobo account on the device and let it create a new database.

If the database isn't corrupt, but the data is inconsistent, you will probably need to use some SQL to fix things. The driver in calibre will maintain the collections, but it only makes changes for books that are in the calibre library and matched to books on the device. If the count for a collection is wrong, that means there is an entry in the database that points to a book not actually on the device. The collection management code in the driver won't do anything in this situation.

The simplest solution is to sign out of the Kobo account and back in. This will rebuild the database, download any synced books and collections, and import the sideloaded books. The next time you connect to calibre it will rebuild the collections.

The next way is using SQL as mentioned above. I'll help if you need it, but if your response to my suggestion is "Use what?", then don't try it.

Having said all that, have you restarted the device? That might fix it as it means the database is reread.
davidfor is offline   Reply With Quote
Old 10-12-2017, 07:36 AM   #512
compurandom
Guru
compurandom ought to be getting tired of karma fortunes by now.compurandom ought to be getting tired of karma fortunes by now.compurandom ought to be getting tired of karma fortunes by now.compurandom ought to be getting tired of karma fortunes by now.compurandom ought to be getting tired of karma fortunes by now.compurandom ought to be getting tired of karma fortunes by now.compurandom ought to be getting tired of karma fortunes by now.compurandom ought to be getting tired of karma fortunes by now.compurandom ought to be getting tired of karma fortunes by now.compurandom ought to be getting tired of karma fortunes by now.compurandom ought to be getting tired of karma fortunes by now.
 
Posts: 920
Karma: 417282
Join Date: Jun 2015
Device: kobo aura h2o, kobo forma
Quote:
Originally Posted by davidfor View Post
Having said all that, have you restarted the device? That might fix it as it means the database is reread.
I forgot about that -- it is possible for the in-memory copy of the database to be corrupt but the on disk version to be OK. In that case, restarting fixes it. I had that happen once.

If restarting doesn't fix it, then a wrong count is a sign of something deeper wrong in the database. Repairing indexes might fix it. If it doesn't, then short of a program to verify the semantics of the database vs. the the books on the device and all the books, not just the ones calibre knows about, you're going to have more problems later that are just easier to fix by rebuilding the database from scratch.
compurandom is offline   Reply With Quote
Advert
Old 10-12-2017, 09:27 AM   #513
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,906
Karma: 47303822
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
Quote:
Originally Posted by compurandom View Post
I forgot about that -- it is possible for the in-memory copy of the database to be corrupt but the on disk version to be OK. In that case, restarting fixes it. I had that happen once.
Usually it is the other way round. The file is corrupt and changes can't be save. When it is reread during a restart, older and probably inconsistent data is read.
Quote:
If restarting doesn't fix it, then a wrong count is a sign of something deeper wrong in the database. Repairing indexes might fix it. If it doesn't, then short of a program to verify the semantics of the database vs. the the books on the device and all the books, not just the ones calibre knows about, you're going to have more problems later that are just easier to fix by rebuilding the database from scratch.
Repairing the indexes is unlikely to fix it. There isn't an index that could be causing this.

But yes, the sooner it is fixed the better. And if isn't, it will probably get worse and if the firmware can't read it at all, it will reset the database and prompt to be setup.
davidfor is offline   Reply With Quote
Old 10-28-2017, 07:16 AM   #514
vjjustin
Enthusiast
vjjustin began at the beginning.
 
Posts: 47
Karma: 10
Join Date: Sep 2017
Device: Kobo Glo HD
Sorry forgot about this, .

In my case, this problem happens when I change the file name (title) and send the new file to kobo and before disconnecting also delete the original file. When this happens the kobo will consider it as two separate files and collections will show an additional file. But the difference is only in the collections and no other impact. This happens only if deletion and addition happens together; if you disconnect and add, the collections show correct values.

I ended up comparing every collection in kobo with calibre and deleting (in kobo) whatever showed difference. Logging out of kobo might have been easier, I believe. Also, restarting doesn't seem to fix it.

The database itself is okay. I did check with the kobo utilities, just to be sure.

A big thank you for the help.

Last edited by vjjustin; 10-28-2017 at 07:23 AM.
vjjustin is offline   Reply With Quote
Old 10-28-2017, 08:01 PM   #515
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,906
Karma: 47303822
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
Quote:
Originally Posted by vjjustin View Post
Sorry forgot about this, .

In my case, this problem happens when I change the file name (title) and send the new file to kobo and before disconnecting also delete the original file. When this happens the kobo will consider it as two separate files and collections will show an additional file. But the difference is only in the collections and no other impact. This happens only if deletion and addition happens together; if you disconnect and add, the collections show correct values.

I ended up comparing every collection in kobo with calibre and deleting (in kobo) whatever showed difference. Logging out of kobo might have been easier, I believe. Also, restarting doesn't seem to fix it.
That doesn't sound right. If you delete a book using calibre, then the driver will remove the collection entries for it. And if you add a book, it should add the collections entries. If you resend a book, and it ends up with a different file name, you will have two books. Calibre will see them as two copies of the same book, but the device will have two books. There should be collection entries for both books. And if you delete a book and then add it in the same session, all the entries for the book should be removed and then added.

And, if the collections don't end up correct after all the adds and deletes in a session, unplug the device, let it do its work and then connect again. The collection management will be done at this point for the books on the device that are in the calibre library. That should fix any inconsistencies from the above.
davidfor is offline   Reply With Quote
Advert
Old 10-30-2017, 05:18 PM   #516
Kuram
Enthusiast
Kuram began at the beginning.
 
Posts: 38
Karma: 10
Join Date: Aug 2013
Device: PW1, KAO (current)
I need help understanding part of the process for setting up the collections. As per the wiki: https://wiki.mobileread.com/wiki/Kob...nd_Collections


Specifically for the "Driver / calibre Configuration" section, what is the relevance of the custom column? Could I not simply setup the stock Series column alone to be the "collection" that the Kobo device uses?

Quote:
In the area for shelf info, type #myshelves, series.


This will ensure that calibre places books onto shelves listed in the myshelves calibre column and a shelf based on the book's series name
I don't understand the distinction here.
Kuram is offline   Reply With Quote
Old 10-30-2017, 05:30 PM   #517
Terisa de morgan
Grand Sorcerer
Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.
 
Terisa de morgan's Avatar
 
Posts: 6,286
Karma: 11806357
Join Date: Jun 2009
Location: Madrid, Spain
Device: Kobo Clara/Aura One/Forma,XiaoMI 5, iPad, Huawei MediaPad, YotaPhone 2
Quote:
Originally Posted by Kuram View Post
Specifically for the "Driver / calibre Configuration" section, what is the relevance of the custom column? Could I not simply setup the stock Series column alone to be the "collection" that the Kobo device uses?
Yes, you could use series, but if somebody wants to use another setup, custom column is the starting point.

Quote:
Originally Posted by Kuram View Post
I don't understand the distinction here.
The meaning is: The book will be in the collection defined by series AND in the collection defined by the custom column #myshelves.
Terisa de morgan is online now   Reply With Quote
Old 10-30-2017, 05:41 PM   #518
Kuram
Enthusiast
Kuram began at the beginning.
 
Posts: 38
Karma: 10
Join Date: Aug 2013
Device: PW1, KAO (current)
If I understand correctly, it would be a method to put a book into several different collections at once, then?

For example I could have Sanderson's Mistborn and The Stormlight Archives novels in their respective collections based on the series name, and then also have all of the novels combined into a custom column-defined series in #myshelves named Cosmere.
Kuram is offline   Reply With Quote
Old 10-30-2017, 06:02 PM   #519
Terisa de morgan
Grand Sorcerer
Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.
 
Terisa de morgan's Avatar
 
Posts: 6,286
Karma: 11806357
Join Date: Jun 2009
Location: Madrid, Spain
Device: Kobo Clara/Aura One/Forma,XiaoMI 5, iPad, Huawei MediaPad, YotaPhone 2
Yes, you are right. You can define as many columns as you like to be transformed in collections, separated by comma
Terisa de morgan is online now   Reply With Quote
Old 10-30-2017, 08:27 PM   #520
compurandom
Guru
compurandom ought to be getting tired of karma fortunes by now.compurandom ought to be getting tired of karma fortunes by now.compurandom ought to be getting tired of karma fortunes by now.compurandom ought to be getting tired of karma fortunes by now.compurandom ought to be getting tired of karma fortunes by now.compurandom ought to be getting tired of karma fortunes by now.compurandom ought to be getting tired of karma fortunes by now.compurandom ought to be getting tired of karma fortunes by now.compurandom ought to be getting tired of karma fortunes by now.compurandom ought to be getting tired of karma fortunes by now.compurandom ought to be getting tired of karma fortunes by now.
 
Posts: 920
Karma: 417282
Join Date: Jun 2015
Device: kobo aura h2o, kobo forma
Or you can use a tag valued column like the directions explain, and put a book in as many shelves as you want using just a single column.
compurandom is offline   Reply With Quote
Old 10-30-2017, 11:42 PM   #521
Kuram
Enthusiast
Kuram began at the beginning.
 
Posts: 38
Karma: 10
Join Date: Aug 2013
Device: PW1, KAO (current)
I'd rather handle it automatically through the series I've already got. I notice though, after trying it out this evening... Kobo collections don't seem to track the index number of the collection? Is there a way around that? The different sort options don't allow me to do this. When happened to be browsing the overdrive catalog through my Kobo, I noticed that the books were showing the series + index number so I am probably missing something.
Kuram is offline   Reply With Quote
Old 10-31-2017, 12:09 AM   #522
Terisa de morgan
Grand Sorcerer
Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.
 
Terisa de morgan's Avatar
 
Posts: 6,286
Karma: 11806357
Join Date: Jun 2009
Location: Madrid, Spain
Device: Kobo Clara/Aura One/Forma,XiaoMI 5, iPad, Huawei MediaPad, YotaPhone 2
Collections are not numbered, so they cannot track the index. But if you want that series and index appear in the list, the best way for sideloaded books, is to handle metadata automatically in calibre and connect the reader a second time after sending the book and the ereader has processed it.
Terisa de morgan is online now   Reply With Quote
Old 10-31-2017, 01:05 AM   #523
Kuram
Enthusiast
Kuram began at the beginning.
 
Posts: 38
Karma: 10
Join Date: Aug 2013
Device: PW1, KAO (current)
I'm sorry, I don't really understand how I'd do that. Would I use metadata plugboards to add the index to the title? Calibre already (seems to) track the index of the series in brackets.

Last edited by Kuram; 10-31-2017 at 01:10 AM.
Kuram is offline   Reply With Quote
Old 10-31-2017, 01:44 AM   #524
Terisa de morgan
Grand Sorcerer
Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.
 
Terisa de morgan's Avatar
 
Posts: 6,286
Karma: 11806357
Join Date: Jun 2009
Location: Madrid, Spain
Device: Kobo Clara/Aura One/Forma,XiaoMI 5, iPad, Huawei MediaPad, YotaPhone 2
Quote:
Originally Posted by Kuram View Post
I'm sorry, I don't really understand how I'd do that. Would I use metadata plugboards to add the index to the title? Calibre already (seems to) track the index of the series in brackets.
You would have to set:
  • "Preferences → Import/export → Sending books to devices" to "Automatic Management"
  • Check "Update metadata at the device -> Set series information" at Kobo driver.
and then the process is:
  1. Send a book to the ereader
  2. Eject the device
  3. After the device has processed the book (you're already again at the home page), connect it again to calibre
  4. After calibre finishes to process the books in device eject again the ereader

Now, at the library view, you should see an additional information for each book: series and number in series.

Anyway, perhaps this is better explained at the Kobo Driver thread, as it is not related at all with shelves/collection.

Last edited by Terisa de morgan; 10-31-2017 at 01:46 AM. Reason: Added info
Terisa de morgan is online now   Reply With Quote
Old 10-31-2017, 01:52 AM   #525
Kuram
Enthusiast
Kuram began at the beginning.
 
Posts: 38
Karma: 10
Join Date: Aug 2013
Device: PW1, KAO (current)
Thank you. I think I may have accidentally come across this, as I noticed some of my books now had the series + index right under the title after I restarted from patching it.
Kuram 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
Aura HD vs Touch vs Glo. themikeyt Kobo Reader 35 07-24-2014 05:39 PM
Aura HD calibre shelf management not working rkr Kobo Reader 3 10-06-2013 10:28 PM
Touch more slow than Glo and Aura? Lucas Malor Kobo Reader 1 09-17-2013 05:54 AM
Touch Shelf management on Touch timss Kobo Reader 7 07-18-2013 12:24 AM
Problem with Calibre Quick Start Guide! Neil Calibre 9 02-20-2010 12:34 AM


All times are GMT -4. The time now is 05:50 AM.


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