Import and Analyze Data

The Epi Info iOS app can import comma-delimited datasets and store them in the device's SQL table. To do this, email a .csv file to an account that can be read with the device's native email app.

IMG_5234.PNG


Touch and hold, then release the attachment. You will see the option to open the file with Epi Info. Touch the Epi Info icon.

IMG_5235.PNG


The app will read the file and display the names of the dataset and variables, along with some information about the columns. The dataset name and variable names are editable fields.

IMG_5236.PNG


At the bottom of the metadata table are "Cancel" and "Save" buttons. Touch "Save". It may take some time to load all of the data into a SQL table so the progress will be displayed at the top of the screen.

IMG_5237.PNG


If there is a data collection form with the same name and same fields on the device, then the records may be read and edited with the form. Regardless, the table is now available for analysis in the Analyze Data portion of the app.

IMG_5238.PNG


Touch the "Set Data Source" banner to see the available data sources. For now, only locally-stored SQL datasets are available.

IMG_5239.PNG


Touch "Table from Device" to see a list of stored datasets. This list will contain datasets loaded from CSV and datasets created with a collection form. The circular red buttons allow deletion of a dataset. (Touching a delete button will prompt the user to confirm before deletion occurs.)

IMG_5240.PNG


Touching a dataset name will load that dataset into a temporary table for analysis. This can take some time so progress is displayed.

IMG_5241.PNG


After loading, the dataset name and record count are displayed, and an "Add Analysis" banner appears at the bottom of the screen.

IMG_5242.PNG


Touching "Add Analysis" reveals the available analyses.

IMG_5243.PNG


Different analyses require different variables to be specified. Pickers are used to select these variables. On iPad, these Pickers are always displayed. On iPhone, they are hidden until the user touches a button. Here, the user has touched "Select Outcome Variable" in the Tables analysis.

IMG_5244.PNG


Here, the Outcome and Exposure variables are both set. Touch the gear button to run the analysis and display the results.

IMG_5245.PNG


Here are the results of this analysis of fictitious foodborne outbreak data. Touch the gear again to select different variables.

IMG_5246.PNG

Data Collection
Store and Export Data

Tutorials
Home

Last edited Sep 24, 2014 at 7:24 PM by zfj4, version 7

Comments

No comments yet.