Grouper Users - Open Discussion List

[Chris Hyzer <>]

Ok, good.  I need to look at this again, there should be a sort in the SQL 
query, not sure how that relates to the Java sort, Im thinking there can be a 
case where entries look sorted on the screen, but really it is skipping some 
people on that page...

Thanks,
Chris


-----Original Message-----
From: Wallaert-Taquet Brigitte 
[mailto:]
 
Sent: Monday, November 28, 2011 8:57 AM
To: Chris Hyzer
Cc: 

Subject: Re: [grouper-users] How export multivalued attribute ldap in LiteUI 
+ Sort with Accents

Le 25/11/2011 17:13, Chris Hyzer a écrit :
> I opened this jira...
>
> Just curious, if you do a SQL query with an order by, does it sort 
> correctly?
Yes
> There are two places where things are sorted in Grouper, in order by, and 
> in Java.  We can do a better job sorting in Java, but we also need sorting 
> in the DB.
>
> https://bugs.internet2.edu/jira/browse/GRP-711
Ok. I try this and it is ok when LiteUI display the list of members (cf 
file joined).
I modify SubjectSortwrapper.java like this :

...
// ajout bw
import java.text.Collator;
import java.util.Locale;

   public int compareTo(Object o) {
     if (!(o instanceof SubjectSortWrapper)) {
       return -1;
     }
     SubjectSortWrapper subjectSortWrapper = (SubjectSortWrapper)o;
     // modif bw tri accentue
     Collator frCollator = Collator.getInstance(Locale.FRENCH);
     return 
frCollator.compare(this.getScreenLabel(),subjectSortWrapper.getScreenLabel());
     //return 
this.getScreenLabel().compareToIgnoreCase(subjectSortWrapper.getScreenLabel());
   }

Thanks !
Brigitte


> Thanks,
> Chris
>
> -----Original Message-----
> From: Wallaert-Taquet Brigitte 
> [mailto:]
> Sent: Thursday, November 24, 2011 8:26 AM
> To: Chris Hyzer
> Cc: 
> 
> Subject: Re: [grouper-users] How export multivalued attribute ldap in 
> LiteUI + Sort with Accents
>
> Hello,
>
> It works, you can commit to SVN, thank you !
>
> Also, someone here tells me that we have problems with sort : the sort
> doesn't take care of the accents. In the example joined, "Sébastien
> Deconinck" should appear before "Sophie Gallina".
>
> Thanks for help !
>
> Brigitte
>
> Le 23/11/2011 18:41, Chris Hyzer a écrit :
>> Currently it doesn't work that way, I opened a jira, and it has a code 
>> tweak you could try if you want the multi-valued attribute to export as 
>> comma separated:
>>
>> https://bugs.internet2.edu/jira/browse/GRP-710
>>
>> If you do this and it works, let me know and I can commit to SVN...
>>
>> Should need to change: SimpleMembershipUpdateImportExport.java
>>
>> FROM:
>>
>>         //lets see what we can get from the subject
>>         for (int i=0;i<headers.length;i++) {
>>           String header = headers[i];
>>           if ("name".equalsIgnoreCase(header)) {
>>             result[i] = subject.getName();
>>           } else if ("description".equalsIgnoreCase(header)) {
>>             result[i] = subject.getDescription();
>>           } else if ("screenLabel".equalsIgnoreCase(header)) {
>>             result[i] = 
>> GrouperUiUtils.convertSubjectToLabelConfigured(subject);
>>           } else if (isAttribute[i]) {
>>             result[i] = subject.getAttributeValue(header);
>>           }
>>         }
>>
>>
>> TO:
>>
>>         //lets see what we can get from the subject
>>         for (int i=0;i<headers.length;i++) {
>>           String header = headers[i];
>>           if ("name".equalsIgnoreCase(header)) {
>>             result[i] = subject.getName();
>>           } else if ("description".equalsIgnoreCase(header)) {
>>             result[i] = subject.getDescription();
>>           } else if ("screenLabel".equalsIgnoreCase(header)) {
>>             result[i] = 
>> GrouperUiUtils.convertSubjectToLabelConfigured(subject);
>>           } else if (isAttribute[i]) {
>>             result[i] = subject.getAttributeValueOrCommaSeparated(header);
>>           }
>>         }
>>
>> Thanks,
>> Chris
>>
>> -----Original Message-----
>> From: 
>> 
>>  
>> [mailto:]
>>  On Behalf Of Wallaert-Taquet Brigitte
>> Sent: Wednesday, November 23, 2011 11:51 AM
>> To: 
>> 
>> Subject: [grouper-users] How export multivalued attribute ldap in LiteUI
>>
>> Hello,
>>
>> My question is in the subject : I put a multivalued attribute
>> (ustlDepartement) in my media.properties :
>> simpleMembershipUpdate.exportAllSubjectFields=name, mail, ustlDepartement
>> but I obtain only one value of this attribute in the export file.
>>
>> Anyone has an idea ?
>>
>> Thanks for help.
>>
>


-- 
Brigitte Wallaert-Taquet
Ingénieure d'études
Chargée d'étude
Espace collaboratif de Documents
Université Lille1
Sciences et Technologies