Sorting of pieces on composer page

Moderators: kcleung, Wiki Admins

Boccaccio
forum adept
Posts: 97
Joined: Thu Jul 03, 2008 11:22 am

Sorting of pieces on composer page

Post by Boccaccio »

Hi everybody!

I just noticed that the links to the work pages are sorted in a strange way. This phenomenon can be seen best for Christoph Graupner. There is a whole bunch of cantatas by Graupner that start with the word "Ach". In the list, we then first get the cantatas where the second word starts with a capital letter: "Ach Gott...", "Ach Herr...." while cantatas where the second word has a lower case come later on: "Ach bleib..." It would be much more convenient (especially when it comes to check whether all works from the Graupner page have ended up here or not) to have them sorted just by the letter no matter whether is is upper or lower case.

So what we have now is:

Ach Gott...
Ach Herr...
Ach bleib...
Ach stirb...

What would be preferred is:

Ach bleib...
Ach Gott...
Ach Herr...
Ach stirb...
pml
Copyright Reviewer
Posts: 1219
Joined: Fri Mar 16, 2007 3:42 am
notabot: 42
notabot2: Human
Location: Melbourne, Australia
Contact:

Re: Sorting of pieces on composer page

Post by pml »

The best way to fix these issues would be the {{DEFAULTSORT}} variable - where you can modify the way a page title sorts in all categories simultaneously – but the page processing on IMSLP disables it.

You'll have to re-order in Graupner’s page by adding something like [[Category:Graupner, Christoph|slightly different version of the title to allow it to sort correctly]] to the pages in question.

Cheers PML
--
PML (talk)
imslp
Site Admin
Posts: 1642
Joined: Thu Jan 01, 1970 12:00 am

Re: Sorting of pieces on composer page

Post by imslp »

First just a note that {{DEFAULTSORT}} usage should probably be kept absolutely minimal, and not to correct systematic problems like this because it takes away all flexibility in the event that, for example, we decide to remove 'Ach' from the sorting process.

That said, the reason for the weird sort is because of the way the database is structured. I think this happens on Wikipedia as well. I know vaguely how to fix it, but this may have to wait for a while because of time constraints.
Boccaccio
forum adept
Posts: 97
Joined: Thu Jul 03, 2008 11:22 am

Re: Sorting of pieces on composer page

Post by Boccaccio »

Well I think there is no need to hurry about this problem, as there as still nearly 1000 works of Graupner to come before we have to think about issues of completeness :D
haydenmuhl
active poster
Posts: 203
Joined: Thu Oct 28, 2010 6:20 pm
notabot: 42
notabot2: Human

Re: Sorting of pieces on composer page

Post by haydenmuhl »

What database does IMSLP use? MySQL?
Classical Voices - a forum for classical singers
imslp
Site Admin
Posts: 1642
Joined: Thu Jan 01, 1970 12:00 am

Re: Sorting of pieces on composer page

Post by imslp »

Yes, I'm trying to find out how to make it sort correctly without having to change the SQL query code. (e.g. just by changing table parameters)
haydenmuhl
active poster
Posts: 203
Joined: Thu Oct 28, 2010 6:20 pm
notabot: 42
notabot2: Human

Re: Sorting of pieces on composer page

Post by haydenmuhl »

Not having access to the DB, I can only guess, but it looks like it may be datatype related.

http://dev.mysql.com/doc/refman/5.0/en/ ... ivity.html

"Binary" and "nonbinary" strings are sorted differently. If you don't want to change the datatype of that field, that page lists how to modify the query to do what you want.

I know I've run into this before, but going the opposite direction.
Classical Voices - a forum for classical singers
Emil
regular poster
Posts: 18
Joined: Mon May 31, 2010 10:00 am
notabot: 42
notabot2: Human

Re: Sorting of pieces on composer page

Post by Emil »

I just spent five minutes looking for Bach's St Matthew Passion.
Unlike most street map indexes, in IMSLP St does not come with the SAs but at the end before Suite.
It's not under Matthaus either.

Could this be improved?
KGill
Copyright Reviewer
Posts: 1295
Joined: Thu Apr 09, 2009 10:16 pm
notabot: 42
notabot2: Human

Re: Sorting of pieces on composer page

Post by KGill »

I'm not sure how that could be changed. It does technically make sense the way it is, after all - T comes before U, not with the As. The most practical way to fix it would be to spell out the word 'Saint' in the page title.
vinteuil
Groundskeeper
Posts: 1445
Joined: Sun Oct 05, 2008 3:01 pm
notabot: YES
notabot2: Bot
Location: U.S.A.
Contact:

Re: Sorting of pieces on composer page

Post by vinteuil »

Actually, I think that "Matthäus-Passion" and "Johannes-Passion" is the best solution, personally
Formerly known as "perlnerd666"
KGill
Copyright Reviewer
Posts: 1295
Joined: Thu Apr 09, 2009 10:16 pm
notabot: 42
notabot2: Human

Re: Sorting of pieces on composer page

Post by KGill »

BWV gives 'Matthäuspassion', 'Johannespassion', and 'Lukaspassion' - so that would indeed appear to be the ideal solution.
Davydov
Copyright Reviewer
Posts: 817
Joined: Sun Aug 17, 2008 8:31 am
notabot: 42
notabot2: Human
Contact:

Re: Sorting of pieces on composer page

Post by Davydov »

Agreed, and done.
pml
Copyright Reviewer
Posts: 1219
Joined: Fri Mar 16, 2007 3:42 am
notabot: 42
notabot2: Human
Location: Melbourne, Australia
Contact:

Re: Sorting of pieces on composer page

Post by pml »

May I flag “Weinachtsoratorium” for a page move – one for the misspelling of “Weihnachts”, and secondly, the BWV prefers the hyphen and capitalisation of “-Oratorium” rather than having a (typically) long German conglomeration. PML
--
PML (talk)
vinteuil
Groundskeeper
Posts: 1445
Joined: Sun Oct 05, 2008 3:01 pm
notabot: YES
notabot2: Bot
Location: U.S.A.
Contact:

Re: Sorting of pieces on composer page

Post by vinteuil »

pml wrote:May I flag “Weinachtsoratorium” for a page move – one for the misspelling of “Weihnachts”, and secondly, the BWV prefers the hyphen and capitalisation of “-Oratorium” rather than having a (typically) long German conglomeration. PML
:oops: mispelling :oops: :oops:
Formerly known as "perlnerd666"
Davydov
Copyright Reviewer
Posts: 817
Joined: Sun Aug 17, 2008 8:31 am
notabot: 42
notabot2: Human
Contact:

Re: Sorting of pieces on composer page

Post by Davydov »

All taken care of (just in time for the 4th cantata) :)
Post Reply