Grouper Users - Open Discussion List

[Chris Hyzer <>]

> 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?

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)...

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