Template issue

jr1 · 05-18-2023, 12:09 AM

I've tried both of these templates for sending books to devices:
{author_sort:.1}/{author_sort}/{series}{series_index:0>5.2f| - | - } {title} - {authors:sublist(0, 1, &)} ({id})

{author_sort[0]}/{author_sort}/{series}{series_index:0>5.2f| - | - } {title} - {authors:sublist(0, 1, &)} ({id})

They both work fine in the template tester but when I push them to my tablet via Calibre Companion, instead of the 1 character from the author_sort field being the name of the 1st subdirectory in the path, I end up with "[Invalid column]" being the first subdirectory in the path.

Any ideas from anyone out there? Thank you in advance!!

theducks · 05-18-2023, 10:31 AM

When I first started, I included {id} in my template.

Turns out, that is not a great plan as things do change ( due to user actions) over time and because of 'ID', you break/reduce reliable, duplicate file detection.

jr1 · 05-18-2023, 11:31 PM

Thanks for the information. I can live without the ID. My bigger problem is trying to get author_sort issue resolved so I can get the single character author last name subdirectory created and get my books and magazines pushed back over to my tablet and be back in business.

05-18-2023, 12:09 AM	#1
jr1 Junior Member Posts: 9 Karma: 10 Join Date: Aug 2019 Device: Samsung Galaxy Tab A	Template issue I've tried both of these templates for sending books to devices: {author_sort:.1}/{author_sort}/{series}{series_index:0>5.2f\| - \| - } {title} - {authors:sublist(0, 1, &)} ({id}) {author_sort[0]}/{author_sort}/{series}{series_index:0>5.2f\| - \| - } {title} - {authors:sublist(0, 1, &)} ({id}) They both work fine in the template tester but when I push them to my tablet via Calibre Companion, instead of the 1 character from the author_sort field being the name of the 1st subdirectory in the path, I end up with "[Invalid column]" being the first subdirectory in the path. Any ideas from anyone out there? Thank you in advance!!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
[1.9.20] css template issue	byword	Sigil	16	09-06-2022 01:52 PM
Template: saving template tester when restarting Calibre	ownedbycats	Library Management	14	03-29-2021 05:57 PM
Template: Converting a search & replace into a template	ownedbycats	Library Management	11	03-26-2021 04:32 AM
Using built-in template functions in a custom template function	ilovejedd	Library Management	4	01-28-2018 12:20 PM
Issue with Send to Device template	BookJunkieLI	Library Management	5	02-14-2014 01:16 AM

05-18-2023, 10:31 AM	#2
theducks Well trained by Cats Posts: 31,001 Karma: 60358908 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	When I first started, I included {id} in my template. Turns out, that is not a great plan as things do change ( due to user actions) over time and because of 'ID', you break/reduce reliable, duplicate file detection.

05-18-2023, 11:31 PM	#3
jr1 Junior Member Posts: 9 Karma: 10 Join Date: Aug 2019 Device: Samsung Galaxy Tab A	Thanks for the information. I can live without the ID. My bigger problem is trying to get author_sort issue resolved so I can get the single character author last name subdirectory created and get my books and magazines pushed back over to my tablet and be back in business.

Advert