size column

[iomari]

Greetings,
It appears that the size column does not total all the formats of a particular entry. How can I accomplish this?

[theducks]

Originally Posted by iomari

Greetings,
It appears that the size column does not total all the formats of a particular entry. How can I accomplish this?

IIRC The size shows the Biggest one (single format) only.

The QC plugin can recalculate the size column values (if you have modified that format after importing/or conversion).
IMHO Total is only useful for Libraries. I send a specific, single format, to my device. Not all formats (which it does poorly with many of those).

[chaley]

You can get a list of the formats with their sizes using a composite custom column (column built from other columns) with the template {:'formats_sizes()'}

You can get the sum of the sizes in one of two ways.

• The most efficient would be to write a custom template function (preferences, advanced, template functions) that sums the values returned by format_sizes. The function would be something like
  

  Function name: mySum
  Arg count: 1
  Program code:
  def evaluate(self, formatter, kwargs, mi, locals, x):
  	r = 0
  	if x.strip():
  		for p in x.split(','):
  			v = p.split(':')[1]
  			r += long(v)
  	return unicode(r)

  Then you would use this function in a composite column with the template

  {:'mySum(formats_sizes())'}

  or perhaps

  {:'human_readable(mySum(formats_sizes()))'}

• Easier if you are not a python programmer but definitely more of a bother to do would be to make a composite custom column containing a variant of the following template:
  

  program: 
  	fs = formats_sizes();
  	v = select(fs, 'PRC');
  	v = add(v, select(fs, 'EPUB'));
  	v = add(v, select(fs, 'MOBI'));
  	v = add(v, select(fs, 'TXT'));
  	v = add(v, select(fs, 'LIT'));
  	v = format_number(v, '{0:5.0f}');
  	human_readable(v)

  Duplicate the v = add... line as many times as necessary to include all the formats of interest.

[iomari]

Thanks guys

[iomari]

chaley your snippet worked perfect for me. Is it possible to format the {:'formats_sizes()'} function with human readable? I tried {:'human_readable(formats_sizes())'} but it returned an error.

[chaley]

Originally Posted by iomari

Is it possible to format the {:'formats_sizes()'} function with human readable? I tried {:'human_readable(formats_sizes())'} but it returned an error.

No. Human_readable requires a single number.

You can, of course, do this in a user-defined formatter function. It would look something like

Function name: mySizes
Arg count: 1
Program code:
def evaluate(self, formatter, kwargs, mi, locals, x):
	from calibre import human_readable
	r = []
	if x.strip():
		for p in x.split(','):
			v = p.split(':')
			r.append(v[0] + ': ' + human_readable(long(v[1])))
	return ', '.join(r)

and would be used something like

{:'mySizes(formats_sizes())'}

[iomari]

cool, thanks