Grouper Users - Open Discussion List

[Loris Bennett <>]

On Fri, 2009-03-13 at 12:00 -0400, Chris Hyzer wrote:
> > One area which interests me is the grouperLoaderGroupQuery, can this be
> > used to create groups from say an export of a department structure? I
> > haven't had a chance to look at this properly yet, but I just really
> > want to know what its main purpose is?
> 
> Yes, the grouperLoaderGroupQuery is one query that can do multiple
>  groups from one query... so the org structure is a good example of
>  this.  Loris, did you already post some examples of what you have
>  working?  Or do you have suggestions for this?

Isn't it that case that "grouperLoaderQuery" actually creates multiple
groups, whereas "grouperLoaderGroupQuery" just allows the display name
to be set?

I am currently using

        grouperLoaderQuery:

        select group_name, subject_id from my_auto_groups

to create the groups. The custom table "my_auto_groups" is filled by my
import client, which extracts the org information from a HR database. I
then have


        grouperLoaderGroupQuery:

        select name as group_name, display_name as group_display_name,
        description as group_description from grouper_groups_v

to set the display names.

> At penn we are generating groups for all our orgs in one folder... it
>  might be better to organize a bit better so we don't have a folder
>  with 500 org groups (currently we do :) ).  I have a group query:
> 
> select subject_id, group_name from EMPLOYEE_ORG_GROUPS_V
> 
> Which links up people with their org(s)...

At first reading I thought I should also try something like that, since
being able to use a single select like that is quite elegant.  However,
I am also keen to keep the hierarchy, rather than having all the groups
in one folder.

Chris, would it be feasible to tweak Grouper so that it can make an org
structure pop into existence as a hierarchy of folders, given a table
containing org_id and parent_org_id information? Looks like it might be
a useful feature for Penn ;-)

Cheers

Loris

> A confusing thing is we have empty orgs, but people want to make groups
>  with those as members since they could have members at some point.  So
>  I menually created those empty groups as placeholders.  Also, there is
>  an orphan cleaner in grouperLoader (which we aren't using, but will at
>  some point) do delete invalid (and empty) groups...
> 
> Regards,
> Chris
> 
> > -----Original Message-----
> > From: Richard James 
> > [mailto:]
> > Sent: Friday, March 13, 2009 11:48 AM
> > To: Chris Hyzer
> > Subject: RE: RE: [grouper-users] Stems and Group Members
> > 
> > Hi Chris,
> > 
> > With yours and Loris' advice as a starting point I have been able to
> > get something set up. As you suggested, for each stem within in the
> > hierarchy there is an "all group", which is populated automatically
> > using the grouper loader, this is perfect for what we need at the
> > moment! So I have grasped how to use grouper loader and how useful it
> > is, and will be trying to use it for other purposes.
> > 
> > One area which interests me is the grouperLoaderGroupQuery, can this be
> > used to create groups from say an export of a department structure? I
> > haven't had a chance to look at this properly yet, but I just really
> > want to know what its main purpose is?
> > 
> > Again, many thanks for your help, still early days using grouper so
> > just picking things up as I go along.
> > 
> > Thanks
> > 
> > Richard
> > 
> > >-----Original Message-----
> > >From: Chris Hyzer 
> > >[mailto:]
> > >Sent: 13 March 2009 15:33
> > >To: Richard James
> > >Subject: RE: RE: [grouper-users] Stems and Group Members
> > >
> > >Did Loris' example help enough?  Do you need more from me?
> > >
> > >Thanks,
> > >Chris
> > >
> > >> -----Original Message-----
> > >> From: Richard James 
> > >> [mailto:]
> > >> Sent: Thursday, March 05, 2009 10:55 AM
> > >> To: Chris Hyzer
> > >> Subject: RE: RE: [grouper-users] Stems and Group Members
> > >>
> > >> Thanks Chris,
> > >>
> > >> I have just looked at the documentation and understand the process
> > of
> > >> what it will be doing. I will have a play around with it in the next
> > >> couple of days, but if you are able to provide an example as a
> > >starting
> > >> point that would be a great help. I think for the purpose of this
> > >> example, it would just be direct children that would be required.
> > >>
> > >> Cheers
> > >>
> > >> Richard
> > >>
> > >> >-----Original Message-----
> > >> >From: Chris Hyzer 
> > >> >[mailto:]
> > >> >Sent: 05 March 2009 15:35
> > >> >To: Richard James
> > >> >Subject: RE: RE: [grouper-users] Stems and Group Members
> > >> >
> > >> >Don't spend too much time if it is confusing, let me know and I can
> > >> give
> > >> >you an example...  basically you need to query the grouper_groups
> > >> table
> > >> >to find the members, let me know if I can help.  Also let me know
> > if
> > >> you
> > >> >want only direct children, or all decendants, both are possible
> > >> >
> > >> >Chris
> > >> >
> > >> >> -----Original Message-----
> > >> >> From: 
> > >> >> 
> > >> >>  
> > >> >> [mailto:]
> > >> >> Sent: Thursday, March 05, 2009 9:47 AM
> > >> >> To: 
> > >> >> 
> > >> >> Subject: Re: RE: [grouper-users] Stems and Group Members
> > >> >>
> > >> >> I thought that was the case with Stem's just needed to clarify
> > >this.
> > >> >> Your suggestion looks like it would achieve what I am aiming for,
> > >so
> > >> I
> > >> >> think I will go down this route. I haven't had an opportunity to
> > >> look
> > >> >> at loader job's yet, so this will give me an opportunity to do so
> > >> and
> > >> >> try it out. Many thanks for your quick response, it's giving me a
> > >> good
> > >> >> starting point and hopefully, if I can get the loader job's
> > figured
> > >> >> out, it will be ideal solution.
> > >> >>
> > >> >> Thanks again,
> > >> >>
> > >> >> Richard
-- 
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