Register Guidelines E-Books Today's Posts Search

Go Back   MobileRead Forums > E-Book Software > Calibre

Notices

Reply
 
Thread Tools Search this Thread
Old 09-07-2022, 06:42 AM   #31
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: 12,447
Karma: 8012886
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
Quote:
Originally Posted by BetterRed View Post
@un_pogaz - the author_sort can be valid according to the algorithm used (e.g. 'invert'), but that does not mean it is correct.
@un_pogaz's method doesn't use the algorithm to generate the sort. The template constructs an author_sort string using the sort values in the author table, then compares that to the author_sort for the book. In other words, it is checking that the book's author_sort is what the author table says it should be.
chaley is offline   Reply With Quote
Old 09-07-2022, 07:39 AM   #32
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: 21,741
Karma: 30237526
Join Date: Mar 2012
Location: Sydney Australia
Device: none
Quote:
Originally Posted by chaley View Post
@un_pogaz's method doesn't use the algorithm to generate the sort. The template constructs an author_sort string using the sort values in the author table, then compares that to the author_sort for the book. In other words, it is checking that the book's author_sort is what the author table says it should be.
@chaley: that raises two questions:
  1. If the authors table has the 'definitive' author_sort value (assuming that's the one that gets altered in Manage Authors) why the need for an author_sort column in the books table - the definitive value(s) is/are available via the books-author-link table?
  2. But, how is it possible that the books table author_sort column can even acquire the 'wrong' value (other than by poking it into the db itself). If I fire up the MDE for one of Maddy St John's books I see my "St John, Madeleine" in the Author sort box on a green ground.
BR
BetterRed is offline   Reply With Quote
Advert
Old 09-07-2022, 08:51 AM   #33
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: 12,447
Karma: 8012886
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
Quote:
Originally Posted by BetterRed View Post
@chaley: that raises two questions:
[*]If the authors table has the 'definitive' author_sort value (assuming that's the one that gets altered in Manage Authors) why the need for an author_sort column in the books table - the definitive value(s) is/are available via the books-author-link table?
It is there for both historical reasons and because from time to time someone wants to change the computed author sort for a book. One example I have seen is that the person wanted the sort to list the authors in a different order than that listed on the book.
Quote:
[*]But, how is it possible that the books table author_sort column can even acquire the 'wrong' value (other than by poking it into the db itself). If I fire up the MDE for one of Maddy St John's books I see my "St John, Madeleine" in the Author sort box on a green ground.[/LIST]BR
You can change it in edit metadata or some plugin. I think that importing a book will set it if the book has calibre metadata.
chaley is offline   Reply With Quote
Old 09-07-2022, 06:27 PM   #34
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: 21,741
Karma: 30237526
Join Date: Mar 2012
Location: Sydney Australia
Device: none
Quote:
Originally Posted by chaley View Post
It is there for both historical reasons and because from time to time someone wants to change the computed author sort for a book. One example I have seen is that the person wanted the sort to list the authors in a different order than that listed on the book.
You can change it in edit metadata or some plugin. I think that importing a book will set it if the book has calibre metadata.
Thanks - one of the few things I'm OCD about is author names, so I go out of my way to get them right.

If I see a book has a tricky author name or title/subtitle, I will add it as an empty book, get its author, title, and subtitle 'sorted', and then cut and paste the format files into the empty book.

And I've never knowingly imported a book that had calibre metadata… embedded within or semi-attached. When I import an EPUB one of the first things I do is run it in through the Modify EPUB plugin and strip out any cruft including non-dc metadata.

BR

Last edited by BetterRed; 09-07-2022 at 06:33 PM.
BetterRed is offline   Reply With Quote
Reply


Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
authors sorting basta Library Management 0 06-16-2020 07:48 AM
Wrong sorting of cyrillic names maleficmax Library Management 9 06-09-2014 03:24 PM
Wrong author sorting order Gnolive PocketBook 3 11-15-2013 04:32 PM
Wrong sorting of titles DigiCam1 Library Management 6 01-24-2013 01:26 PM
Sorting by authors Zifnab Library Management 2 04-16-2011 05:25 PM


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


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