Plugboard, template, and custom composite column recipes

[strolego]

Hi
I'd like transfer my book on my new kindle with the following structure
Library/Author/Title
but I'm not able to obtain "Library" automatically
I'm trying to create a column with the name of the library, maybe using the function current_library_name(), but I always obtain an empty field.
Any suggestion
Thank you in advance

[chaley]

Originally Posted by strolego

Hi
I'd like transfer my book on my new kindle with the following structure
Library/Author/Title
but I'm not able to obtain "Library" automatically
I'm trying to create a column with the name of the library, maybe using the function current_library_name(), but I always obtain an empty field.
Any suggestion
Thank you in advance

What templates have you tried?

[strolego]

Originally Posted by chaley

What templates have you tried?

I've tried
New Column -> Biblioteca (i.e. Library in italian)
Default Value -> {program:current_library_name()}

I've also tried with {program:'current_library_name()'}
but without success

[chaley]

Originally Posted by strolego

I've tried
New Column -> Biblioteca (i.e. Library in italian)
Default Value -> {program:current_library_name()}

I've also tried with {program:'current_library_name()'}
but without success

I see two problems:

1. Default values can't be templates. Templates are used only in "Columns built from other columns" and not as default values.
2. General Program Mode templates don't use {} characters. Use
   

   program:current_library_name()

   Alternatively use Template Program Mode (TPM). Something like this:
   

   {:'current_library_name()'}

   If you wish you could use this TPM template in the save template:
   

   {:'current_library_name()'}/{authors}/{title}

[strolego]

Originally Posted by chaley

I see two problems:

1. Default values can't be templates. Templates are used only in "Columns built from other columns" and not as default values.
2. General Program Mode templates don't use {} characters. Use
   

   program:current_library_name()

   Alternatively use Template Program Mode (TPM). Something like this:
   

   {:'current_library_name()'}

   If you wish you could use this TPM template in the save template:
   

   {:'current_library_name()'}/{authors}/{title}

Thank you! It works perfectly

[dunhill]

Originally Posted by chaley

Assuming you are running calibre 6.12 or later:

{#kobo_percent_read:'switch_if($ >= 100, 'finished', $ <= 0, 'unread', 'reading')'}

And what would it be like if I used the status column and in the percentage column I put 100 if the status said Read?

Example:
I have my status column to rate the status of the book (read, to be read, reading)
And since I do not synchronize the reader process, I would like if the status of the book is Read, in the process column it would put 100

[chaley]

Originally Posted by dunhill

And what would it be like if I used the status column and in the percentage column I put 100 if the status said Read?

Example:
I have my status column to rate the status of the book (read, to be read, reading)
And since I do not synchronize the reader process, I would like if the status of the book is Read, in the process column it would put 100

I don't understand. What is the process column type? What is the status column type? Where does the result of the template go? What are the exact computation rules?

[dunhill]

Originally Posted by chaley

I don't understand. What is the process column type? What is the status column type? Where does the result of the template go? What are the exact computation rules?

My status column is linked to goodreads and is updated with the goodreads sync plugin
What I am looking for is that if in that custom column that I have called #goodreadstags it says "Read" in another column where the reading process should appear, it tells me 100
The template should be in the custom column that depends on the result of #goodreadstags

I have tried
{#goodreadstags:'switch_if($ = 'Read', '100')'}

[chaley]

Originally Posted by dunhill

I have tried
{#goodreadstags:'switch_if($ = 'Read', '100')'}

Try this:

{#goodreadstags:'switch_if($ == 'Read', '100', '')'}

The comparison operator is ==, not =. The switch_if function requires a default that is used if there isn't a match. I added the empty string.

[dunhill]

Originally Posted by chaley

Try this:

{#goodreadstags:'switch_if($ == 'Read', '100', '')'}

The comparison operator is ==, not =. The switch_if function requires a default that is used if there isn't a match. I added the empty string.

That worked, thanks Chaley!

[BruDeV]

program:
# windows filename aliases

	windows_alias_000 = titlecase(uppercase(field('title')));

# less-than sign -> left arrowhead \u02c2
	windows_alias_010 = re(windows_alias_000, "<", "˂" );
# greater-than sign -> right arrowhead \u02c3
	windows_alias_020 = re(windows_alias_010, ">", "˃" );
# colon -> modifier colon \uA789
	windows_alias_030 = re(windows_alias_020, ":", "꞉" );
# quote marks, -> single quote \u0027
	windows_alias_040 = re(windows_alias_030, "(\"|‘|’|‚|‛|“|”|„|‟)", "'" );
# solidus, division slash, fraction slash -> big solidus \u29f8
	windows_alias_050 = re(windows_alias_040, "(/|∕|⁄)", "⧸" );
# reverse solidus -> big reverse solidus \u29f9
	windows_alias_060 = re(windows_alias_050, "\u005c", "⧹" );
# vertical line -> broken bar \u00a6
	windows_alias_070 = re(windows_alias_060, "\|", "¦" );
# question mark -> Devanagan glottal stop \u097d
	windows_alias_080 = re(windows_alias_070, "\?", "ॽ" );
# asterisk -> flower puncuation mark \u2055
	windows_alias_090 = re(windows_alias_080, "\*", "⁕" );
# period, raised dot, two dot leader, one dot leader -> stenographic full stop \u2e3c
	windows_alias_100 = re(windows_alias_090, "(\.|⸳|‥|․)", "⸼" );
	
# extra stuff

# change multiple stenographic full stops to -> elipsis \u2026
	windows_alias_110 = re(windows_alias_100, "(⸼⸼⸼|⸼ ⸼ ⸼)", "…" );
# change versus
	windows_alias_120 = re(windows_alias_110, "\bversus\b", "vs" );
	windows_alias_130 = re(windows_alias_210, " vs： ", " vs " );
# change figure dash, en dash, em dash to -> hyphen-minus
	windows_alias_140 = re(windows_alias_220, "(‒|–|—)", " - " );
	windows_alias_150 = re(windows_alias_230, "--", "-" );
	windows_alias_160 = re(windows_alias_240, "- - -", " - " );

# add space after 'modifier colon' or 'stenographic full stop'
	windows_alias_200 = re(windows_alias_160, "(꞉|⸼\D)(\w)", "\1 \2" );

# remove extra spaces	
	windows_alias_900 = re(windows_alias_200, "( {2,})", " " );
	windows_alias_910 = re(windows_alias_900, "^( )(.*)", "\2" );
	windows_alias_920 = re(windows_alias_910, "(.*)( )$", "\1" );

[BruDeV]

# question mark ➤ possibilities: \u0241 "Ɂ", \0242 "ɂ", \u02a1 "ʡ", \u0294 "ʔ", \u03c0 "ˀ"

# asterisk ➤ modifier letter cross acsent \u02df
	windows_alias_090 = re(windows_alias_080, "\*", "˟" );

[Protoplast26]

I would like to create something like this

Filename: Create file paths grouping authors into [A - D]-like categories (WinCE/Mobile (Mobipocket)) (Sweetpea)
Spoiler:
{author_sort:switch(^[A-D],[A - D],^[E-J],[E - J],^[K-O],[K - O],^[P-T],[P - T],^[U-Z],[U - Z],[Other])}

but i would like a file path for each letter to be stored in a separate folder, is it possible?

[chaley]

Originally Posted by Protoplast26

I would like to create something like this but i would like a file path for each letter to be stored in a separate folder, is it possible?

The Formatting subsection of the Advanced Formatting section in Template Language manual has examples that get close to what I think you want. The example is

If you want only the first two letters of the data, use:
{author_sort:.2} - Only the first two letters of the author sort name

You would use

{author_sort:.1}

to get the first character.

[Protoplast26]

Originally Posted by chaley

The Formatting subsection of the Advanced Formatting section in Template Language manual has examples that get close to what I think you want. The example is

You would use

{author_sort:.1}

to get the first character.

thanks