Grouper Users - Open Discussion List

["Hyzer, Chris" <>]

Depends how you set it up.

If you have a SQL like string configured, it will get deleted.

If you have a group query, it will lose all memberships I believe.

Thanks
Chris

-----Original Message-----
From: 

 
[mailto:]
 On Behalf Of Carl Waldbieser
Sent: Tuesday, July 24, 2018 4:00 PM
To: grouper-users 
<>
Cc: Michael Gettes 
<>;
 John Schrader 
<>
Subject: Re: [grouper-users] Grouper Loader - Create reference groups from 
SQL rows?


I finally managed to get this working, so now I have a follow up question.
What happens if my data changes such that one of the groups that has been 
dynamically created goes away in the data?

I'm guessing that the group remains in Grouper but doesn't have any members 
in it after the next time the loader runs?  Is that correct?

Thanks,
Carl Waldbieser
ITS Identity Management
Lafayette College

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

fwiw ND has a structure:

etc:loader:banner:{a_group_that_represents_the_SQL_GROUP_LIST}
The loader attributes are set on this group.

We also use the grouperLoaderGroupQuery attribute (a distinct list of
groups to load)

# This loader job will create and load orgCode reference groups from
blablabla.

grouperSession = GrouperSession.startRootSession();
addGroup("etc:loader:banner", "orgCodes", "orgCodes");
cloaderGroup = GroupFinder.findByName(grouperSession,
"etc:loader:banner:orgCodes");
groupAddType(cloaderGroup.name, "grouperLoader");
setGroupAttr(cloaderGroup.name, "grouperLoaderDbName", "banner");

setGroupAttr(cloaderGroup.name, "grouperLoaderGroupQuery", "SELECT DISTINCT
lower('nd:basis:banner:employee:orgcode:' || ORGN_LEVEL_8) AS GROUP_NAME,
ORGN_LEVEL_8_TITLE AS GROUP_DESCRIPTION FROM bla bla bla WHERE BLA");
setGroupAttr(cloaderGroup.name, "grouperLoaderQuery", "SELECT
lower('nd:basis:banner:employee:orgcode:' || ORGN_LEVEL_8) AS GROUP_NAME,
NDID AS SUBJECT_IDENTIFIER, 'nd' AS SUBJECT_SOURCE_ID FROM bla bla bla
WHERE BLA");

setGroupAttr(cloaderGroup.name, "grouperLoaderType", "SQL_GROUP_LIST");

setGroupAttr(cloaderGroup.name, "grouperLoaderQuartzCron", "02 45 11,22 * *
?");
setGroupAttr(cloaderGroup.name, "grouperLoaderScheduleType", "CRON");

loaderRunOneJob(cloaderGroup);


Happy Friday !
-John






On Fri, Jul 13, 2018 at 3:51 PM Carl Waldbieser 
<>
wrote:

> 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
>


-- 
John Schrader
Identity and Access Management
Office of Information Technologies
University of Notre Dame

EVERYTHING SHOULD BE MADE AS SIMPLE AS POSSIBLE, BUT NOT ANY SIMPLER
—ALBERT EINSTEIN