Skip to content

Instantly share code, notes, and snippets.

View yanokwa's full-sized avatar

Yaw Anokwa yanokwa

View GitHub Profile
@yanokwa
yanokwa / gist:a2a03d691ef4cf3d5bee
Created August 29, 2014 20:23
/help/form-design/data-preloading
Beginning with ODK Collect 1.4.3, you can pre-load data into a new submission.
If you have pre-existing data from a baseline survey, a listing survey, or any other source, you may want to reference that data in your survey form. For example, you might already have data on a household's agricultural plots when you go to collect follow-up data about those plots.
When you want to reference pre-existing data in a survey form, the first step is to upload one or more .csv files as support files when you upload your form definition (the same way you upload media support files in the Form Upload window). The first row of each .csv file should be a header that includes short, unique names for each column; subsequent rows should contain the data itself.
Columns in your .csv files must be separated by commas. Depending on your regional settings, Excel may save .csv files with semi-colons or other characters between columns, instead of commas; if that's the case, you will need to manually replace the column separators