Library Management: various questions not worth their own thread

[7hir7een]

Also, I'd like to trim down long kindle book titles that often have the series name and the genre in the title.

Is there any way to search for titles that are, say, over 100 characters?

[Comfy.n]

Originally Posted by 7hir7een

Also, I'd like to trim down long kindle book titles that often have the series name and the genre in the title.

Is there any way to search for titles that are, say, over 100 characters?

title:"~^.{100}"

that's based on a search @chaley gave us to search for very large comments

[ownedbycats]

Originally Posted by 7hir7een

Also, I'd like to trim down long kindle book titles that often have the series name and the genre in the title.

Is there any way to search for titles that are, say, over 100 characters?

template:"""program: strlen($title)#@#:n:>=100"""

[ownedbycats]

"Quotations" are auto-removed in title sort. not other punctuation like (parentheses) or ...ellipses. (Fanfic titles tend to go more stylistic). Is there a tweak for this? per_language_title_sort_articles doesn't seem suitable.

[ownedbycats]

I want to display a column icon when there's data files in the book. There's two ways I can see to do this:

1. Create a rule for program: extra_file_names(',') with any value. High-impact.

2. Update a noncomposite column (either #admintags or a new #extrafiles) and use Action Chains to update it. Less impact, but without a way (that I know of) to auto-update it when adding a file (which means forgetting).

Is extra_file_names() very slow, or is there a better option?

[chaley]

Originally Posted by ownedbycats

I want to display a column icon when there's data files in the book. There's two ways I can see to do this:

1. Create a rule for program: extra_file_names(',') with any value. High-impact.

2. Update a noncomposite column (either #admintags or a new #extrafiles) and use Action Chains to update it. Less impact, but without a way (that I know of) to auto-update it when adding a file (which means forgetting).

Is extra_file_names() very slow, or is there a better option?

Other than a python template, extra_file_names() is the only way to determine that something is in the data directory. That function must read the disk to make the determination, so yes, it will not be fast. Whether it is fast enough only you can know. I suspect it will be acceptable because it will only run when the book is visible in the booklist and the answer to extra_file_names() is cached.

As for the action chains, perhaps you can partially solve the problem by running the chain when calibre starts or stops. You might also be able to convince Kovid to add an event to the methods in cache.py that modify the data directory.

[BetterRed]

I use the extra_data_files function to show a folder icon:

program:
	if has_extra_files()
		then 'folder.png'
	else
		'transparent_square.png'
	fi

I have a library of 8,473 books, 2,951 (~35%) books have non-empty 'data' folders (there are probably a few hundred empty ones, I don't bother removing empty data folders). The library is on a 7,200 rpm SATA III (6.0Gb/s) HDD.

Because it's a wet cold Sunday morning, I removed the rule. I cannot discern any noticeable difference when hitting page down on the book list (48 lines per page), it is more or less instantaneous with or without the 'has_extra_files' column icon rule.

BR

[ownedbycats]

<p><span class='label'>Series</span>: <div class='metadata' id='seriesHTML'><a class='serieslink' href='., /, 2, 4, 5, 8, 9, :, a, c, e, f, g, h, i, n, o, p, r, s, t, u, v, w'> , &amp;, 3, [, ], a, b, d, e, f, h, i, k, l, n, o, r, s, t, u, w, ’</a></div><p>

<p><span class='label'>Series</span>: <div class='metadata' id='seriesHTML'><a class='serieslink' href='., /, 1, 7, 9, :, a, c, e, f, g, h, i, n, o, p, r, s, t, u, v, w'> , ', 3, E, N, S, [, ], i, k, n, o, s, t, y</a></div><p>

Due to some unknown glitch with FanFicFare, I have an unknown number of books where the longtext metadata column contains a string that resembles these two. Can fix it by replacing the stored metadata from website, but any idea how to search for affected fics?

[chaley]

Originally Posted by ownedbycats

<p><span class='label'>Series</span>: <div class='metadata' id='seriesHTML'><a class='serieslink' href='., /, 2, 4, 5, 8, 9, :, a, c, e, f, g, h, i, n, o, p, r, s, t, u, v, w'> , &amp;, 3, [, ], a, b, d, e, f, h, i, k, l, n, o, r, s, t, u, w, ’</a></div><p>

<p><span class='label'>Series</span>: <div class='metadata' id='seriesHTML'><a class='serieslink' href='., /, 1, 7, 9, :, a, c, e, f, g, h, i, n, o, p, r, s, t, u, v, w'> , ', 3, E, N, S, [, ], i, k, n, o, s, t, y</a></div><p>

Due to some unknown glitch with FanFicFare, I have an unknown number of books where the longtext metadata column contains a string that resembles these two. Can fix it by replacing the stored metadata from website, but any idea how to search for affected fics?

Use regexp search to look for books where the column contains

href='., /,

?

[ownedbycats]

Worked, thanks. Only a few stories affected thankfully.

[adolwyn]

If I am updating my whole library (I made a longer post on its own about everything), is the best practice to download metadata first (to ensure the various ids are set up properly) and then download covers? Or does it matter?

[ownedbycats]

Adding ISBN first (manually or with the Check ISBN plugin) can help in getting the metadata + covers for your specific edition, at least.

[saxondawg]

Hi, folks. As a longtime Calibre user (almost since its inception) I have, of course, tinkered enough with my library that I have re-converted everything multiple times, going to various formats. Since my preferences were always set to place summary metadata at the front of the book, I have ended up, suddenly with books that have the metadata three or four times in front of the book. I wish there were a button for this in Quality Check. Is there some way to remove excess metadata summaries from multiple books without editing them one by one? This is not a huge deal, but a solution would be appreciated!

[theducks]

Quality check plugin: check for multiple jackets

[BetterRed]

I would use this plugin ==>> Modify ePub



Modify Epub doco

BR