Plugboard, template, and custom composite column recipes

[JJanssen]

Originally Posted by eschwartz

Sure.
It's a trick I saw used elsewhere, which makes for much more reusable code (and which I should've used back when someone was having a lot of trouble editing an attached python script ).

I've changed the bits around a little. It now uses the current library as the default, but you can also pass it an explicit path if you want to.

def init_cache(library_path = None):
	from calibre.db.backend import DB
	from calibre.db.cache import Cache
	from calibre.utils.config import prefs
	if library_path == None:
		library_path = prefs['library_path']
	backend = DB(library_path)
	cache = Cache(backend)
	cache.init()
	return cache

cache = init_cache()
#cache = init_cache('/Users/jasper/Documents/Calibre Main Library/')
#cache = init_cache(library_path = '/Users/jasper/Documents/Calibre Test Library/')
#
# The parameter can be empty, for the currently opened library, 
# or you can pass a specific Library's path if you wish.
#
#-------------------- Usage specific code starts here ------------------

import math
from collections import defaultdict

series_info = defaultdict(dict)
fract_ids = []
[.... etc ....]

Putting the prefs import inside the init_cache function is just more elegant, to my mind, and it also makes the thing even more reusable/readable. Putting the imports for math and defaultdict after the initialisation of the cache object is not *strictly* Python best practice, but in this case I think it's warranted because those are imports for the specific code we're writing in this go-around, and when ordered like this, everything up to line 19 is a straight copy/paste over to any script that wants to work with a calibre DB.

[saluli]

Hi! I am testing how to make a plugboard that results in something like this:

When there is a series:
[CUSTOMCOLUMN] (series [01]) - Title

When there is no series
[CUSTOMCOLUMN] - Title


But I am not sure how to do it.

For now, I managed to get
customcolumn - series [01] - Title
and
customcolunm - Title,
using
{#customcolumn} - {series}{series_index:0>2s| [|] - }{}{title}

What can I change to get my Uppercase and put the brackets and parentheses where I want them?

[eschwartz]

[{#customcolumn:uppercase()}]{series:| (|}{series_index:0>2s| [|])} - {title}

[amely]

hi

I searched forum and read this whole thread and even though question was asked few times but answers aren't really what I need.

when saving to disk if series index has decimal point (I don't know technical term) I need to switch to different template to save it the way I like or to rename when saved.

How I like series to look is series 01 , series 02 , series 02.10 etc...

to achieve that I use

{authors}/{series}/{authors} - {series} {series_index:0>2s|   | - }{title}

for regular numbers
and

{authors}/{series}/{authors} - {series} {series_index:0>5.2f|   | - }{title}

for decimal ones.


Is there a way to tell calibre to recognise that series index has decimal point and to use second template?

I don't know if it is possible nor how to write that command so any help would be appreciated, even if it is just to say it isn't possible at all.

[chaley]

Originally Posted by amely

hi

I searched forum and read this whole thread and even though question was asked few times but answers aren't really what I need.

when saving to disk if series index has decimal point (I don't know technical term) I need to switch to different template to save it the way I like or to rename when saved.

How I like series to look is series 01 , series 02 , series 02.10 etc...

to achieve that I use

{authors}/{series}/{authors} - {series} {series_index:0>2s|   | - }{title}

for regular numbers
and

{authors}/{series}/{authors} - {series} {series_index:0>5.2f|   | - }{title}

for decimal ones.


Is there a way to tell calibre to recognise that series index has decimal point and to use second template?

I don't know if it is possible nor how to write that command so any help would be appreciated, even if it is just to say it isn't possible at all.

Post 550 gives you the clue -- how to determine if a number (a series index) is an integer or has a decimal point. However, after some thought I came up with a more efficient way to do it. Here is an example template in General Program Mode:

program:
	no_decimal = template('{authors}/{series}/{authors} - {series} {series_index:0>2s|   | - }{title}');
	has_decimal = template('{authors}/{series}/{authors} - {series} {series_index:0>5.2f|   | - }{title}');
	contains(
		field('series_index'),
		'\.',
		has_decimal, 
		no_decimal)

[eschwartz]

chaley,

The simple answer is always the one we don't see.
Does it contain a period.

[amely]

Originally Posted by chaley

Post 550 gives you the clue -- how to determine if a number (a series index) is an integer or has a decimal point. However, after some thought I came up with a more efficient way to do it. Here is an example template in General Program Mode:

program:
	no_decimal = template('{authors}/{series}/{authors} - {series} {series_index:0>2s|   | - }{title}');
	has_decimal = template('{authors}/{series}/{authors} - {series} {series_index:0>5.2f|   | - }{title}');
	contains(
		field('series_index'),
		'\.',
		has_decimal, 
		no_decimal)

I'm sorry I missed it, I'll concentrate better next time when reading
I'm grateful you took time to make this more efficient way

[Penny_Dreadful]

I want to make a custom column that will show an icon when the amazon identifier is a Kindle ASIN which is 10 characters starting with "B" eg. amazon:B018E7HFDA or amazon:B01ARSC61U but not amazon:0451460715 or when there is no amazon identifier.

Thanks for any help

[Penny_Dreadful]

I've got as far as this

program: test(select(field('identifiers'),'amazon'),'1 ','')

which is how my goodreads identifier column works, but it's a simple yes or no query, either there is a goodreads identifier (an icon appears) or there isn't. It's the next bit, where I think I'll need a regex where I'm stumped.

[chaley]

Originally Posted by Penny_Dreadful

I've got as far as this

program: test(select(field('identifiers'),'amazon'),'1 ','')

which is how my goodreads identifier column works, but it's a simple yes or no query, either there is a goodreads identifier (an icon appears) or there isn't. It's the next bit, where I think I'll need a regex where I'm stumped.

Use an advanced column icon rule so you can use a GPM template. Here is one rule (template) that adds a wizard wand icon to the title column if an identifier matches my understanding of the pattern you specify. It uses re_group in an odd way to return a value only if the pattern matches.

You can of course put everything onto one line, making the select the first parameter to re_group. I didn't because assigning to "a" doesn't cost much (if anything) and makes the template much more readable.

[Penny_Dreadful]

Thank you so much, this is perfect!

[Schuhsohle]

Hi i am new to the organisation with Calibre and i need some advice to get some custom columns to work.

i want two custom colums on the top so i can sort my ebook to this preference.

Spoiler:

The first column should be the reading order like 1, 2, 3 . . .etc.
and the second should be the time where the story plays.

Spoiler:

so i dont know what i have to put in the spaces for the creation of an custom column to get this working.
oh and there are two different times XXXVSY and XXXNSY with NSY comes after VSY (it is the Timeline from Star Wars in German like BBY(Before the Battle of Yavin) and ABY (After the Battle of Yavin))

Spoiler:

I hope someone can help me

sorry for my bad english

[famewolf]

I have read and attempted various posts/tutorials on how to get the series and book number into the title for my kindle paperwhite. I have created a metadata plugboard specifying ANY Format (originally just mobi) for device KINDLE2 (which is what calibre tells me is connected when I plug my kindle paperwhite up) with the following being used for title: {series}{series_index:0>2s| – | – }{title}

However when I view the book on the device and in calibre's device view the series info is not present.

Any suggestions?

[eschwartz]

Plugboards are not supported for dual-MOBI ebooks. Make sure you are converting to AZW3.

[famewolf]

Originally Posted by eschwartz

Plugboards are not supported for dual-MOBI ebooks. Make sure you are converting to AZW3.

Thanks for the reply. I tried opening one of the books in question on the kindle and it told me it wasn't there even though I had sent it and it was displaying so I rebooted the kindle...when I did, all the files were displaying the way they should so I'll just write this one off as a gremlin.

Can you or anyone else suggest the best filter to use to get author, title, series and series # displayed? I ask because some books with long titles are scrolling off the screen when at the end. Perhaps it should be Book #, Book title, author, series?