MobileRead Forums - View Single Post

Merischino · 07-28-2010, 05:20 PM

short answer: yes.

Long answer:
to "correct" the metadata for all of Anne McCaffrey's 105 works (in my database), i perform a number of different procedures, all of which include the steps of selecting the works(s) in a calibre GUI list, hitting "e" to open what I will call the 'metadata editing window" and then depending on whether there are multiple items or a single item selected, making changes to the Author and the Author Sort fields, if it's an actual novel downloading metadata such as the ISBN, to enable doanloading of the cover. Once all that is done, I close out that metadata editing window, I hit "c" to "convert" the file back into the same format it was when I began.

So, for Anne McCaffery's "Power Lines", which may show up at first in my library as "Power Lines" by "Power Lines" showing up in a list of authors sorted as "Power Lines" (note, not reversed)

I would select that item, hit "e"
In the dialog box that opens, I would change the Author to "McCaffrey, Anne" and then select that text and tab over to the next field for "author sort" and hit command-V to paste the duplicate text into the second field.

I would then possibly make other edits buyt for now we are focusing on the author and author sort issues.

After making those two fields display the same, desired, text, I would click "ok"

and expect that my library would now sort according to the new information, irrespective of whether or not I have overwritten the existing files with the new data. E.g., I would expect "Power Lines" on the left under "Title" to be the same, "Power Lines" to the right under author to have changed, and to read "McCaffrey, Anne", and if I removed the search query and sorted the total library on "author" I would expect the book "Power Lines" to appear in the "M" section for McCaffrey, Anne and not in the "A" section, and not to show "Anne McCaffrey" in either the "a" or the "m" section, but to show "McCaffrey, Anne" in the "m" section of that list.

Now, I do not know when my changes to the metadata within the GUI get reflected in the Metadata.db. Whether that happens instantaneously or only if/unless I convert (or re-convert, since it's going to the same format) or (ugh) "save to disk".

But, only one thing can I say is true:
I have put a lot of time and effort into changing the metadata, by hitting "e" and editing the metadata in that window, to reflect what I have b een posting here as what I believed to be in my database.

Namely, that all my author fields should have the same exact entry as the author-sort field.

What happens with it after I hit "e" and make edits, I cannot speak to.

And, again I thank you for your help and apologize for my frustration, which I know must be coming through. It's not directed at you.

07-28-2010, 05:20 PM	#40
Merischino Groupie Posts: 199 Karma: 436584 Join Date: Jul 2010 Location: the beautiful Pacific Northwest Device: Kindle Oasis, Pixel 2, Kindle Fire HD 8	short answer: yes. Long answer: to "correct" the metadata for all of Anne McCaffrey's 105 works (in my database), i perform a number of different procedures, all of which include the steps of selecting the works(s) in a calibre GUI list, hitting "e" to open what I will call the 'metadata editing window" and then depending on whether there are multiple items or a single item selected, making changes to the Author and the Author Sort fields, if it's an actual novel downloading metadata such as the ISBN, to enable doanloading of the cover. Once all that is done, I close out that metadata editing window, I hit "c" to "convert" the file back into the same format it was when I began. So, for Anne McCaffery's "Power Lines", which may show up at first in my library as "Power Lines" by "Power Lines" showing up in a list of authors sorted as "Power Lines" (note, not reversed) I would select that item, hit "e" In the dialog box that opens, I would change the Author to "McCaffrey, Anne" and then select that text and tab over to the next field for "author sort" and hit command-V to paste the duplicate text into the second field. I would then possibly make other edits buyt for now we are focusing on the author and author sort issues. After making those two fields display the same, desired, text, I would click "ok" and expect that my library would now sort according to the new information, irrespective of whether or not I have overwritten the existing files with the new data. E.g., I would expect "Power Lines" on the left under "Title" to be the same, "Power Lines" to the right under author to have changed, and to read "McCaffrey, Anne", and if I removed the search query and sorted the total library on "author" I would expect the book "Power Lines" to appear in the "M" section for McCaffrey, Anne and not in the "A" section, and not to show "Anne McCaffrey" in either the "a" or the "m" section, but to show "McCaffrey, Anne" in the "m" section of that list. Now, I do not know when my changes to the metadata within the GUI get reflected in the Metadata.db. Whether that happens instantaneously or only if/unless I convert (or re-convert, since it's going to the same format) or (ugh) "save to disk". But, only one thing can I say is true: I have put a lot of time and effort into changing the metadata, by hitting "e" and editing the metadata in that window, to reflect what I have b een posting here as what I believed to be in my database. Namely, that all my author fields should have the same exact entry as the author-sort field. What happens with it after I hit "e" and make edits, I cannot speak to. And, again I thank you for your help and apologize for my frustration, which I know must be coming through. It's not directed at you.