Grouper Users - Open Discussion List

["Hyzer, Chris" <>]

1.       How does it know it’s a rename instead of a new group and delete old one?  J  so yes, it creates new and abandons the old.  You can put a SQL like string on group names so it deletes ones not in query.

2.       Look in grouper_loader_log table, you will see times for queries.  Note, run that job again, how long is the second run?  Shorter since not a lot changed.   First it runs loader query to get the members and list of groups.  Then it loops through the groups and gets the grouper list for each one if they exist.

3.       For attributes, no you cant do that now, but just curious, are they all single valued strings, single assign to the object?  How many attributes would you be assigning?  Would you specify that in the grouperLoaderGroupQuery (column for attribute name1, column for attribute value1, column for attribute name2, etc?

 

Thanks

Chris

 

 

 

From: Akki Kumar [mailto:]
Sent: Monday, November 21, 2016 4:18 PM
To: Hyzer, Chris <>;
Subject: Grouper Org Hierarchies

 

Hi Chris,

 

I created organization hierarchies via grouper loader using below documentation:
https://spaces.internet2.edu/display/Grouper/Organization+hierarchies+via+the+grouper+loader

 

 

After running SQL Loader multiple times, I have some questions:

• I updated the group name in the DB and ran the SQL grouper loader. Instead of updating a group name, it created a new group and added members to it. This lead to multiple groups with old and new group names. Does grouper loader (SQL_Group_list) has diff functionality for the organizational hierarchies? Or it only creates new groups and adds members to it?

 

• After I start running SQL grouper loader, it took around 1.5hrs - 2hrs to start processing and creating groups in the Grouper. How does grouper loader query DB? Does it first run group query and then loader query? Or Run both at the same time?

 

•  Using the SQL grouper loader, is there a way to add attributes to a group?

Eg:-

 

Department Hierarchy (Folder)

|   

|_ Software_Development (Group) 

          |

          |_Supervisor_Name_Attr

          |

          |_Supervisor_Approval_Attr

 

 

Thank you,

Akki