Managing Form Submissions in Central¶
To find the Form submissions page, first find the form in the Form listings page (Form Overview page for that form. Click on the tab below the form name to find the submissions.) and click on it. You will be taken to the
The table preview you see here will show you the first ten fields of your survey and their results, with the latest submissions shown closest to the top. Any downloadable files will appear with a green download link you can use to directly download that media attachment. The submission's instance ID will always be shown at the right side of this preview table.
It is not yet possible to screen or delete submissions for quality or edit submission data. These features are planned for future releases. For now, you will need to pull your data out of Central before you can work with it. Right now, you can do this in one of two ways:
- The CSV Download option will get you a
.zipfile containing one or more
.csvtables, along with any multimedia submitted to the form. This is a good option if you already have custom tools you wish to use, or you want to import it into an offline analysis tool like SPSS or Stata.
- The OData connector allows you connect a live representation of the data to OData-capable tools like Microsoft Excel, Microsoft Power BI, Tableau, SAP, and others. This option has some advantages: the data is transferred more richly to maintain more data format information, and the feed is always live, meaning any analysis or reports you perform in your tool over an OData connection can be easily refreshed as more submissions come in.
Learn more about these options below:
Downloading submissions as CSVs¶
To download all submission data as a
.csv tables, click on the Download all # records button on the right side of the listing page:
Once it completes downloading, you will find one or more files when you extract it:
- A root table
.csvnamed after your Form title.
- Join table
.csvfiles representing any repeats you may have in your form, with join columns on the left of each table relating each row to its counterpart in the parent table. Each join table is named to reflect its relationship with the others. If there is only one
.csvfile, then your form has no repeats.
- A folder named
fileswhich contains subfolders, each named after an
instanceIdof a submission. Each subfolder then contains a set of file attachments relating to that submission. If no
filesfolder exists, then no multimedia attachments have been submitted to this form.
- If you have enabled Client Audit Logging on your form, and log events have been submitted to the server, then you will find a file that ends with
- audit.csv. This file combines all the logging data from all submissions to the form into a single table.
Connecting to submission data over OData¶
To connect a third-party tool to Central over OData, you will need a link to paste into the tool. You can find this link by clicking on the Analyze via OData button on the right side of the listing page:
Once you click on it, you should see this popup appear:
Because OData is a industry standard, only one link is necessary to make most tools work. However, because it is a relatively new technology, some tools need a little bit of customization to work correctly. If you are using such a tool, like Power BI, click on its tab to get the special link we provide for it. Otherwise, copy the link as-is and paste it into your tool.
If you want to use the free and popular R statistics and analysis tool, we recommend you use ruODK. A guide for getting started with it can be found here. Just like ODK itself, ruODK is developed and supported by community members. If you wish to help improve it, you can find information on GitHub.
When asked for login information, provide the email address and password you use to log into ODK Central. Make sure you trust the tool you are using before you do this.