Grouper Users - Open Discussion List

[Shilen Patel <>]

You should be able to do it by specifying a grouperLoaderGroupQuery that contains all the groups.

https://spaces.internet2.edu/display/Grouper/Grouper+-+Loader

Thanks!

- Shilen

On 10/9/16, 11:59 PM, "Jeff McCullough" <> wrote:

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