Quote:
Originally Posted by Starson17
I don't want to belabor the point, but the records display what is in "author" and sort by what is in "author_sort" To help you fix it, I have to make sure you are looking at the content of the two fields. For some reason, you either are not seeing what I see, or you aren't looking at the right location.
To further explain, here is how Calibre works: When you add a book, you tell Calibre the author name. Calibre then tries to figure out the author_sort name. It's not very smart about this and just sticks the last part of the name at the front, separated by a comma. From then on, it will not change the author_sort. If it isn't sorted as you want, you need to change author_sort. If the author name isn't showing up correctly, you need to change that. Changing one does not change the other.
If you prefer to use Lastname, Firstname, there's a tweak that will prevent this name reversal or control it when Calibre enters the author_sort field. If you don't use the Tweak, and tell Calibre the name is "Brown, Dan," Calibre will just enter "Dan, Brown" into the author_sort field and sort on D.
|
hmmm.
Here's what I think:
a) My correcting the metadata isn't getting "saved" (however it is that one "saves" thbeir changes
b) My having a corrected (according to my beliefs, which granted could be faulty) database when I posted the first item in this thread, and my having continued making changes and what have you based on what I've read as a result of posting on this thread, including moving my library for example before posting my metadata.db file and
c) something I don't yet understand which could potentially make my typing "e" to edit the metadata, making standardized entries to "author" and "author sort" fields and expecting that my changes both register and are retained (either I'm going into the data "the wrong way" or what I'm doing "isn't taking" or something else is going on.
For example, if I go in right now as I write this and I find Don Quixote as a record in my database, hit "e" to enter the metadata editing window, what I see as "author-sort" is the same as what is entered for "author", namely Cervantes Saavedra, Miguel de
Now, I might want to enter ti a different way and have it sort on something other than the "d". but that isn't what my problem is. It's that, no matter what changes I make to the database, it keeps reverting itself back to the utter chaos it was at the moment immediately after I added all the files.
so that, Anne McCaffrey is entered into the Author and Author-Sort fields in a multiplicity of ways. And as a result, her name shows up in sorts in a hundred different ways. And, me making changes to the metadata does not appear to have much impact on that chaos.
So... clearly, whatever I'm doing ain't cutting it. I wish it were just a simple cut and dried user-error issue because I can learn how to fix my own behavior.