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 04-01-2010, 10:13 AM   #1
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
multiple authors in metadata

Does anyone know how to properly enter multiple authors into the Calibre author field?
When I have books with two authors, the downloaded metadata is never consistent. Sometimes, it uses an "&", other times a slash.

If I separate them with a comma, will Calibre know that two authors belong to that book?
tulsa is offline   Reply With Quote
Old 04-01-2010, 10:42 AM   #2
GRiker
Comparer of the Ephemeris
GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.
 
Posts: 1,496
Karma: 424697
Join Date: Mar 2009
Device: iPad
If there are multiple unrelated authors, Author Sort should be:
last_primary & first_secondary last_secondary, first_primary
Code:
Smith & William Jones, John
which displays on the Kindle as
John Smith & William Jones

If there are multiple related authors, Author Sort should be:
last_primary, first_primary & first_secondary
Code:
Smith, John & Nancy
which displays on the Kindle as
John & Nancy Smith

Remember to check Preferences|Conversion|MOBI|Use author sort for author.

G
GRiker is offline   Reply With Quote
Old 04-01-2010, 11:06 AM   #3
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
Quote:
Originally Posted by GRiker View Post
If there are multiple unrelated authors, Author Sort should be:
last_primary & first_secondary last_secondary, first_primary
Code:
Smith & William Jones, John
which displays on the Kindle as
John Smith & William Jones

If there are multiple related authors, Author Sort should be:
last_primary, first_primary & first_secondary
Code:
Smith, John & Nancy
which displays on the Kindle as
John & Nancy Smith

Remember to check Preferences|Conversion|MOBI|Use author sort for author.

G
Ok, thanks. Does that work for the Sony 900, as well?
I was actually thinking along the lines of organization within Calibre. I usually only keep about 10 books on my devices at any given time.
But thanks!
tulsa is offline   Reply With Quote
Old 04-01-2010, 11:21 AM   #4
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 GRiker View Post
If there are multiple unrelated authors, Author Sort should be:
last_primary & first_secondary last_secondary, first_primary

which displays on the Kindle as
John Smith & William Jones
That's odd. I always enter the author field as:

Code:
John Smith & William Jones
then I click the author_sort button (on the metadata single dialog screen), which enters it as:

Quote:
Smith, John & Jones, William
Quote:
If there are multiple related authors, Author Sort should be:
last_primary, first_primary & first_secondary
Code:
Smith, John & Nancy
which displays on the Kindle as
John & Nancy Smith
In this case, I just enter:

Code:
John Smith & Nancy Smith
which, after clicking the author_sort button, becomes:

Code:
Smith, John & Smith, Nancy
I've never tried your method. Is there any problem if I search for Nancy Smith and/or John Smith as the author? IOW, is "Smith, John & Nancy" properly parsed as two authors named Smith?
Starson17 is offline   Reply With Quote
Old 04-01-2010, 11:37 AM   #5
GRiker
Comparer of the Ephemeris
GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.
 
Posts: 1,496
Karma: 424697
Join Date: Mar 2009
Device: iPad
My technique is what I use to massage multiple authors for proper display on Kindle. I don't know how other readers display author metadata.

Quote:
I've never tried your method. Is there any problem if I search for Nancy Smith and/or John Smith as the author? IOW, is "Smith, John & Nancy" properly parsed as two authors named Smith?
Yes, that's been my experience on the Kindle.

G
GRiker is offline   Reply With Quote
Old 04-01-2010, 11:48 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 GRiker View Post
Yes, that's been my experience on the Kindle.
G
I assume the "Yes" is that it is properly parsed as two authors named Smith on the Kindle. I wonder about inside the SQL database of Calibre. I don't have an e-reader, so that's all that I see. I was thinking about a search like author:"Nancy Smith" and the same for John Smith. Would it pull up all the books by them, including the joint authorship and sole authorship books.
Starson17 is offline   Reply With Quote
Old 04-01-2010, 12:00 PM   #7
GRiker
Comparer of the Ephemeris
GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.
 
Posts: 1,496
Karma: 424697
Join Date: Mar 2009
Device: iPad
I should have made it clear that I was referring to Kindle-optimized author metadata.

On the Kindle, searching for an author is a full-text search. I've never had a problem finding a jointly-authored book using either "John Smith" or "Nancy Smith" as the search term. It could be that the Kindle is actually finding the text within the text, as opposed to in the metadata. My focus has been on presenting the authors in an acceptable fashion on the Kindle, and I discovered that this style worked best for me. I do understand that it's not a correct sorting value, but it's what's needed for the Kindle to show it properly.

Within calibre, I treat the Author field differently - I enter the author attribution as I expect it to ultimately be displayed on the device:
Code:
John Smith & William Jones
John Smith & Nancy Smith
That allows me to search for "Nancy Smith" in calibre, and for the author(s) to be properly rendered on the Kindle.

I realize that this may not be an optimal solution for folks with multiple devices utilizing different formats. Once I receive my iPad I may have to revisit this ...

G
GRiker is offline   Reply With Quote
Old 04-01-2010, 12:03 PM   #8
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
Quote:
Originally Posted by Starson17 View Post
I assume the "Yes" is that it is properly parsed as two authors named Smith on the Kindle. I wonder about inside the SQL database of Calibre. I don't have an e-reader, so that's all that I see. I was thinking about a search like author:"Nancy Smith" and the same for John Smith. Would it pull up all the books by them, including the joint authorship and sole authorship books.
This is kinda what was going through my mind.

This would then bring up the issue about the way Calibre physically stores the ebook. Since its stored by author/title/nameofbook, seems it would be difficult for Calibre to decide which author is the primary author.

There ought to be a new field like 1st author, 2nd author, etc. Or at least have the option of adding an author and then having Calibre always use the first author to store the book under.

dunno.. just thinkin' out loud.
tulsa is offline   Reply With Quote
Old 04-01-2010, 12:10 PM   #9
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 tulsa View Post
This is kinda what was going through my mind.

This would then bring up the issue about the way Calibre physically stores the ebook. Since its stored by author/title/nameofbook, seems it would be difficult for Calibre to decide which author is the primary author.

There ought to be a new field like 1st author, 2nd author, etc. Or at least have the option of adding an author and then having Calibre always use the first author to store the book under.

dunno.. just thinkin' out loud.
Having worked on the code, I know a bit about this. Calibre considers each author to be an item of metadata called "author" in another chunk of metadata (a list) called "authors." Each author is independently linked to the book. Searches for an author will find all of that author's books regardless of whether he's a single or joint author and regardless of whether he's first or last in a list.

Calibre stores a multi-author book in its black box secret and thou-shalt-not-touch storage system under the name of the first author in the list, but that doesn't mean that author is any more primary than the others. It's just how the book is stored, and since we're supposed to ignore that, it makes no difference.

Last edited by Starson17; 04-01-2010 at 12:14 PM.
Starson17 is offline   Reply With Quote
Old 04-01-2010, 12:31 PM   #10
HarryT
eBook Enthusiast
HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.
 
HarryT's Avatar
 
Posts: 85,544
Karma: 93383043
Join Date: Nov 2006
Location: UK
Device: Kindle Oasis 2, iPad Pro 10.5", iPhone 6
Quote:
Originally Posted by Starson17 View Post
I assume the "Yes" is that it is properly parsed as two authors named Smith on the Kindle. I wonder about inside the SQL database of Calibre. I don't have an e-reader, so that's all that I see. I was thinking about a search like author:"Nancy Smith" and the same for John Smith. Would it pull up all the books by them, including the joint authorship and sole authorship books.
My experience is that you'd need to enter the author, in Calibre, as "Smith, John & Smith, Nancy". That will definitely store the two authors separately and will subsequently match searches by either name.

If you enter an author of that form, and then edit the metadata for a book and look at the "author" drop-down, you'll find that it lists "Smith, John" and "Smith, Nancy" as separate authors. If, on the other hand, you enter "Smith, John & Nancy", the drop-down will list "Smith, John", but then simply "Nancy".

Last edited by HarryT; 04-01-2010 at 12:33 PM.
HarryT is offline   Reply With Quote
Old 04-01-2010, 01:11 PM   #11
chaley
Grand Sorcerer
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: 11,703
Karma: 6658935
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
Quote:
Originally Posted by Starson17 View Post
Having worked on the code, I know a bit about this. Calibre considers each author to be an item of metadata called "author" in another chunk of metadata (a list) called "authors." Each author is independently linked to the book. Searches for an author will find all of that author's books regardless of whether he's a single or joint author and regardless of whether he's first or last in a list.
To add a bit more...

As Starson17 said, author names are stored as individual records. Author lists are a set of words separated by certain magic 'words' such as 'and', 'with', and '&'. Thus you should enter each author in the list as a complete name and separate the authors with one of the magic words. If you do not follow this convention, then some authors will be missing or incorrect. That may be OK (it certainly is for GRiker), or it may not be.

When you ask for your books to be sorted by author, they are not in fact sorted by author but are instead sorted by author_sort. Author_sort is not stored the same way as author. Instead of being an individual record per author, author_sort is kept as a single string per book. When you add a book or press the 'compute author_sort' button in the edit metadata dialog, by default calibre looks at each author in order, attempts to guess the last name, generates a guessed 'lastname, firstname' string, then adds this string to the author_sort field for the book. There are two interesting consequences:

1. calibre can get it wrong, and will get it wrong in the case of names like 'fred smith esq'. This example will become, 'esq, fred smith'.
2. you can change author_sort however you wish without having any effect on the real author name. This permits you to correct any guessing errors, and also lets you choose arbitrary strings for sorting.

Finally, a few people (I am one of them) choose to maintain author names in library order ('ln, fn') instead of spoken order ('fn ln'). If you choose this route, you will need to set a 'tweak' in Calibre so that it won't carefully undo your work and generate nonsense author_sort values. See this post for details on this.

Have fun.
chaley is offline   Reply With Quote
Old 04-01-2010, 02:07 PM   #12
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
When you ask for your books to be sorted by author, they are not in fact sorted by author but are instead sorted by author_sort. Author_sort is not stored the same way as author. Instead of being an individual record per author, author_sort is kept as a single string per book.
And I suppose this makes sense, as sorting is done per book, while searching is done per author.

Quote:
Finally, a few people (I am one of them) choose to maintain author names in library order ('ln, fn') instead of spoken order ('fn ln').
One of the reasons there are only "a few" is that it's really hard to switch to your system. You really need to write the script that does a global copy of the author_sort field into the author field. I know, it's tricky when dealing with Esq., De, La, Jr., and multiple authors, but without an automatic tool, switching means facing a long manual editing/renaming session.
Starson17 is offline   Reply With Quote
Old 04-01-2010, 03:26 PM   #13
chaley
Grand Sorcerer
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: 11,703
Karma: 6658935
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
Quote:
Originally Posted by Starson17 View Post
One of the reasons there are only "a few" is that it's really hard to switch to your system.
Ahhh, but I was lucky. I did it from the beginning, fighting against the author_sort processing until I didn't need to anymore.

A script (command line program) to copy author_sort to author wouldn't be hard to build, but I suspect that the number of users would be almost indistinguishable from zero.
chaley is offline   Reply With Quote
Old 04-01-2010, 04:31 PM   #14
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
Ahhh, but I was lucky. I did it from the beginning, fighting against the author_sort processing until I didn't need to anymore.
Yes, that's currently the easiest way - from the beginning.

Quote:
A script (command line program) to copy author_sort to author wouldn't be hard to build, but I suspect that the number of users would be almost indistinguishable from zero.
Perhaps so, and since you don't need it and you are the one who would have to write it, why should you spend your time writing something that you won't use ........ Hmmmmmm ....... something about that story rings a bell
Starson17 is offline   Reply With Quote
Old 04-02-2010, 07:46 AM   #15
HarryT
eBook Enthusiast
HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.
 
HarryT's Avatar
 
Posts: 85,544
Karma: 93383043
Join Date: Nov 2006
Location: UK
Device: Kindle Oasis 2, iPad Pro 10.5", iPhone 6
Quote:
Originally Posted by chaley View Post
As Starson17 said, author names are stored as individual records. Author lists are a set of words separated by certain magic 'words' such as 'and', 'with', and '&'. Thus you should enter each author in the list as a complete name and separate the authors with one of the magic words. If you do not follow this convention, then some authors will be missing or incorrect. That may be OK (it certainly is for GRiker), or it may not be.
Thank you - that confirms what I'd determined by experiment, as I said in post #10 above.
HarryT is offline   Reply With Quote
Reply

Tags
author, calibre, metadata

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple Authors pdurrant Calibre 33 12-21-2017 12:37 PM
Kobo & multiple authors Medieval Guy Calibre 7 07-02-2010 04:32 PM
Question about multiple formats and metadata ficbot Calibre 6 01-14-2010 11:20 PM
Issues with multiple authors iain_benson Calibre 2 04-26-2009 01:16 PM
Calibre and Multiple Authors Xenophon Calibre 6 09-26-2008 11:04 AM


All times are GMT -4. The time now is 10:23 PM.


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