Custom series field bug (?)

[Nitro]

In calibre I have custom column called series_id, it contains short form (abbreviation) of series name. Calibre also created field called series_id_index. Everything works nice when I'm sending files to my devices, but... When I'm trying to set the file naming scheme for CC it works bit different than in calibre.
Filed {series} contains only series name, by {#series_id} includes also number in it, so I have "HP [1]" where I should have only "HP". Moreover {#series_id_index} is unknown to CC.

Is it bug or it should work like this?

My scheme: {author_sort}/{#series_id}{series_index:02%d| - | - }{title}

[theducks]

Series type fields ALWAYS have an index value. ( 0 is a valid value. I use that for pieces that have no set order)

You can go through some template gyrations to suppress that when the series_index is 0 , but 0 will ALWAYS show in the Calibre Library View

[chaley]

Originally Posted by Nitro

In calibre I have custom column called series_id, it contains short form (abbreviation) of series name. Calibre also created field called series_id_index. Everything works nice when I'm sending files to my devices, but... When I'm trying to set the file naming scheme for CC it works bit different than in calibre.
Filed {series} contains only series name, by {#series_id} includes also number in it, so I have "HP [1]" where I should have only "HP". Moreover {#series_id_index} is unknown to CC.

Is it bug or it should work like this?

Sort of a bug, sort of a feature. The template processor currently handles the following columns:

• {title}, {title_sort} (title is the real title. No articles are moved)
• {authors}, {first_author}, {author_sort}, {first_author_sort}
• {series}, {series_index}
• {id} (the calibre database identifier, which is a number)
• text-type custom columns {#col_lookup_name}

Currently custom series columns are classed as text-type and are converted to text.

However, it is reasonable to treat custom series as special cases. I will change CC to return the bare series for #series and to format #series_index as it does the standard series column.

My scheme: {author_sort}/{#series_id}{series_index:02%d| - | - }{title}

Even after I make the change that template won't work. The format specifications for CC are different from those in calibre. In this case you would want %02d, not 02%d. For more info see the FAQ answer What can I use in a CC file name template?, in particular the info on series index formatting.