Export Advanced Options

When exporting the survey data, you can select a number of advanced options as necessary.

Figure 1 - The advanced options

The options (which vary depending on the Export File Type) are:

• Loop Handling - this option is only available if the survey included loops. Here you specify how loops are to be handled for the export. The options are:
• Separate File - the default export format for loops creates one export file for each loop, and one export file for the top level. In the files containing the loop data there will be one row per loop iteration per respondent, so there will be several rows for each respondent. Each row will have the responseid (system generated respondent id) of the respondent and the precode of the loop id for the iteration as identifiers, and then the answers for the questions inside the loop for that specific iteration for that respondent. This means you can export a hierarchical survey without having to generate a flattened template.
• Single File - Instead of exporting loop data as separate files, you can export all data belonging to a survey in one single file. Loop data will then be expanded. This means that variables will be created to represent each iteration of each question.
• Position of Loop Variables - if you have specified Single file in the Loop Handling option, you can then select where the loop variables are to be placed. The options are:
• As in questionnaire - the loop variables are positioned as the corresponding loop was placed in the survey.
• Appended at the end - the loop variables are added at the end of the survey.
• Truncate open ends - (default Off) for Open Text questions with no field width specified, you can truncate the exported texts. Set to On, then set a character limit; any characters over the limit will be removed.
• Text in Question Labels - select the text you wish to be included as the question labels.
• Text only - the label element will contain only the text of the question.
• Title only - the label element will contain only the title of the question.
• Title and Text - the label element will contain the question title followed by - followed by the question text.
• Question ID - the label element will contain the question id.
• Text in Answer Element Labels - allows you to specify whether the Answer element of a Grid, Open Text List or Numeric List Question is to be positioned in front of the Question label, after the Question label, or without the Question label, when exporting survey data.
• Export Language - if the survey is multilingual then you can select the language you wish to export.
• Locale - determines the formatting of elements such as numbers (decimal point) and dates/times. Select the locale most appropriate for the person or system receiving the file.
• Deliver files uncompressed - select to have the data files delivered via email in uncompressed (not zipped) format. This setting is only applicable when using the email method to deliver the file(s).
• Override auto-generated export file name - select to include dynamic values in the export file name. Note that if the rule is recurring and does not contain TASKID, the output file may be overwritten each time.
• Override email options - opens some fields that allow you to change some of the default email options which will otherwise be used.

Note: When filtering by date range, if the End date time is set to 00:00, data for the end date is not included in the export. To include responses from the end date, set the time to 23:59.