Quote:
Originally Posted by laji
Sorry, it can not handle commas in author field. I mean, inside of ONE author. It changes commas to |, and reorders the parts of a name by comma.
The book...
Austen, Jane & Barrett, Julia - Charlotte
...'s authors in ABCH became...
Barrett| Julia(2) Austen| Jane(11)
...in ABC-ABCH became...
Austen, Jane & Barrett, Julia. Barrett| Julia(2) Austen| Jane(11)
(Clickable 3 parts are divided by color and underline.)
Please, do not advice to use reordered (Jane Austen) variant - I NEVER and NOWHERE use them, not depending of the used language. This behavior is conflicts with human logics, and is used only in primitiv pidgin languages, like english. Languages with logical structure, like hungarian, use human logical order, and do not need author_sort, date_sort, adresse_sort, breechessize_sort solutions. And the second: I can not leave the comma, because surnames and family names are often not detectable, and there are variants with 2 or more family names; for example, often in spanish.
|
@laji:
I am seeing multiple causes and effects in your example.
1. Standard Calibre changes the name of an author to include the '|' when it converts the author name from FN LN to LN, FN. See a real example below showing metadata.db table authors, fields id,name and sort. Note that even a new author id was created.
..................................... id ........name .......... sort
Original FN LN.............: "20" "Alys Arden" "Arden, Alys"
After Change to LN,FN.: "28" "Arden| Alys" "Arden, Alys"
2. ABCH has always used exactly what the "official" Calibre author name was.
3. Nothing in ABCH makes anything "clickable" or "non-clickable".
4. Standard Calibre makes its authors "clickable" in various locations in the GUI. Emphasis on "its" authors. "Its" authors may not be what the "real" authors are. What you see on your system appears to be caused by a corrupt author field in your example book. Calibre parsed it the way it always parses the authors of a newly added book, but apparently the original addition had a malformed author field. Being Calibre, there are many ways to determine what is really going on with your example book, but the way I would do it would be to look in the metadata.db file at tables authors, books_authors_link and books to piece together the full story.
5. The ABCH custom column is supposed to be created as "text, column shown in the tag browser". If instead it were created as "comma separated text, like tags, shown in the tag browser", a comma would explode a LN, FN author into 2 pieces within the tag browser. This is undesirable, which is why it should be created as "text, column shown in the tag browser".
6. ABCH should show a comma instead of the bar, even if standard Calibre created the bar in the "official" name of the author. So, I will soon post a new version of ABCH that changes all bars (if there are any) to commas for the values in the ABCH custom column table.
DaltonST