Skip to Content.
Sympa Menu

grouper-users - [grouper-users] RE: Grouper Loader

Subject: Grouper Users - Open Discussion List

List archive

[grouper-users] RE: Grouper Loader

Chronological Thread 
  • From: "Hyzer, Chris" <>
  • To: BELL F.C. <>
  • Cc: "" <>
  • Subject: [grouper-users] RE: Grouper Loader
  • Date: Tue, 19 Apr 2016 16:56:58 +0000
  • Accept-language: en-US
  • Authentication-results:; dkim=none (message not signed) header.d=none;; dmarc=none action=none;
  • Spamdiagnosticmetadata: NSPM
  • Spamdiagnosticoutput: 1:23

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


Note, do addMember not delMember J





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%';









select NAME


where id = '0593061946b841f1b7e5ddcce457ee7f';


qsuob:faculties:artf:Chicago Group


I will try and configure a loader job




From: Hyzer, Chris []
Sent: 19 April 2016 16:06
To: BELL F.C. <>
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.





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




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…





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.









Archive powered by MHonArc 2.6.16.

Top of Page