Grouper Users - Open Discussion List

["Black, Carey M." <>]

Steven,

I have not done this (yet) but have often wonder about such use of google 
spreadsheets.  ( Good luck, let us know if you get something working. And 
ideally... share the code. :) )

On the google spreadsheet API side...

I think v4 is the latest API version....
        
https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/get
                or maybe
        
https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/getByDataFilter

        There are Java sample code/library ( and other languages too) ).
        I don't see a "JSON output" format, but someone could walk the sheet 
and get the data then produce whatever JSON blob they wanted to from there. 
Likely there would need to be a transformation anyways, so there is some work 
to be done there.
        This idea feels "fragile" and easily broken by users mucking with the 
format/details of the sheet.

        If you really wanted to do something like this, I think there is a 
way to make a "form" that frontends the google sheet too. ( So you can 
control how the data gets into the sheet.)


I think I could even imagine a Loader Job ( Java code ) that could be 
scheduled to "pull" the data. ( If someone wanted to go that far with this 
idea.)

HTH.

-- 
Carey Matthew 



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

 
[mailto:]
 On Behalf Of Hyzer, Chris
Sent: Thursday, January 11, 2018 8:38 AM
To: Steven Carmody 
<>;
 Grouper-Users 
<>
Subject: RE: [grouper-users] group membership .. input from google spreadsheet

Can you transform the csv to json and call addMember with "replace" and that 
will load into grouper?

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

 
[mailto:]
 On Behalf Of Steven Carmody
Sent: Wednesday, January 10, 2018 11:36 AM
To: Grouper-Users 
<>
Subject: [grouper-users] group membership .. input from google spreadsheet

Hi,

yes, I know, this is bad practice. But, I'm quite sure that Brown isn't the 
only campus where some depts are using spreadsheets as pseudo-databases.

Has anyone figured out a way to "regularly" provide the contents of a google 
spreadsheet to a process that would read and parse a CSV file and update a 
group's membership ?

Google Cloud Services supports cron in some form -- is there a way to export 
a spreadsheet to a CSV file and then mail the CSV file to a process ?

Is there a way from a linux machine to "mount" the google spreadsheet and 
issue commands to it ?

Is there some other way to move the contents from google to a linux machine ?

thanks for every suggestion, however crazy !