View Single Post
Old 02-22-2024, 09:21 AM   #602
chaley
Grand Sorcerer
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 12,476
Karma: 8025702
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
Quote:
Originally Posted by tagehring View Post
Adding screenshots of the problem after fixing #2 above. I'm trying to map the author_sort to a user-created Author Sort column, I know it's not the default author_sort metadata tag. But I would prefer overwriting the default author_sort via CSV if possible.
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.
chaley is offline   Reply With Quote