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: 29,958
Karma: 55705602
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 |
05-08-2024, 11:09 AM | #993 |
Grand Sorcerer
Posts: 12,256
Karma: 74007256
Join Date: Nov 2007
Location: Toronto
Device: Nexus 7, Clara, Touch, Tolino EPOS
|
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: 36,598
Karma: 146496996
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,776
Karma: 7029857
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. |
|
05-08-2024, 07:10 PM | #996 |
Well trained by Cats
Posts: 29,958
Karma: 55705602
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,776
Karma: 7029857
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: 29,958
Karma: 55705602
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,776
Karma: 7029857
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,286
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. |
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 |