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

Go Back   MobileRead Forums > E-Book Software > Calibre

Notices

Reply
 
Thread Tools Search this Thread
Old 03-28-2010, 07:57 AM   #1
StanByk
Connoisseur
StanByk began at the beginning.
 
Posts: 54
Karma: 10
Join Date: Apr 2009
Location: London, UK
Device: Sony PRS-650
Author Sort - change automatically?

Hi,
as has been discussed here the Sony ereaders don't seem to honour the author sort field. In calibre I have added authors with their first name first, eg.
author: Isaac Asimov
author_sort: Asimov, Isaac

Is there a way to automatically change author to be the same than author sort?
E.g. change Isaac Asimov to Asimov, Isaac?

I have quite a few books in my library and don't want to do it manually.

Thank you,
Robert
StanByk is offline   Reply With Quote
Old 03-28-2010, 08:40 AM   #2
tulsa
Zealot
tulsa has a complete set of Star Wars action figures.tulsa has a complete set of Star Wars action figures.tulsa has a complete set of Star Wars action figures.tulsa has a complete set of Star Wars action figures.tulsa has a complete set of Star Wars action figures.
 
tulsa's Avatar
 
Posts: 135
Karma: 488
Join Date: Mar 2010
Location: Tulsa, OK, USA
Device: Kindle 2, Sony PRS 900
I'm not sure about doing the whole shebang automatically, but you can bulk edit books if you want.

If your library is huge, just type in Asimov in the search bar.
Then select all the books you want to change the author. Right click and select "edit meta information" and then "edit meta information in bulk". under "Author(s)" type in what you want and Calibre will change the author for all those books.
tulsa is offline   Reply With Quote
 
Advertisement
Old 03-28-2010, 08:58 AM   #3
DoctorOhh
US Navy, Retired
DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.
 
DoctorOhh's Avatar
 
Posts: 8,908
Karma: 12755553
Join Date: Feb 2009
Location: North Carolina
Device: Nexus 7
Quote:
Originally Posted by StanByk View Post
Hi,
as has been discussed here the Sony ereaders don't seem to honour the author sort field. In calibre I have added authors with their first name first, eg.
author: Isaac Asimov
author_sort: Asimov, Isaac

Is there a way to automatically change author to be the same than author sort?
E.g. change Isaac Asimov to Asimov, Isaac?

I have quite a few books in my library and don't want to do it manually.
Your correct the Books by Author menu does do first name then last name for authors. There is another option you might want to consider. I use PRS+ on my 505 which allows me to browse the actual folders on the device. When I use the Browse Folders option and drill down to the authors they are indeed Last name first. See attached images.
Attached Thumbnails
Click image for larger version

Name:	Browse_folders_1.jpg
Views:	114
Size:	80.8 KB
ID:	48771   Click image for larger version

Name:	Browse_folders_2.jpg
Views:	108
Size:	31.1 KB
ID:	48772   Click image for larger version

Name:	Browse_folders_3.jpg
Views:	110
Size:	28.5 KB
ID:	48773   Click image for larger version

Name:	Browse_folders_4.jpg
Views:	105
Size:	26.2 KB
ID:	48774   Click image for larger version

Name:	Browse_folders_5.jpg
Views:	109
Size:	49.6 KB
ID:	48775   Click image for larger version

Name:	Browse_folders_6.jpg
Views:	111
Size:	66.9 KB
ID:	48782  
DoctorOhh is offline   Reply With Quote
Old 03-28-2010, 09:39 AM   #4
chaley
"chaley", not "charley"
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 5,907
Karma: 1217216
Join Date: Jan 2010
Location: France
Device: Many android devices
Quote:
Originally Posted by StanByk View Post
Hi,
as has been discussed here the Sony ereaders don't seem to honour the author sort field. In calibre I have added authors with their first name first, eg.
author: Isaac Asimov
author_sort: Asimov, Isaac

Is there a way to automatically change author to be the same than author sort?
E.g. change Isaac Asimov to Asimov, Isaac?
No and Yes. The 'no' part is that I know of no easy way to bulk copy author_sort to author. There might be some tricks with the command line functions, and it can be done using SQL (being *very careful* not to break everything), but I found that in the end it was easier to do it by hand. I did it by hand for some 400 books by using the metadata editor in the GUI and copying author_sort to author (click, E, copy, paste, click OK, repeat. sigh). Tulda's suggestion would save time if you have many fewer authors than books, but be careful of books with multiple authors.

The 'yes' part is that once you have corrected author to be ln,fn, you need to tell Calibre how to compute the author_sort so that it doesn't end up backwards. First, set the 'tweak' that tells calibre how to copy author to author_sort. See this post for some instructions.
chaley is offline   Reply With Quote
Old 04-03-2010, 11:09 PM   #5
DoctorOhh
US Navy, Retired
DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.
 
DoctorOhh's Avatar
 
Posts: 8,908
Karma: 12755553
Join Date: Feb 2009
Location: North Carolina
Device: Nexus 7
Quote:
Originally Posted by StanByk View Post
Hi,
as has been discussed here the Sony ereaders don't seem to honour the author sort field. In calibre I have added authors with their first name first, eg.
author: Isaac Asimov
author_sort: Asimov, Isaac

Is there a way to automatically change author to be the same than author sort?
E.g. change Isaac Asimov to Asimov, Isaac?

I have quite a few books in my library and don't want to do it manually.

Thank you,
Robert
It just occurred to me that Calibre will let you create your collections from the author_sort field if you change the device interface plugin setting from tags, series to just author_sort (see attached) then all of you collections would be based on the author_sort field. In my case all collections would be Last Name, first name - example - Asimov, Isaac.
Attached Thumbnails
Click image for larger version

Name:	Sony_Device_interface_plugin.jpg
Views:	209
Size:	43.9 KB
ID:	49141  
DoctorOhh is offline   Reply With Quote
Old 04-04-2010, 09:56 AM   #6
Starson17
Wizard
Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.
 
Posts: 4,004
Karma: 177841
Join Date: Dec 2009
Device: WinMo: IPAQ; Android: HTC HD2, Archos 7o; Java:Gravity T
Quote:
Originally Posted by chaley View Post
No and Yes. The 'no' part is that I know of no easy way to bulk copy author_sort to author. There might be some tricks with the command line functions, and it can be done using SQL (being *very careful* not to break everything), but I found that in the end it was easier to do it by hand. I did it by hand for some 400 books
One alternative to SQL and/or manual conversion would be to save-to-disk all books in the ln, fn format, then reimport them, with the "swap author firstname and lastname" option turned off and the "get metadata only from filename" option turned on. This should reverse the name. The cost would be the loss of other metadata.
Starson17 is offline   Reply With Quote
Old 06-02-2011, 04:28 PM   #7
cwalger
Junior Member
cwalger began at the beginning.
 
Posts: 2
Karma: 10
Join Date: Jun 2011
Device: Nook Touch
You can copy the author_sort field to author field easily using calibre's bulk edit.
1. Select books you want to change, click "edit metadata in bulk"
2. on the "search and replace" tab, select "regular expression" from the "search mode" dropdown
3. fill in:
search field = author_sort
search for = (.+)
replace with = \1
destination field = author
4. hit ok
cwalger is offline   Reply With Quote
Old 06-02-2011, 04:37 PM   #8
chaley
"chaley", not "charley"
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 5,907
Karma: 1217216
Join Date: Jan 2010
Location: France
Device: Many android devices
Quote:
Originally Posted by cwalger View Post
You can copy the author_sort field to author field easily using calibre's bulk edit. [...]
There have been many improvements since last April. Easier than using S/R is using Manage Authors and pushing the "Copy all author sort values to author" button.
chaley is offline   Reply With Quote
Old 06-03-2011, 01:53 AM   #9
cwalger
Junior Member
cwalger began at the beginning.
 
Posts: 2
Karma: 10
Join Date: Jun 2011
Device: Nook Touch
That's true, but you can't do that for a selected group of ebooks, can you? I think you can only 'manage authors' for your entire library.
cwalger is offline   Reply With Quote
Old 03-21-2012, 07:15 AM   #10
TurtleTots
Member
TurtleTots began at the beginning.
 
Posts: 19
Karma: 24
Join Date: Dec 2011
Device: iphone
Quote:
Originally Posted by chaley View Post
If you are happy with calibre's default 'firstname lastname' author ordering, don't read on.

If you want to use "Lastname, Firstname" for authors, then you probably also want to change how calibre copies the author names to the author_sort field. If you don't, then you must manually edit author_sort every time you import a new book or change an author's name to avoid sorting by author displaying the list in a very strange order.

You can control how the copy using a calibre 'tweak' that changes how author_sort is generated from author. In the file tweaks.py, change author_sort_copy_method to either copy or comma (see below for more detail). Tweaks.py is found in your settings directory, which for me on windows 7 is C:\Users\charles\AppData\Roaming\calibre.

From tweaks.py:
Code:
# The algorithm used to copy author to author_sort
# Possible values are:
#  invert: use "fn ln" -> "ln, fn" (the original algorithm)
#  copy  : copy author to author_sort without modification
#  comma : use 'copy' if there is a ',' in the name, otherwise use 'invert'
author_sort_copy_method = 'invert'
I use 'copy'.

If the current author_sort fields are not correct, then once you set the tweak you can reset all the author_sort fields in one swoop. First, verify that the author names are all as you want them. Then select the books you want to change, press E to get the bulk metadata editor, check the box "automatically set author sort", and push OK. The author_sort field for all the selected books will be recomputed from the author field according to the value of the tweak.
I like fn ln for authors, but would really like the author_sort field to be fn ln also....How do I do that?????
TurtleTots is offline   Reply With Quote
Old 03-21-2012, 07:59 AM   #11
mbovenka
Wizard
mbovenka ought to be getting tired of karma fortunes by now.mbovenka ought to be getting tired of karma fortunes by now.mbovenka ought to be getting tired of karma fortunes by now.mbovenka ought to be getting tired of karma fortunes by now.mbovenka ought to be getting tired of karma fortunes by now.mbovenka ought to be getting tired of karma fortunes by now.mbovenka ought to be getting tired of karma fortunes by now.mbovenka ought to be getting tired of karma fortunes by now.mbovenka ought to be getting tired of karma fortunes by now.mbovenka ought to be getting tired of karma fortunes by now.mbovenka ought to be getting tired of karma fortunes by now.
 
Posts: 1,262
Karma: 1619751
Join Date: Oct 2007
Location: Almere, The Netherlands
Device: Kobo Aura H2O
Quote:
Originally Posted by TurtleTots View Post
I like fn ln for authors, but would really like the author_sort field to be fn ln also....How do I do that?????
Use 'copy' for the tweak value, and if needed, recompute the author_sort by selecting the books you want to change and do a Bulk Edit Metadata -> 'Automatically set author sort'
mbovenka is offline   Reply With Quote
Old 03-23-2012, 04:36 AM   #12
TurtleTots
Member
TurtleTots began at the beginning.
 
Posts: 19
Karma: 24
Join Date: Dec 2011
Device: iphone
Quote:
Originally Posted by mbovenka View Post
Use 'copy' for the tweak value, and if needed, recompute the author_sort by selecting the books you want to change and do a Bulk Edit Metadata -> 'Automatically set author sort'
I have done this multiple times!!!!! It does nothing I have reloaded all my books (5300+) twice. I started to edit metadata one by one....then tried the bulk edit after the tweak again, and it puts everything back the way it was I'm soooo frustrated
TurtleTots is offline   Reply With Quote
Old 03-23-2012, 06:32 AM   #13
DoctorOhh
US Navy, Retired
DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.
 
DoctorOhh's Avatar
 
Posts: 8,908
Karma: 12755553
Join Date: Feb 2009
Location: North Carolina
Device: Nexus 7
Quote:
Originally Posted by TurtleTots View Post
I have done this multiple times!!!!! It does nothing I have reloaded all my books (5300+) twice. I started to edit metadata one by one....then tried the bulk edit after the tweak again, and it puts everything back the way it was I'm soooo frustrated
Reloading books is not needed. Once you set the tweak to copy you should be able to open the tag browser and right click on the authors field then select Manage Authors and recalculate the Author sort values. Read this section of the FAQ for a more complete explanation.
DoctorOhh is offline   Reply With Quote
Old 03-23-2012, 01:26 PM   #14
theducks
Grand Sorcerer
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 15,263
Karma: 6020309
Join Date: Aug 2009
Location: (The original) Silicon Valley, USA
Device: Galaxy Tab 2, Astak Pocket Pro, K4NT
Quote:
Originally Posted by TurtleTots View Post
I have done this multiple times!!!!! It does nothing I have reloaded all my books (5300+) twice. I started to edit metadata one by one....then tried the bulk edit after the tweak again, and it puts everything back the way it was I'm soooo frustrated
Author_sort is calculated from Author and uses the tweaks to determine how to do the calculation (Library order or Strictly Alphabetical, Copy or Flip)

Author must be correct for Automatic (calculate) Set to work as you have configured. GIGO still applies here
theducks is online now   Reply With Quote
Old 03-24-2012, 03:10 AM   #15
TurtleTots
Member
TurtleTots began at the beginning.
 
Posts: 19
Karma: 24
Join Date: Dec 2011
Device: iphone
Ok, well I had my 'code guy' AKA Hubby, look to she what I was doing wrong.... I had used 'copy author to author_sort without modification' instead of 'copy'
Thanks for your help guys!!
TurtleTots 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
Automatically change titles to contain series info? HunterZ Calibre 8 08-15-2010 10:02 PM
Can I change author sort with Calibre? Sydney's Mom Calibre 4 12-09-2009 10:33 PM
Author Sort wexdan Calibre 2 10-22-2009 04:21 PM
Author Sort polly Calibre 6 10-04-2009 09:22 AM
Author(s) & Author Sort BobF Calibre 11 01-02-2009 06:01 PM


All times are GMT -4. The time now is 03:45 PM.


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