Using templates for file names, plugboards, composite columns, searches, tooltips

[ownedbycats]

Thank you!

[ownedbycats]

Question: I'm converting my fanfic column icon rules to a single advanced rule.

program: 
   f = field('#fanficcat');
   strcat
   (
    contains(f, "Dragon Age: Origins", 'dragonageorigins.png', ''), 
    contains(f, "Half-Life", 'halflife.png', ''), 
    contains(f, "Mass Effect", 'masseffect.png', ''), 
    contains(f, "The Elder Scrolls", 'theelderscrolls.png', ''), 
    contains(f, "Pokémon", 'pokemon.png', ''), 
    contains(f, "Portal", 'portal.png', ''), 
   )

It works except for when there's multiple values (#fanficcat is a tag-like). Clicking on one of the crossovers in the book list and opening the template editor shows "masseffect.pngpokemon.png".

What should I do?

[ownedbycats]

Adding a colon to the end of each filename (e.g. halflife.png:) worked. I'm not sure if that's the proper solution though.

[chaley]

Originally Posted by ownedbycats

Adding a colon to the end of each filename (e.g. halflife.png:) worked. I'm not sure if that's the proper solution though.

It is correct if you want multiple icons per rule. The colon is used to separate multiple icons for a rule. If you want only one icon then use first_non_empty to pick the first 'contains' that returns a value.

That said, checking the code I note that an empty icon file name, as in your example, isn't handled very efficiently. I will fix that.

[ownedbycats]

Originally Posted by chaley

It is correct if you want multiple icons per rule. The colon is used to separate multiple icons for a rule. If you want only one icon then use first_non_empty to pick the first 'contains' that returns a value.

That said, checking the code I note that an empty icon file name, as in your example, isn't handled very efficiently. I will fix that.

Yes, I wanted multiple icons per column.

[ownedbycats]

For fanfiction readers who read on Kobo:

If you have FanFicFare set up with both a Fandom and Status column (or just do it manually), putting this into the Subtitle template (Customize KoboTouchExtended > Metadata, on device & advanced tab) will display the info as a subtitle on Kobo.

program:
	if field('#yourfandomcolumn') then
		template('{#yourfandomcolumn} | {#yourstatuscolumn}')
	fi

If there's multiple entries in a taglike Fandom column, this will just display the first one (thanks chaley!):

program:
	if field('#yourfandomcolumn') then
		template('{#yourfandomcolumn:sublist(0,1,\,)} | {#yourstatuscolumn}')
	fi

[ownedbycats]

If you have columns for them, putting this in the template tester will let you see the average number of pages per chapter.

program:
	chapters = $$#chaptercount;
	pages = $$#pagecount;

	if chapters>#0 then divide(pages, chapters)
	fi

[dunhill]

Hi, someone still uses the thread settings
https://www.mobileread.com/forums/sh...&postcount=137
https://www.mobileread.com/forums/sh...&postcount=172
Rereading the previous post you will find beautiful jewels but for some reason they have stopped working.
I leave you a screenshot, in case the one who made the mistake is the one between the chair and the keyboard.
Thank you very much as always.

[chaley]

Originally Posted by dunhill

Hi, someone still uses the thread settings
https://www.mobileread.com/forums/sh...&postcount=137
https://www.mobileread.com/forums/sh...&postcount=172
Rereading the previous post you will find beautiful jewels but for some reason they have stopped working.
I leave you a screenshot, in case the one who made the mistake is the one between the chair and the keyboard.
Thank you very much as always.

The function in the first post has 4 arguments. The function in the second post has 5 arguments. It appears that you are using the function in the second post (5 arguments) with the "number of arguments" from the first post (4 arguments).

Try following the instructions *exactly* from one or the other of the posts, including setting the number of arguments box to the correct value.

[dunhill]

Originally Posted by chaley

The function in the first post has 4 arguments. The function in the second post has 5 arguments. It appears that you are using the function in the second post (5 arguments) with the "number of arguments" from the first post (4 arguments).

Try following the instructions *exactly* from one or the other of the posts, including setting the number of arguments box to the correct value.

Thank you very much, I had not realized, as the second link was a modification of the first. That is where I went wrong.

[dunhill]

Originally Posted by dcmarquardt

I just wanted to share this here because I spent the last few hours trying to narrow down how to accomplish this...

Background: I recently converted my entire audiobook (multi-mp3 per book) collection into M4B's so that I could manage them with calibre following the "One File Per Book" pattern. (If anyone is interested in a decent way to batch-process that, feel free to PM me)... Once I loaded all of my M4B files into calibre, fixed up all the metadata, etc... it occurred to me that I would create a virtual library called "Audiobooks"... The search expression I used for that is: format:M4B. Easy enough. Now, some of the newly loaded audiobooks that I have, also have various e-book formats (epub, pdf, etc...) that I added to their calibre records for convenience.

Problem: I have a virtual library that shows me all of my audiobooks... that's great, but what if I'm browsing through them and want a specific one to read on my tablet? So I decided to add a custom column that would be called "Audio Only"... basically if the book has only a single format, and that format is equal to "M4B" in my case, then it would show yes, otherwise if there were additional formats available it would show no... or a check/x-mark as it ended up. I'm a software dev, so writing some code isn't anything new, but I was surprised that I couldn't find something out here already to have a simple if... this and this are true ... then 'yes' else 'no' ...

Solution:
I created a custom column template that displays a green check if the book is "Audio Only", and a red X if it has non-audio formats attached to it. Here's how:

Preferences -> Add your own columns -> Add

Lookup Name: onlyaudio
Column Heading: Audio Only
Column Type: Column built from other columns
Show checkmarks: Checked
Template:

program:cmp(count(template('[[format]]'), ','), 1, 'no', in_list(template('[[format]]'), ',', 'M4B', 'yes', 'no'), 'no')

---

This can be adapted to give you a yes/no column if the book contains only one specific format and no others... just paste that in there and replace the M4B with whatever format you want to single out... if it is the ONLY one present, the column will have a value of yes, otherwise no... you can swap those around as needed also to gain the desired result.

One possible improvement I may work on is in the event I someday store more than a single audio format inside calibre, in which case I would need to go through all of the formats and check them... at that point it becomes more complex because I could potentially have >1 formats but have them all be audio... I'll leave that one for another day.

It is possible that the template could recognize more than one format ?

program:cmp(count(template('[[format]]'), ','), 1, 'no', in_list(template('[[format]]'), ',', 'Ogg', 'Si', 'no', ',', 'M3u', 'Si', 'no', ',', 'M4a', 'Si', 'no', ',', 'Mp3', 'Si', 'no'), 'no')

[capink]

Originally Posted by dunhill

It is possible that the template could recognize more than one format ?

program:
	my_formats = 'm4b,epub,fb2';
	if list_intersection(lowercase($formats), my_formats, ',') then
		'yes'
	else
		'no'
	fi

[dunhill]

Originally Posted by capink

program:
	my_formats = 'm4b,epub,fb2';
	if list_intersection(lowercase($formats), my_formats, ',') then
		'yes'
	else
		'no'
	fi

Thank you. Otherwise my syntax was going to be eternal

[BetterRed]

Find More Posts by buffygurl

[ownedbycats]

For those who read fanfics on a Kobo, here's something you can put in a composite column to show how many chapters you've read of a fic as of the last time you connected the device. Note that this relies on using Kobo Utilities and FanFicFare; read the comments for more details.

program:
# 'Current reading location' stored by Kobo Utilities. 
input = $#kobobookmark;
# These last three are saved by FanFicFare. 
fandom = $#fanficcat;
status = $#fanficstatus;
ccount = $$#chaptercount;

	if 
		fandom
	then

		if	
# Note that this is FanFicFare's file structure. If you download with a different tool, it may not work.	
				substr(input, 0, 10) == 'OEBPS/file'
			&& 	
# Anthologies have a different file structure, so we should ignore those.
				!status inlist 'Anthology'
		then		
# Since I pause at the beginning of chapters, I subtract by one. 
			strcat(format_number(re(input, '.*\/file(\d+).*', '\1') - 1, '{0:,d}'), '/',ccount)
		else
# Showing a regular chapter count for everything else.
			ccount
		fi
	fi

Thanks to those who helped me figure this out a while back.