Kobo Collection Manager revisited

[PeterT]

Originally Posted by JSWolf

Thing is, at the moment, there's no program that I know of outside of calibre for managing series on a Kobo. And since you'd need calibre to manage series, it's a good idea to also manage collections.

NickelSeries by pgaskin supports the series info embedded in epub3 content. See NickelSeries https://pgaskin.net/kepubify/ns/

[Shohreh]

Does it work well on the Kobo Clara?

Because I have a couple of questions about assigning books to Collections on it:
1. In "My Books", is it possible to select multiple books and assign them all to the same Collection in one go?
2. In "My Books", hide books that were assigned to a Collection?

And ideally, is there a way to assign a book to a collection when copying it from the computer (ie. side-loaded), so I don't have to do that manually for each book?

---
"Download Kobo Collection Manager" → "Access to jcremers.com was denied. You don't have authorization to view this page. HTTP ERROR 403"

https://forum.jcremers.com/index.php/topic,677.new.html → Gateway time-out Error code 504

--
To add an item to a Collection…
1. Copy KoboReader.sqlite, right after a reboot, to avoid the "database disk image is malformed" and "Runtime error : UNIQUE constraint failed" errors
2. Open, and do an INSERT into the ShelfContent table
3. Copy the file back into the Kobo

I don't know how safe it is.

CREATE TABLE ShelfContent (
        ShelfName       TEXT,
        ContentId       TEXT,
        DateModified    TEXT,
        _IsDeleted      BOOL,
        _IsSynced       BOOL,
        PRIMARY KEY(ShelfName, ContentId)
);

CREATE TABLE Event (
        EventType INTEGER NOT NULL,
        FirstOccurrence TEXT,
        LastOccurrence TEXT,
        EventCount INTEGER DEFAULT 0,
        ContentID TEXT,
        ExtraData BLOB, Checksum TEXT,
        PRIMARY KEY (EventType, ContentID) );
);

SELECT date("LastOccurrence") as Date, ContentID as Title FROM Event WHERE ContentID IS NOT NULL AND ContentID IS NOT '' AND  ContentID NOT LIKE '%.png' AND ContentID NOT LIKE '%.txt' GROUP BY ContentID HAVING LastOccurrence = MAX(LastOccurrence) ORDER BY Date DESC limit 5;