Hi Everyone!
Is there any way to integrate SQL (postgreSQL, MySQL or any SQL) to ODK
Aggregate? We're hoping to merge several data sets from multiple (but
similar ODK forms) from several of our field offices so as to avoid
downloading each data set for every office at a time. This becomes tedious
when we're handling several different forms.
What do I need to look into?
Your assistance will greatly be appreciated.
Kind regards,
Ramadhan Swalleh
The most reliable way to do this would be to implement you own JSON data
server that ODK Aggregate can publish into.
https://opendatakit.org/use/aggregate/data-transfer/ and in particular,
https://code.google.com/p/opendatakit/wiki/AggregateToJSonXmlREDCapPublishers#Simple_JSON_Publisher
You can then set up publishersin ODK Aggregate for each of your field
office forms to publish into that one single downstream server.
And because you wrote that server, it can store the data in whatever
database representation you need.
Alternatively, if you host your own server, you could define a view across
the tables to consolidate the data sets, but would need to use MySQL tools
directly to use that for analysis.
Hi Everyone!
Is there any way to integrate SQL (postgreSQL, MySQL or any SQL) to ODK
Aggregate? We're hoping to merge several data sets from multiple (but
similar ODK forms) from several of our field offices so as to avoid
downloading each data set for every office at a time. This becomes tedious
when we're handling several different forms.What do I need to look into?
Your assistance will greatly be appreciated.
Kind regards,
Ramadhan Swalleh--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en
You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com