Skip to Content.
Sympa Menu

grouper-users - [grouper-users] creating empty groups from an SQL source

Subject: Grouper Users - Open Discussion List

List archive

[grouper-users] creating empty groups from an SQL source

Chronological Thread 
  • From: Jeff McCullough <>
  • To: Gouper Users List <>
  • Subject: [grouper-users] creating empty groups from an SQL source
  • Date: Sun, 9 Oct 2016 20:59:33 -0700
  • Ironport-phdr: 9a23:A5GG1xRFlmV0JB6ec/agnGcfCNpsv+yvbD5Q0YIujvd0So/mwa64ZReN2/xhgRfzUJnB7Loc0qyN7PCmBDdLuMvJmUtBWaIPfidNsd8RkQ0kDZzNImzAB9muURYHGt9fXkRu5XCxPBsdMs//Y1rPvi/6tmZKSV3XfDB4LeXtG4PUk9//l6Xro8WSME10g2+SZq5qIQ/+kB7crNJepYp5Nu5lxQHOv2NFYaFL3m5yPnqSmQrx/MG94MQl/ihN7aEP7clFBIf3capwaLdzETAiNH065IW/txTNQw6EznERSGYblhdZRQXJ8UepDd/KriLmu78li2GhNsrsQOVxAGz64g==

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

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.


Archive powered by MHonArc 2.6.19.

Top of Page