Default export allows you to export all the survey answers data along with certain system data and metadata provided during import file upload.
If several import files were provided with different metadata columns in each of them the resulting file will contain all the columns from all import files.
The following two example import files were manually imported to the WEB channel of a demo survey which contained several questions:
First import file
Second import file
The columns were associated in the following way:
|CID||Used as a CUSTOMER_ID column|
|ADDR||Used as an ADDRESS column|
|LANG||Used as a LANGUAGE column|
Questionnaires were created and answered. In this case "Question text" was used for export columns in the exporter settings. Here's a resulting default export from that survey:
|Survey Id||Questionnaire Id||Creation||Start Time||End Time||State||Customer EXTERNAL_ID||Address||Language||CUSTOMER_ID||LANG||CID||METADATA2||ADDR||METADATA1||Thank you for taking your time to complete our survey. Please click "Next" to continue.||Please rate your experience (1-10)||Please answer: Yes/No/Other||Any other thoughts?|
|68||508177||2016-09-28 12:12:06||2016-09-28 12:14:29||2016-09-28 12:15:34||Completed||DEMO1email@example.com||EN||DEMO1||EN||DEMO1||Salesfirstname.lastname@example.org||Germany||8||No||Open text answer|
|68||508178||2016-09-28 12:12:06||2016-09-28 12:14:30||2016-09-28 12:16:36||Completed||DEMO2email@example.com||EN||DEMO2||EN||DEMO2firstname.lastname@example.org||France||7||Other(Open text in configurable question answer)||Another answer|
|Survey Id||Survey Channel ID||System column|
|Questionnaire Id||A unique identifier of an individual questionnaire||System column|
|Creation||Timestamp of the event when questionnaire became Created||System column|
|Start Time||Timestamp of the event when questionnaire became Started||System column|
Timestamp of the event when questionnaire became:
|State||Questionnaire state at the moment of export||System column|
|Customer EXTERNAL_ID||Customer ID||System column|
|Address||Customer address||System column|
|Language||Questionnaire language||System column|
|CUSTOMER_ID||Alias for Customer ID column. Only shown if Customer ID column name used in at least one import file is different from
|LANG||Original name of questionnaire language column in the import file||Metadata column|
|CID||Original name of Customer ID column in the import file||Metadata column|
|METADATA2||Metadata column from second import file||Metadata column|
|ADDR||Original name of customer address column in the import file||Metadata column|
|METADATA1||Metadata column from first import file||Metadata column|
|Thank you for taking your time to complete our survey. Please click "Next" to continue.||
Question text of the first question in the questionnaire
This is a delimiter question in the demo survey and columns with this type of question are always empty in export files.
|Please rate your experience
Question text of the second question in the questionnaire
This is a scalable question with a scale from 1 to 10.
Question text of the third question in the questionnaire
This is a configurable question with the following answers:
The open portion of the answer is shown in parentheses.
|Any other thoughts?||
Question text of the fourth question in the questionnaire
This is an open question.
Please note: Order of columns is not guaranteed for Default exporter. Please use custom exporter in case you want a guaranteed order of columns in the resulting file.
Please sign in to leave a comment.