|
It makes no sense to copy from a books author_sort to the author_sort table. A book can have multiple authors, and there is no guarantee that the books author sort value is decomposable into individual author sort values. Therefore, there is no way to do what you are asking via metadata import. You can control the algorithm calibre uses to derive sort name via Preferences->Tweaks and you can correct individual author sort values by right clicking the author name in the tag browser and choosing "Manage authors". Once you have corrected the value for a particular author, it will remain that way for future imports as well.
|