setting authors.name to authors.sort

richardsugg · 01-18-2013, 12:24 PM

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?

richardsugg · 01-18-2013, 12:51 PM

Found it and "wow"! In tag browser, right click on Authors and choose "manage authors". THere's an option there to do *exactly* what I wanted.

Sabardeyn · 01-18-2013, 03:50 PM

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.

01-18-2013, 12:24 PM	#1
richardsugg Junior Member Posts: 8 Karma: 10 Join Date: Sep 2011 Device: iPad	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?

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

Similar Threads
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

01-18-2013, 12:51 PM	#2
richardsugg Junior Member Posts: 8 Karma: 10 Join Date: Sep 2011 Device: iPad	Found it and "wow"! In tag browser, right click on Authors and choose "manage authors". THere's an option there to do exactly what I wanted.

01-18-2013, 03:50 PM	#3
Sabardeyn Guru Posts: 644 Karma: 1242364 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.

Advert