Clara BW Automated way to keep track of books read?

[Shohreh]

Hello,

Title says it all: Is there an automated way to keep track of books I read and removed, considering I only read side-loaded books?

If possible, I'd rather avoid re-installing KOReader because the stock firmware is good enough for my needs. Also, I just copy files manually to the Kobo through a file manager — I only bother with Calibre to remove DRM's when needed.

Maybe in the KoboReader.sqlite file?

sqlite> .tables
AbTest                 KoboPlusAssetGroup     Tab
Achievement            KoboPlusAssets         Wishlist
Activity               OverDriveCards         WordList
AnalyticsEvents        OverDriveCheckoutBook  content
Authors                OverDriveLibrary       content_keys
BookAuthors            Reviews                content_settings
Bookmark               Rules                  ratings
DbVersion              Shelf                  shortcover_page
DropboxItem            ShelfContent           user
Event                  SubscriptionProducts   volume_shortcovers
GDriveItem             SyncQueue              volume_tabs

Thank you.

[Sirtel]

With calibre it's easy. Otherwise, no idea.

[Shohreh]

Provided there's no other way to keep track of books, can copying a file to the Kobo through Calibre be done through the command-line?

[Sirtel]

Originally Posted by Shohreh

Provided there's no other way to keep track of books, can copying a file to the Kobo through Calibre be done through the command-line?

I think so, but you'll still need to use the UI to save the reading progress from your Kobo to calibre (the Kobo Utilities plugin does that). I don't think you can do that via command line. I may be wrong, of course.

[Shohreh]

It's possible to list files added to Calibre, but it obviously misses DRM-free books I copied directly to the Kobo

"C:\Program Files\Calibre2\calibredb.exe" list

Maybe someone knows if the Kobo firmware keeps track of all EPUBs ever copied into the reader, which would solve the problem.

[Shohreh]

What about the Event table in KoboReader.sqlite, as copied just after a reboot to avoid the "Runtime error: database disk image is malformed (11)"?

sqlite> .schema Event
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 DISTINCT ContentID FROM Event ORDER BY LastOccurrence DESC LIMIT 10