Easiest method for bulk-setting SeriesID

[ownedbycats]

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.

[Quoth]

Download to PC and import via Calibre? That's what I do with books from Amazon or Kobo.
Series info is often wrong on ebooks from Amazon. I never noticed on the Series I bought from Kobo.

[ownedbycats]

I'd prefer to keep my books loaded from the Kobo store.

[Terisa de morgan]

Originally Posted by ownedbycats

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.

Isn't this the same that Kobo driver does? I mean, reading the comment, it looks like that.

[ownedbycats]

If I understood davidfor's post right, it was rolled into the KoboTouch driver at some point. My sideloaded series show up in the Series tab without using the Update Metadata feature.

[Terisa de morgan]

Originally Posted by ownedbycats

If I understood davidfor's post right, it was rolled into the KoboTouch driver at some point. My sideloaded series show up in the Series tab without using the Update Metadata feature.

My sideloaded series too. So, only the series which are populated from kobo are untouched, isn't it?

[ownedbycats]

Yes. I tried changing the series name and running KU's Update Metadata but it didn't change the SeriesID even with the option to update the Kobo ePubs selected.

[Terisa de morgan]

Have you tried?
1.- Connect device
2.- Device library
3.- Manage series

[Terisa de morgan]

If it doesn't work this, could you attach a debug log? I don't know very much the plugin, but I know it a bit as I have my own version.

[DNSB]

Do you have the Update purchased books checkbox checked on the Metadata, on device and advanced tab of the KoboTouch/KoboTouchExtended driver?

[ownedbycats]

Yes, I have it set to update store-bought books. If I change the series name it updates those. But it does not modify the SeriesID in the content table.

EDIT: From testing, it also doesn't update SeriesID if I update a sideloaded series name.

[Skaak]

Were you ever able to figure out a way to resolve this? I have the same problem: a series from the Kobo store had some volumes in a "separate" series because the publisher entered a different name. I was able to associate them with entries in Calibre and update the series name, but they still show as different series on the Kobo device (presumably because the IDs are different). Using KoboUtilities to "Manage series" doesn't actually appear to do anything beyond the original name change.

[ownedbycats]

I've resorted to manually editing the database with SQLiteStudio. I copy the series name into the SeriesID column.

Occasionally a sync will set the SeriesID back to the original one. Annoying, but thankfully it doesn't happen a lot.

[PeterT]

There is a setting in the device driver configuration to "update purchased books" on the metadata tab. Does setting that make any difference?

Sent from my Pixel 7a using Tapatalk

[Rugbyfan1986]

Can you not just load the books into calibre, and update the series data in calibre, then connect your kobo device and update metadate, without having to sideload the books.

You may have to do something to ensure the book on your kobo matches the book on calibre (someone with more knowledge than me should be able to enlighten you as to how to do this)