Save to Disk

[Dethmaul]

I have a hard one (for me anyway).
I have my collection broken down into the following:

Reading Order - This is for books that are part of a multiverse. Books such as Star Wars or the Honorverse. They usually are in multiple series with multiple authors.

Example: Title - The Mandalorian Armor, Author - K.W. Jeter, Series - Bounty Hunter Wars, Series Index - 1, Read Order - Rebellion Era, Read Order Index - 42.

Save to Disk Result Wanted: Rebellion Era\[042] The Mandalorian Armor.xxx

Books Series - Books in a series - usually by the same author

Example: Title - Sackett's Land, Author - Louis L'Amour, Series - The Sackett's, Series Index - 1

Save to Disk Result Wanted: L\L'Amour, Louis\Sackett's, The\01 - Sackett's Land.xxx

Template: {author_sort[0]}/{author_sort}/{series}/{series_index:0>2s} - {title}

Stand Alone Novels - One shot books

Example: Title - A Walk to Remember, Author - Nicholas Sparks

Save to Disk Result Wanted: S\Sparks, Nicholas\Novels\A Walk to Remember.xxx

I have have several custom columns to help with this (I think i should be helping anyway.)

Custom Columns Created

Lookup Name: cc
Column Heading: Stand Alone Novels
Column Type: Text, column show in tag browser
Template:
Data Input: Example: Novels - Nicholas Sparks

Lookup Name: dd
Column Heading: Stand Alone Save
Column Type: Column built from other columns
Template: {#CC:shorten(6,,0)}
Sort: Text
Example of data: Novels - Nicholas Sparks

Lookup Name: readorder
Column Heading: Read Order
Column Type: Text column for keeping series-like information
Template:
Example of data: Rise of the Empire Era

Lookup Name: zz
Column Heading: STD_Series
Column Type: Column built from other columns
Template: {series_index:| [ | ] }{title}
Sort: Text

Lookup Name: aa
Column Heading: Series Save
Column Type: Column built from other columns
Template: {author_sort:.1}/{author_sort}/{series:ifempty ({#DD})||/}{series_index:0>2s|| - }{title}
Sort: Text

Lookup Name: yy
Column Heading: STD_Collection
Column Type: Column built from other columns
Template: {#readorder_index:| [ | ] }{title}
Sort: Text

Lookup Name: bb
Column Heading: Collection Save
Column Type: Column built from other columns
Template: {#readorder:||/}{#readorder_index:|Book | - }{title}{series:| - | - }{series_index:|Book |}

What I would like it to do is the following:
If part of a multiverse save as: {#readorder}/{#readorder_index:| [ | ] }{title}, if part of a series {author_sort:.1}/{author_sort}/{series:ifempty ({#DD})||/}{series_index:0>2s|| - }{title}, or if stand alone {#CC:shorten(6,,0)}/{title}

I think the above recipes are correct for what I am wanting, but I want it to run as one function. I want it to do any one of the above based on the info provided in the columns.

Is this possible or not?

Are my recipes correct for what I am wanting based on the columns I have and the results I want for each type?

Any help is appreciated.

Oh current plugboards... they don't seem to work correctly.

epub:save to disk {#readorder:lookup(.,#yy,#zz)} Destination: title

mobi:save to disk {#readorder_index:0>3s|[ | ] }{title} Destination: title

Really on my device, I just need titles to show as [##] - Book Title

Edit:
The hoop jumping is for backing up my collection on cloud storage.

[theducks]

I think your names all make the path to long and Calibres truncate rules kick in.

metadata.opf contains ALL the DB entries (XML), just back up the Library folder KISS

[eschwartz]

A valiant effort.

Looks fairly decent, but I prefer general program mode (very flexible if you know what you are doing) so I reimplemented it entirely from scratch -- why keep extra custom columns around if they can be consolidated in one? Besides, every custom template column slows down the database as it is built and rebuilt dynamically.

Save to Disk template:

program:

# Define the series and series index, using readorder if possible.
# Fallback on "Novels".
series = first_non_empty(
	field('#readorder'),
	series_sort(),
	'Novels'
);
sidx = ifempty(
	finish_formatting(field('#readorder_index'), '0>3s', '[', '] '),
	finish_formatting(field('series_index'), '0>2s', '', ' - ')
);

author = strcat(
	substr(field('author_sort'), 0, 1), '/',
	field('author_sort'), '/'
);

final_result = strcat(
	# If readorder does *not* exist, prepend author info.
	test(
		field('#readorder'),
		'',
		author
	),
	series, '/', sidx, field('title')
);