Plugboard, template, and custom composite column recipes

[Penny_Dreadful]

Hello, I'm looking for some help creating a composite column combined with an advanced icon rule, to give me a column that has icons for the online libraries I can borrow that book from. I currently have columns for each of theses online libraries but I'm hoping to combine the columns into one.

The Calibre Library is my Wish-list/To Read Library so its full of empty books with full metadata. The ID field might have ids for "borrowbox", "wheelers" and "odid" which is a combined ID that might have Overdrive ID and/or a Kindle Unlimited ID. It might also not have any of those IDs in which case I'd like nothing to show in that column.

The IDs look like this:
borrowbox:AAU_779614 Three uppercase letters then an underscore then six numbers ^[A-Z]{3}_\d{6}$ is the regex I am using for the single column
wheelers:9781760873752 Yes this is the ISBN 13 of the book ^(?=(?:\D*\d){10}(?:(?:\D*\d){3})?$)[\d-]+$ ISBN regex.

and the odid can look like one of these:
odid:5426939@wapldmc.overdrive.com
odid:B088PB8T42@ak/unlimited
odid:2077018@wapldmc.overdrive.com&B00PY6CSNM@ak/unlimited

and my icons are named kunlimited.png, wheelers.png, borrowbox.png and overdrive.png

Thanks for any help!

I've created the column listing the IDs by using the template:
program:
strcat(select(field('identifiers'),'odid'),' ', select(field('identifiers'),'borrowbox'),' ', select(field('identifiers'),'wheelers'));

but getting the icons to work using an advanced rule is just confusing me.

[davidfor]

Originally Posted by Penny_Dreadful

Hello, I'm looking for some help creating a composite column combined with an advanced icon rule, to give me a column that has icons for the online libraries I can borrow that book from. I currently have columns for each of theses online libraries but I'm hoping to combine the columns into one.

The Calibre Library is my Wish-list/To Read Library so its full of empty books with full metadata. The ID field might have ids for "borrowbox", "wheelers" and "odid" which is a combined ID that might have Overdrive ID and/or a Kindle Unlimited ID. It might also not have any of those IDs in which case I'd like nothing to show in that column.

The IDs look like this:
borrowbox:AAU_779614 Three uppercase letters then an underscore then six numbers ^[A-Z]{3}_\d{6}$ is the regex I am using for the single column
wheelers:9781760873752 Yes this is the ISBN 13 of the book ^(?=(?:\D*\d){10}(??:\D*\d){3})?$)[\d-]+$ ISBN regex.

and the odid can look like one of these:
odid:5426939@wapldmc.overdrive.com
odid:B088PB8T42@ak/unlimited
odid:2077018@wapldmc.overdrive.com&B00PY6CSNM@ak/unlimited

and my icons are named kunlimited.png, wheelers.png, borrowbox.png and overdrive.png

Thanks for any help!

I've created the column listing the IDs by using the template:
program:
strcat(select(field('identifiers'),'odid'),' ', select(field('identifiers'),'borrowbox'),' ', select(field('identifiers'),'wheelers'));

but getting the icons to work using an advanced rule is just confusing me.

The result of the advanced icon rule has to be the name of the icon to use. I can't work out how to return multiple icons in one advance rule, so, you need one rule per icon that could be displayed. If you could have only one source for each book, we could create a rule that returned a single icon name.

The following advanced rule should work to give the icon for Overdrive:

program:
id = select(field('identifiers'),'odid');
contains(id, 'overdrive', 'overdrive.png','')

And for Amazon Unlimited

program:
id = select(field('identifiers'),'odid');
contains(id, 'unlimited', 'kunlimited.png','')

Add each of the above as separate advanced rules with the "Kind" of either "composed icons w/text" or "composed icons w/no text". That will allow multiple icons to be shown in a single column.

For "Borrowbox" and "Wheelers", the value of the identifier shouldn't matter, just that the identifier exists. And you can use simple icon rules. The first field needs to be set to either "composed icons w/text" or "composed icons w/no text". The condition is "If the Identifiers column has id value: wheelers". And then do a similar rule for "Borrowbox".

[Penny_Dreadful]

@davidfor Thank you so much, the big thing I was missing was "composed icons" now I know why my rules kept on overwriting each other!

The advanced rule code helped heaps too, my Wishlist library is now so much more useful now I can see all the libraries I can borrow a book from in a single column instead of having them spread across three columns.

The amount of help you give out on these forums is amazing, thank you!

[chaley]

Originally Posted by davidfor

The result of the advanced icon rule has to be the name of the icon to use. I can't work out how to return multiple icons in one advance rule,

Return a colon-separated list of icon file names. You can construct that list icon by icon using list_union

[davidfor]

Originally Posted by chaley

Return a colon-separated list of icon file names. You can construct that list icon by icon using list_union

Colon's of course.

[Carmelocotonto]

Hi,
Is it possible to add the value of a custom column to the book description?, and then add the result to the epub file?
Thanks

[davidfor]

Originally Posted by Carmelocotonto

Is it possible to add the value of a custom column to the book description?, and then add the result to the epub file?

A metadata plugboard can update the comments field when the book is sent to the device or a save to disk is done. This can include data from any column.

[Carmelocotonto]

Originally Posted by davidfor

A metadata plugboard can update the comments field when the book is sent to the device or a save to disk is done. This can include data from any column.

Thanks. Something like...
epub:save_to_disk = ([{#words} - {comments}] -> comments)

But I don't see what happens. Where will the new 'comments' be?

I have created custom columns but I have never used templates. Any help will help me.

This is what I want (I have modified this one by hand):


And then, polish epub.

[davidfor]

Originally Posted by Carmelocotonto

Thanks. Something like...
epub:save_to_disk = ([{#words} - {comments}] -> comments)

But I don't see what happens. Where will the new 'comments' be?

I have created custom columns but I have never used templates. Any help will help me.

This is what I want (I have modified this one by hand):
Attachment 180021

And then, polish epub.

What you have would work. But, it would be pretty ugly on the device. What I use is:

{comments}{:'raw_field("tags")'|<p><b>Tags:</b> |</p>}{rating:rating_as_stars()|<p><b>Rating:</b> |</p>}{#kobo_last_read:|<p><b>Last Read:</b> |</p>}{:'test(field('#words'),'<p>',test(field('#pages'),'<p>',''))'}{#words:|<b>Word count:</b> |}{:'test(field('#words'),test(field('#pages'),' ',''),'')'}{#pages:|<b>Page count:</b> |}{:'test(field('#words'),'</p>',test(field('#pages'),'</p>',''))'}

That produces something like:

This is the book comment.

Tags: Science Fiction, Space Opera
Pages: 200 Words: 123450

The complications in the plugboard is in case any of the values are missing.

Another was posted in the Kobo forum in the last couple of days. That one puts the details first. And the post has some screenshots of what it looks like on a Kobo device.

[theducks]

Not all devices support (can display) Comments.
Where they choose to gather what they display, might be another.
And if you use a wireless delivery, who knows what they filter/insert/replace

[shonaich]

I have a kindle paperwhite 2015 and do all my ebook management via calibre. I want to use the plugboard to put the rating (star amount) in either the title as a superscript to make it less conspicuous or in the author field. Is there a way to make it a superscript? I've searched and can't find anything on it and my programming skills were tasked to the max just to be able to write my plugboard in the first place, lol.

Also, I have {author_sort} going to the author field.  I'd assumed that if I added another value, the output would place it after the author's name.  So, {author_sort}{rating:| *|} would become 'First Last *3'. Instead it's 'First *3 Last' and I'm not sure why.

I've tried everything my extremely limited understanding knows, but I can't get it to put anything after the author name, it always puts it in the middle.

Sorry if I've used the code tags wrong, I didn't want the bit of code to make a mess...

Thanks for any help!

[ownedbycats]

Is there any specific template function for marked books? For visibility reasons I'd like to apply column colouring to them.

[chaley]

Originally Posted by ownedbycats

Is there any specific template function for marked books? For visibility reasons I'd like to apply column colouring to them.

Nope, there is no way to see marks in a template.

[vargr]

Hello, can anyone help with a template I'm trying to make for cover generation? I want it to take a text field that's a series of 2+ names separated by slashes, and return just the first word of each name, retaining the slashes.

i.e., so that "John Doe/Jim Smith" would show as "John/Jim" on the generated cover.

[chaley]

Originally Posted by vargr

Hello, can anyone help with a template I'm trying to make for cover generation? I want it to take a text field that's a series of 2+ names separated by slashes, and return just the first word of each name, retaining the slashes.

i.e., so that "John Doe/Jim Smith" would show as "John/Jim" on the generated cover.

One of these should do it. Using general program mode:

program: list_re(field('#text'), '/', '^(..*?)\b.*$', '\1')

Using template program mode:

{#text:'list_re($, '/', '^(..*?)\b.*$', '\1')'}

Change #text to be the lookup name of your text column.

The above also handles single names. For example "John Doe/Fred/Jim Smith" produces "/John/Fred/Jim". If you don't want that then change the \b to a space character.