|01-18-2013, 12:24 PM||#1|
Join Date: Sep 2011
setting authors.name to authors.sort
I wanted my author names to be the same as the sort field. I didn't see a way in Calibre to do this en masse, so used sqlite3 to do
update authors set name=sort;
The data looked correct, but in the main screen of calibre, all the author names showed up as "Lastname & Firstname" rather than "Lastname, Firstname". If I edit the metadata of an individual book, Calibre correctly shows "Lastname, Firstname" in the author field. It's only on the main screen that the "&" shows up as a separator.
How can I get the author name to be the same as the author sort field?
|01-18-2013, 03:50 PM||#3|
Join Date: May 2009
Location: The Right Coast
Device: PC (Calibre), Nexus 7 2013 (Moon+ Pro), HTC HD2/Leo (Freda)
Calibre is quite powerful and many desirable functions are built in. The problem is usually trying to remember where it is located and how to use it.
Remember to look at Preferences>Tweaks as that tends to be the location for "set it once and leave it that way" kinds of options.
|Thread Tools||Search this Thread|
|Thread||Thread Starter||Forum||Replies||Last Post|
|Author sort field with several authors||vRiki||Library Management||6||11-27-2012 02:05 PM|
|Sort Authors by First Name on Tag Browser||toothpicz||Calibre||3||02-13-2012 06:34 AM|
|Authors and Authors Sort||sadievan||Library Management||2||06-29-2011 03:33 PM|
|How do you sort Authors||rjfernandez||Calibre||8||11-21-2010 01:50 PM|
|Sort authors by last name||LightHouse Lady||Calibre||21||08-10-2010 05:32 AM|