Grouper Users - Open Discussion List

["Klug, Lawrence" <>]

Chris,

 

The hierarchical orgs  demo went well.  Now I want to see if I can apply it to our organization.   We have four levels of hierarchy her at UCLA:  Org: Division: Sub-Division: Department. I’m guessing that the first three levels will be stems and departments will be the groups.  Each of the four have ID and title columns in a de-normalized “departments” table.  In order to pull in the assignments, we will join to an employee table using  department ID as foreign key.  What configuration changes are necessary to make this  work?

 

Thanks,

 

Lawrence

 

From: Chris Hyzer [mailto:]
Sent: Tuesday, December 13, 2011 11:04 AM
To: Klug, Lawrence
Cc:
Subject: RE: Grouper Loader

 

Try setting this in the grouper-loader.properties and restart (GSH, something, whatever):

 

# auto-add grouper loader types and attributes when grouper starts up if they are not there

loader.autoadd.typesAttributes = true

 

chris

 

From: Klug, Lawrence
Sent: Tuesday, December 13, 2011 1:59 PM
To: Chris Hyzer
Cc:
Subject: RE: Grouper Loader

 

Chris,

 

I’ve been working through this exercise.  When I create the orgsConfig group, I’m not seeing the “grouperLoader”  option for “Select Group Types”

 

Thanks,

 

Lawrence

 

 

 

From: Chris Hyzer
Sent: Thursday, December 08, 2011 11:37 AM
To: Klug, Lawrence
Cc:
Subject: RE: Grouper Loader

 

Ok, yes, I think it is appropriate, and we do this at Penn J

 

Here is the doc on hierarchies with Grouper loader, and I added a lot of info about how we do this at Penn as an example:

 

https://spaces.internet2.edu/display/Grouper/Organization+hierarchies+via+the+grouper+loader

 

Let me know how it goes J

 

Thanks,

Chris

 

 

From: Klug, Lawrence
Sent: Thursday, December 08, 2011 12:02 PM
To: Chris Hyzer
Subject: RE: Grouper Loader

 

Hi Chris,

 

Here is the use case:  We have a payroll system at the University that contains an hierarchical structure ( organization, division, sub- division, department ).  We want to feed this data into grouper automatically creating the groups analogous to the structure in the payroll database.  There would be an initial large import, followed by periodic updates as the database changes.   Would Grouper Loader be the appropriate tool?

 

Thanks,

 

Lawrence

 

From: Chris Hyzer
Sent: Wednesday, December 07, 2011 4:19 PM
To: Klug, Lawrence;
Subject: RE: Grouper Loader

 

The loader will load memberships into a group or list of groups based on a query (and you can have multiple grouper loader jobs).

 

Steps are: make the query, make a group and assign the grouperLoader type, set the attributes.

 

Let me know if you are loading 1 group or a list of groups from one query, and I can give more specifics.  The hard part is writing the query though, the rest should be easy J

 

Thanks,

Chris

 

From: On Behalf Of Klug, Lawrence
Sent: Wednesday, December 07, 2011 6:05 PM
To:
Subject: [grouper-users] Grouper Loader

 

Question:

 

Let’s say I want to configure Grouper Loader to feed Subjects and Groups into the Grouper Repository from an SQL database.  What high-level steps are required?  How do I know which  columns to provide to Grouper when writing the SQL query?

 

Thanks,

 

Lawrence