Using templates for file names, plugboards, composite columns, searches, tooltips

[eschwartz]

Originally Posted by chaley

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)

Applying one teeny update.
You can use the current library path from the preferences with a simple

from calibre.utils.config import prefs
library_path = prefs['library_path']

I referred this script to someone so it came up.

Enclosed is a downloadable add-series-to-custom-column.py.zip for convenience. It assumes the custom column is "#formatted_series".

[phossler]

This thread might be a useful stickie

[PeterT]

Originally Posted by phossler

This thread might be a useful stickie

It is and has been for a LONG time!

[crissman]

Not sure if this post is relevant for this thread or not, but I was wondering if I could pick some peoples brains on and ideas to manage a book that belongs several series.

Example:
Stuart Woods - Reckless Abandon
Series: Stone Barrington [10]
Series: Holly Barker [4]

or

R.A. Salvatore -The Crystal Shard
Series: Icewind Dale Trilogy [1]

but also can be read as part of a much larger reading order for those wishing to read about Drizzt

Series: Legends of Drizzt [4]

This would especially be useful for reading books with both publication orders, chronological orders, or chosen reading orders for several series that overlap for example, The Enderverse Saga that incorporates many series.

Currently I have been just entering in the secondary series into the title.
Author: R.A. Salvatore
Title: The Crystal Shard: Also Icewind Dale Book 1
Series: Legends of Drizzt [4]

Kinda of ugly in my opinion and not good if you want to sort by the different series.

Thanks crissman

[BetterRed]

@crissman - If you're not OCD about duplicate books then maybe something like this.



Notes is a long text (like Comments) custom column cloaked by an icon in the book list. The EPUB is Here link is created via the Link tool in the long text (Comments) editor.

BR

[chaley]

Originally Posted by crissman

Not sure if this post is relevant for this thread or not, but I was wondering if I could pick some peoples brains on and ideas to manage a book that belongs several series.

The thread https://www.mobileread.com/forums/sho...d.php?t=252883 might be of help.

[eschwartz]

Originally Posted by PeterT

It is and has been for a LONG time!

In point of fact, it has not been a sticky for very long at all. This one was: https://www.mobileread.com/forums/sho...d.php?t=118563

P.S. Thanks chaley, I guess you stickied it?
Well, whoever did... perhaps the nearly-identical thread can be unstickied or merged and the OPs deduplicated?

[PeterT]

I stand corrected. TheDucks did it.

[chaley]

One issue here is that stickies seem not to be used for conversations. You can see that most of them are closed to new posts. This thread is certainly an outlier.

[eschwartz]

Depends on the thread, see here for example: https://www.mobileread.com/forums/forumdisplay.php?f=150


Sometimes stickies are there to pin very-important-discussions where everyone can find them, which is what I believe the plugboards/templates thread is all about.

[theducks]

Stickies can be open or closed. They are 2 distinct operations.
Some are closed to keep them lean (and hopefully read) for very important topics.

Others, like the "Plugin ideas" are open so as to generate ideas (and inspiration to develop)

[crissman]

Originally Posted by BetterRed

@crissman - If you're not OCD about duplicate books then maybe something like this.

Attachment 135100

Notes is a long text (like Comments) custom column cloaked by an icon in the book list. The EPUB is Here link is created via the Link tool in the long text (Comments) editor.

BR

Actually I guess I can say I am a little OCD, I like things to looks a certain way, and having duplicate entries wouldn't really work for me, The Idea is sound but not quite what I was looking for. I was almost just considering just using a second series column.

Thanks
crissman

[crissman]

Originally Posted by chaley

The thread https://www.mobileread.com/forums/sho...d.php?t=252883 might be of help.

Thanks, I will look into reading this tomorrow and see what might help, a little to tired at the moment. and just wanted to express my thanks for the reply.


crissman

[Amalthia]

Hi,

It appears that my plugboard settings have stopped working for my Sony PRS-T3. I created a column for my title, called "title_sony" and I've attached a screenshot of my plugboard settings.

The goal is that the information in my title_sony column should be what is in my title field on the device. I'm not sure what may have changed but my settings used to work and now they don't.

I'd appreciate any and all help.

Thanks,
Amalthia

p.s. I'm on Calibre: 2.20

[eschwartz]

Looks like it should work? (device_db is for changing the Sony onboard db on connect, right?)

Are these books you are transferring now?