Grouper Users - Open Discussion List

[Gail H Lift <>]

I have written Google sheets from a Linux server. If you want to try that route, let me know and I'll send sample code. 

On Jan 11, 2018 9:18 AM, "Black, Carey M." <> wrote:

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 !