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: "Hyzer, Chris" <>
  • To: Steven Carmody <>, Grouper-Users <>
  • Subject: RE: [grouper-users] group membership .. input from google spreadsheet
  • Date: Thu, 11 Jan 2018 13:37:40 +0000
  • Accept-language: en-US
  • Authentication-results: spf=none (sender IP is ) ;
  • Ironport-phdr: 9a23:F35kgxaErUr3wl/em6jrcHH/LSx+4OfEezUN459isYplN5qZrs28bnLW6fgltlLVR4KTs6sC17KP9fi4EUU7or+5+EgYd5JNUxJXwe43pCcHRPC/NEvgMfTxZDY7FskRHHVs/nW8LFQHUJ2mPw6arXK99yMdFQviPgRpOOv1BpTSj8Oq3Oyu5pHfeQpFiCagbb9oMBm6sRjau9ULj4dlNqs/0AbCrGFSe+RRy2NoJFaTkAj568yt4pNt8Dletuw4+cJYXqr0Y6o3TbpDDDQ7KG81/9HktQPCTQSU+HQRVHgdnwdSDAjE6BH6WYrxsjf/u+Fg1iSWIdH6QLYpUjm58axlVAHnhzsGNz4h8WHYlMpwjL5AoBm8oxBz2pPYbJ2JOPZ7eK7WYNEUSndbXstJVyJPHJ6yb5cBAeQCM+ZXrYj9qEcBoxSxHgSsGPjgxiNUinPqwaE30eIsGhzG0gw6GNIOtWzZoNv3OqYSUOG60rPIwS3eZP5I2Tf98onIcgsvrfqRWr9wdNbeyUkvFgLEkFqQs5foPzKO1usRqWSb8vJgWvypi24hsQ1+vCWgxto1h4TPm4kbyUjE+D1nzIooJNC0UkB2bcC+HJdNtCyWK5F6T8MjTm1wpSo3xKEKtYS/cSQX0pgr2QPTZvidf4SV4B/uVeCcKipiin1/YrKwnROy/FCgyuLiUsm0105HoDJZn9fLqnwA2QXf59WFRfdj50uh3i2A2B7J5uFDPEA0ibHUK5k8wr42i5Ufq1zDHjXxmEXqkqCZalkk+umv6+TheLnmoYKcN5NwigH5NaQumdazDvg/MggLR2Sb+OK826P//UDhXrlGk/w7nrPXvZzEP8gXu620DxNP3osj6huzFzKm384ZnXkDIlJFYhWHj43xNlHLPP/4Dfe+glWynzdx3P3GP6bhDYnXInjeiLfuY7B960hGxAUt0N9f+opYCqsdL/LrRk/xqNvYAwc2MwyuxObnFc192Z0EWW6WH6+ZK73dsUWT5u80J+mMZZQVuCrmK/Q7/fLujHk5mUMDcqmz25sYdmy4Eup8L0qHfHXsn4RJLWBfhRYzUuHswHaLSztUa2f6C7kg6y82DrWtBJ3GQYy8qLab2zi9WJBaezYCQn+WFmrwep/BZuwBcjnadsB7lSEcWKLkVpQszwqGtQnmxqBhI/aOvCAUqMSw+sJy4riZtQAg+CYwR++dyWCWBSkgm2gIVi07xoh+ukc710+O164+jvBFQ48Ar8hVWxs3YMaPh9dxDMr/D0eYJo+E
  • Spamdiagnosticmetadata: NSPM
  • Spamdiagnosticoutput: 1:99

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 !



Archive powered by MHonArc 2.6.19.

Top of Page