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

Go Back   MobileRead Forums > E-Book Software > Calibre > Devices

Notices

Reply
 
Thread Tools Search this Thread
Old 01-24-2020, 02:13 PM   #1
Mich06
Member
Mich06 began at the beginning.
 
Posts: 23
Karma: 10
Join Date: Jan 2020
Device: Kindle Paperwhite 32 GB
Authors' sort in Kindle Paperwhite

Hello there !
I'm using the last Kindle Paperwhite 32 GB and Calibre 3.48.
Everything runs fine when transferring azw3 ebooks from Calibre to Kindle, however when trying to sort books by authors in the Kindle, they appear sorted as:
First Name, Last Name (eg: Albert Camus, before Charles Andler)

I would have expected books sorted as:
Last Name, First Name (eg: Charles Andler, before Albert Camus)

The metadata in calibre are sorted correctly, and in the Device Window, when I click on the author column, they sort as Last Name, First Name...
In the Kindle 'document' directory, names appear correctly as 'Camus, Albert'.
(In calibre send to device options, the setting is {author_sort}/{title} - {authors}, as expected)

I suppose the problem lies in the way the Kindle reads the azw3 metadata calibre sends.

Is there a way to resolve this ?

Thanks.
Mich06 is offline   Reply With Quote
Old 01-24-2020, 04:57 PM   #2
hobnail
Running with scissors
hobnail ought to be getting tired of karma fortunes by now.hobnail ought to be getting tired of karma fortunes by now.hobnail ought to be getting tired of karma fortunes by now.hobnail ought to be getting tired of karma fortunes by now.hobnail ought to be getting tired of karma fortunes by now.hobnail ought to be getting tired of karma fortunes by now.hobnail ought to be getting tired of karma fortunes by now.hobnail ought to be getting tired of karma fortunes by now.hobnail ought to be getting tired of karma fortunes by now.hobnail ought to be getting tired of karma fortunes by now.hobnail ought to be getting tired of karma fortunes by now.
 
Posts: 1,552
Karma: 14325282
Join Date: Nov 2019
Device: none
Not the answer you want but my solution was to buy a Kobo; see attached for how you can view books by author properly.

If I remember correctly there is a plugin for calibre that will redo all of the author names to be lastname, firstname. Which is what I'd done, and then I used it again to put them back to the correct format after I bought the Kobo.
Attached Thumbnails
Click image for larger version

Name:	IMG_20200124_134917.jpg
Views:	255
Size:	200.4 KB
ID:	176636  
hobnail is offline   Reply With Quote
Advert
Old 01-24-2020, 05:16 PM   #3
BetterRed
null operator (he/him)
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 20,568
Karma: 26954694
Join Date: Mar 2012
Location: Sydney Australia
Device: none
Quote:
Originally Posted by Mich06 View Post
<snip>
Is there a way to resolve this ?
Don't know much about Kindles, but I think a plugboard might to the trick.

See Preferences->Plugboards and there's sticky at top of Library Management subforum with examples of usage.

BR
BetterRed is online now   Reply With Quote
Old 01-24-2020, 05:20 PM   #4
jhowell
Grand Sorcerer
jhowell ought to be getting tired of karma fortunes by now.jhowell ought to be getting tired of karma fortunes by now.jhowell ought to be getting tired of karma fortunes by now.jhowell ought to be getting tired of karma fortunes by now.jhowell ought to be getting tired of karma fortunes by now.jhowell ought to be getting tired of karma fortunes by now.jhowell ought to be getting tired of karma fortunes by now.jhowell ought to be getting tired of karma fortunes by now.jhowell ought to be getting tired of karma fortunes by now.jhowell ought to be getting tired of karma fortunes by now.jhowell ought to be getting tired of karma fortunes by now.
 
jhowell's Avatar
 
Posts: 6,496
Karma: 84420419
Join Date: Nov 2011
Location: Tampa Bay, Florida
Device: Kindles
Kindles expect the author name in the book's metadata to be stored in "last, first" format. This is normally the format used for the "author sort" field in calibre.

There is an option in the MOBI Output tab when converting books to "Use author sort for author" which should make this come out the way you want.
jhowell is online now   Reply With Quote
Old 01-24-2020, 05:42 PM   #5
Mich06
Member
Mich06 began at the beginning.
 
Posts: 23
Karma: 10
Join Date: Jan 2020
Device: Kindle Paperwhite 32 GB
Quote:
Originally Posted by jhowell View Post
Kindles expect the author name in the book's metadata to be stored in "last, first" format. This is normally the format used for the "author sort" field in calibre.

There is an option in the MOBI Output tab when converting books to "Use author sort for author" which should make this come out the way you want.
Oh yes, thanks, I just found out that option in the AZW3 Output ! I'll try that with some books to test, and I'll let you know if it works... it should...!

Thanks to all people that answered
Mich06 is offline   Reply With Quote
Advert
Old 01-24-2020, 06:17 PM   #6
Mich06
Member
Mich06 began at the beginning.
 
Posts: 23
Karma: 10
Join Date: Jan 2020
Device: Kindle Paperwhite 32 GB


Well, it doesn't seem to work. I checked ON the "use author_sort as author" in the AZW3 Output, converted a book from EPUB to AZW3, with no effect.

I tried to look inside the AZW3 with the editor, and here's the header of the OPF file:

<?xml version='1.0' encoding='utf-8'?>
<package xmlns="http://www.idpf.org/2007/opf" unique-identifier="calibre_id" version="2.0">
<metadata xmlns:calibre="http://calibre.kovidgoyal.net/2009/metadata" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlnspf="http://www.idpf.org/2007/opf">
<dc:title>Des milliers de places vides</dc:title>
<dc:creator opf:file-as="Inconnu(e)" opf:role="aut">Alain Wagneur</dc:creator>


It should be 'Wagneur, Alain' and not 'Alain Wagneur', right ? So that option in the AZW3 plugin doesn't seem to function.......
Mich06 is offline   Reply With Quote
Old 01-24-2020, 08:24 PM   #7
jhowell
Grand Sorcerer
jhowell ought to be getting tired of karma fortunes by now.jhowell ought to be getting tired of karma fortunes by now.jhowell ought to be getting tired of karma fortunes by now.jhowell ought to be getting tired of karma fortunes by now.jhowell ought to be getting tired of karma fortunes by now.jhowell ought to be getting tired of karma fortunes by now.jhowell ought to be getting tired of karma fortunes by now.jhowell ought to be getting tired of karma fortunes by now.jhowell ought to be getting tired of karma fortunes by now.jhowell ought to be getting tired of karma fortunes by now.jhowell ought to be getting tired of karma fortunes by now.
 
jhowell's Avatar
 
Posts: 6,496
Karma: 84420419
Join Date: Nov 2011
Location: Tampa Bay, Florida
Device: Kindles
Quote:
Originally Posted by Mich06 View Post


Well, it doesn't seem to work. I checked ON the "use author_sort as author" in the AZW3 Output, converted a book from EPUB to AZW3, with no effect.
I just tried the same thing and it worked for me, sorting properly on my Kindle. Note that on the Kindle the name will appear as “first last” but will sort as “last, first”.

The file-as data it showed for my book looked correct, “last, first”. Yours looks odd. Check the calibre entry for your book and see what author sort shows.

Last edited by jhowell; 01-24-2020 at 08:27 PM.
jhowell is online now   Reply With Quote
Old 01-24-2020, 09:41 PM   #8
Mich06
Member
Mich06 began at the beginning.
 
Posts: 23
Karma: 10
Join Date: Jan 2020
Device: Kindle Paperwhite 32 GB
Ok, I found out what happened : I didn't really re-convert the file, because I didn't uncheck "Keep stored conversion settings for selected books"... Now I did it and it seems to work !
Well, this Calibre setting is not very clear : the "Remove/Keep stored conversion settings" appear ONLY if you select more that one book. No way to re-convert a single book !

I checked the new OPF section in the AZW3 file, and now, it reads :
<dc:title>Des milliers de places vides</dc:title>
<dc:creator opf:file-as="Wagneur, Alain" opf:role="aut">Alain Wagneur</dc:creator>

So it seems that the opf:file-as="Last, First" is the key...

Thanks for your help !
Mich06 is offline   Reply With Quote
Old 01-24-2020, 10:21 PM   #9
BetterRed
null operator (he/him)
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 20,568
Karma: 26954694
Join Date: Mar 2012
Location: Sydney Australia
Device: none
FWIW: the single book convert dialogue has a Restore Defaults button in the bottom left corner.

BR
BetterRed is online now   Reply With Quote
Old 01-24-2020, 10:53 PM   #10
hobnail
Running with scissors
hobnail ought to be getting tired of karma fortunes by now.hobnail ought to be getting tired of karma fortunes by now.hobnail ought to be getting tired of karma fortunes by now.hobnail ought to be getting tired of karma fortunes by now.hobnail ought to be getting tired of karma fortunes by now.hobnail ought to be getting tired of karma fortunes by now.hobnail ought to be getting tired of karma fortunes by now.hobnail ought to be getting tired of karma fortunes by now.hobnail ought to be getting tired of karma fortunes by now.hobnail ought to be getting tired of karma fortunes by now.hobnail ought to be getting tired of karma fortunes by now.
 
Posts: 1,552
Karma: 14325282
Join Date: Nov 2019
Device: none
Quote:
Originally Posted by jhowell View Post
There is an option in the MOBI Output tab when converting books to "Use author sort for author" which should make this come out the way you want.
What about bought books or ones from the library, project gutenberg, etc.? Do the kindle versions of those come with the author names in the format expected by the kindle?
hobnail is offline   Reply With Quote
Old 01-25-2020, 12:34 PM   #11
Bookstooge
Guru
Bookstooge ought to be getting tired of karma fortunes by now.Bookstooge ought to be getting tired of karma fortunes by now.Bookstooge ought to be getting tired of karma fortunes by now.Bookstooge ought to be getting tired of karma fortunes by now.Bookstooge ought to be getting tired of karma fortunes by now.Bookstooge ought to be getting tired of karma fortunes by now.Bookstooge ought to be getting tired of karma fortunes by now.Bookstooge ought to be getting tired of karma fortunes by now.Bookstooge ought to be getting tired of karma fortunes by now.Bookstooge ought to be getting tired of karma fortunes by now.Bookstooge ought to be getting tired of karma fortunes by now.
 
Bookstooge's Avatar
 
Posts: 760
Karma: 2090886
Join Date: May 2019
Device: Kindle Oasis 1st Gen
Quote:
Originally Posted by hobnail View Post
What about bought books or ones from the library, project gutenberg, etc.? Do the kindle versions of those come with the author names in the format expected by the kindle?
Your guess is as good as the Publisher's!

You'd have to check the metadata for those in Calibre before sending them to your kindle...
Bookstooge is offline   Reply With Quote
Old 01-25-2020, 04:15 PM   #12
Mich06
Member
Mich06 began at the beginning.
 
Posts: 23
Karma: 10
Join Date: Jan 2020
Device: Kindle Paperwhite 32 GB
Quote:
Originally Posted by BetterRed View Post
FWIW: the single book convert dialogue has a Restore Defaults button in the bottom left corner.

BR
Ah yes !
Mich06 is offline   Reply With Quote
Old 01-25-2020, 07:55 PM   #13
BetterRed
null operator (he/him)
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 20,568
Karma: 26954694
Join Date: Mar 2012
Location: Sydney Australia
Device: none
Quote:
Originally Posted by Mich06 View Post
Ah yes !
Don't worry you're not the first to miss it.

In print media the bottom left corner is usually the cheapest place to place your ad.

BR
BetterRed is online now   Reply With Quote
Old 01-28-2024, 04:35 PM   #14
sjohnson717
Member
sjohnson717 began at the beginning.
 
Posts: 19
Karma: 10
Join Date: May 2008
Device: Amazon Kindle, Apple iPad
Lots of misinformation in this thread. Yes, you can display lastname,first name on your Kindle Paperwhite (or any other ebook). Use Plugboards. They're a little confusing--seems almost like programming but get past the technical and do this:

Go to Preferences and find Plugboards. In the row for "Add new plugboard," choose Any under Format and Any under Device. In the "source template" column, type:

{author_sort}

And under the "Destination field," enter "authors."
sjohnson717 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
Kindle Paperwhite (2015) Author sort order markcumbria Devices 9 06-20-2019 08:32 PM
Kindle authors sort cherrycharity Library Management 5 03-31-2015 06:36 PM
Troubleshooting Can not sort by authors on Kindle PW ctm3rd Amazon Kindle 14 12-02-2013 01:15 PM
setting authors.name to authors.sort richardsugg Library Management 2 01-18-2013 03: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 09:55 PM.


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