05-08-2024, 04:07 AM | #991 |
Member
Posts: 14
Karma: 10
Join Date: Apr 2022
Location: Missouri, USA
Device: Kobo Sage & Kindle Paperwhite 4
|
Tried that like 20 times, restarted Calibre, my PC, and the Kobo even, and the collections never deleted off the Kobo Manually editing the database was the only way that finally got rid of them
|
05-08-2024, 09:27 AM | #992 |
Well trained by Cats
Posts: 30,409
Karma: 58055234
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
|
Oh! you are editing the Kobo DB
I tested only at Calibre |
Advert | |
|
05-08-2024, 11:09 AM | #993 |
Grand Sorcerer
Posts: 12,650
Karma: 74500000
Join Date: Nov 2007
Location: Toronto
Device: Libra H2O, Libra Colour
|
I think one issue with editting the Kobo database is that the device does a sync with the Kobo servers; I think there is an option in Kobo Utilities to cleanse the collections which I again think sets a date of change on the rows to allow the sync to have the desired effect.
Sent from my Pixel 7a using Tapatalk |
05-08-2024, 06:46 PM | #994 |
Bibliophagist
Posts: 39,853
Karma: 154147706
Join Date: Jul 2010
Location: Vancouver
Device: Kobo Sage, Libra Colour, Lenovo M8 FHD, Paperwhite 4, Tolino epos
|
On the second page of the KoboTouch/KoboTouchExtended driver, check the box beside Delete Empty Bookshelves (Kobo used to refer to collections as bookshelves).
|
05-08-2024, 06:56 PM | #995 | |
Grand Sorcerer
Posts: 11,961
Karma: 7225107
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
|
Quote:
I also found that collections won't go away (be set to "deleted) unless there is an actual template in the template box or an actual column name in the collections box, or both. Interestingly enough, the column name doesn't need to be a real column. Example: I was able to delete all my collections by setting the collections column box to the lookup name "foobar", which of course doesn't exist. How to change this behavior isn't obvious because it is likely that some people depend on how it currently works. I am strongly tempted to leave it the way it is. Of course, Preferences / Sending to device / Metadata management must be set to automatic for any of this to happen. |
|
Advert | |
|
05-08-2024, 07:10 PM | #996 |
Well trained by Cats
Posts: 30,409
Karma: 58055234
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
|
Does the Compress Device Database item on KU, do the actual purge?
|
05-08-2024, 07:24 PM | #997 |
Grand Sorcerer
Posts: 11,961
Karma: 7225107
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
|
|
05-11-2024, 08:34 PM | #998 | |
Member
Posts: 14
Karma: 10
Join Date: Apr 2022
Location: Missouri, USA
Device: Kobo Sage & Kindle Paperwhite 4
|
Quote:
Which has nothing to do with my issue cause none of the shelves were "empty", that only deletes collections when all books inside said collection have been removed from the device, I didn't remove any books so none of the collections I no longer wanted were "empty" |
|
05-15-2024, 12:40 PM | #999 |
Connoisseur
Posts: 60
Karma: 10
Join Date: Jun 2020
Device: Kobo Aura HD
|
Searh serie name with condition
Hello,
Do you know how i can do a search for serie name where their serie_index can be greater than 20 for example . I only want the serie name , not all ebooks with serie_index > 20, or any template ... just a search method with serie name as result Thanks for your help Last edited by Doum; 05-15-2024 at 12:43 PM. |
05-15-2024, 12:51 PM | #1000 | |
Well trained by Cats
Posts: 30,409
Karma: 58055234
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
|
Quote:
But the following steps might work 1) Code:
series:true and series_index:>=20 Now create a CSV Catalog with only the series name. (Catalog respects the current view) Alternate way if your SQL foo is moderate is to use a SQL Browser (for SQL Lite) and roll your own query |
|
05-15-2024, 01:00 PM | #1001 | |
Grand Sorcerer
Posts: 11,961
Karma: 7225107
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
|
Quote:
See your original thread at https://www.mobileread.com/forums/sh...d.php?t=361245 |
|
06-02-2024, 05:57 PM | #1002 |
Wizard
Posts: 1,320
Karma: 29121666
Join Date: Mar 2010
Location: UK
Device: Kobo Forma, Icarus, iPad Mini 2, Kobo Touch, Google Nexus 7
|
Can someone help with editing a template in the Kobo Utilities plug-in?
Currently, I use the subtitle field for subseries & index: {#subseries:|| {#subseries_index} - } {#myshelves} What I want to do is add a new bit which will pull through any "From Where" fields (#fromwhere) that contain the word "Nominee", separating them with a comma if there are more than one. This should be on a new line if there is an entry for subseries. Is that doable? Last edited by maddz; 06-02-2024 at 05:59 PM. |
06-09-2024, 07:06 AM | #1003 | |
Wizard
Posts: 1,320
Karma: 29121666
Join Date: Mar 2010
Location: UK
Device: Kobo Forma, Icarus, iPad Mini 2, Kobo Touch, Google Nexus 7
|
Quote:
{#subseries:|| {#subseries_index} - } {#myshelves} {#hugonominees:|| - {#hugonominees}} However, I don't understand why it isn't inserting the hyphen between my shelves and the nominations list when there is an entry in the latter field. Ideally, I want each section to be on a separate line, but I can't figure out newlines in the template language. I am guessing I should use something like character('newline') or \n... |
|
06-09-2024, 08:46 AM | #1004 | |||
Grand Sorcerer
Posts: 11,961
Karma: 7225107
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
|
Quote:
Quote:
Code:
{#hugonominees:|| - {#hugonominees}} I think you want Code:
{#hugonominees:| - |} Quote:
I think this GPM template gets close to what you want. Code:
program: # This template produces a three line result. # Line 1 is the subseries, or - if there isn't one. # Line 2 is the shelves, or '-' if there aren't any # Line 3 is the hugo nominees, or '-' if there aren't any ss = $subseries; ssi = $subseries_index; if ss then ss_res = ss & ' - ' & ssi else ss_res = '-' fi; shelves = ifempty($#myshelves, '-'); hugo = ifempty($hugonominees, '-'); return ss_res & character('newline') & shelves & character('newline') & hugo |
|||
06-09-2024, 12:05 PM | #1005 | |
Wizard
Posts: 1,320
Karma: 29121666
Join Date: Mar 2010
Location: UK
Device: Kobo Forma, Icarus, iPad Mini 2, Kobo Touch, Google Nexus 7
|
Quote:
The || is to suppress the function if there is no entry in the field prior to || (so I don't get " - My Shelves" if there is no entry for a subseries but I get just "My Shelves" instead). I output 'My Shelves' so I can see at a glance if a particular series is split across multiple shelves - which has happened - so I know to update Calibre to correct the error. Given I have 6700+ ebooks collected since the early 2000s, eyeballing the Calibre list makes for easily missed inconsistencies. It's been cleaned up over the years though, so eventually I'll drop that section of the plugboard. What it's doing is if there are entries in all 3 fields is producing the output: 'Subseries' 'Subseries Index' - 'My Shelves' 'Hugo Nominations' What I want it to do is produce: 'Subseries' 'Subseries Index' - 'My Shelves' - 'Hugo Nominations' Ideally, it should be: 'Subseries' 'Subseries Index' 'My Shelves' 'Hugo Nominations' But I am not sure if the subtitle field can take more than one line... If there is less than three entries (every title will have 'My Shelves'), the line breaks for the subseries and Hugos should be suppressed, so there is either 1 line or 2 lines: 'My Shelves' or 'Subseries' Subseries Index' 'My Shelves' or 'My Shelves' 'Hugo Nominations' I hope this makes sense! I'm fiddling with the output now, as I am trying to prioritise my reading; some novels from the packet are in the Best Editor nominations, and they are low priority, so I want to see which unread title to go for first. |
|
Tags |
custom column, tag, tags |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
custom column i need a little help | shinken | Calibre | 3 | 09-15-2010 03:41 AM |
Using Custom Metadata in Save Template | EJvdH | Calibre | 1 | 07-02-2010 06:06 AM |
Accessories Decalgirl Kindle 2 custom skin template | srmalloy | Amazon Kindle | 6 | 04-09-2010 09:55 PM |
Donations for Custom Recipes | ddavtian | Calibre | 5 | 01-23-2010 04:54 PM |
Help understanding custom recipes | andersent | Calibre | 0 | 12-17-2009 02:37 PM |