Home. What is an XLSForm? XLSForm is a form standard created to help simplify the authoring of forms in Excel. Authoring is done in a human readable format using a familiar tool that almost everyone knows - Excel. XLSForms provide a practical standard for sharing and collaborating on authoring forms. They are simple to get started with but allow for the authoring of complex forms by someone familiar with the syntax described below. The XLSForm is then converted to an ODK XForm, a popular open form standard, that allows you to author a form with complex functionality like skip logic in a consistent way across a number of web and mobile data collection platforms. Basic format Each Excel workbook usually has two worksheets: survey and choices. The survey worksheet This worksheet gives your form its overall structure and contains most of the content of the form. The choices worksheet This worksheet is used to specify the answer choices for multiple choice questions.
Question types Multiple choice Rank. XLSForm.org. Tomcat Install. Installation Overview The general sequence for setting up a Tomcat server is as follows: Define your server requirements and install your server.Install Tomcat on your server.Configure your server and network devices so that laptops or Android devices connecting to the internet from an external access point (e.g., Starbucks) can access your server. You may wish to restrict access to your server to devices directly connected to your local network. In this case, ODK Collect would not be able to access your server (to download forms or upload finalized forms) until the ODK Collect device returns to your site and establishes a direct connection to your local network.Obtain and Install an SSL certificate if you need secure (https:) access.Select and Install your database server (MySQL or PostgreSQL).Download and install ODK Aggregate.
Server Requirements The key questions are: How available do you need your server to be (e.g., 24/7, 8/5)? Google App Engine services provides all of these features. OpenDataKitInstallation - crossriver-openhds - Installing the Open Data Kit Aggregate Server - Cross River implementation of the OpenHDS. First, download the ODK Aggregate server application for Windows: You should download a version in the 1.0.X series (e.g ODK Aggregate v1.0.9 windows-installer.exe) Next, run the installation file The installation will create a folder and place the configured WAR file there. You'll need to remember this location This next step is very important. ODK will not function properly if you do not configure this properly. You must provide a valid Google account. Once the installation finishes, you will find the following files in the output directory: Now, you need to run the database script for ODK (create_db_and_user.sql).
Before you can deploy the ODK WAR file, You will need to install the MySQL Java Connector: Download the connector from This will download a zip file. Finally, you can deploy the ODKAggregate.war file to Tomcat. Google Earth Outreach. Open Data Kit (ODK) is a suite of tools that allows data collection using mobile devices and data submission to an online server, even without an Internet connection or mobile carrier service at the time of data collection. Once you've collected data in the field with ODK Collect, you can upload and manage your data using ODK Aggregate.
ODK Aggregate is the intermediary server storage platform that accepts the data and can send it on to external applications, if desired. ODK Aggregate also allows you to download your datasets in aggregated formats, such as one .csv file. ODK Aggregate allows you to use Google's AppEngine hosting platform for managing your remotely collected data online. Created by developers at the University of Washington's Computer Science and Engineering department and members of Change, Open Data Kit is an open-source project available to all.
Please visit their ODK project page for more information, recent updates, more tutorials, and to contribute to the project. Rough Guide to rural data collection with ODK | Blog | Aptivate. This post has three purposes, which I think overlap sufficiently to combine them: A User Guide for the system that we developed for UNICEF, IDS and RuralNet Zambia A Developers' Guide for anyone wishing to build something similar Notes on lessons learned that may assist future implementers view project Project goals Automate the data entry part of a long paper-based survey, by replacing the paper forms with electronic devices. Hardware and application selection The survey has several long and complex questions, and long sets of multiple-choice answers. Text entry is required for many fields. Two possible hardware platforms were identified: Tablet laptops with touch screens Tablet mobile devices (iPad or Android tablet) We selected the latter for this project due to lower cost, lighter weight, better usability and longer battery life.
The available software options that we identified were: Form creation For help in building surveys using XLS2XForm, please see the documentation. To be written. CollectSourceCodeOverview - opendatakit - Layout of ODK Collect source code - Open Data Kit (ODK) is a free and open-source set of tools to help create mobile data collection services. AggregateAWSInstall - opendatakit - How to install ODK Aggregate on an AWS-EC2/Linux/MySQL server. - Open Data Kit (ODK) is a free and open-source set of tools to help create mobile data collection services.
AggregateToJSonXmlREDCapPublishers - opendatakit - ODK Aggregate publishing capabilities - Open Data Kit (ODK) is a free and open-source set of tools to help create mobile data collection services. ODK Aggregate is intended to act as a locus for aggregation of data from devices running ODK Collect. Once collected, data can be published to 3rd party servers. There are 5 publishers available: Google Spreadsheet Google Fusion Tables REDCap (Xml publishing) Simple JSON publisher Ohmage JSON publisher (with media attachments) The last 3 publishers are in ALPHA. Google Fusion Tables -- repeat groups are published to their own Fusion Tables, and users must create their own VIEW to join these repeat tables against the top-level fusion table that is accessible through the ODK Aggregate UI. REDCap publisher fails when publishing media attachments. REDCap publisher has naming conventions for fields which may change.
Below are details of the submission protocols used for the REDCap, Simple JSON and Ohmage JSON publishers. Each submission is published into REDCap using a separate http POST request, and each attachment is also published as a separate http POST request. Submission POST request <? AggregateToJSonXmlREDCapPublishers - opendatakit - ODK Aggregate publishing capabilities - Open Data Kit (ODK) is a free and open-source set of tools to help create mobile data collection services.
ODK Aggregate is intended to act as a locus for aggregation of data from devices running ODK Collect. Once collected, data can be published to 3rd party servers. There are 5 publishers available: Google Spreadsheet Google Fusion Tables REDCap (Xml publishing) Simple JSON publisher Ohmage JSON publisher (with media attachments) The last 3 publishers are in ALPHA.
Google Fusion Tables -- repeat groups are published to their own Fusion Tables, and users must create their own VIEW to join these repeat tables against the top-level fusion table that is accessible through the ODK Aggregate UI. Below are details of the submission protocols used for the REDCap, Simple JSON and Ohmage JSON publishers. Each submission is published into REDCap using a separate http POST request, and each attachment is also published as a separate http POST request. Submission POST request NOTE: The URL to which the REDCap data is POSTed must end in a slash. URL-encoded UTF-8 form body with the following key-value pairs: <? AggregateTroubleshooting - opendatakit - Troubleshooting connection problems between ODK Aggregate and ODK Collect - Open Data Kit (ODK) is a free and open-source set of tools to help create mobile data collection services.
Read this if: You've set up ODK Aggregate and it runs great and you can access it from a browser on your machine. NOTE: the path after the hostname is case sensitive, so is different from You've installed ODK Collect on a phone. You can't get ODK COllect to download forms from ODK Aggregate. Here are some troubleshooting tips. Verify that your phone isn't in Airport mode... Can you can access the ODK Aggregate home page from your phone's browser? Can you reach the ODK Aggregate home page from another laptop or computer? If one or both fail, refer to the Getting Browsers to Work section. If the browser, works: Refer to Form List shows but Downloads Fail if you can see the list of forms but cannot download them to the phone.
Here are the two cases for troubleshooting getting the browsers to talk. Both Phone Browser and Other Browser Fail Possible causes are: Only Phone Browser Fails To troubleshoot the naming of your server: Open Data Kit » Tomcat Install. Installation Overview The general sequence for setting up a Tomcat server is as follows: Define your server requirements and install your server.Install Tomcat on your server.Configure your server and network devices so that laptops or Android devices connecting to the internet from an external access point (e.g., Starbucks) can access your server.
You may wish to restrict access to your server to devices directly connected to your local network. In this case, ODK Collect would not be able to access your server (to download forms or upload finalized forms) until the ODK Collect device returns to your site and establishes a direct connection to your local network.Obtain and Install an SSL certificate if you need secure (https:) access.Select and Install your database server (MySQL or PostgreSQL).Download and install ODK Aggregate.
Server Requirements The key questions are: How available do you need your server to be (e.g., 24/7, 8/5)? Google App Engine services provides all of these features. Open Data Kit Step by step. Getting started with ODK - Install Aggregate on Ubuntu 12 | Data Discussions. Source Checkout - opendatakit - Open Data Kit (ODK) is a free and open-source set of tools to help create mobile data collection services. Android - Data collection frameworks like ODK.
Open Data Kit » Aggregate. Yaw Anokwa. Open Data Kit » AMPATH Improving Care At Scale With ODK and OpenMRS. AMPATH is the one of the largest HIV treatment programs in sub-Saharan Africa and is Kenya's most comprehensive initiative to combat the virus. The program's catchment area has over 2 million people and provides care to more than 130,000 HIV-positive patients across 55 urban and rural clinics. To provide care at this scale, AMPATH has invested in tools like OpenMRS (an open source medical record system) and Open Data Kit, to help improve the efficiency and impact of their health providers. Home-Based Counseling and Testing with ODK Collect AMPATH has an extensive home-based and counseling program where community health workers (CHWs) go house to house to identify and enroll persons in need of care (i.e., pregnant women not in antenatal care, orphaned children, persons at high risk for tuberculosis infection).
The workers need mobile data collection to document socio-economic data (including GPS location of household) and to implement the counseling and testing protocol. Open Data Kit » Encrypted Forms. Overview Encrypted forms provide a mechanism to keep your data private even when using http: for communications (e.g., when you do not have an SSL certificate or https: is not available). Encrypted forms may also enable Google App Engine deployments (and deployments using other web database services, e.g., AWS) to comply with data privacy laws, eliminating the necessity for setting up your own servers to meet those requirements.
Encrypted forms apply asymmetric public key encryption at the time the form is finalized within ODK Collect. This encrypted form can then be submitted up to ODK Aggregate and downloaded to ODK Briefcase. This process ensures that the finalized form's data (and media attachments) are encrypted before being submitted to ODK Aggregate, remain encrypted while stored on ODK Aggregate, and remain encrypted as the data and attachments are pulled into ODK Briefcase, where they are again stored in encrypted form. Requirements Security Concerns Configuration Form Definition 1. Open Data Kit » Form Design. This page is a reference guide for users who edit the raw XML in ODK forms. If you use the XLSForm form designer, see for form design help. The purpose of this document is to provide a detailed breakdown of XForms, specifically the subset of XForms implemented by JavaRosa, so that anyone can make their own forms.
As of this writing there are several tools to help create your own XForms that work on JavaRosa platforms. They all allow you to create XForms, though generally the easier they are to use the less advanced functionality they provide. Begin with a JavaRosa-compliant automated design tool Use an automated tool compatible with JavaRosa to build the basic XForm. We have a form design guide, and the JavaRosa community has a description of the specification we support and a good tutorial. Our experience is that these form design tools can provide a good starting point, but, to enable advanced features, you will inevitably need to edit the resulting form. <! Instance. Nribeka/openmrs-module-odkconnector. XLSForm Offline v1.3 (Windows, Mac) XLSForm. XLSForm is a tool to simplify the creation of forms. Forms can be designed with Excel and XLSForm will convert it to an XForm that can be used with GeoODK tools. This tutorial teaches you to build your forms using Excel.
Please refer to the sample Excel file as you read through the tutorial. Each workbook must have two worksheets: survey and choices. The survey worksheet contains the structure and most of the content of the form. Each of these worksheets has a set of necessary columns that must be present for the .xls file to be valid. GeoODK Collect supports a number of simple question types: To collect the name and gps coordinates of a store use the following Excel file: GeoODK Collect has support for both ‘select one’ and ‘select all that apply’ questions. There are three columns on the ‘choices’ sheet: ‘list name’ contains the name of multiple choice list this choice belongs to. We can also add multiple choices questions that allow multiple answers to be selected, like so: XLSForm.org. Converting ODK XML Data to CSV. Formhub.