In my old database, I had authors listed "last name, first name", which was easier to scan by eye. However, using Bookpedia and Amazon.com, the author names come in "first name last name". Although this seems 'normal,' it's much more difficult for the eye to pick out certain names, and I have to change all of my previous entries to match in order to sort columns correctly.
Has anyone else had this problem, and how have you dealt with it?
Thanks,
McFitz
Bookpedia: Author last name, first name or vice versa?
I'm not sure it's a problem, but rather a habit you've developed. A few weeks of reading names in non-reverse order may in time seem normal.
I'm not unsympathetic: I reversed all my names in Skype in order to group people with the same family names. It's less of a problem in 'pedia because the filters let us isolate names so quickly.
However, a DB like Endnote does allow a choice of naming style, and that might be good to have one day in the 'pedia apps.
I'm not unsympathetic: I reversed all my names in Skype in order to group people with the same family names. It's less of a problem in 'pedia because the filters let us isolate names so quickly.
However, a DB like Endnote does allow a choice of naming style, and that might be good to have one day in the 'pedia apps.
- teacher24_70
- Addicted to Bruji
- Posts: 94
- Joined: Sun Nov 21, 2004 12:51 am
- Location: Kansas
- Contact:
My original database that I imported from was set up the same way--last name, first name. I'm in the process right now of rearranging them to match the new default.
Unfortunately, I'm having to manually change them one at a time. A SMALL time saver was to sort by author and then it would at least group books by the same author together. I could then change one item and copy/paste it into the others by that author. I also started by creating a smart-collection of all items where author contains ",". This at least isolated all those I had to "fix" together. Of course it also pulled up all items that had multiple authors, but it was a least MOSTLY narrowed down.
It's a royal pain but I know that it will be worth it in the end to be able to sort correctly.
At least we can still sort by first OR last--it's just a matter of which one our eyes see first.
Unfortunately, I'm having to manually change them one at a time. A SMALL time saver was to sort by author and then it would at least group books by the same author together. I could then change one item and copy/paste it into the others by that author. I also started by creating a smart-collection of all items where author contains ",". This at least isolated all those I had to "fix" together. Of course it also pulled up all items that had multiple authors, but it was a least MOSTLY narrowed down.
It's a royal pain but I know that it will be worth it in the end to be able to sort correctly.
At least we can still sort by first OR last--it's just a matter of which one our eyes see first.
If you downloaded TextWrangler to remove the quotations then you can use the same power of regular expressions to flip the first and last names (not sure what happens with books with more than one author, so make sure to make backups as usual).
Look for:
replace with:
After setting up the search and replace, in the find window, use command-g (find again) make sure it's a one author book and use command-= (replace) to fli, this way overlooking the change.
Look for:
Code: Select all
<key>Author</key>\r\t\t\t<string>(.*), (.*)</string>
Code: Select all
<key>Author</key>\r\t\t\t<string>\2 \1</string>
- teacher24_70
- Addicted to Bruji
- Posts: 94
- Joined: Sun Nov 21, 2004 12:51 am
- Location: Kansas
- Contact: