add ability to load groups via csv

----Original Message----
From: grouper-users-request@internet2.edu grouper-users-request@internet2.edu On Behalf Of Sawyer, Mona Zarei
Sent: Friday, August 18, 2017 11:10 AM
To: Black, Carey M. <black.123@osu.edu>; grouper-users@internet2.edu
Subject: [grouper-users] RE: schedule group member's import weekly

Hello Carey,

Thanks for your advice.
We implemented the schedule in the Cron and now it is working fine.

Thank you so much.
Best Regards,
Mona.

Mona Z Sawyer M.Sc.
Programmer Intermediate
Middleware and Identity Services
Information Technology
1320 S. Dixie Hwy
Suite 1000.49
Coral Gables, Fl 33146
305-284-2214

"At the U, we transform lives through teaching, research and service."

----Original Message----
From: Black, Carey M. black.123@osu.edu
Sent: Wednesday, August 16, 2017 4:21 PM
To: Sawyer, Mona Zarei <monaz@miami.edu>; grouper-users@internet2.edu
Subject: RE: schedule group member's import weekly

Mona,

To my knowledge, the Loader only (currently) supports SQL or LDAP data sources for the jobs. ( Supporting CSV seems possible too. But maybe not necessary.)

It looks like you have a command line way to run a process to import the csv file already. Could you just put that into a cron job on the host?
The users still need a way to update the csv file. ( Most Unix installs support SCP with little to no configuration. You would need OS level accounts/permissions, but those seem like a small maintenance/one time setup.

You might also opt to use the UI (or have the end users use the UI) to "bulk add" the members that way too. ( Someone need to "upload the file somewhere either way.)
"Add members" --> " import a list of members ." link to show the UI to cut/paste the Username list into.
Options include a CSV file.
"
How to add members?
Search for members to add
Copy/paste a list of member IDs
Import a file
"
NOTE: there is a check box at the bottom that lets the import " Replace existing members?" if that is desired. ( I think the process just adds by default. This option removes all members then puts your list in to the group.)

You might also opt to create a client program to read the csv and make web services calls too.
A bit more work, but it could be handed off to the end user to use whenever they update the csv. You avoid needing to run the import job yourself, and empower them to make changes as needed, on their schedule.
Which is a lot like what they grouper client does. However, I am not clear on how the grouper client authenticates to Grouper. ( That may or may not be a concern for your use case.)

Hope some part of that helps.

–
Carey Matthew Black.123@osu.edu

----Original Message----
From: grouper-users-request@internet2.edu grouper-users-request@internet2.edu On Behalf Of Sawyer, Mona Zarei
Sent: Wednesday, August 16, 2017 3:22 PM
To: grouper-users@internet2.edu
Subject: [grouper-users] schedule group member's import weekly

we are trying to setup grouper to read a csv file every week to populate a group's members.
We are aware that we can populate a group from a csv file using the grouper client ( [grouper.clientBinary-2.3.0]$ java -jar grouperClient.jar --operation=addMemberWs --groupName=UsersGRoupA --subjectIdsFile=members.csv)
However, we are not sure how we can schedule it, like we can do in grouper loader to run on a scheduled time.
Are we able to setup reading a csv file in the loader? If not how can we schedule the client to run weekly?

Thank you so much.
Best Regards,
Mona.

Mona Z Sawyer M.Sc.
Programmer Intermediate
Middleware and Identity Services
Information Technology
1320 S. Dixie Hwy
Suite 1000.49
Coral Gables, Fl 33146
305-284-2214

"At the U, we transform lives through teaching, research and service."