Grouper Users - Open Discussion List

["Dr. Loris Bennett" <>]

Hi Chris,

I finally got round to trying this out. It works fine for my SOR groups.
In this case I have already created the folder hierarchy and the empty
SOR groups and just let the loader fill them.

In the case of the roll-up groups, the loader creates the groups so
there is no preexisting information about the display name. Here, too,
one solution wold be to create empty groups in advance.

However, I was wondering whether there is any alternative to this. I am
thinking along the lines of taking the display name of the SOR group in
the folder and replacing the SOR bit of the display name with some
roll-up identifier, i.e. 

        My Org Unit (SOR) -> My Org Unit (all) 

This should be possible with a bit of SQL jiggery-pokery, right?

Loris

On Tue, 2008-12-09 at 03:25 -0500, Chris Hyzer wrote:
> This is done and unit tested for RC2.
> 
> https://bugs.internet2.edu/jira/browse/GRP-195
> 
> There is a new grouper loader attribute called grouperLoaderGroupQuery, 
> where you write a query with a row for each group in a group list, and with 
> one mandatory column "GROUP_NAME", and two optional columns: 
> "GROUP_DISPLAY_NAME" (note, the UI term for this is display path, this 
> includes display extensions for all parent folders), and 
> "GROUP_DESCRIPTION".
> 
> Here is the doc for this attribute in the grouper loader doc:
> 
> grouperLoaderGroupQuery: query (optional) for SQL_GROUP_LIST which should 
> return cols: group_name, group_display_name (optional), group_description 
> (optional) which if there are used for the group display and and extension. 
> Note: the parent stem display names are only changed when creating them. 
> This should return all groups in the membership list, and if not there, its 
> ok, the extension will be used as display extension, and a generated 
> description. Note: the display name is the display path, with the display 
> extension of each parent stem.
> 
> Note: I added this to the change log:
> 
> #  2008/12/9: v1.4.0 RC2 HEAD: if you are using grouper loader, and you are 
> not auto creating types and attributes in grouper config, then add this new 
> attribute with GSH:
> 
>     * subj=SubjectFinder.findById("GrouperSystem")
>       sess=GrouperSession.start(subj)
>       type=GroupType.createType(sess, "grouperLoader")
>       read=Privilege.getInstance("read")
>       admin=Privilege.getInstance("admin")
>       type.addAttribute(sess, "grouperLoaderGroupQuery", read, admin, false)
> 
> 
> When the group loader auto creates groups in the sql list, there is a new 
> attribute where you can set group metadata (display name and description). 
> Note: the display name is the display path, with the display extension of 
> each parent stem.
> 
> Regards,
> Chris
> 
> > -----Original Message-----
> > From: Dr. Loris Bennett
> > Sent: Tuesday, November 18, 2008 3:00 AM
> > To: Chris Hyzer
> > Subject: RE: [grouper-users] grouperLoader: Setting display name
> >
> > An extra columns sounds good. If the complete display name, e.g.
> >
> >         fu-berlin:central_services:computer_centre:auto|FU
> >         Berlin:Central Services:Computer Centre:automatic|123456
> >
> > would that form a reasonable basis for setting display names for the
> > folders and groups?
> >
> > Loris
> >
> > On Mon, 2008-11-17 at 13:23 -0500, Chris Hyzer wrote:
> > > Currently there is not a way... how would you want to do it?  Another
> > column in the membership query for group_display_name?
> > > Or another way to translate (another query, or hook)
> > >
> > > Chris
> > >
> > > > -----Original Message-----
> > > > From: Dr. Loris Bennett
> > > > Sent: Monday, November 17, 2008 9:59 AM
> > > > To: Grouper Users Mailing List
> > > > Subject: [grouper-users] grouperLoader: Setting display name
> > > >
> > > > Hi,
> > > >
> > > > If I generate a whole hierarchy of folders with grouperLoader, is
> > there
> > > > any way to set the display names of the folders at the same time?
> > > >
> > > > Currently I am generating the folder hierarchy separately to set
> > the
> > > > display names and then allowing grouperLoader just to add the
> > groups.
> > > >
> > > > Regards
> > > >
> > > > Loris
> >
> 
-- 
Dr. Loris Bennett (Mr.)
Freie Universität Berlin
ZEDAT - Zentraleinrichtung für Datenverarbeitung / Computer Center
Compute & Media Service
Fabeckstr. 32, Room 221
D-14195 Berlin
Tel ++49 30 838 51024
Fax ++49 30 838 56721
Email 

Web www.zedat.fu-berlin.de