Grabbing data from script

hey doug,

i'm ccing the list in case others (maybe mitch or waylon) have ideas.

i believe that since aggregate uses scheduled tasks to generate the
exports, there is no easy url to hit. your best bet is to use google
spreadsheets or fusion tables and use the gdata api (or some other app
built from gdata) to pull the data.

yaw

··· ---------- Forwarded message ---------- From: Doug Browning Date: Thu, Aug 25, 2011 at 18:59 Subject: Grabbing data from script To: contact@opendatakit.org

Is there a way to get the data uploaded from Aggregate through a
script? I want to say download the .csv from a python script so I can
then process it via calls to ArcMap. Is there a url or something to
grab the csv? I can not find anything about it. I tried the groups
but it will not let me post. I also looked at have it go to google
docs and then get it from there. Is that possible?

thanks a lot

Doug,

I think the question is what is the timeframe you need this feature.
We are exposing complete retrevial of all data from Aggregate right
now so that the new version of Briefcase (a stand alone app that runs
on a local machine) can download all the submissions. Briefcase will
then take the data and generate a csv for you locally on your machine.
This sounds similar to the functionality you are looking for and will
probably expose functionality you want.

I also thinks it's reasonable for Aggregate to expose the list of
files we expose through the UI to a servlet making it easy for people
to grab. Please file an issue as a feature request on the open data
kit code website describing how you would like it to work. Depending
on the difficulty of the request we could add that next week sometime
because I don't think it will be difficult but it's hard to say until
we know the details. We used to expose them via a servlet when the UI
was all run through the servlets. Now that we have a javascript front
end we have lost that functionality, it should not be difficult to add
back in.

As Yaw suggested a third way is to send the data to google and
retreive it but that will be a lot of coding for you.

Waylon

··· On Thu, Aug 25, 2011 at 10:48 AM, Yaw Anokwa wrote: > hey doug, > > i'm ccing the list in case others (maybe mitch or waylon) have ideas. > > i believe that since aggregate uses scheduled tasks to generate the > exports, there is no easy url to hit. your best bet is to use google > spreadsheets or fusion tables and use the gdata api (or some other app > built from gdata) to pull the data. > > yaw > > > > ---------- Forwarded message ---------- > From: Doug Browning > Date: Thu, Aug 25, 2011 at 18:59 > Subject: Grabbing data from script > To: contact@opendatakit.org > > > Is there a way to get the data uploaded from Aggregate through a > script? I want to say download the .csv from a python script so I can > then process it via calls to ArcMap. Is there a url or something to > grab the csv? I can not find anything about it. I tried the groups > but it will not let me post. I also looked at have it go to google > docs and then get it from there. Is that possible? > > thanks a lot > > -- > Post: opendatakit@googlegroups.com > Unsubscribe: opendatakit+unsubscribe@googlegroups.com > Options: http://groups.google.com/group/opendatakit?hl=en >