Export Data
You use Export Data to export interview data for analysis using products such as UNICOM Intelligence Reporter or IBM SPSS Statistics. The files that Export Data creates are written to a zip file in your user folder. The filename is InterviewExporter.ProjectName.DataType.DateTime.zip; for example, InterviewExporter.test.csv.20061120.1600.zip for a delimited text file for the test project, exported at 4pm on 20 November 2006.
You can export data in the following formats:
▪delimited text file (CSV)
▪UNICOM Intelligence data file (supports hierarchical data)
▪Quantum data file (DAT)
▪SAS system file
▪IBM SPSS Statistics file (SAV)
▪Triple-S data file (fixed or CSV)
▪UNICOM Intelligence XML data file (supports hierarchical data).
You can calculate and then generate two extra data columns that contain the start and finish times for each case. The start and finish times are based on the selected time zone of your choosing.
You can also include only records that relate to a specific filter condition (such as time period or survey status). Export Data provides several filters that you can change to your requirements. You can also create your own filters, or delete filters that are no longer needed.
If you are exporting in delimited text format and the data contains categorical data, you can choose between exporting category (response) names or values (codes).
You can export the following types of data:
▪respondent data only (that is, data from live interviews)
▪test data only
▪both respondent and test data.
and can include all system variables, only common system variables, or no system variables at all. You can also choose which types of data variables to export; for example, categorical and numeric variables but not text, boolean, or date variables.
You can export data with any combination of the following interview statuses:
▪Completed successfully
▪Active/in progress
▪Timed out
▪Stopped by the script
▪Stopped by the respondent
▪Interview system shutdown
▪Terminated by a signal from the questionnaire script
▪Reviewed
Finally, you can choose to export data gathered before or after a specific date/time, or select a date/time range.
An advanced option is available for users who want more control over the export process.
Export Data does not normally export dirty data but can be configured to do so. Speak to your UNICOM Intelligence Interviewer administrator if you need to export dirty data.
See also