change 'sort by title' with 'title'

[jcarlier]

hi

i have another problem..

i have many books with invalid 'sort by title'

ex:
title :'Un homme a marier'
sort by title :'homme a marier, Un'

see hardcopy attached

i woulld like to have ALL field 'sort by title' same as field 'title'

it enables me to sort TITLE strictly_alphabetic

many thanks for your support ...

[jcarlier]

I found a solution :

use 'Sqlite database browser ' for browsing metadata.db and make a sql command for replacing ...

but if you have another solution ...

[crdf]

Not sure if this is what you are asking for, but this seems a language problem.

Preferences->Advanced->Tweaks->Set the list of words cosidered to be "articles" for sort strings

per_language_title_sort_articles = {
# English
'eng' : (r'A\s+', r'The\s+', r'An\s+'),
# French
'fra' : (r'Le\s+', r'La\s+', r"L'", r'Les\s+', r'Un\s+', r'Une\s+',
r'Des\s+', r'De\s+La\s+', r'De\s+', r"D'"),
}
default_language_for_title_sort = None
title_sort_articles=r'^(A|The|An)\s+'


More languages here: http://manual.calibre-ebook.com/customize.html

[jcarlier]

i have :
# Indiquer la liste des mots considérés comme des "articles" pour les chaines de tri

per_language_title_sort_articles = {'ron': ('Un\\s+', 'O\\s+', 'Ni\xc5\x9fte\\s+'), 'tur': ('Bir\\s+',), 'por': ('A\\s+', 'O\\s+', 'Os\\s+', 'As\\s+', 'Um\\s+', 'Uns\\s+', 'Uma\\s+', 'Umas\\s+'), 'ita': ('Lo\\s+', 'Il\\s+', "L'", 'La\\s+', 'Gli\\s+', 'I\\s+', 'Le\\s+'), 'nld': ('De\\s+', 'Het\\s+', 'Een\\s+', "'n\\s+", "'s\\s+", 'Ene\\s+', 'Ener\\s+', 'Enes\\s+', 'Den\\s+', 'Der\\s+', 'Des\\s+', "'t\\s+"), 'spa': ('El\\s+', 'La\\s+', 'Lo\\s+', 'Los\\s+', 'Las\\s+', 'Un\\s+', 'Una\\s+', 'Unos\\s+', 'Unas\\s+'), 'fra': ('Le\\s+', 'La\\s+', "L'", 'Les\\s+', 'Un\\s+', 'Une\\s+', 'Des\\s+', 'De\\s+La\\s+', 'De\\s+', "D'"), 'ell': ('O\\s+', 'I\\s+', 'To\\s+', 'Ta\\s+', 'Tus\\s+', 'Tis\\s+', "'Enas\\s+", "'Mia\\s+", "'Ena\\s+", "'Enan\\s+"), 'eng': ('A\\s+', 'The\\s+', 'An\\s+'), 'swe': ('En\\s+', 'Ett\\s+', 'Det\\s+', 'Den\\s+', 'De\\s+'), 'deu': ('Der\\s+', 'Die\\s+', 'Das\\s+', 'Den\\s+', 'Ein\\s+', 'Eine\\s+', 'Einen\\s+', 'Dem\\s+', 'Des\\s+', 'Einem\\s+', 'Eines\\s+'), 'hun': ('A\\s+', 'Az\\s+', 'Egy\\s+'), 'afr': ("'n\\s+", 'Die\\s+')}

default_language_for_title_sort = None

title_sort_articles = '^(A|The|An)\\s+'


for the new entries ==> ok

but i have to change the old ones in db

[kovidgoyal]

So use the Update title sort option in the bulk metadata edit dialog.

[DoctorOhh]

Originally Posted by kovidgoyal

So use the Update title sort option in the bulk metadata edit dialog.

I feel slow, I haven't scrolled down the Bulk metadata update window in a very long time. Not only did I discover the Update title sort option but a couple of other things I didn't realize existed.

[jcarlier]

So use the Update title sort option in the bulk metadata edit dialog.

have you the same solution for Author ???

[DoctorOhh]

Originally Posted by jcarlier

So use the Update title sort option in the bulk metadata edit dialog.

have you the same solution for Author ???

Yes.

Select a couple of books and actually look at the Bulk metadata edit window.

[jcarlier]

i don't see where you can replace 'sort on author' by 'author' on Bulk metadata edit window

see hard copy

[Adoby]

It is a combination of first applying the tweak and then updating the titles using the bulk edit metadata dialog. Otherwise only new or manually edited titles use the tweak.

[theducks]

Originally Posted by jcarlier

i don't see where you can replace 'sort on author' by 'author' on Bulk metadata edit window

see hard copy

The one right under the Authors box (I won't try the French ).
That works even if you enter nothing else on the form because it reads Authors and calculate the sort based upon the current (Tweaks) Rule

[DoctorOhh]

Originally Posted by jcarlier

i don't see where you can replace 'sort on author' by 'author' on Bulk metadata edit window

The Search and Replace tab (bulk metadata edit window) should work for this, but you'll need someone else to guide you if you need help.

You can go the other way (from Author_sort to Author) by going to the tag browser, right clicking on Author and selecting Manage Authors.

Originally Posted by theducks

The one right under the Authors box (I won't try the French ).
That works even if you enter nothing else on the form because it reads Authors and calculate the sort based upon the current (Tweaks) Rule

He doesn't want to set Author_sort he wants to mass copy Author to Author_sort.

[theducks]

Originally Posted by DoctorOhh

He doesn't want to set Author_sort he wants to mass copy Author to Author_sort.

If the author_sort_copy_method tweak is 'Copy', that will be the result of Automatically setting (from Authors)

I use this all the time to get rid of the Red's detected by the QC PI

[DoctorOhh]

Originally Posted by theducks

If the author_sort_copy_method tweak is 'Copy', that will be the result of Automatically setting (from Authors)

I use this all the time to get rid of the Red's detected by the QC PI

Excellent, so walk him through the tweak and he should be all set.

[jcarlier]

thanks but ..

If the author_sort_copy_method tweak is 'Copy', that will be the result of Automatically setting (from Authors)

ok for the new entries but quid for the old ones ??