Kobo Collection Manager revisited

[PeterT]

I stand corrected AGAIN. Helps if you have the shelf/collection setting done correctly in the driver.

The STANDARD Kobo Touch driver DOES sync shelves/collections on the initial sync. Info on Shelf Contents is stored in the table ShelfContent with the key being the location on the Kobo that the book has been stored.

on the other hand, SERIES info is stored in the Kobo Content table, which is the table populated by the eReader when it scans for content.

This is why CollectionManager sets collections on the initial connection, but then totally ignores series info.

[John F]

Originally Posted by JSWolf

The filename? What if I have two books with the same name?

Jon, could you download the collection manager and try it.

[PeterT]

Actually the filename is the fully qualified name; not just the epub. So for instance my testing had

INSERT INTO ShelfContent(rowid,ShelfName,ContentId,DateModified,_IsDeleted,_IsSynced) VALUES(381,'ToReadSoon','file:///mnt/onboard/Lawrence, Mark/Grey Sister - Mark Lawrence.epub','2025-04-23T17:56:53Z','false','false');

[JeanC]

I got most of my info from working with claude.ai and others. Lots of trial and error, then i asked it to go search github for how the calibre kobo driver does it, and i had an addon called autoshelf, who did a similar thing.
Conclusion, to add/modify collections you are dealing with tables shelf and shelfcontent. The main table however, content, should be left alone, the kobo handles that on reconnect.

I included my main.cpp, i'm open to suggestion, have been thinking like putting it up on github if there's interest.

Originally Posted by PeterT

Actually the filename is the fully qualified name; not just the epub. So for instance my testing had

INSERT INTO ShelfContent(rowid,ShelfName,ContentId,DateModified,_IsDeleted,_IsSynced) VALUES(381,'ToReadSoon','file:///mnt/onboard/Lawrence, Mark/Grey Sister - Mark Lawrence.epub','2025-04-23T17:56:53Z','false','false');

[jgray]

Unlike the others, this is just what I want - something that only handles collections. That was the only reason I installed Calibre. I don't use its other functions.

Thanks for posting about this.

[jgray]

How do I add a book to multiple collections? For example, Fiction and Mystery.