Grouper Users - Open Discussion List

[Jeff McCullough <>]

I’ve been playing around with SQL_SIMPLE and GROUP_LIST for grouper loader 
connections. I’d like to create a list of title code groups that are empty to 
start, and then some are populated with current accounts. The empty to start 
part is necessary for creating title code groups for various jobs on campus. 
Some of the title codes are not currently being used, but they may in the 
future. We want to create title code based nested groups for various job 
types. We are hoping to hand this off to the HR group, since they are the 
authorities as title code groupings may change over time. They will want to 
add all the nested title code groups at once rather than having to worry 
about adding them later when someone new is using a previously unused title 
code. 

I can’t see a easy way to directly create them besides using SQL_GROUP_LIST 
and using a select statement like:

select ‘0’ as subject_id, group_name, etc… 

against a view that has a list of all possible title codes. The ‘0’ is 
unresolved, but it does create an empty group. Is there another way to do 
this? I haven’t seen it in the documentation, though there are discussions 
about creating org trees and class lists of nested groups. Maybe I’m missing 
the obvious. Who knows.

Thanks,
Jeff