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,985
Karma: 56143930
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 offline   Reply With Quote
Advert
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,269
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
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,859
Karma: 147879470
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,791
Karma: 7029971
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
Advert
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,985
Karma: 56143930
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 offline   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,791
Karma: 7029971
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,985
Karma: 56143930
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 offline   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,791
Karma: 7029971
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
Old 06-02-2024, 05:57 PM   #1002
maddz
Wizard
maddz ought to be getting tired of karma fortunes by now.maddz ought to be getting tired of karma fortunes by now.maddz ought to be getting tired of karma fortunes by now.maddz ought to be getting tired of karma fortunes by now.maddz ought to be getting tired of karma fortunes by now.maddz ought to be getting tired of karma fortunes by now.maddz ought to be getting tired of karma fortunes by now.maddz ought to be getting tired of karma fortunes by now.maddz ought to be getting tired of karma fortunes by now.maddz ought to be getting tired of karma fortunes by now.maddz ought to be getting tired of karma fortunes by now.
 
Posts: 1,297
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.
maddz is offline   Reply With Quote
Old 06-09-2024, 07:06 AM   #1003
maddz
Wizard
maddz ought to be getting tired of karma fortunes by now.maddz ought to be getting tired of karma fortunes by now.maddz ought to be getting tired of karma fortunes by now.maddz ought to be getting tired of karma fortunes by now.maddz ought to be getting tired of karma fortunes by now.maddz ought to be getting tired of karma fortunes by now.maddz ought to be getting tired of karma fortunes by now.maddz ought to be getting tired of karma fortunes by now.maddz ought to be getting tired of karma fortunes by now.maddz ought to be getting tired of karma fortunes by now.maddz ought to be getting tired of karma fortunes by now.
 
Posts: 1,297
Karma: 29121666
Join Date: Mar 2010
Location: UK
Device: Kobo Forma, Icarus, iPad Mini 2, Kobo Touch, Google Nexus 7
Quote:
Originally Posted by maddz View Post
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?
Well, in the end I created a custom column for the various nominations and used the following template:

{#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...
maddz is offline   Reply With Quote
Old 06-09-2024, 08:46 AM   #1004
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,791
Karma: 7029971
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
Quote:
Originally Posted by maddz View Post
Well, in the end I created a custom column for the various nominations and used the following template:

{#subseries:|| {#subseries_index} - } {#myshelves} {#hugonominees:|| - {#hugonominees}}
As said in the calibre template documentation, don't use subtemplates Single Function Mode.
Quote:
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.
Are you are referring to the last expression?
Code:
{#hugonominees:|| - {#hugonominees}}
The expression doesn't make sense to me. It appears to be trying to include #hugonominees twice, with a hyphen between them. And again, the subtemplate shouldn't be used.

I think you want
Code:
{#hugonominees:| - |}
Quote:
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...
The character() function works only in General Program Mode.

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
chaley is offline   Reply With Quote
Old 06-09-2024, 12:05 PM   #1005
maddz
Wizard
maddz ought to be getting tired of karma fortunes by now.maddz ought to be getting tired of karma fortunes by now.maddz ought to be getting tired of karma fortunes by now.maddz ought to be getting tired of karma fortunes by now.maddz ought to be getting tired of karma fortunes by now.maddz ought to be getting tired of karma fortunes by now.maddz ought to be getting tired of karma fortunes by now.maddz ought to be getting tired of karma fortunes by now.maddz ought to be getting tired of karma fortunes by now.maddz ought to be getting tired of karma fortunes by now.maddz ought to be getting tired of karma fortunes by now.
 
Posts: 1,297
Karma: 29121666
Join Date: Mar 2010
Location: UK
Device: Kobo Forma, Icarus, iPad Mini 2, Kobo Touch, Google Nexus 7
Quote:
Originally Posted by chaley View Post
As said in the calibre template documentation, don't use subtemplates Single Function Mode.
Are you are referring to the last expression?
Code:
{#hugonominees:|| - {#hugonominees}}
The expression doesn't make sense to me. It appears to be trying to include #hugonominees twice, with a hyphen between them. And again, the subtemplate shouldn't be used.

I think you want
Code:
{#hugonominees:| - |}
The character() function works only in General Program Mode.

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
The expression is used in the Kobo Utilities output plugboards to define the output to the Subtitle field. I think it was Davidfor who helped me to set it up initially because of the problems with sorting braided series (I use a main series with the index as the internal chronology, and the subseries is added as appropriate; if you include the subseries in the series output, it doesn't sort properly - all entries with a subseries sort to the end of the list).

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.
maddz 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 11:51 PM.


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