Kobo show wrong numbers of books in shelves/collection

[jiembe]

I had to replace an erroneous sqlite database in my Kobo Libra. It's result the Kobo display a wrong number of books in its shelves/collections.

Calibre don't see anything wrong in the database and compacting the database didn't solve the problem.

It's their a way of correcting the database other then delete/create each collections.

[JSWolf]

Originally Posted by jiembe

I had to replace an erroneous sqlite database in my Kobo Libra. It's result the Kobo display a wrong number of books in its shelves/collections.

Calibre don't see anything wrong in the database and compacting the database didn't solve the problem.

It's their a way of correcting the database other then delete/create each collections.

Do you have Automatic Management set in Preferences > Sending books to devices?

[jiembe]

No. It's set to Manual Management. Why ?

[JSWolf]

Originally Posted by jiembe

No. It's set to Manual Management. Why ?

The description of Automatic management is...

Automatic management: calibre automatically keeps metadata on the device in sync with the calibre library, on every connect

This will sort your problem.

[jiembe]

But Calibre don't manage the shelves on kobo. How could that help? I'm not a fan of automatic thing... So I'll do it if I am reassured about it.

[JSWolf]

Originally Posted by jiembe

But Calibre don't manage the shelves on kobo. How could that help? I'm not a fan of automatic thing... So I'll do it if I am reassured about it.

Calibre can manage the collections (no longer called shelves) on your Kobo. If you do that then Automatic management would sort the problem.

The problem is most likely that you did some collection management between your last backup and the database that became corrupt. There is no good reason not to let Calibre handle your collections. So go into Calibre, set Automatic management, check that your eBooks and the Kobo driver are set to use Tags & Series for collections. Then make sure Tags and Series are set correctly and let Calibre fix the problem. All you'd need to do is connect youe Kobo to the library and it will do it all for you. It's that easy.

[jiembe]

There is no good reason not to let Calibre handle your collections.

Yes there is. There's no direct link between the collection names on my kobo and Tags and Series in Calibre.

[chaley]

Originally Posted by jiembe

Yes there is. There's no direct link between the collection names on my kobo and Tags and Series in Calibre.

You can use any calibre columns, custom or not, for collections. Depending on how you organized your collections that might be one "Kobo Collections" column or specific data-oriented collection columns.

For example, I use two columns a template for collections. The template uses two columns to build collection names:

• The authors column. The template builds collections named "Authors: X" where X is the first letter of each author's last name.
• A special "tags" column that contains the collection names I want for each book. I currently have 18 possible values. No book currently uses more than 3.

It is true that it can take some time to map your existing collections onto columns in calibre then to enter the data. From my experience, back to the Sony PRS readers, it is worth it. I can easily see the same "collections" while using calibre without the device connected, and it is trivial to reload the reader if something goes wrong.

EDIT: mention I use templates.

[davidfor]

Originally Posted by jiembe

But Calibre don't manage the shelves on kobo. How could that help? I'm not a fan of automatic thing... So I'll do it if I am reassured about it.

You got me here. If you are not using calibre to do the collection management on the device, why are you asking here how to fix the problem? And calibre is perfectly capable of doing the collection management for you in many ways.

But, going back to the first post, how do you know the collection count is wrong? The number shown in the collection list is the number of books in the collection. You might not see them all when you open the collection if you have the filter set to not show all books. Otherwise, the only way it could be wrong, is if the entries in the database are inconsistent. And, I don't know how that could happen.

[jiembe]

why are you asking here how to fix the problem?

Because I need help with my kobo. This is the device thread is it not?
Because I use Calibre and I hoped that I could resolve the problem from Calibre (isn't why there is a database management in your KoboUtilities)

how do you know the collection count is wrong? The number shown in the collection list is the number of books in the collection. You might not see them all when you open the collection

Because when I do a search in my kobo with the books which respond to the criteria of the collection I find no more. And the search in kobo in this case is without any filter. And I don't use any filter in the kobo's books listing.

Oh also because kobo tell there is 12 books in the collection and I have only 10 books of the type in the kobo. Surely that's wrong isn't it?

[theducks]

Originally Posted by jiembe

Because I need help with my kobo. This is the device thread is it not?
Because I use Calibre and I hoped that I could resolve the problem from Calibre (isn't why there is a database management in your KoboUtilities)

For Kobo device help, you should use the Kobo Readers (as in hardware) forum
https://www.mobileread.com/forums/fo...play.php?f=223

This forum is for Calibre support FOR a specific device.

[jiembe]

OK I'm going to.

[davidfor]

Originally Posted by jiembe

Because I need help with my kobo. This is the device thread is it not?
Because I use Calibre and I hoped that I could resolve the problem from Calibre (isn't why there is a database management in your KoboUtilities)

This forum is for discussion of issues with calibre. And this section is for discussion of issues between calibre and the device. Your statement is that you are not creating collections on the device using calibre. Which suggests this is the wrong place to ask the question. Or we have misunderstood you.

Because when I do a search in my kobo with the books which respond to the criteria of the collection I find no more. And the search in kobo in this case is without any filter. And I don't use any filter in the kobo's books listing.

Oh also because kobo tell there is 12 books in the collection and I have only 10 books of the type in the kobo. Surely that's wrong isn't it?

If you are not using calibre for collection management, the collections are not automatic. You have to add the books to the collection. You either select the book and add it to a collection or you edit the collection and add a selection of books. Kobo has no automation for the collections. There are no searches involved. If you have a collection for a type of book, and you don't have all books of that type in the collection, it is because you did not put them into the collection.

But, if you aren't actually talking collections but either the Author or the Series list, that is a different. They are both automatically built from the books metadata so will change as you add or remove books without you doing anything else. I have never found any errors in this. The time there have appeared to be something wrong, it was the book. Either the author was different ("JRR Tolkein" vs "J. R. R. Tolkein") or the series was ("Lord of the Rings" vs "The Lord of the Rings"). Fixing the metadata fixed the lists.

[jiembe]

Originally Posted by davidfor

If you are not using calibre for collection management, the collections are not automatic. You have to add the books to the collection. You either select the book and add it to a collection or you edit the collection and add a selection of books. Kobo has no automation for the collections. There are no searches involved. If you have a collection for a type of book, and you don't have all books of that type in the collection, it is because you did not put them into the collection.

After some research I arrived at that conclusion (which wasn't evident for me: automatic is at the beginning manual !)

As I understand I could create a column, populate it with my own collection's names and then tell Calibre that #column is the collection link. Is it correct? What stop me now is creating a new column change the modify date of all books which is a problem since I'm using that date to follow through some reediting (as my css/html comprehension increase).

[JSWolf]

Originally Posted by jiembe

After some research I arrived at that conclusion (which wasn't evident for me: automatic is at the beginning manual !)

As I understand I could create a column, populate it with my own column's names and then tell Calibre that #column is the collection link. Is it correct? What stop me now is creating a new column change the modify date of all books which is a problem since I'm using that date to follow through some reediting (as my css/html comprehension increase).

You can create a new columns for collections or you can use the two existing columns. There is one called Tags that's used when you are creating collections that are not part of a series and one called Series when you do want to create collections based on series and/or use the Series column to populate the Series field in the Kobo database. You can have series on a Kobo without needing collections.