Easiest method for bulk-setting SeriesID

ownedbycats · 04-22-2024, 10:07 AM

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 · 04-22-2024, 11:23 AM

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 · 04-22-2024, 11:30 AM

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

Terisa de morgan · 04-22-2024, 12:14 PM

Quote:

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 · 04-22-2024, 12:16 PM

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 · 04-22-2024, 01:05 PM

Quote:

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 · 04-22-2024, 01:14 PM

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 · 04-22-2024, 02:49 PM

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

Terisa de morgan · 04-22-2024, 02:51 PM

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 · 04-22-2024, 04:02 PM

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

ownedbycats · 04-22-2024, 05:02 PM

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 · 05-11-2024, 11:46 AM

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 · 05-11-2024, 01:40 PM

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 · 05-11-2024, 01:59 PM

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 · 05-11-2024, 04:11 PM

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)

04-22-2024, 10:07 AM	#1
ownedbycats Custom User Title Posts: 9,569 Karma: 64960981 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 10:16 AM.

04-22-2024, 05:02 PM	#11
ownedbycats Custom User Title Posts: 9,569 Karma: 64960981 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	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. Last edited by ownedbycats; 04-22-2024 at 05:16 PM.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Bulk Tag Editing (Bulk-adding Prefixes for Heirarchical Tags)	Jackwc	Library Management	3	01-14-2024 06:24 PM
bulk setting tags	jmgant108	Library Management	1	08-04-2022 10:48 PM
Bulk fill title with same value (like bulk rename author)?	rebl	Library Management	1	08-22-2014 01:05 PM
Setting up Calibre for email-not Gmail method.	Tight	Calibre	1	01-04-2012 04:44 PM
Setting series index in bulk metadata search&replace	bubak	Calibre	4	12-19-2010 05:04 PM

04-22-2024, 11:23 AM	#2
Quoth the rook, bossing Never. Posts: 12,368 Karma: 92073397 Join Date: Jun 2017 Location: Ireland Device: All 4 Kinds: epub eink, Kindle, android eink, NxtPaper11	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.

04-22-2024, 11:30 AM	#3
ownedbycats Custom User Title Posts: 9,569 Karma: 64960981 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	I'd prefer to keep my books loaded from the Kobo store.

04-22-2024, 12:16 PM	#5
ownedbycats Custom User Title Posts: 9,569 Karma: 64960981 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	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.

04-22-2024, 01:14 PM	#7
ownedbycats Custom User Title Posts: 9,569 Karma: 64960981 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	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.

04-22-2024, 02:49 PM	#8
Terisa de morgan Grand Sorcerer Posts: 6,393 Karma: 12408443 Join Date: Jun 2009 Location: Madrid, Spain Device: Kobo Clara/Aura One/Forma,XiaoMI 5, iPad, Huawei MediaPad, YotaPhone 2	Have you tried? 1.- Connect device 2.- Device library 3.- Manage series

04-22-2024, 02:51 PM	#9
Terisa de morgan Grand Sorcerer Posts: 6,393 Karma: 12408443 Join Date: Jun 2009 Location: Madrid, Spain Device: Kobo Clara/Aura One/Forma,XiaoMI 5, iPad, Huawei MediaPad, YotaPhone 2	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.

04-22-2024, 04:02 PM	#10
DNSB Bibliophagist Posts: 40,573 Karma: 157444380 Join Date: Jul 2010 Location: Vancouver Device: Kobo Sage, Libra Colour, Lenovo M8 FHD, Paperwhite 4, Tolino epos	Do you have the Update purchased books checkbox checked on the Metadata, on device and advanced tab of the KoboTouch/KoboTouchExtended driver?

05-11-2024, 11:46 AM	#12
Skaak Junior Member Posts: 3 Karma: 10 Join Date: May 2024 Location: Washington State Device: Kobo Libra Colour	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.

05-11-2024, 01:40 PM	#13
ownedbycats Custom User Title Posts: 9,569 Karma: 64960981 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	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.

05-11-2024, 01:59 PM	#14
PeterT Grand Sorcerer Posts: 12,756 Karma: 75000002 Join Date: Nov 2007 Location: Toronto Device: Libra H2O, Libra Colour	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

Advert

Advert

05-11-2024, 04:11 PM	#15
Rugbyfan1986 Member Posts: 23 Karma: 10 Join Date: Aug 2021 Device: Kobo	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)