Updated version of "humaniosurvey" app stores to Google Spreadsheets - with gotcha solved

17 views
Skip to first unread message

Edward Vielmetti

unread,
Sep 26, 2012, 11:54:17 PM9/26/12
to humanio-discuss
Please find attached a version of the "humaniosurvey" that was circulated
to this list as a sample app that uses the Google Spreadsheet
interface to store data.

I've trimmed out all (?) of the extraneous references to the mailer
system that tastylabs
uses, so that it should run with just the dependency of the gdata
python package at
http://code.google.com/p/gdata-python-client/

One operations note that was a temporary gotcha. To make this work, you need to
first create a Google spreadsheet, and secondly set up the column
headers so that
it matches the python dictionary that you are storing. I found that
discussion here
http://code.google.com/p/gdata-python-client/issues/detail?id=481
You cannot simply store data to a blank spreadsheet using the code
provided; you'll
get a 400 error telling you to try your request later.

Thanks as always for working sample code, it makes getting a useful system up
and running that much easier. Look for the
save_to_gdata()
function as a way to insert this into other running code that you have.

--
Edward Vielmetti +1 734 330 2465
edward.v...@gmail.com
humaniosurvey-gdata.py

Nick Nguyen

unread,
Sep 27, 2012, 4:09:21 PM9/27/12
to humanio...@googlegroups.com
Nice!  Thanks for cleaning up my code.

-n.
Reply all
Reply to author
Forward
0 new messages