Opend Data Kit (ODK) is a free opensource java applications tools for data capturing and aggregate the data and store it in a server. Uses of ODK is for digital surveys instead of the physical paper survey.
Before ODK was introduced, manual surveys have a long process to implement.
The physical paper survey involves decide the questions on the paper survey form, Collecting the survey data and finally aggregate survey data results.
Odk is not a single tool but it has different following modules
First, generate war file using odk agggregate packe on windows.
the following are required to setup ODK on windows
Go to the official opendatakit website and download ODK package for corresponding operating system Downloaded ODK Aggregate v1.4.3 windows-installer.exe and click on it for follow the steps.
The above screenshot explains about the folder where odk application.war is deployed
Above ip address is to provide Amazon public IP address
This IP address is the location of an instance where Postgres is installed. ODK and Postgres are installed on the same machine, so providing 127.0.0.1 as Postgres instance
This screen talks about odk application database, user details information
The above setup creates following files as per below screenshots.
create_db_and_user.sql :- This is SQL script for creating database odk_prod , user :- odk_user, password: odk_user and granting all privileges for odk_user
ODKAggregate.war :- This is odk aggregate application need to deploy in tomcat server.
Please install postgres. Once postgres is installed, please follow below steps to create odk database, odk users
Execute the Postgres SQL shell (psql) commandline client using the postgres username and password (the password you chose during the installation of the database), and supply the create_db_and_user.sql to it. To open the psql commandline client, open a cmd window (Windows), terminal window (MacOS) or term window (Linux) and ‘cd’ to the directory containing the psql client (psql.exe on Windows). Then, please type:
psql –username postgres
And enter the PostgreSQL server password. You will then be within the psql commandline client. You should see a ‘postgres=#’ prompt. Type:
Here is what this looks like on Windows, with what you must type in red:
Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:\Windows\System32>cd “\Program Files\PostgreSQL\9.0\bin”
C:\Program Files\PostgreSQL\9.0\bin>psql.exe –username postgres
Password for user postgres:*******
WARNING: Console code page (437) differs from Windows code page (1252)
8-bit characters might no work correctly. See psql reference
page “Notes for Windows users” for details.
Type “help” for help.
postgres=# \cd D:/odksetup/ODKAGG~1
postgres=# \i create_db_and_user.sql
You are now connected to database “odk_prod”.
Next step is to install java and tomcat. once installed deploy war to tomcat
copy the ODKAggregate.war to the /var/lib/tomcat6/webapps/ODKAggregate directory of the Apache Tomcat installation.
sudo keytool -genkey -alias admin -keypass adminpass -keystore certificate.jks -storepass adminpass
The above command generates certificate.jks in the current folder. Please copy certificate.jks file to /var/lib/tomcat6/conf and add/modify below entries in /var/lib/tomcat6/conf/server.xml
<?xml version="1.0" encoding="UTF-8"?>
<Connector port="8443" protocol="HTTP/1.1" SSLEnabled="true" maxThreads="150" scheme="https" secure="true" clientAuth="false" sslProtocol="TLS" keystoreFile="conf/certificate.jks" keystorePass="adminpass" />
8443 is SSL port for tomcat and 8080 is for normal HTTP request Next step is to start Apache Tomcat server(if not already started)
visit http://ipaddress:8080/ODKAggregate/ and go to the Management / Permissions tab to complete configuring the access rights for ODK Aggregate.