Templates: various questions not worth their own thread

[chaley]

Originally Posted by ownedbycats

Question: Rarely when updating a saved template, I get an error about it being duplicated when using it elsewhere. This disappears upon restart. Is this a known glitch?

Does this happen if you push the Replace button instead of the Create button?

[ownedbycats]

Unless my hand slipped, I used the replace button.

[chaley]

Originally Posted by ownedbycats

Unless my hand slipped, I used the replace button.

In which case I can't explain it. Next time it happens please capture the exact error message.

[criscros]

I have a question I can't quite figure out. I was trying to create a virtual library or a search on a % column. I can do <100 and get 99 or below, but I can't figure out how to include rows that are empty. Probably dead simple, but beyond me
Thanks!!

[ownedbycats]

Originally Posted by criscros

I have a question I can't quite figure out. I was trying to create a virtual library or a search on a % column. I can do <100 and get 99 or below, but I can't figure out how to include rows that are empty. Probably dead simple, but beyond me
Thanks!!

#intcolumn:false should work for search

$$#intcolumn== 'None' for template

I have the latter for my readstatus() template:

Spoiler:

program:

	if ($$#percentread >=#1 && $$#percentread <=#99) || ($#readinglist == 'Reference')
	then 'currentlyreading' 

	elif $#readinglist=='To Be Read' && $$#percentread ==#0
	then 'toberead' 

	elif $$#percentread >=#100
	then 'read' 

	elif $$#percentread == 'None'
	then 'undefined' 

	elif $$#percentread >=#0
	then 'unread' 

	fi

[theducks]

Originally Posted by criscros

I have a question I can't quite figure out. I was trying to create a virtual library or a search on a % column. I can do <100 and get 99 or below, but I can't figure out how to include rows that are empty. Probably dead simple, but beyond me
Thanks!!

Have you tried colname:true and colname:<100

[capink]

Try this search:

#percent:false or #percent:<100

replace #percent with your column name

[criscros]

This

#percent:false or #percent:<100

actually looks like it works. I'll have to go through to see if what I expect is there.
Thanks!

[ownedbycats]

program:
	id = list_re($#admintags, ',', 'related:(\d+)', '\1');
	strcat('<a href="', 'calibre://book-details/My%20Books/',id, '">', 'Related Book','</a>')

This looks for related:x entries in #admintags, extracts x and then uses strcat to turn it into a link.

If there's multiple ids returned by the list_re how would I create a link for each one instead of calibre://book-details/My%20Books/x,y,z?

[chaley]

Originally Posted by ownedbycats

program:
	id = list_re($#admintags, ',', 'related:(\d+)', '\1');
	strcat('<a href="', 'calibre://book-details/My%20Books/',id, '">', 'Related Book','</a>')

This looks for related:x entries in #admintags, extracts x and then uses strcat to turn it into a link.

If there's multiple ids returned by the list_re how would I create a link for each one instead of calibre://book-details/My%20Books/x,y,z?

Something like this, suitably altered for your columns and for the formatting you want.

program:
	ids = list_re($tags, ',', '(.*)', '\1');
	links = '';
	for id in ids:
		links = links & strcat('<a href="', 'calibre://book-details/My%20Books/',id, '">', 
					'Related Book','</a>', ', ')
	rof;
# remove the trailing comma
	substr(links, 0, -1)

[ownedbycats]

It works

Btw, what should I put for "My Books" in the url when there's a space?

[isarl]

Originally Posted by ownedbycats

It works

Btw, what should I put for "My Books" in the url when there's a space?

Just guessing – but probably you can URL-encode it which for a space character would mean using “%20”.

[isarl]

Originally Posted by ownedbycats

It works

Btw, what should I put for "My Books" in the url when there's a space?

After a little more experimentation, and if you are wiling to use Python templates in Calibre, then the standard library function urllib.parse.quote() may be of use to you – here's an example Python template which uses this function to correctly encode a string in the manner I described above:

python:
def evaluate(book, context):
  import urllib.parse
  return urllib.parse.quote(book.title)

Example output:

To%20Say%20Nothing%20of%20the%20Dog
The%20Poppy%20War
The%20Fifth%20Season

(At first I thought the Calibre template function to_hex() might be useful, but it hex-encodes the entire string, and without the “%” character. Not really what we want here.)

[chaley]

Originally Posted by isarl

(At first I thought the Calibre template function to_hex() might be useful, but it hex-encodes the entire string, and without the “%” character. Not really what we want here.)

Actually, to_hex() is exactly what you want. If you use it then you don't do any url encoding.

Libraries that are hex encoded must start with '_hex_-'.

Here is an example of building a calibre:// url using the function.

program:
	lib = 'library.test_small';
	hex_lib = '_hex_-' & to_hex(lib);
	url = 'calibre://book-details/' & hex_lib & '/' & $id;
	'<a href="' & url & '">Book id ' & $id & '</a>'

It produces links that look like

calibre://book-details/_hex_-6c6962726172792e746573745f736d616c6c/1385

You can also use it for query strings. Instead of q=string, you use eq=hex-encoded-string.

All of this is documented here.

[ownedbycats]

That's useful to know