Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management

Notices

Reply
 
Thread Tools Search this Thread
Old 05-08-2024, 04:07 AM   #991
BrandonGiesing
Member
BrandonGiesing began at the beginning.
 
BrandonGiesing's Avatar
 
Posts: 14
Karma: 10
Join Date: Apr 2022
Location: Missouri, USA
Device: Kobo Sage & Kindle Paperwhite 4
Quote:
Originally Posted by theducks View Post
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
BrandonGiesing is offline   Reply With Quote
Old 05-08-2024, 09:27 AM   #992
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 29,912
Karma: 55267620
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
theducks is online now   Reply With Quote
Old 05-08-2024, 11:09 AM   #993
PeterT
Grand Sorcerer
PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.
 
PeterT's Avatar
 
Posts: 12,234
Karma: 74000000
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
PeterT is offline   Reply With Quote
Old 05-08-2024, 06:46 PM   #994
DNSB
Bibliophagist
DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.
 
DNSB's Avatar
 
Posts: 36,252
Karma: 145735552
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).
DNSB is online now   Reply With Quote
Old 05-08-2024, 06:56 PM   #995
chaley
Grand Sorcerer
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 11,768
Karma: 7029857
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
Quote:
Originally Posted by DNSB View Post
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.
chaley is offline   Reply With Quote
Old 05-08-2024, 07:10 PM   #996
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 29,912
Karma: 55267620
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?
theducks is online now   Reply With Quote
Old 05-08-2024, 07:24 PM   #997
chaley
Grand Sorcerer
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 11,768
Karma: 7029857
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
Quote:
Originally Posted by theducks View Post
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.
chaley is offline   Reply With Quote
Old 05-11-2024, 08:34 PM   #998
BrandonGiesing
Member
BrandonGiesing began at the beginning.
 
BrandonGiesing's Avatar
 
Posts: 14
Karma: 10
Join Date: Apr 2022
Location: Missouri, USA
Device: Kobo Sage & Kindle Paperwhite 4
Quote:
Originally Posted by PeterT View Post
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.


Quote:
Originally Posted by DNSB View Post
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"
BrandonGiesing is offline   Reply With Quote
Old 05-15-2024, 12:40 PM   #999
Doum
Connoisseur
Doum began at the beginning.
 
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.
Doum is offline   Reply With Quote
Old 05-15-2024, 12:51 PM   #1000
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 29,912
Karma: 55267620
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
Quote:
Originally Posted by Doum View Post
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)
Code:
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
theducks is online now   Reply With Quote
Old 05-15-2024, 01:00 PM   #1001
chaley
Grand Sorcerer
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 11,768
Karma: 7029857
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
Quote:
Originally Posted by Doum View Post
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
chaley is offline   Reply With Quote
Reply

Tags
custom column, tag, tags

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

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


All times are GMT -4. The time now is 06:59 PM.


MobileRead.com is a privately owned, operated and funded community.