![]() |
#16 |
Custom User Title
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 9,155
Karma: 62872439
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
|
As stated in post #11, that does not update the SeriesID. It only updates Series.
|
![]() |
![]() |
![]() |
#17 |
Junior Member
![]() Posts: 3
Karma: 10
Join Date: May 2024
Location: Washington State
Device: Kobo Libra Colour
|
I checked, and this setting was admittedly not checked for me in the KoboTouchExtended preferences. I set it, ejected the device, and reconnected it (to ensure the metadata sync occurred; I have trouble getting it to fire off manually outside of connection events). Didn't make any difference (I was successfully able to update the series name prior to this setting being enabled, but despite being named the same--and treated as the same series in Calibre--on the device the books are still shown as in two different, now identically-named series). Thank you for the suggestion, though! Hopefully this setting will make other metadata edits more transparent when I associate purchased books with local Calibre records.
|
![]() |
![]() |
![]() |
#18 | |
Junior Member
![]() Posts: 3
Karma: 10
Join Date: May 2024
Location: Washington State
Device: Kobo Libra Colour
|
Quote:
I need to figure out who to pester to get this properly implemented in the normal synching behavior; it's vexing that a metadata sync will update the name but not the ID. |
|
![]() |
![]() |
![]() |
#19 |
Custom User Title
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 9,155
Karma: 62872439
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
|
I haven't seen any weird effects of using this SQLite query, but backup first to be safe.
Code:
UPDATE content SET SeriesID = Series; |
![]() |
![]() |
![]() |
#20 | |
Groupie
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 186
Karma: 616200
Join Date: May 2014
Location: Spain
Device: Kobo Forma, Hisense A5
|
Quote:
As for @skaak suggestion of getting it integrated the update of that column in Kobo Utilities, due to Kobo updating it, I don't think it would be practical. I update manually that column putting the values Kobo uses in the store for downloaded books of the same series, and in some cases, I had to let two different values, mostly when I mixed American and UK editions of a series. |
|
![]() |
![]() |
![]() |
#21 |
Custom User Title
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 9,155
Karma: 62872439
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
|
Syncing with the store doesn't always reset it. I'm not sure what triggers it to split apart into a dozen series again, though adding a new book to the series sometimes (but not 100%) does it.
Unfortunately, Kobo Utilities is not maintained anymore since davidfor's passing so it's all community patches. My python isn't quite good enough to attempt it myself. Last edited by ownedbycats; 06-17-2024 at 04:19 PM. |
![]() |
![]() |
![]() |
#22 | |
Grand Sorcerer
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 6,319
Karma: 12117215
Join Date: Jun 2009
Location: Madrid, Spain
Device: Kobo Clara/Aura One/Forma,XiaoMI 5, iPad, Huawei MediaPad, YotaPhone 2
|
Quote:
|
|
![]() |
![]() |
![]() |
#23 |
Custom User Title
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 9,155
Karma: 62872439
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
|
I'm seeing ContentType=6 on both store books and sideloads.
|
![]() |
![]() |
![]() |
#24 |
Grand Sorcerer
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 6,319
Karma: 12117215
Join Date: Jun 2009
Location: Madrid, Spain
Device: Kobo Clara/Aura One/Forma,XiaoMI 5, iPad, Huawei MediaPad, YotaPhone 2
|
Then, in theory, it should update all of them. If I'm able this weekend (or some point this week), I'll try to enable debug and see what's happening with the series.
|
![]() |
![]() |
![]() |
#25 |
Custom User Title
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 9,155
Karma: 62872439
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
|
I suspect that the SeriesID never gets changed by the Kobo driver or Utilities once it's first set - when changing the name of a sideloaded series and then syncing metadata, the SeriesID remains unmodified.
|
![]() |
![]() |
![]() |
#26 | |
Custom User Title
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 9,155
Karma: 62872439
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
|
Quote:
The SQLite query from #19 put everything back in order. |
|
![]() |
![]() |
![]() |
|
![]() |
||||
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 |