10-02-2010, 06:13 AM | #1 |
Grand Sorcerer
Posts: 12,014
Karma: 7257321
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
|
Plugboard, template, and custom composite column recipes
Several people are doing interesting and useful things with templates, plugboards, and composite fields. This thread is both a request that they share what they have done and a place to put the information.
Suggestions/recipes are summarized below. Don't hesitate to post corrections and useful variants. Kindle/Kobo
Filename (Save Templates)
General Metadata
Useful stored templates
Template Searches
Common composite custom columns All the recipes below require the creation of a custom column of type 'Column built from other columns', called a composite column. Creation instructions are under the spoiler. Spoiler:
Deprecated
Last edited by chaley; 10-28-2024 at 10:24 AM. |
10-02-2010, 07:46 AM | #2 | |||
Member
Posts: 12
Karma: 10
Join Date: Aug 2009
Location: Australia
Device: Sony PRS-505; PRS-300; Kindle 3
|
Hi, thanks for implementing this feature.
I have been playing around with the Metadata plugboards to get the titles on a Kindle 3 to show series information. I used the following template: Quote:
Quote:
However, when a book is sent that is not part of a series, I get a leading - - in the title e.g.: Quote:
Last edited by economix; 10-02-2010 at 07:50 AM. |
|||
Advert | |
|
10-02-2010, 07:51 AM | #3 | |
Grand Sorcerer
Posts: 12,014
Karma: 7257321
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
|
Quote:
Code:
{series}{series_index:0>2s| - | - }{title} You might want to take a look at the (new) template tutorial in the manual. There are lots of fun toys. |
|
10-02-2010, 08:33 AM | #4 |
Grand Sorcerer
Posts: 9,707
Karma: 32763414
Join Date: Dec 2008
Location: Krewerd
Device: Pocketbook Inkpad 4 Color; Samsung Galaxy Tab S6
|
Thanks to the plugboard and composite fields, I can now use Calibre for my WinCE/Mobile (Mobipocket) devices.
The filename is made up as; {author_sort}/{series}/{title} - v{#version:0>2s} {title} consists of series and index, because the Sony isn't supported by the plugboard. It's not a big deal, as you want the series info with the title anyway, otherwise, ordering by title simply doesn't make any sense. My plugboard is more interresting: {#author_title_sort}{#raw:test( - [raw],)} - {title} is plugged into the title field for PRC and MOBI files. {#author_title_sort} is a field that looks a bit like {author_sort}, except I don't want the entire first name. Especially on my PDA, where the screenwidth is not too wide, the full name would take too much room. "Andersen, Hans Christian - Fairy Tales" vs "Andersen, H.C. - Fairy Tales" The {#raw} means I've not checked the book yet and I won't have it in PDF format. I am working on a save template for my BBMini: it uses these composite fields: {#folder_name} is a composite field: {#folder_a_t:lookup(#folder_a_t,#u_z)} {#folder_a_t} is a composite field: {#folder_a_j:lookup(#folder_a_j,#folder_k_t)} {#folder_k_t} is a composite field: {#k_o:lookup(#k_o,#p_t)} {#folder_a_j} is a composite field: {#a_e:lookup(#a_e,#f_j)} {#u_z} is a composite field: {#first_letter:contains([U-Z],[U - Z],)} {#p_t} is a composite field: {#first_letter:contains([P-T],[P - T],)} {#k_o} is a compositie field: {#first_letter:contains([K-O],[K - O],)} {#f_j} is a compositie field: {#first_letter:contains([F-J],[F - J],)} {#a_e} is a compositie field: {#first_letter:contains([A-E],[A - E],)} {#first_letter} is a compositie field: {author_sort:.1} I tried to add them into one, but it gave me an error |
10-02-2010, 04:12 PM | #5 |
Wizard
Posts: 4,812
Karma: 26912940
Join Date: Apr 2010
Device: sony PRS-T1 and T3, Kobo Mini and Aura HD, Tablet
|
Just curious
Why isn't the SOny supported by the plugboard? Helen |
Advert | |
|
10-02-2010, 04:21 PM | #6 |
Wizard
Posts: 3,130
Karma: 91256
Join Date: Feb 2008
Location: Germany
Device: Cybook Gen3
|
|
10-02-2010, 04:24 PM | #7 | |
Grand Sorcerer
Posts: 12,014
Karma: 7257321
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
|
Quote:
The plugboard supports changing the metadata for books *in the book*. Sony's don't use the metadata in the books, but instead use the information in the device's database (unless something goes wrong and the database is rebuilt). For lots of reasons, the information in the sony database is built using calibre's metadata, not the book's metadata, so changes made using the plugboard won't be used in the database. I can change the sony driver to use the plugboard when writing to its database, but the changes are non-trivial. My concern is that any mistake will change existing collection data. My experience to date with that sort of mistake has not been at all pleasant. Edit: The restriction has been removed. Sony DBs are now fully supported by the plugboard, using the special format 'device_db'. Last edited by chaley; 10-08-2010 at 06:26 AM. |
|
10-02-2010, 06:15 PM | #8 | |
Enthusiast
Posts: 45
Karma: 92
Join Date: Oct 2008
Location: Culver City, CA
Device: Kindle1, Kindle 3 wi-fi 3G, Kindle basic, Kindle Fire
|
Quote:
This works perfectly on the K1 - not on the K3. Is there something else I need to do, or is this something that needs to be added in Calibre itself? |
|
10-02-2010, 09:44 PM | #9 | |
Groupie
Posts: 155
Karma: 112134
Join Date: May 2009
Location: Kuala Lumpur
Device: iPad, K3, K4, T1
|
Quote:
{series:|| }{series_index:0>2s|[|] - }{title} |
|
10-02-2010, 10:11 PM | #10 | |
Zealot
Posts: 106
Karma: 501816
Join Date: Jan 2010
Location: Australia
Device: K3, K4, KPW
|
Quote:
I would like to use a combination though where I reduce the author to last name, initial and the series as above. I didn't understand the hash (#) used by the other poster though. Brewjono |
|
10-02-2010, 10:29 PM | #11 |
Zealot
Posts: 106
Karma: 501816
Join Date: Jan 2010
Location: Australia
Device: K3, K4, KPW
|
Hoping for some further clarification here.
Prefix this with I am using a K3. Any changes I make to the Preferences > Sending books to devices > Save Template only affects the Folder and file name structure within the Documents folder of my Kindle ie what I can see when using Windows Explorer, Any changes I make to the Preferences > Metadata Plugboards only affects what is displayed on my Kindle screen. Example: If I include info regarding the series on the send to device template it will include that info in windows exploer but not on the Kindle screen. If I want to display that series data on the actual kindle screen I have to use a Metadata Plugboard. That all being said does anybody have a suggestion of a plugboard I can use that will display the series as described by chaley ie {series}{series_index:0>2s| - | - }{title} and also the shortened author name as described be Sweetpea. I have been finding that with the full series name, title, and author it obviously doesn't fit on the K3 screen. I did notice that if you hover over it, it shows a second line of text. Thanks, Brewjono |
10-02-2010, 10:36 PM | #12 | ||
Wizard
Posts: 4,812
Karma: 26912940
Join Date: Apr 2010
Device: sony PRS-T1 and T3, Kobo Mini and Aura HD, Tablet
|
Quote:
I am trying to get the plugboard working adequately for my mother's kindle 3 and was hoping to be able to test/do it without actually having the kindle. (I have it now but her birthday is getting close) My mother is 85 and lives several thousand miles away so her being able to do it herself is problematic. Using this example Quote:
Along Came a Spider - James PattersonAC1.mobi And this on save to disk and on folder device. Along Came a Spider - James Patterson.mobi What am I doing wrong? Helen |
||
10-02-2010, 10:57 PM | #13 |
US Navy, Retired
Posts: 9,867
Karma: 13806776
Join Date: Feb 2009
Location: North Carolina
Device: Icarus Illumina XL HD, Kindle PaperWhite SE 11th Gen
|
I don't have your answer but I'm relatively sure you can test out the plug board by using the Connect to Folder option.
|
10-02-2010, 11:27 PM | #14 |
Enthusiast
Posts: 45
Karma: 92
Join Date: Oct 2008
Location: Culver City, CA
Device: Kindle1, Kindle 3 wi-fi 3G, Kindle basic, Kindle Fire
|
I got an answer on a different board - I should have selected Kindle2 in order for it to work on the K3.
I am a happy Kindler. |
10-02-2010, 11:49 PM | #15 | ||
Wizard
Posts: 4,812
Karma: 26912940
Join Date: Apr 2010
Device: sony PRS-T1 and T3, Kobo Mini and Aura HD, Tablet
|
Quote:
Quote:
|
||
Tags |
custom column, tag, tags |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
custom column i need a little help | shinken | Calibre | 3 | 09-15-2010 03:41 AM |
Using Custom Metadata in Save Template | EJvdH | Calibre | 1 | 07-02-2010 06:06 AM |
Accessories Decalgirl Kindle 2 custom skin template | srmalloy | Amazon Kindle | 6 | 04-09-2010 09:55 PM |
Donations for Custom Recipes | ddavtian | Calibre | 5 | 01-23-2010 04:54 PM |
Help understanding custom recipes | andersent | Calibre | 0 | 12-17-2009 02:37 PM |