Saving ebooks Template Problem

[Tanjamuse]

Hi.

Could it be possible to use composite columns in the template for saving to disk?

I have the following template but it reverts back to the one before when I try to use it:

'{#fandom_main} - {#fandom_secondary}/{author}/{title} ({#story_id})

If it's not possible to use composite columns, can I use only the first 2 tags in the Fandom column? They are split with a &.

Otherwise some of the names of folders it saves to ends up being longer than my windows can handle like the following:

Buffy the Vampire Slayer,Cheers (TV),Cupid (TV 1998),Star Trek_ Deep Space Nine Ties - Fandom,Charmed,Greek and Roman Mythology,A-Team (TV),I Dream of Jeannie

Thanks so much.

Edit: After further thought, could I create a template where only part of it is activated based on conditions like amount of tags in a custom tag-column?

[Divingduck]

You can use composite columns. You can use the function sublist e.g.
{tags:sublist(0,2,\,)} to extract values from a list like tags.
https://manual.calibre-ebook.com/gen...ndex-separator

[Divingduck]

@Kovid,

I think, there seems to be something wrong in the manual. Missing/wrong character for backslash.

First place:
https://manual.calibre-ebook.com/template_lang.html, section:
"Using functions in templates - single-function mode"

Arguments are separated by commas. Commas inside arguments must be preceeded by a backslash ( ‘' ). The last (or only) argument cannot contain a closing parenthesis ( ‘)’ ). Functions return the value of the field used in the template, suitably modified.

( ‘' ) --> [‘] instead of [\]

Second place:
https://manual.calibre-ebook.com/gen...ndex-separator

Examples using basic template mode and assuming that the tags column (which is comma-separated) contains "A, B, C": {tags:sublist(0,1,,)} returns "A". {tags:sublist(-1,0,,)} returns "C". {tags:sublist(0,-1,,)} returns "A, B".

instead of

Examples using basic template mode and assuming that the tags column (which is comma-separated) contains "A, B, C": {tags:sublist(0,1,\,)} returns "A". {tags:sublist(-1,0,\,)} returns "C". {tags:sublist(0,-1,\,)} returns "A, B".

[Tanjamuse]

Originally Posted by Divingduck

You can use composite columns. You can use the function sublist e.g.
{tags:sublist(0,2,\,)} to extract values from a list like tags.
https://manual.calibre-ebook.com/gen...ndex-separator

Could you show me how to based on my columns if I add what I've got in them?

[Divingduck]

For the template
{#fandom_main} - {#fandom_secondary}/{author}/{title} ({#story_id})

change to:

{#fandom_main:sublist(0,2,\,)} - {#fandom_secondary:sublist(0,2,\,)}/{author}/{title} ({#story_id})

In case your column definition is like tags. If not, you need to check if your list separator is a comma or something else and correct the separator to what ever you are using.


The result should be something like
fandom_main1,fandom_main2 - fandom_secondary,fandom_secondary\author\title (story_id)

It takes from each of your two fandom columns list the first two items.

[Tanjamuse]

The separator is a &.

Alternate I have a composite column like this:

{#fandoms:count(&)}

Could it be possible to create a template that says:

if it's more than 2 fandoms add Multi-Crossovers to the folder it saves to?

[Divingduck]

What is your column definition exactly for both columns (with an example)?
Is it only a text column like
Buffy the Vampire Slayer,Cheers (TV)&Cupid (TV 1998)&Star Trek_ Deep Space Nine Ties

Then your separator should be & or \&

In the end you can do do everything you want in a template. If you want to do more complex combinations use the program mode in the template, e.g.

Spoiler:

program:
lib = current_library_name();
tmp1 = template('MainLib/{author_sort}/{author_sort}{series:| - |} {series_index:0>2s} - {title}');
tmp2 = template('OtherLibs/{author_sort}/{author_sort}{series:| - |} {series_index:0>2s} - {title}');
contains(lib,"Calibre Bibliothek",tmp1,tmp2);

This one will move books to two different folders (MainLib, OtherLibs) depending on a library name. "Calibre Bibliothek" goes to MainLib and all others go to OtherLibs.

For now I haven't the time to help more but this evening I can spend some time to help if you give me some more input of your structure (or maybe someone else can jump in too).

[Tanjamuse]

Ok, I'll try:

I've added screenshots for all the columns involved.

I think I would prefer this solution:

If the count of fandoms is more than 2, have the template put the story in a folder called: Multiple Crossovers without adding the fandoms. The rest of it would be like the one I have (it will always end with this):

/{author}/{title} ({#story_id})

If I can create a whole bunch of templates, does that mean that I can create a lot of different versions based on the libaries I have?

[kovidgoyal]

https://github.com/kovidgoyal/calibr...af0b50ad768902

should take care of it when the manual is rebuilt for the next release.

[Tanjamuse]

I've looked over the template language in the manual and found this thread: https://www.mobileread.com/forums/sh...d.php?t=294354

Which got me to here:

{#fandoms:sublist(0,1,&)||/}{#fandoms:sublist(0,2,&)||/}/{author}/{title} ({#story_id})

The fandoms column is a tag column, but with names, which means the separator is &.

The template above gives me this:

Buffy the Vampire Slayer,Cheers (gy,A-Team (TV),I Dream of Jeannie

I would much prefer a option like I posted yesterday with counting and then adding them to a folder called: Multiple Crossovers, that would make them much easier to find.

[Divingduck]

Originally Posted by kovidgoyal

[url]should take care of it when the manual is rebuilt for the next release.

Thanks a lot

[Divingduck]

If I can create a whole bunch of templates, does that mean that I can create a lot of different versions based on the libaries I have?

Yes. This is something where you use the general program mode within the template language like I show in post #7

I would much prefer a option like I posted yesterday with counting and then adding them to a folder called: Multiple Crossovers, that would make them much easier to find.

You can use the "Template program mode" - something like this:

program: 

tmp1 = template('{#fandom_main:sublist(0,2,\,)} - {#fandom_secondary:sublist(0,2,\,)}/{author}/{title} ({#story_id})');
tmp2 = template('Multiple Crossovers/{author}/{title} ({#story_id})');

	cmp(
		count(
			field('#fandom_main'), 
			','), 
		2, 
		tmp1, 
		tmp2, 
		tmp2)

tmp1 and tmp2 are two different templates (you can adust it like you need it). cmp compares two values and give in this case two different templates depending on count back. You need to use the function field() to use the values of the metadata. ',' is the separator for the values (change it to what you need, e.g. '&'). In this example the template 1 is used if count is less than 2.

Reference:
https://manual.calibre-ebook.com/gen...p-x-y-lt-eq-gt
https://manual.calibre-ebook.com/tem...l-program-mode

[Tanjamuse]

I've made a small change to what you posted since it had to be 3 fandoms or more instead of 2, I've also deleted the - because it added it to the end of the folder names whenever there was only 1 or 2 fandoms Can you add a string for when it's only 2 fandoms it needs to add them to a folder named Crossovers but it needs to keep the fandoms?

program: 

tmp1 = template('{#fandom_main:sublist(0,2,\,)}{#fandom_secondary:sublist(0,2,\,)}/{author}/{title} ({#story_id})');
tmp2 = template('Multiple Crossovers/{author}/{title} ({#story_id})');

	cmp(
		count(
			field('#fandom_main'), 
			','), 
		3, 
		tmp1, 
		tmp2, 
		tmp2)

[Divingduck]

Not sure if I get your request correct. a example could help for each variant

When you need more differentiation than less, equal, greater then the function switch() is maybe more suitable for your task. Something like:

program: 
tmp0 = template('No Crossovers/{author}/{title} ({#story_id})');
tmp1 = template('{#fandom_main:sublist(0,2,\,)}{#fandom_secondary:sublist(0,2,\,)}/{author}/{title} ({#story_id})');
tmp2 = template('Crossovers/{#fandom_main:sublist(0,2,\,)}{#fandom_secondary:sublist(0,2,\,)}/{author}/{title} ({#story_id})');
tmp3 = template('Multiple Crossovers/{author}/{title} ({#story_id})');

## old version check if count is lt, eq,gr
#	cmp(
#		count(
#			field('#fandom_main'), 
#			','), 
#		3, 
#		tmp1, 
#		tmp2, 
#		tmp2);

## new version as "case of count =x"
switch(
		count(field('#fandom_main'), ','),
				0, tmp0,
				1, tmp1,
				2, tmp2,
				3, tmp3,
				tmp3);

# in first position of a line means it is a comment, you can delete them if you want. The mechanism works like "if count = 0 use template 0, if count = 1 use template 1 up to count =3 and if count different to 0,1,2,3 use template 3 (or what ever else you want to do


Regarding the '-', you can use as well |-|, || or |-|- for a prefix and/or suffix

[Tanjamuse]

I'll try to be more specific:

I would like them sorted like this:

3 or more fandoms in Multiple Crossovers

only 2 fandoms in Crossovers

The one below only creates the Crossover and no longer the Multiple Crossovers, instead it creates a folder with only the first 2 fandoms in the long list from the multiple crossovers.

program: 
tmp0 = template('No Crossovers/{author}/{title} ({#story_id})');
tmp1 = template('{#fandom_main:sublist(0,2,\,)}{#fandom_secondary:sublist(0,2,\,)}/{author}/{title} ({#story_id})');
tmp2 = template('Crossovers/{#fandom_main:sublist(0,2,\,)}{#fandom_secondary:sublist(0,2,\,)}/{author}/{title} ({#story_id})');
tmp3 = template('Multiple Crossovers/{author}/{title} ({#story_id})');

## old version check if count is lt, eq,gr
#	cmp(
#		count(
#			field('#fandom_main'), 
#			','), 
#		3, 
#		tmp1, 
#		tmp2, 
#		tmp2);

## new version as "case of count =x"
switch(
		count(field('#fandom_main'), ','),
				0, tmp0,
				1, tmp1,
				2, tmp2,
				3, tmp3,
				tmp3);

I need help for another version of the template as well.