Using ODK Aggregate With an Access Database

Support
1

Hi Guys,

I am quite new with the ODK aggregate and i am doing project that uses an
access database.
My question is, can ODK aggregate work with the access db or does it only
work with SQL?
Users of the ODK collect upload forms onto Formhub and formhub is normally
quite congested so I was wondering
if the ODK forms could be uploaded straight into the database if I am using
Access?
Anyone who can help? I'd really appreciate.

Tracy

2

Hi Tracy

As far as I am aware the only db options are MySQL and postgres. To get the data into access you would need to do some post processing. Another option would be to use Google app engine and stream the data to Google spreadsheet of fusion tables.

Bashir

··· From: opendatakit@googlegroups.com [mailto:opendatakit@googlegroups.com] On Behalf Of Tracy Kay Sent: 13 August 2014 10:19 AM To: opendatakit@googlegroups.com Subject: [ODK Community] Using ODK Aggregate With an Access Database

Hi Guys,

I am quite new with the ODK aggregate and i am doing project that uses an access database.
My question is, can ODK aggregate work with the access db or does it only work with SQL?
Users of the ODK collect upload forms onto Formhub and formhub is normally quite congested so I was wondering
if the ODK forms could be uploaded straight into the database if I am using Access?
Anyone who can help? I'd really appreciate.

Tracy

--

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.

This email is free from viruses and malware because avast! Antivirus protection is active.

3

Hi tracy, where yo able to get a work around, on using access instead of
mysql

··· On Wednesday, 13 August 2014 11:19:21 UTC+3, Tracy Kay wrote: > > Hi Guys, > > > I am quite new with the ODK aggregate and i am doing project that uses an > access database. > My question is, can ODK aggregate work with the access db or does it only > work with SQL? > Users of the ODK collect upload forms onto Formhub and formhub is normally > quite congested so I was wondering > if the ODK forms could be uploaded straight into the database if I am > using Access? > Anyone who can help? I'd really appreciate. > > Tracy >
4

Hi Ayoub,

I was not able to do so, are you facing the same problem?

··· On Tue, Jun 23, 2015 at 11:09 AM, Ayoub Kakande wrote:

Hi tracy, where yo able to get a work around, on using access instead of
mysql

On Wednesday, 13 August 2014 11:19:21 UTC+3, Tracy Kay wrote:

Hi Guys,

I am quite new with the ODK aggregate and i am doing project that uses
an access database.
My question is, can ODK aggregate work with the access db or does it only
work with SQL?
Users of the ODK collect upload forms onto Formhub and formhub is
normally quite congested so I was wondering
if the ODK forms could be uploaded straight into the database if I am
using Access?
Anyone who can help? I'd really appreciate.

Tracy

--

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 a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/J2H_HAp0Weo/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

5

ODK Aggregate only works with MySQL, PostgreSQL and on AppEngine.

Once you have ODK Aggregate set up, there are various publishing and
data-export options that you can use to move the data into an Access
database or other tool.

··· On Wed, Jul 1, 2015 at 5:44 AM, Tracy Kimani wrote:

Hi Ayoub,

I was not able to do so, are you facing the same problem?

On Tue, Jun 23, 2015 at 11:09 AM, Ayoub Kakande akakande@gmail.com wrote:

Hi tracy, where yo able to get a work around, on using access instead of
mysql

On Wednesday, 13 August 2014 11:19:21 UTC+3, Tracy Kay wrote:

Hi Guys,

I am quite new with the ODK aggregate and i am doing project that uses
an access database.
My question is, can ODK aggregate work with the access db or does it
only work with SQL?
Users of the ODK collect upload forms onto Formhub and formhub is
normally quite congested so I was wondering
if the ODK forms could be uploaded straight into the database if I am
using Access?
Anyone who can help? I'd really appreciate.

Tracy

--

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 a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/J2H_HAp0Weo/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

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