I am new to ODK, I have just recently learned how to build forms,
collect data, and store it on aggregate running on google AppEngine. I
am developing for someone who wants the data collected from ODK
collect to be mapped into a mysql database on a server. Based on what
I understand of the ODK toolkit, which is very limited I was thinking
we could export form data into a CSV which aggregate lets you do
through its gui. Then I thought to run a script that takes all the CSV
files and maps it into the database following some sort of rules based
on parsed column headers and tables. That script could be automated to
run every week or month. The only manual part would be generating the
CSV files. Now, I am new to ODK, though I have a background in IT and
programming, so if you have any ideas on how to do this more
efficiently with say another set of technologies, feel free to suggest
to me how you would do this. I would really appreciate your input...
shreyas,
aggregate 1.0 doesn't have to run in google app engine. you can also
run it on a tomcat server backed with mysql. the code is in beta, but
maybe you can try it and see if it works for you.
if you need cloud functionality, you might consider packing it up in a
virtual machine and deploying it on amazon web services.
yaw