Skip to Content.
Sympa Menu

grouper-users - Re: [grouper-users] Grouper Loader - Create reference groups from SQL rows?

Subject: Grouper Users - Open Discussion List

List archive

Re: [grouper-users] Grouper Loader - Create reference groups from SQL rows?


Chronological Thread 
  • From: Carl Waldbieser <>
  • To: Michael Gettes <>
  • Cc: grouper-users <>
  • Subject: Re: [grouper-users] Grouper Loader - Create reference groups from SQL rows?
  • Date: Fri, 13 Jul 2018 15:50:58 -0400 (EDT)
  • Ironport-phdr: 9a23:FCRrwR0ct1PUzOyTsmDT+DRfVm0co7zxezQtwd8ZseITK/ad9pjvdHbS+e9qxAeQG9mDtbQc06L/iOPJYSQ4+5GPsXQPItRndiQuroEopTEmG9OPEkbhLfTnPGQQFcVGU0J5rTngaRAGUMnxaEfPrXKs8DUcBgvwNRZvJuTyB4Xek9m72/q99pHPYghEniaxba9vJxiqsAvdsdUbj5F/Iagr0BvJpXVIe+VSxWx2IF+Yggjx6MSt8pN96ipco/0u+dJOXqX8ZKQ4UKdXDC86PGAv5c3krgfMQA2S7XYBSGoWkx5IAw/Y7BHmW5r6ryX3uvZh1CScIMb7Vq4/Vyi84Kh3SR/okCYHOCA/8GHLkcx7kaZXrAu8qxBj34LYZYeYP+d8cKzAZ9MXXWRPUMZPWSJCAIy8YZYBAOUdMuhXronzoEcOoACiBQm1GOzj1iVFimP00KA8zu8vERvG3AslH98Wrnnbts/1NKMPWu+11qbIySjMYOhX2Tjj84jHbAohquyLULN+a8XRzVQgGBjEjlqOtYPoJDeV2f4Ds2eB7+tvS/6vi3I5pA1rvDeg29osh5DPi4kIyV7E7T10zJs7KNC8UkJ3fNGpHZlKuy2HKod6WN4uTm5qtSoi17ELt5q2cDIXxJkoxRPTceGLfoiS7h79SOqdPC90iG9rdb+7nRq+7Eetx+/mWsWpzVpGtDdJn9fSun0Lyhfd8NKISuFn8UekwTuP1x7c6uVDIU0skKrbN4Quz7wqmpoXq0vDEDX5mUXog6+KakUr5PKk5Pr6bbX7vpOcNol0hR/iMqk2h8CyD+A1PhITU2WU++mwzqDv8VDjTLlXgfA7kLHVsJXAKsQaoq65DRVV0oEm6xunATapytAYkmQcI1JEZh2Ik5PkO1XUL/D2F/i+g0qjkCt3x//YJLHuHIjCLmXbnLf7Ybl981JcyBY0zd1H6JJUELYBIO/rWkDvrtzUFwI5MxeqzOb9E9VwzYceWWOUAq+FK6Per0WE5uMpI+mQeoAVojD9JOY55/Lwl3M2h0ISfbT6lacQPVW5FfRvLkHRTnfwntoaWTMFsxYiQffClVOGFzNfeiDhcbg742QQAZiiRbjKQoyngbGa0T3zSoJfYmxMC12HOXPheYyVVusQZWSfLtI3wW9MbqSoV4J0jULmjwT90bcya7OMoiA=

Michael,

Thanks-- I think I get it, except-- what do you assign the LoaderType
properties on? The stem? Some random group?

Thanks,
Carl Waldbieser
ITS Identity Management
Lafayette College

----- Original Message -----
From: "Michael Gettes"
<>
To: "waldbiec"
<>
Cc: "grouper-users"
<>
Sent: Friday, 13 July, 2018 15:36:34
Subject: Re: [grouper-users] Grouper Loader - Create reference groups from
SQL rows?

Change your SQL to do the following:

SELECT SUBJECT_ID, ‘Stem1:Stem2:’||grpname as GROUP_NAME
From tables
Where conditions;

And configure this as Loadertype SQL_GROUP_LIST and you’re done.

Later you can do things like SELECT SUBJECT_ID,
‘basis:byDept:’||DeptID||’:Staff:’StaffLevel as GROUP_NAME and now you are
creating multi-level groups. Be sure to set things such as 'Groups like sql
part’ and 'Group query (metadata on groups)’ as needed.

A single SQL query with a loader job can generate 10s of thousands of groups.
Did this at PSU and managed 90,000 course groups in 1 hour daily run.

Happy to discuss by phone if you wish.

/mrg

On Jul 13, 2018, at 3:08 PM, Carl Waldbieser
<<mailto:>>
wrote:


I have rows coming from a SQL connection like this:

SUBJECT_ID GROUP_NAME
========== ==========
subject-A group-1
subject-B group-1
subject-C group-2
subject-D group-1
...

I'd like the loader to create "group-1" and "group-2" and "group-N" in a
particular stem and populate the memberships, but I'm unsure if (1) the
loader can do that, and (2) how to configure the loader to do that if it is
possible.

Any pointers would be great!

Thanks,
Carl Waldbieser
ITS Identity Management
Lafayette College



Archive powered by MHonArc 2.6.19.

Top of Page