Grouper Users - Open Discussion List

["Hyzer, Chris" <>]

If its not a recurring thing, then you can make a query that generates GSH:

 

https://spaces.internet2.edu/display/Grouper/GrouperShell+(gsh)#GrouperShell(gsh)-CreateascriptfromSQL

 

Note, do addMember not delMember J

 

Thanks

Chris

 

From: BELL F.C. [mailto:]
Sent: Tuesday, April 19, 2016 11:19 AM
To: Hyzer, Chris <>
Subject: RE: Grouper Loader

 

OK Chris thanks for getting back to me, I will try and explain a bit better.

 

Basically in the example below I was wanting to automate the addition of the five ‘dcl’ members to the ‘Chicago group’

 

select subjectid

from subject

where subjectid like 'dcl%';

 

dcl0bw

dcl0jb

dcl0jem

dcl6rs

dcl6ts

 

 

select NAME

from GROUPER.GROUPER_GROUPS

where id = '0593061946b841f1b7e5ddcce457ee7f';

 

qsuob:faculties:artf:Chicago Group

 

I will try and configure a loader job

 

Frank

 

From: Hyzer, Chris []
Sent: 19 April 2016 16:06
To: BELL F.C. <>
Cc:
Subject: RE: Grouper Loader

 

I don’t really understand the question.  If you configure a loader job with a query it will do the groups and / or memberships for you.

 

https://spaces.internet2.edu/display/groupertrain/Grouper+Training#GrouperTraining-a

 

Thanks

Chris

 

From: BELL F.C. []
Sent: Tuesday, April 19, 2016 9:29 AM
To: Hyzer, Chris <>
Subject: RE: Grouper Loader

 

Dear Chris,

 

I am now at a stage where I would like to automate the process of adding members to groups.

 

I would like to select persons ( subject_id’s ) from the subject table based on some criteria and then perform the required inserts into the relevant tables

( grouper_memberships , grouper_groups etc. ).

 

 

Is there a  best way of doing this ?

Can I use existing code which sits behind the UI to perform this operation manually and handles all of the hex id’s ?

 

Thank you for all of your help with Grouper t date.

 

Kind regards,

 

Frank Bell

Durham University

England

 

 

From: Hyzer, Chris []
Sent: 06 April 2016 15:36
To: BELL F.C. <>
Subject: RE: Grouper Loader

 

I would run it from WEB-INF\bin where you have your UI or WS running from.  I.e. you have a tomcat right?  Where does that point to?

 

Basically you can run it from anywhere that you have the correct properties files setup… probably multiple of your locations would work J  read the stdout when you start gsh and make sure its pointing to the right place…

 

Thanks

Chris

 

From: BELL F.C. []
Sent: Wednesday, April 06, 2016 6:24 AM
To: Hyzer, Chris <>
Subject: Grouper Loader

 

Hi Chris,

 

Sorry to bother you but I am really struggling to familiarise myself with using the Grouper loader.

 

We have installed Grouper on a linux platform running against an ORACLE database ( pre-installed data is QS University of Bristol ).

 

However, your YouTube training video refers to a DOS prompt C:\temp> gsh –loader

 

When I have ran a find for gsh I am getting 50 different possibilities ( see attached ).

 

Do you have a script for setting the Grouper environment variables etc. or perhaps an idiots guide for using the Grouper loader ?

 

Thank you in advance,

 

Frank Bell

 

Durham, England.

 

 

 

Frank Bell |  IS Specialist  |  Computing and Information Service 

Durham University  |  Mountjoy Research Centre, Rowan Block| Stockton Road | DURHAM DH1 3UZ |  Phone 0191 334 4054 | 07946-236007

 

THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY MATERIAL and is thus for use only by the intended recipient. If you received this in error, please contact the sender and delete the e-mail and its attachments from all computers.