Export Results

Data File

When a project is complete, the survey results can be exported via iTunes or email.

In general, most researchers will choose to use the email option. It is simple and intuitive to participants. File sharing is more likely to be useful if the researcher provides the participants with devices, which are then returned.

The results are exported as a .csv file. There will be a data file for each participant ID. A run-once survey may be run with different participant IDs and thus there may be more than one file. If there is one participant ID, as is always the case for a scheduled survey, there will be one output file per project (see the image below). Unopened survey runs (i.e., that have not been responded to) are not saved or recorded.

The first four lines of the data file are as follows:

  1. Survey Name
  2. Author
  3. Subject ID
  4. Blank

Below this header information, every 3 lines reports on one survey run. The first line of a survey run has “Start time” and “End time” headings in Columns A and B and question numbers from Column C on. The second line has the start and end timestamps in Columns A and B and the responses listed from Column C on. The third line is a timestamp for each response.

The following data file (opened as a spreadsheet) is for 2 survey runs with the following question types:

  1. List
  2. Checkbox
  3. Slider
  4. Text

Exporting results via email

When the last run of a scheduled survey has been notified, an alert will appear asking participants if they would like to email the results back now or later. If the participant misses the last survey run, this message will still appear when they open the app again. This alert will show after each run-once survey. If participants opt to email results later, to do this they will need to go to the PIEL Survey home screen and tap the arrow to the right of the survey name. This will offer the alternative of emailing the results or deleting the survey.

Results will be emailed to the address in listed in the author-email field of the Control File. If no email is placed in the Control File, the participant can type in the email when the email pscreen appears.

After emailing the responses, the data can be deleted by clicking "Delete All Responses". This will bring up a confirmatory message.

We recommend that participants don't delete data until it is confirmed that the researcher has received the results.

Exporting results via file sharing

The data file can be accessed in iOS devices using iTunes file sharing.

  • Plug the device into the computer and open iTunes.
  • Click on the icon indicating your device at the top of the window.
  • Click on file sharing.
  • Scroll down to the PIEL Survey app and click.
  • In the window on the right you will see the data file (.csv)
  • Either drag and drop the file or save it to your desired location.