Plugboard, template, and custom composite column recipes

[BrandonGiesing]

Originally Posted by theducks

You can Manage the collections column: the (multi)select the collection name: click the delete icon

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

[theducks]

Oh! you are editing the Kobo DB

I tested only at Calibre

[PeterT]

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

[DNSB]

On the second page of the KoboTouch/KoboTouchExtended driver, check the box beside Delete Empty Bookshelves (Kobo used to refer to collections as bookshelves).

[chaley]

Originally Posted by DNSB

On the second page of the KoboTouch/KoboTouchExtended driver, check the box beside Delete Empty Bookshelves (Kobo used to refer to collections as bookshelves).

I experimented with this a bit. The Kobo driver doesn't actually delete the collections, instead setting them to "deleted". Collections with this status don't show on the Kobo but are still in the db. Others have speculated on how they can be made to be truly deleted, for example by doing a sync with the mothership. I don't know whether "deleted" collections have a significant performance impact.

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.

[theducks]

Does the Compress Device Database item on KU, do the actual purge?

[chaley]

Originally Posted by theducks

Does the Compress Device Database item on KU, do the actual purge?

Looking at the code, no. It does a "vacuum", which removes empty holes in the database. It doesn't do anything with "deleted" collections.

[BrandonGiesing]

Originally Posted by PeterT

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.

I haven't synced my device in literal months (last sync date was Nov 2023) cause it hasn't connected to Wifi so that isn't it.

Originally Posted by DNSB

On the second page of the KoboTouch/KoboTouchExtended driver, check the box beside Delete Empty Bookshelves (Kobo used to refer to collections as bookshelves).

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"

[Doum]

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

[theducks]

Originally Posted by Doum

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

AFAIK Calibre was not designed for that level of fineness.

But the following steps might work
1)

series:true and series_index:>=20

That gets you the list of 20+ series.
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

[chaley]

Originally Posted by Doum

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

Please don't double post.

See your original thread at https://www.mobileread.com/forums/sh...d.php?t=361245