Automate extracting details from Google Forms

[olexandr-konovalov]

https://github.com/burnash/gspread/pulls may be used for this.

[egonw]

Another option is this R package.

[trallard]

How are the GForms details being extracted at the moment and where are they going? If these are meant to go into a file/issue in GH I can take this

[yochannah]

The links to the forms are here: #33 - I don't actually have edit access to them to add you or see the results though. @selina-aragon can you help with this?

@trallard failing that, could most of the work be done with a dummy form?

[yochannah]

Processing the results into a file (e.g. an html or markdown file for jekyll) would be perfect.

[trallard]

We will eventually need access to the forms to creat some authorization tokens for the automation tasks. So Ideally we want access to the form and response (and edit access).

I could work on a dummy form and link to GH ... for a quick mock up

[yochannah]

@trallard I would like to launch this within the next couple of weeks to time with the talk I am doing at GCCBOSC at the end of June. Is that doable? I'll poke Selina about sharing the forms, but worst case is I re-create them with an account where I have write access.

[trallard]

It would normally be completely doable... but I am officially on leave from Saturday until the 8th of July and I have a long list of outstanding actions for the week. So I would not be able to pick this up until I am back from holidays (sorry)

[selina-aragon]

Hi @yochannah, I've made you owner of the forms. Let me know if that works?

[yochannah]

@selina-aragon I still can't get in, sorry! These two, either yoyehudi or yochannah at gmail etc. would be great!

https://docs.google.com/forms/d/1W75S7DCa9Iv5FHTL7oeUWAnakl-oaEBoY5oNVcvDX5A/viewform?edit_requested=true
https://docs.google.com/forms/d/1qEfuzo3TacqHYBatq9Gea3vPd_SFMpAqjlEe3TGt6ag/viewform?edit_requested=true

@trallard Thanks for letting me know and enjoy your break!

[yochannah]

@selina-aragon I lie, I've just seen the invites in my inbox!

[selina-aragon]

ah, that’s why. It had yo@intermine.org<mailto:yo@intermine.org> Changing it just now. Should be accessible in 5 mins. On 11 Jun 2018, at 09:40, Yo Yehudi <notifications@github.com<mailto:notifications@github.com>> wrote: @selina-aragon<https://github.com/selina-aragon> I still can't get in, sorry! These two, either yoyehudi or yochannah at gmail etc. would be great! https://docs.google.com/forms/d/1W75S7DCa9Iv5FHTL7oeUWAnakl-oaEBoY5oNVcvDX5A/viewform?edit_requested=true https://docs.google.com/forms/d/1qEfuzo3TacqHYBatq9Gea3vPd_SFMpAqjlEe3TGt6ag/viewform?edit_requested=true @trallard<https://github.com/trallard> Thanks for letting me know and enjoy your break! — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub<#3 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/ASpioh9s_HlqSQ1I-yhA2QDmXMwJuqezks5t7iz8gaJpZM4S-hIJ>. The University of Edinburgh is a charitable body, registered in Scotland, with registration number SC005336.

[trallard]

Cool... If I can have a look at the forms and the responses fields I can make a start and will finish over the first week of July if that works.

I suppose for the time being we could keep the data extraction as manual and automated for the future?

[trallard]

Hi! I am back. @selina-aragon @yochannah any chance we can get this moving forward?

[yochannah]

@trallard can you email me your preferred google id to add you? I only have your sheffield email