![]() |
#1 |
Custom User Title
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 9,207
Karma: 63194629
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 ![]() 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. |
![]() |
![]() |
![]() |
#2 |
the rook, bossing Never.
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 12,238
Karma: 89531599
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 | |
|
![]() |
#3 |
Custom User Title
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 9,207
Karma: 63194629
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.
|
![]() |
![]() |
![]() |
#4 | |
Grand Sorcerer
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 6,325
Karma: 12117215
Join Date: Jun 2009
Location: Madrid, Spain
Device: Kobo Clara/Aura One/Forma,XiaoMI 5, iPad, Huawei MediaPad, YotaPhone 2
|
Quote:
|
|
![]() |
![]() |
![]() |
#5 |
Custom User Title
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 9,207
Karma: 63194629
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 | |
|
![]() |
#6 |
Grand Sorcerer
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 6,325
Karma: 12117215
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?
|
![]() |
![]() |
![]() |
#7 |
Custom User Title
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 9,207
Karma: 63194629
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.
|
![]() |
![]() |
![]() |
#8 |
Grand Sorcerer
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 6,325
Karma: 12117215
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 |
![]() |
![]() |
![]() |
#9 |
Grand Sorcerer
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 6,325
Karma: 12117215
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.
|
![]() |
![]() |
![]() |
#10 |
Bibliophagist
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 38,932
Karma: 153006036
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?
|
![]() |
![]() |
![]() |
#11 |
Custom User Title
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 9,207
Karma: 63194629
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. |
![]() |
![]() |
![]() |
#12 |
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.
|
![]() |
![]() |
![]() |
#13 |
Custom User Title
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 9,207
Karma: 63194629
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. |
![]() |
![]() |
![]() |
#14 |
Grand Sorcerer
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 12,550
Karma: 74358018
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 |
![]() |
![]() |
![]() |
#15 |
Member
![]() Posts: 20
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) |
![]() |
![]() |
![]() |
|
![]() |
||||
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 |