View Single Post
Old 02-22-2024, 11:19 AM   #604
tagehring
Junior Member
tagehring began at the beginning.
 
Posts: 8
Karma: 10
Join Date: Apr 2018
Location: Central Virginia
Device: Boox Note Air 3
Quote:
Originally Posted by chaley View Post
I suspect that it isn't possible without changing the plugin. The problem: depending on the API used, changing the author causes calibre to recompute the author sort. If the plugin sets author after author_sort then the recomputation will overwrite what was set. If my guess is correct then the fix would be for the plugin to ensure that author_sort is always set after author.

The most reliable way to do this is an expansion of what you are already doing.
  1. Clear all values from the sort custom column using bulk metadata edit.
  2. Run Import list.
  3. Select all books now having values in the custom column using #column_key:true
  4. Use bulk metadata edit / search and replace to copy the custom column to the author_sort column.
You could use the Action Chains plugin to do all the above steps in one chain.
Now that I've got import working reliably and overwriting data the way I want, I think I'm going to just replace the Author column and then tweak the author sort algorithm to include some of the prefixes/suffixes/copywords it's missing and then recompute the values.
tagehring is offline   Reply With Quote