04-22-2024, 09:07 AM | #1 |
Custom User Title
Posts: 8,711
Karma: 62000001
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. |
04-22-2024, 10:23 AM | #2 |
the rook, bossing Never.
Posts: 11,275
Karma: 85874895
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. |
Advert | |
|
04-22-2024, 10:30 AM | #3 |
Custom User Title
Posts: 8,711
Karma: 62000001
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, 11:14 AM | #4 | |
Grand Sorcerer
Posts: 6,254
Karma: 11768331
Join Date: Jun 2009
Location: Madrid, Spain
Device: Kobo Clara/Aura One/Forma,XiaoMI 5, iPad, Huawei MediaPad, YotaPhone 2
|
Quote:
|
|
04-22-2024, 11:16 AM | #5 |
Custom User Title
Posts: 8,711
Karma: 62000001
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.
|
Advert | |
|
04-22-2024, 12:05 PM | #6 |
Grand Sorcerer
Posts: 6,254
Karma: 11768331
Join Date: Jun 2009
Location: Madrid, Spain
Device: Kobo Clara/Aura One/Forma,XiaoMI 5, iPad, Huawei MediaPad, YotaPhone 2
|
My sideloaded series too. So, only the series which are populated from kobo are untouched, isn't it?
|
04-22-2024, 12:14 PM | #7 |
Custom User Title
Posts: 8,711
Karma: 62000001
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, 01:49 PM | #8 |
Grand Sorcerer
Posts: 6,254
Karma: 11768331
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, 01:51 PM | #9 |
Grand Sorcerer
Posts: 6,254
Karma: 11768331
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, 03:02 PM | #10 |
Bibliophagist
Posts: 35,880
Karma: 145675564
Join Date: Jul 2010
Location: Vancouver
Device: Kobo Sage, Forma, Clara HD, 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?
|
04-22-2024, 04:02 PM | #11 |
Custom User Title
Posts: 8,711
Karma: 62000001
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 04: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 05:24 PM |
bulk setting tags | jmgant108 | Library Management | 1 | 08-04-2022 09:48 PM |
Bulk fill title with same value (like bulk rename author)? | rebl | Library Management | 1 | 08-22-2014 12:05 PM |
Setting up Calibre for email-not Gmail method. | Tight | Calibre | 1 | 01-04-2012 03:44 PM |
Setting series index in bulk metadata search&replace | bubak | Calibre | 4 | 12-19-2010 04:04 PM |