Grouper Users - Open Discussion List

[Steven Carmody <>]

That example would be incredibly helpful. Please send it along.

I have to read a sheet, not write it, but that should be an easy change.

On 1/11/18 9:24 AM, Gail H Lift wrote:
> 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." < 
> <mailto:>> 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
>     
> <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
>     
> <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 
>
>  
> <mailto:>
>
>
>     -----Original Message-----
>     From: 
>
>     
> <mailto:>
>     
> [mailto:
>     
> <mailto:>]
>  On Behalf Of Hyzer, Chris
>     Sent: Thursday, January 11, 2018 8:38 AM
>     To: Steven Carmody 
> <
>     
> <mailto:>>;
>  Grouper-Users
>     
> <
>  
> <mailto:>>
>     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:>
>     
> [mailto:
>     
> <mailto:>]
>  On Behalf Of Steven
>     Carmody
>     Sent: Wednesday, January 10, 2018 11:36 AM
>     To: Grouper-Users 
> <
>     
> <mailto:>>
>     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 !