Grouper Users - Open Discussion List

["Klug, Lawrence" <>]

Chris,

 

I think these docs will help a lot.

 

Thanks,

 

Lawrence

 

From: Chris Hyzer [mailto:]
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