Quote:
Originally Posted by StanByk
Hi,
as has been discussed here the Sony ereaders don't seem to honour the author sort field. In calibre I have added authors with their first name first, eg.
author: Isaac Asimov
author_sort: Asimov, Isaac
Is there a way to automatically change author to be the same than author sort?
E.g. change Isaac Asimov to Asimov, Isaac?
|
No and Yes. The 'no' part is that I know of no easy way to bulk copy author_sort to author. There might be some tricks with the command line functions, and it can be done using SQL (being *very careful* not to break everything), but I found that in the end it was easier to do it by hand. I did it by hand for some 400 books by using the metadata editor in the GUI and copying author_sort to author (click, E, copy, paste, click OK, repeat. sigh). Tulda's suggestion would save time if you have many fewer authors than books, but be careful of books with multiple authors.
The 'yes' part is that once you have corrected author to be ln,fn, you need to tell Calibre how to compute the author_sort so that it doesn't end up backwards. First, set the 'tweak' that tells calibre how to copy author to author_sort. See
this post for some instructions.