{"action":"opened","issue":{"url":"https://api.github.com/repos/WisconsinEngineerMagazine/Wisconsin-Engineer/issues/42","repository_url":"https://api.github.com/repos/WisconsinEngineerMagazine/Wisconsin-Engineer","labels_url":"https://api.github.com/repos/WisconsinEngineerMagazine/Wisconsin-Engineer/issues/42/labels{/name}","comments_url":"https://api.github.com/repos/WisconsinEngineerMagazine/Wisconsin-Engineer/issues/42/comments","events_url":"https://api.github.com/repos/WisconsinEngineerMagazine/Wisconsin-Engineer/issues/42/events","html_url":"https://github.com/WisconsinEngineerMagazine/Wisconsin-Engineer/issues/42","id":415405248,"node_id":"MDU6SXNzdWU0MTU0MDUyNDg=","number":42,"title":"Create a system to upload staff lists from Spreadsheet to website","user":{"login":"earlejam","id":22418102,"node_id":"MDQ6VXNlcjIyNDE4MTAy","avatar_url":"https://avatars2.githubusercontent.com/u/22418102?v=4","gravatar_id":"","url":"https://api.github.com/users/earlejam","html_url":"https://github.com/earlejam","followers_url":"https://api.github.com/users/earlejam/followers","following_url":"https://api.github.com/users/earlejam/following{/other_user}","gists_url":"https://api.github.com/users/earlejam/gists{/gist_id}","starred_url":"https://api.github.com/users/earlejam/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/earlejam/subscriptions","organizations_url":"https://api.github.com/users/earlejam/orgs","repos_url":"https://api.github.com/users/earlejam/repos","events_url":"https://api.github.com/users/earlejam/events{/privacy}","received_events_url":"https://api.github.com/users/earlejam/received_events","type":"User","site_admin":false},"labels":[{"id":281772020,"node_id":"MDU6TGFiZWwyODE3NzIwMjA=","url":"https://api.github.com/repos/WisconsinEngineerMagazine/Wisconsin-Engineer/labels/enhancement","name":"enhancement","color":"84b6eb","default":true},{"id":281772021,"node_id":"MDU6TGFiZWwyODE3NzIwMjE=","url":"https://api.github.com/repos/WisconsinEngineerMagazine/Wisconsin-Engineer/labels/help%20wanted","name":"help wanted","color":"159818","default":true}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2019-02-28T01:32:37Z","updated_at":"2019-02-28T01:32:37Z","closed_at":null,"author_association":"CONTRIBUTOR","body":"Not sure exactly what this could look like, but here's a few ideas:\r\n\r\n- Google sheets spreadsheet holds staff lists for every department. Write some google apps script to write the staff into the corresponding html/JS staff file. Write some code (CRON job?) on the web host to pull this file every day at 3am, updating the web page.\r\n\r\nOR\r\n\r\n- Google sheets spreadsheet holds staff lists for every department. Write the google apps script to write staff in the same way as above. Automatically push the staff changes on days that it detects changes to the file. On the web host, install Git and clone our repo. Either have it automatically pull every night at 3am or just fetch, only pulling if changes have been detected. Would have to make sure it would only pull the one file, otherwise merge conflicts could break the site temporarily."}}
{"actor":{"display_login":"earlejam"}}