Import user data from mysql database table

Hi,

the non-profit ngo I would like to help works with lots of volunteers. People submit biodiversity data through a web-based form that is imported into a mysql database. We would like to add odk into this data flow to enable mobile data collection. Is there a way to take user data from the mysql database into ODK Aggregate?

Thanks,
Kristof

There is no easy way to do this.

ODK Aggregate is best viewed as a data collection point for mobile data
submitted from ODK Collect.

From there, most users would set up a publisher or export data to CSV for
data processing.

In your case, I would recommend you:
(1) set up ODK Aggregate to gather data from devices using ODK Collect
(2) write a server that accepts data published from ODK Aggregate, and
insert it into your MySQL database schema.

This preserves all downstream processing, yet expands the mechanisms for
data gathering at the front end.

The data publishing options are described here:
https://opendatakit.org/use/aggregate/data-transfer/

The simplest to implement is probably the Simple JSON Publisher

https://code.google.com/p/opendatakit/wiki/AggregateToJSonXmlREDCapPublishers#Simple_JSON_Publisher

ยทยทยท On Mon, Oct 20, 2014 at 12:05 PM, wrote:

Hi,

the non-profit ngo I would like to help works with lots of volunteers.
People submit biodiversity data through a web-based form that is imported
into a mysql database. We would like to add odk into this data flow to
enable mobile data collection. Is there a way to take user data from the
mysql database into ODK Aggregate?

Thanks,
Kristof

--

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