Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management

Notices

Reply
 
Thread Tools Search this Thread
Old 01-18-2013, 12:24 PM   #1
richardsugg
Junior Member
richardsugg began at the beginning.
 
Posts: 6
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?
richardsugg is offline   Reply With Quote
Old 01-18-2013, 12:51 PM   #2
richardsugg
Junior Member
richardsugg began at the beginning.
 
Posts: 6
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.
richardsugg is offline   Reply With Quote
 
Enthusiast
Old 01-18-2013, 03:50 PM   #3
Sabardeyn
Guru
Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.
 
Sabardeyn's Avatar
 
Posts: 629
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.
Sabardeyn is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

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


All times are GMT -4. The time now is 08:20 AM.


MobileRead.com is a privately owned, operated and funded community.