Skip to Content.
Sympa Menu

grouper-users - Re: [grouper-users] group membership .. input from google spreadsheet

Subject: Grouper Users - Open Discussion List

List archive

Re: [grouper-users] group membership .. input from google spreadsheet

Chronological Thread 
  • From: Steven Carmody <>
  • To: Gail H Lift <>, "Black, Carey M." <>
  • Cc:
  • Subject: Re: [grouper-users] group membership .. input from google spreadsheet
  • Date: Thu, 11 Jan 2018 11:11:55 -0500
  • Ironport-phdr: 9a23:zgKtaR3ZGrkAaS3usmDT+DRfVm0co7zxezQtwd8ZseMSL/ad9pjvdHbS+e9qxAeQG9mDsrQc06L/iOPJYSQ4+5GPsXQPItRndiQuroEopTEmG9OPEkbhLfTnPGQQFcVGU0J5rTngaRAGUMnxaEfPrXKs8DUcBgvwNRZvJuTyB4Xek9m72/q99pHPfglEniaxba9vJxiqsAvdsdUbj5F/Iagr0BvJpXVIe+VSxWx2IF+Yggjx6MSt8pN96ipco/0u+dJOXqX8ZKQ4UKdXDC86PGAv5c3krgfMQA2S7XYBSGoWkx5IAw/Y7BHmW5r6ryX3uvZh1CScIMb7Vq4/Vyi84Kh3SR/okCYHOCA/8GHLkcx7kaZXrAu8qxBj34LYZYeYP+d8cKzAZ9MXXWpPUNtPWSxPAY2yYYUAAOUDMulEoIfwvEcOoBikCAWwGO/ixD1Fi3nr1qM6yeQhFgTG0RQ9EdISrnvUssv6NKEPWu2r1qbI1zDDb/RL1jb99YPFdQshoe2SUrJub8XRz1EgGB/fgVWKrIzlOC6a1+QWvmeA9epgUuyui2g9pw5vvzev294hh4/UjYwbzVDE8D92wIczJdCgR057ZtmkEJRUty6ELYd5XsQiQ2RutS0nybMGoYa2cDYLxZg7xRPSbvKHfouT7R7/UeucLit0iG54d7+6mxm+7VWvx+j5W8WqzlpHqjJJnsTQun0OzRDe5MeKRuFj8ku/2TuDzR7f5vxGLE0yiKHVMYQuwqQqmZoWqUnDHjH5mEHxjKKOc0Ur4Omo6+D+brX/up+QK5Z4iw7gPqgwnsGzG+s4Mg8JX2iU/eSzyqfv8lH+QLVPlvE2k6/Zv47GJckDuKK0AhNZ34Qm5haxDDqpy8gUkHwIIV5ZZB6Iko3kNE3SLP/lCPqyhkqgnClvyvzeO73uGJTNLnzNkLf7erZ97lZRyBEvzd9B+ZJbFLcBL+rvVUDrrtzYCxg5PBG0wuv8E9p9zIQeWGyJAqODLqzdrEKI6vo1I+aQfI8VpCr9K/896v7hl385nkIdfbG30psNcXy4A+9mLFuDYXr3mdoBFWYKvhEiTOzxllGOSz9TZ3CuX60i/DE7DpypDZvdSoy3nrOOwTq7TdVqYTVpA1GIWVegU4SKR79YZyKWCtJkkzcEE7WtVtllnVuEsAbxyP4vBePO9zxQkNSpnIx/4+TYlldrr2dcCN+AlWyBUjcnsHkPQmoNwK1hrEo14V6Z1K90krQMDsBe+f5PZQwzL5vbw/1SAcr1RQSHc9uUHgX1Cu66CC08G4pii+QFZFxwTpD71kjO

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:


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....

                or maybe


        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.)


Carey Matthew


-----Original Message-----



On Behalf Of Hyzer, Chris
Sent: Thursday, January 11, 2018 8:38 AM
To: Steven Carmody



Subject: RE: [grouper-users] group membership .. input from google

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

-----Original Message-----



On Behalf Of Steven
Sent: Wednesday, January 10, 2018 11:36 AM
To: Grouper-Users

Subject: [grouper-users] group membership .. input from google


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

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 !

Archive powered by MHonArc 2.6.19.

Top of Page