Templates: various questions not worth their own thread

[ownedbycats]

For numerical columns, is there a better way to equal 0 while excluding nulls?

	elif (percent >=#1 && percent <=#99||$$#lastread !='None' && percent ==#0 && percent !='None')
	then 'currentlyreading'

[chaley]

Originally Posted by ownedbycats

For numerical columns, is there a better way to equal 0 while excluding nulls?

	elif (percent >=#1 && percent <=#99||$$#lastread !='None' && percent ==#0 && percent !='None')
	then 'currentlyreading'

You don't say where you got "percent". If it comes from a $$#something then I would use

raw_field('#something', -1)

that ensures that if #something isn't defined then the value of percent is -1.

[ownedbycats]

Yup, that did it. I did have to change my 'undefined' check to make sure it worked:

program:

percent = raw_field('#percentread', -1);

	if 'dnf' inlist_field '#admintags'
	then 'didnotfinish'

	elif (percent >=#1 && percent <=#99||$$#lastread != 'None' && percent ==#0)
	then 'currentlyreading' 

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

	elif readgoal() inlist $#admintags && percent ==#0
	then 'backlog' 

	elif percent >=#100
	then 'read' 

	elif percent >=#0
	then 'unread' 

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

	fi

[chaley]

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

This would be faster.

elif percent ==# -1
	then 'undefined'

If for some reason -1 won't work then pick a value that does, perhaps something like -100000.

[ownedbycats]

That did it.

I also just realized I could change line 14 to also use inlist_field and it still works.

[correoparaappzz]

Hi, is it possible to change icons individually in a template that is displayed in the tag browser?

like in format

[ownedbycats]

Not by default. Job Spy can do it. GUI tool Tag browser icons.

[correoparaappzz]

Originally Posted by ownedbycats

Not by default. Job Spy can do it. GUI tool Tag browser icons.

[BetterRed]

Format icon overrides can be placed in <calibre config>\resources\images\mimetypes.

Try to find 128x128 pngs.

BR

[Comfy.n]

PHP Code:

program: out = '  💾 '; epub=select(formats_sizes(),'EPUB'); epub_str=cmp(epub,'','', '', strcat('EPUB: ', human_readable(epub), ' | ')); out=strcat(out, epub_str); 
pdf=select(formats_sizes(),'PDF'); pdf_str=cmp(pdf,'','', '', strcat('PDF: ', human_readable(pdf), ' | ')); out=strcat(out, pdf_str); 
azw2=select(formats_sizes(),'AZW2'); azw2_str=cmp(azw2,'','', '', strcat('AZW2: ', human_readable(azw2), ' | ')); out=strcat(out, azw2_str); 
azw3=select(formats_sizes(),'AZW3'); azw3_str=cmp(azw3,'','', '', strcat('AZW3: ', human_readable(azw3), ' | ')); out=strcat(out, azw3_str); 
bmp=select(formats_sizes(),'BMP'); bmp_str=cmp(bmp,'','', '', strcat('BMP: ', human_readable(bmp), ' | ')); out=strcat(out, bmp_str); 
cbr=select(formats_sizes(),'CBR'); cbr_str=cmp(cbr,'','', '', strcat('CBR: ', human_readable(cbr), ' | ')); out=strcat(out, cbr_str); 
cbz=select(formats_sizes(),'CBZ'); cbz_str=cmp(cbz,'','', '', strcat('CBZ: ', human_readable(cbz), ' | ')); out=strcat(out, cbz_str); 
computer=select(formats_sizes(),'COMPUTER'); computer_str=cmp(computer,'','', '', strcat('COMPUTER: ', human_readable(computer), ' | ')); out=strcat(out, computer_str); 
dir=select(formats_sizes(),'DIR'); dir_str=cmp(dir,'','', '', strcat('DIR: ', human_readable(dir), ' | ')); out=strcat(out, dir_str); 
djvu=select(formats_sizes(),'DJVU'); djvu_str=cmp(djvu,'','', '', strcat('DJVU: ', human_readable(djvu), ' | ')); out=strcat(out, djvu_str); 
docx=select(formats_sizes(),'DOCX'); docx_str=cmp(docx,'','', '', strcat('DOCX: ', human_readable(docx), ' | ')); out=strcat(out, docx_str); 
fb2=select(formats_sizes(),'FB2'); fb2_str=cmp(fb2,'','', '', strcat('FB2: ', human_readable(fb2), ' | ')); out=strcat(out, fb2_str); 
gif=select(formats_sizes(),'GIF'); gif_str=cmp(gif,'','', '', strcat('GIF: ', human_readable(gif), ' | ')); out=strcat(out, gif_str); 
htmlz=select(formats_sizes(),'HTMLZ'); htmlz_str=cmp(htmlz,'','', '', strcat('HTMLZ: ', human_readable(htmlz), ' | ')); out=strcat(out, htmlz_str); 
jpeg=select(formats_sizes(),'JPEG'); jpeg_str=cmp(jpeg,'','', '', strcat('JPEG: ', human_readable(jpeg), ' | ')); out=strcat(out, jpeg_str); 
jpg=select(formats_sizes(),'JPG'); jpg_str=cmp(jpg,'','', '', strcat('JPG: ', human_readable(jpg), ' | ')); out=strcat(out, jpg_str); 
kfx=select(formats_sizes(),'KFX'); kfx_str=cmp(kfx,'','', '', strcat('KFX: ', human_readable(kfx), ' | ')); out=strcat(out, kfx_str); 
lit=select(formats_sizes(),'LIT'); lit_str=cmp(lit,'','', '', strcat('LIT: ', human_readable(lit), ' | ')); out=strcat(out, lit_str); 
lrf=select(formats_sizes(),'LRF'); lrf_str=cmp(lrf,'','', '', strcat('LRF: ', human_readable(lrf), ' | ')); out=strcat(out, lrf_str); 
lrx=select(formats_sizes(),'LRX'); lrx_str=cmp(lrx,'','', '', strcat('LRX: ', human_readable(lrx), ' | ')); out=strcat(out, lrx_str); 
md=select(formats_sizes(),'MD'); md_str=cmp(md,'','', '', strcat('MD: ', human_readable(md), ' | ')); out=strcat(out, md_str); 
mobi=select(formats_sizes(),'MOBI'); mobi_str=cmp(mobi,'','', '', strcat('MOBI: ', human_readable(mobi), ' | ')); out=strcat(out, mobi_str); 
odt=select(formats_sizes(),'ODT'); odt_str=cmp(odt,'','', '', strcat('ODT: ', human_readable(odt), ' | ')); out=strcat(out, odt_str); 
opml=select(formats_sizes(),'OPML'); opml_str=cmp(opml,'','', '', strcat('OPML: ', human_readable(opml), ' | ')); out=strcat(out, opml_str); 
png=select(formats_sizes(),'PNG'); png_str=cmp(png,'','', '', strcat('PNG: ', human_readable(png), ' | ')); out=strcat(out, png_str); 
rar=select(formats_sizes(),'RAR'); rar_str=cmp(rar,'','', '', strcat('RAR: ', human_readable(rar), ' | ')); out=strcat(out, rar_str); 
rtf=select(formats_sizes(),'RTF'); rtf_str=cmp(rtf,'','', '', strcat('RTF: ', human_readable(rtf), ' | ')); out=strcat(out, rtf_str); 
snb=select(formats_sizes(),'SNB'); snb_str=cmp(snb,'','', '', strcat('SNB: ', human_readable(snb), ' | ')); out=strcat(out, snb_str); 
svg=select(formats_sizes(),'SVG'); svg_str=cmp(svg,'','', '', strcat('SVG: ', human_readable(svg), ' | ')); out=strcat(out, svg_str); 
tpz=select(formats_sizes(),'TPZ'); tpz_str=cmp(tpz,'','', '', strcat('TPZ: ', human_readable(tpz), ' | ')); out=strcat(out, tpz_str); 
txt=select(formats_sizes(),'TXT'); txt_str=cmp(txt,'','', '', strcat('TXT: ', human_readable(txt), ' | ')); out=strcat(out, txt_str); 
xps=select(formats_sizes(),'XPS'); xps_str=cmp(xps,'','', '', strcat('XPS: ', human_readable(xps), ' | ')); out=strcat(out, xps_str); 
zero=select(formats_sizes(),'ZERO'); zero_str=cmp(zero,'','', '', strcat('ZERO: ', human_readable(zero), ' | ')); out=strcat(out, zero_str); 
zip=select(formats_sizes(),'ZIP'); zip_str=cmp(zip,'','', '', strcat('ZIP: ', human_readable(zip), ' | ')); out=strcat(out, zip_str); 
out 


Hi,

I'm using the above composite to display human readable format sizes and this looks fine on Book Details but I wanted to prevent the trailing pipe showing when there's only one format available, so instead of...

💾 EPUB: 1.2 MB |

the ideal output would be:

💾 EPUB: 1.2 MB

Ideas?

[chaley]

Originally Posted by Comfy.n

Hi,

I'm using the above composite to display human readable format sizes and this looks fine on Book Details but I wanted to prevent the trailing pipe showing when there's only one format available, so instead of...

💾 EPUB: 1.2 MB |

the ideal output would be:

💾 EPUB: 1.2 MB

Ideas?

Put this just before the last line:

	if substr(out, -2, 0) == '| ' then
		out = substr(out, 0, -3)
	fi;

For fun, here is a template that does almost the same thing but hundreds of around fifty times faster. A difference is that the formats are output in alphabetic order, not the order you specified.

program: 
	out = '  💾  ';
	fmts = list_sort(formats_sizes(), 0, ',') ;
	for fmt_data in fmts:
		fmt = sublist(fmt_data, 0, 1, ':');
		size = sublist(fmt_data, 1, 2, ':'); 
		str = if size ># 0 then strcat(fmt, ': ', human_readable(size), ' | ') else '' fi;
		out=strcat(out, str) 
	rof;
	if substr(out, -2, 0) == '| ' then
		out = substr(out, 0, -3)
	fi;
	out

[Comfy.n]

Originally Posted by chaley

For fun, here is a template that does almost the same thing but hundreds of times faster. A difference is that the formats are output in alphabetic order, not the order you specified.

program: 
	out = '  💾  ';
	fmts = list_sort(formats_sizes(), 0, ',') ;
	for fmt_data in fmts:
		fmt = sublist(fmt_data, 0, 1, ':');
		size = sublist(fmt_data, 1, 2, ':'); 
		str = if size ># 0 then strcat(fmt, ': ', human_readable(size), ' | ') else '' fi;
		out=strcat(out, str) 
	rof;
	if substr(out, -2, 0) == '| ' then
		out = substr(out, 0, -3)
	fi;
	out

Whee!

Much better indeed:

[correoparaappzz]

Originally Posted by Comfy.n

Hi,

I'm using the above composite to display human readable format sizes and this looks fine on Book Details but I wanted to prevent the trailing pipe showing when there's only one format available, so instead of...

💾 EPUB: 1.2 MB |

the ideal output would be:

💾 EPUB: 1.2 MB

Ideas?

hi, how did you put images in the identifiers?

[Comfy.n]

Originally Posted by correoparaappzz

hi, how did you put images in the identifiers?

If I recall correctly, I had to create this composite column Identifiers2... {identifiers}



..then it's just a column icon rule set at Preferences -> Look&feel:

[correoparaappzz]

Originally Posted by Comfy.n

If I recall correctly, I had to create this composite column Identifiers2... {identifiers}

Attachment 213230

..then it's just a column icon rule set at Preferences -> Look&feel:

Attachment 213231

another question, is it posible to do the same in Book Details?