View Single Post
Old 04-22-2024, 09:07 AM   #1
ownedbycats
Custom User Title
ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.
 
ownedbycats's Avatar
 
Posts: 8,841
Karma: 62032373
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
Bulk-setting of SeriesID

So there's a a series on the Kobo Store that for some stupid reason got split up into a bunch of smaller series. As I load my books from the store, this resulted in nearly a dozen duplicates on the Series tab.

After some investigation (and experimentation - don't worry, I took a backup ) I found that setting the SeriesID column in the content table of KoboReader.sqlite could merge them.

Is there some easier way to set this without pulling out SQLiteStudio all the time?

The now-unmaintained KoboUtilities has the option to set SeriesID, but it apparently leaves the one from storebought kepubs alone.

Last edited by ownedbycats; 04-22-2024 at 09:16 AM.
ownedbycats is offline   Reply With Quote