Install and configure Open Data Kit

First we will download the proper version of ODK Aggregate.

You will meet a long configuration process. You may not need to tweak all of these because most of the time the default value is just fine.

Here the installer will create a .war and .sql file based on the configurations you set. The .sql file will have the codes necessary for the databases and the .war file will set the web application. Keep pressing return (Enter) to scroll through the initial setup files, probably will take seven – nine returns.

And then,

Here is everything you will meet while the installation.

If you go to the installation folder (/home/sr/odk) you’ll find three files.

  1. ODKAggregate.war
  2. README.html
  3. create_db_and_user.sql

Login to the MySQL and use the .sql file to create the database.

You may want to create a mysql-connector for the Tomcat. Extract the tar file and move the mysql-connector-java-5.1.40.jar file to /opt/tomcat/lib directory.

We are almost there. come back to the ODK installation folder, rename ODKAggregate.war to ROOT.war. Move the ROOT.war file to /opt/tomcat/webapps folder.

In your browser hit your At first you may end up to a blank page. Hit it again with And there is an error.

There is still some things need to be done. Tomcat 8, Glassfish and Jetty require few additional configuration steps to run ODK Aggregate. All of these webservers require configuration settings to enable cookies under HTTPS. Otherwise, ODK Aggregate uses no special Tomcat features and it should operate correctly within any compliant Servlet web container.

Edit the context.xml file of Tomcat.

If you are not familiar with Vim commands, here is a quick tip. Use vi to start edit a file. Hit i to insert or edit a line. Hit escape to exit the insert mode, hit : to enter the menu mode. In menu mode (with :) type wq to save edits and exit vi mode. Simply hit q! to exit without saving. We used these commands to add useHttpOnly="false" (line-19) to our file.

Create a directory called WEB-INF inside webbapps folder and create two file here.

Add these lines inside the file and save it.

Add another file called jetty-web.xml and add these lines.

Remember : to enter menu, wq to save and quit.

Clean the browser cache, restart the browser. Go to, use admin as username, aggregate as password.

You have successfully reached the shore. Congratz and enjoy!


Design a form with XLSForm. This is as simple as working with Excel sheets, no coding requires. Here is a sample. Once the form is finished, use this page to convert and upload to ODK Aggregate.

Download and install ODK Collect to you android device. Set your credentials from General Stting>Configure Platform Setting. Once set, check if you can fetch blank form with Get Blank Form. Download the form from there, fill it, save and send finalized form back to Aggregate.

If you don’t have internet with you, try ODK Briefcase. It can pull finalized data from your devise to your PC and send later on. It can even download submitted data from ODK Aggregate in bulk.

You can even publish your data to Fusion table in stream. You can export the data as KML and see on Google Earth.

Pages: 1 2