ODK Aggregate with Postgres and Tomcat

Development
1

Hello all,
are there any current documentation showing how to set up ODK Aggregate with
Postgres and Tomcat?

Thanks in advance,
Tumaini

2

have you tried just using the installer? it should do most of the setup for you.

··· On Tue, Aug 30, 2011 at 00:07, Tumaini Kilimba wrote: > Hello all, > are there any current documentation showing how to set up ODK Aggregate with > Postgres and Tomcat? > Thanks in advance, > Tumaini
3

Hi,
I have prepared the form in ODK collect and published in formhub, But I need to connect this form to my database in Postgres, So, if know anybody, can you help me to describe how can I do it. I heard about ODK aggregate but couldnot do with it.

I would be very much thankful if anybody tell me procedure.

4

First, use the installer to install ODK Aggregate on AppEngine, to
understand the simple case. Then use the installer to install to Tomcat.
Follow the AppEngine and Tomcat installation instructions on our
non-developer website here: http://opendatakit.org/use/aggregate/

If you want to build from sources, after cloning the project, follow the
instructions in the CONFIGURE.txt of the source tree for configuring your
development environment. Verify that you can run and debug using the
AppEngine development server.

To run Eclipse locally with MySQL under the development environment, you
must delicately combine the file generated by the odk-gae-settings project
with the files generated by the odk-mysql-settings project. The resulting
file would replace the odk-gae-settings-latest.jar within the
eclipse-aggregate-gae tree. To combine them, replace the jdbc.properties
file with the one from the mysql jar and edit the odk-settings.xml file,
replacing the datastore bean definition with the definition from the mysql
jar. This will give you a hybrid that should run under AppEngine
development server but access the MySQL database backend for storage.

To run Eclipse fully with Tomcat and MySQL, you'll have to figure that out
yourself. It is not easy.

Mitch

··· On Thu, Jul 19, 2012 at 9:33 AM, wrote:

I had been trying this same problem, but I haven't found the answer. I
have been trying with the project aggregate-src and eclipse-aggregate-gae.

Please help me!

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

5

If you want to access the underlying data in formhub, you should talk
to the formhub developers at
https://groups.google.com/d/forum/formhub-dev.

If you want to install ODK Aggregate backed with PostgreSQL, follow
the instructions at
http://opendatakit.org/use/aggregate/tomcat-install. Once that's up
and running, the data is stored according to spec at
https://code.google.com/p/opendatakit/wiki/AggregateDatabaseStructure.

Yaw

··· -- Need ODK services? Go to http://nafundi.com for form design, data cleaning, custom reporting, and software development for ODK.

On Sat, Jul 20, 2013 at 3:28 AM, saugatstha2011@gmail.com wrote:

Hi,
I have prepared the form in ODK collect and published in formhub, But I need to connect this form to my database in Postgres, So, if know anybody, can you help me to describe how can I do it. I heard about ODK aggregate but couldnot do with it.

I would be very much thankful if anybody tell me procedure.

--
You received this message because you are subscribed to the Google Groups "ODK Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

6

A post was split to a new topic: Tomcat PostgreSQL connector jar file