Plugboard, template, and custom composite column recipes

[chaley]

Originally Posted by DMee

Don't suppose there's any way of getting it to use any other character in place of space?

I could live with, say, underscores

__32
_132
1999

??

{series_index:_>6d}

[kovidgoyal]

You could probably get it to use one of the various unicode spaces like the non-breaking space or the thin space/thick space. I doubt those space characters are compressed.

[DMee]

Aaaargh!! Thought you had cracked it then but....

PLUGBOARD TEMPLATE ERROR format: type d requires an integer..

Can't handle my 0.25 series numbers :-(

I give up :-(

[chaley]

Originally Posted by DMee

Aaaargh!! Thought you had cracked it then but....

PLUGBOARD TEMPLATE ERROR format: type d requires an integer..

Can't handle my 0.25 series numbers :-(

I give up :-(

I didn't realize you were using floating point numbers. This template handles them

{series_index:_>7.2f}

[DMee]

FINALLY

WOOOOOO

I owe you a pint

[DMee]

OK, now I know it can be done - is there any simple, easy way to swap plugboards so I can use the simple setup for most books and then use this for those awkward series?

[eschwartz]

Use a custom column to set which ones deserve the new template (or tag them) and do a list lookup to determine which template to use. When I get on the computer I will work out a general program mode template to do it, assuming no one beats me to it.

[eschwartz]

Okay, so assuming you want "Series Name [03] Book Title" as per post #533.

series_index should be prepended with underscores, to bump it up to 4 digits.

If the custom column "#complex_series" is set to true -- I'll just test if it has any value -- it will add two decimal places. Mark each awkward series with this.
(This would be easier if I could figure out how to test within a template for a numer with decimals.)

Template should be:

program:

ser_num = test(
	field('#complex_series'),
	finish_formatting(
		field('series_index'),
		'_>7.2f',
		' [',
		'] '
	),
	finish_formatting(
		field('series_index'),
		'_>4d',
		' [',
		'] '
	),
);

strcat(
	field('series'),
	ser_num,
	field('title')
)

(You can delete whitespace if you want, but I left it in to clarify what I am doing.)

[DMee]

O.....K......
Mind officially blown

At moment I am using metadata plugboard which allows me to email any book to my kindle and get it formatted as I want.

So, idiot instructions please. Where does this code go and how do I alter my workflow to use it??

[chaley]

Originally Posted by eschwartz

If the custom column "#complex_series" is set to true -- I'll just test if it has any value -- it will add two decimal places. Mark each awkward series with this.
(This would be easier if I could figure out how to test within a template for a numer with decimals.)

The following tests whether a number is an integer by comparing the integer formatted value against the floating point formatted value.

program: 
	sindex = raw_field("series_index");
	cmp(format_number(sindex, '{0:d}'), format_number(sindex, '{0:f}'), 'not int', 'int', 'not int')

[DMee]

Chaley, if that checks on a per-item basis it won't trigger for all the books in the series, just those with fractions?

[chaley]

Originally Posted by DMee

Chaley, if that checks on a per-item basis it won't trigger for all the books in the series, just those with fractions?

You are right. I answered what I thought was the question, but clearly I was confused.

I have a python "script" that puts the correct format for a series into a custom column. It looks at all books in the series, figures out whether it needs decimals and how many leading zeros (could be underscores) are required, and then writes the correct format for "format_number" to the custom column for each book in the series. The script is run from the command line with calibre-debug -e. I mention this mostly to agree that I was being dense, especially as I had already solved this problem in a different way, but if you are comfortable with this sort of thing you are welcome to use the script appropriately modified.

The script is:

Spoiler:

def init_cache(library_path):
	from calibre.db.backend import DB
	from calibre.db.cache import Cache
	backend = DB(library_path)
	cache = Cache(backend)
	cache.init()
	return cache

import math
from collections import defaultdict
	
cache = init_cache(library_path = 'path-to-your-library')
series_info = defaultdict(dict)

for id_ in cache.all_book_ids():
	series = cache.field_for('series', id_)
	if series:
		sidx = cache.field_for('series_index', id_)
		str_sidx = str(sidx)
		components = str_sidx.split('.')
		if components[1] == '0':
			fract_part = 0
		else:
			fract_part = len(components[1])
		val_part = len(components[0])
		series_info[series]['val_part'] = max(series_info[series].get('val_part', 0), val_part)
		series_info[series]['fract_part'] = max(series_info[series].get('fract_part', 0), fract_part)
		
for series,sinfo in series_info.iteritems():
	fract_part = sinfo['fract_part']
	format_str = '{0:0%d.%df}'%(sinfo['val_part'] + fract_part + (1 if fract_part > 0 else 0), fract_part)
	sids = cache.search('series:"=' + series + '"')
	dct = {book_id:format_str for book_id in sids}
	cache.set_field('#text', dct)

[eschwartz]

Originally Posted by chaley

The following tests whether a number is an integer by comparing the integer formatted value against the floating point formatted value.

program: 
	sindex = raw_field("series_index");
	cmp(format_number(sindex, '{0:d}'), format_number(sindex, '{0:f}'), 'not int', 'int', 'not int')

Must keep this trick in mind. I knew there had to be something.

Originally Posted by DMee

Chaley, if that checks on a per-item basis it won't trigger for all the books in the series, just those with fractions?

And I didn't think of this either. So it was not you who was confused, chaley.

[JSWolf]

delete post

[EnergyLens]

I thought this would be easy, but I am totally lost.

I know how to do a search for only PDF by excluding other formats, but I don't know how to use the template language to do the same...

Can someone give me a quick pointer?