Library Management: various questions not worth their own thread

[ownedbycats]

This did it:

#purchasesource:true AND (date:>=2013 AND date:<=2019)

[ownedbycats]

What's the best way to find items in a custom column that end with a period? I have a template that can produce these if I forgot to fill out another column first.

[chaley]

Originally Posted by ownedbycats

What's the best way to find items in a custom column that end with a period? I have a template that can produce these if I forgot to fill out another column first.

Is it a tags-like column? If so, this search template will be the fastest way. Set 'field' to your column lookup key. This will work for non-tags-like, but in that case it won't be much faster than a GPM template.

python:
def evaluate(book, context):
	field = '#genre'

	items = book.get(field, [])
	if not isinstance(items, (list, tuple, set)):
		items = (items, )
	for t in items:
		if t.endswith('.'):
			return '1'
	return ''

[ownedbycats]

Thank you!

[ownedbycats]

In my series:true VL, what would be the lowest-impact way to exclude series with only one book?

[chaley]

Originally Posted by ownedbycats

In my series:true VL, what would be the lowest-impact way to exclude series with only one book?

This template search should be fast enough to use in a VL. You probably want to make it a stored template.

python:
def evaluate(book, context):
	# Return True ('yes') if the value in 'field' is used by more than 'test_count' books.
	# This template only works with single value fields such as Series, Publisher, and enumerations
	field = 'series'
	test_count = 1

	db = context.db.new_api
	id_map = context.globals.get('id_map')
	if id_map is None:
		context.globals['id_map'] = id_map = db.get_item_name_map(field)
		context.globals['item_book_count'] = db.get_usage_count_by_id(field)
	item_book_count = context.globals['item_book_count']

	item_id = id_map.get(book.get(field))
	if item_id is None or item_book_count.get(item_id, 0) <= test_count:
		return ''
	return 'yes'

[ownedbycats]

That worked! I saved it as series_multibook().

[correoparaappzz]

hi, is there a way to change author_sort from 'Last Name, First Name' to 'First Name Last Name' without doing it one by one in Manage authors

[Karellen]

Originally Posted by correoparaappzz

hi, is there a way to change author_sort from 'Last Name, First Name' to 'First Name Last Name' without doing it one by one in Manage authors

Probably need to explain why you would want to do that. There might be another way to get the results you are after.

Check out Preferences>Tweaks>Author sort name algorithm

[theducks]

Quality check Plugin can identify and fix 2 common Author name issues
1)Initials format. 2 )Name order (Fn Ln or Ln, Fn)
Step 0 is to configure the PI with your preferences (author Initial format)
Step 1 is to run Check Metadata: the author with or without commas (what is the wrong way for you): Select All results: Fix:...
Step 2 is to do the same check, except for Initials. And the Fix: Initials

The only fix that this can't find or do is when it is a Joe and Jane Smith type. You need to hand edit to Joe Smith&Jane Smith. If you do this in rename in the Tag Browse , it does all uses

[correoparaappzz]

Originally Posted by Karellen

Probably need to explain why you would want to do that. There might be another way to get the results you are after.

Check out Preferences>Tweaks>Author sort name algorithm

[ownedbycats]

Is there better way to do this search? Want to find books that have tags only in subjects.

(NOT tags:"=.Comics" 
AND NOT tags:"=.Documentations & Manuals" 
AND NOT tags:"=.Fanfiction" 
AND NOT tags:"=.Fiction" 
AND NOT tags:"=.Magazines & Publications" 
AND NOT tags:"=.Nonfiction") 

AND tags:"=.Subjects"

[PeterT]

Not being a templats language expert, I'd think that using list_intersection might be an idea; something along the lines of list_intersection(tags, <list of comics, fanfiction, etc>

If the list_intersection is null and tags = subjects

[chaley]

Originally Posted by PeterT

Not being a templats language expert, I'd think that using list_intersection might be an idea; something along the lines of list_intersection(tags, <list of comics, fanfiction, etc>

If the list_intersection is null and tags = subjects

List_intersection was the first thing I thought of, but given that the OP is using the "=." form of the search, it won't work well because it checks the entire value.

Using in_list might be better than a series of and conditions. It depends on how common the tests are, because search does shortcutting. By in_list I mean something like this:

program:
	if ! ("\.Comics$|\.Documentations & Manuals$|\.Fanfiction$|\.Fiction$|\.Magazines & Publications$|\.Magazines & Publications$" inlist $tags) && "\.Subjects$" inlist $tags then
		'whatever'
	fi

However, what you have isn't bad because of shortcutting, is easy to read, and easy to change, so I probably wouldn't mess with it.

[7hir7een]

Is there a way to create a tag from two different tags that will stay updated?

i.e., I have "Horror & Ghost Stories" and "Science Fiction"

I want "Horror/Science Fiction" to be the tag for the intersection of both genres. I know I can do this manually via searching and tagging, but it'd be nicer if there was an automatic way of doing it