[Using Sakai] [Building Sakai] Weird issue ordering by Lastname

[Qu, Yuanhua]

It appears correct to me if user names are sorted by lastname:

"John Del Potro" and "Peter Delaware"

Last name " Potro" should list after "Delaware" if sort names ascending order.  We did notice that sakai sort users by last names mostly, not by first name or full name.  We do have request from our users to change name sorting by first names instead of last name, I guess most people know first names better than last names.

-Qu






On 1/26/12 7:06 AM, "Feliz Gouveia" <fribeiro at ufp.edu.pt> wrote:

could be because the default Java collation sort order ignores
whitespaces? if so, maybe the code should be modified to always
include the collation of the current locale. That would solve at the
same time the language specific ordering issues.

regards, Feliz

On 26 January 2012 12:59, Daniel Merino <daniel.merino at unavarra.es> wrote:
> Hi, Feliz, and thanks for your answer.
>
> We don't have the KNL-696 patch applied. However, after taking a look on
> it, I understand that this patch is applied to make a custom sort order
> for the last names according to the locale preferences.
>
> However, our issue is happening with last names without non-ASCII
> characters and also working in english language.
>
> For example, in a fresh english installation the same problem would
> happen (or that's what I think!) for, i.e., the ficticious users "John
> Del Potro" and "Peter Delaware". Peter would be listed before John.
>
> We have the 2.7.1 version. Could somebody confirm if I am right or wrong?
>
> I have created this JIRA about this:
> https://jira.sakaiproject.org/browse/KNL-873
>
> Best regards.
>
> Feliz Gouveia escribió:
>> Daniel, I'm not sure if this could be the case but check
>> https://jira.sakaiproject.org/browse/KNL-696.
>>
>> For languages with special characters, the collation should be
>> specified for the locale being used. Otherwise you'll have also
>> problems ordering with accents and other non-ascii characters. I
>> remember this was not in the code and we had to do it to sort names.
>>
>> regards, Feliz
>>
>>
>> On 26 January 2012 09:44, Daniel Merino <daniel.merino at unavarra.es> wrote:
>>
>>> Hi everybody.
>>>
>>> One of our teachers has reported us a weird issue we hadn't noticed before.
>>>
>>> Given two students, whose lastnames are "Martinez Torcal" and "Martin
>>> Troncoso", these lastnames are written in the LASTNAME field of the
>>> SAKAI_USER table.
>>>
>>> Ordering in the database client, in excel or any other application, the
>>> logical alphabetical order is first "Martin Troncoso" and after
>>> "Martinez Torcal", just because the blank space is counted as a character.
>>>
>>> However, in our Sakai 2.7.1 with kernel 1.1.13 they are ordered at Site
>>> Info, Assignments, etc. just the opposite: first "Martinez Torcal" and
>>> after "Martin Troncoso". The same issue happens with LDAP users.
>>>
>>> I have searched at JIRA, but I haven't found any clue about this. Also,
>>> I have looked at BaseUserDirectoryService in the Kernel code:
>>>
>>> http://source.sakaiproject.org/viewsvn/kernel/trunk/kernel-impl/src/main/java/org/sakaiproject/user/impl/BaseUserDirectoryService.java?view=markup
>>>
>>> but the getSortName() method doesn't seem to do nothing wrong.
>>>
>>> Please, could you tell me if this problem has been reported and solved
>>> in the past?
>>>
>>> Thanks in advance.
>>> Best regards.
>>> --
>>> Daniel Merino Echeverría
>>> daniel.merino at unavarra.es
>>> Gestor de teleformación - Centro Superior de Innovación Educativa.
>>> Tfno: 948-168489 - Universidad Pública de Navarra.
>>> --
>>> Donde todos piensan igual nadie piensa mucho. (Walter Lippmann)
>>>
>>> _______________________________________________
>>> sakai-dev mailing list
>>> sakai-dev at collab.sakaiproject.org
>>> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>>>
>>> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"
>>>
>>
>>
>>
>>
>
> --
> Daniel Merino Echeverría
> daniel.merino at unavarra.es
> Gestor de teleformación - Centro Superior de Innovación Educativa.
> Tfno: 948-168489 - Universidad Pública de Navarra.
> --
> Tener la conciencia limpia es síntoma de mala memoria. (Les Luthiers)
> _______________________________________________
> sakai-user mailing list
> sakai-user at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-user
>
> TO UNSUBSCRIBE: send email to sakai-user-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"



--
Feliz Ribeiro Gouveia

Universidade Fernando Pessoa            http://www.ufp.pt
Centro de Recursos Multimediaticos      Tel 351-22.507.13.06
M.I.N.D. Lab                            Fax 351-22.550.82.69
Pr 9 de Abril 349                       fribeiro at ufp.edu.pt
P-4249-004 Porto
_______________________________________________
sakai-user mailing list
sakai-user at collab.sakaiproject.org
http://collab.sakaiproject.org/mailman/listinfo/sakai-user

TO UNSUBSCRIBE: send email to sakai-user-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-user/attachments/20120126/00028f47/attachment-0001.html