What this feature is, why you should use it and when
Step by step implementation of this feature
This section explains what the "Upload Responses" is and why you should use it
What: This advanced feature allows you to upload responses in your survey.
Why: This advanced feature is used for creating respondents automatically. This is often used to make data entry quick when adding the responses of those who took paper surveys to the results of those who took electronic surveys.
We are about to show you step by step how to implement this feature
To use this feature follow the steps bellow:
- Design your survey.
- Create a CSV ('comma separated values' format) Data File in accordance with your survey.
- Write an email body text on the "Email Survey" page and click [Back].
- Click [Go] next to the 'Upload responses' on the 'Launch Survey' page.
- Select the []'Send email to respondent' check box if your CSV data file contains email addresses and you wish to send emails.
- Specify the column number of the 'email address' field in the CSV file (if it exists).
- Specify the column number of the 'profile code' field for Teacher/Student surveys.
- Click [Browse] to open the CSV data file saved locally on your computer.
- Click [Import] to import respondent data in your survey.
- Only commas, semicolons and tabs can serve as delimiters.
- If you use one of the above delimiters in a text field you should enclose it in double quotes (for example, "1 part, 2 part";3 part). To use double quotes in a text field you should double them up (for example, """1 part, 2 part"""). (would appear as "1 part, 2 part").
- Responses to the "Pick one or 'other'" and "Dropdown box" questions are indicated in one field (answer number or answer text). Note that if your answer choices contain numeric texts you should specify the text of the selected answer but not its order number. The selected 'other' answer choice is indicated as a text field and unselected one as an empty field.
- Responses to the "Check All" and "List Box" questions are specified as 0 or 1 (0 - unselected answer, 1 - selected answer) according to the quantity of the answer choices. The selected 'other' answer choice is indicated as a text field and unselected one as an empty field.
- Responses to the "Rate Different Items Along the Scale of Your Choice" question are specified as figures (from 1 to 12, and 0 if no radio button was selected to an answer) corresponding to the number of scale columns, starting from the first answer to the last one in order top-down.
- Responses to the "Compare One Against Another" question are specified as numeric values (one field for each answer choice that is compared) corresponding to the quantity how much this answer choice was selected.
- Responses to the "Single Line Text with Pre-Format Option" and "Multi Line Text Response" are specified as text answers (one field for each text answer).
- Responses to the "Numeric Allocation" are specified as
numeric values (one field for each numeric value,
and additional field for total). The total field is always updated
with the sum of the values of other fields.
Note: if you use "Calculate total sum" option for this type of question make sure that total number of the uploaded data fits into the indicated range, otherwise responses will not be uploaded.
Note that if your survey includes "3D Matrix" you should specify as many empty fields in the csv data file as there are products, features or services listed in the question.
Let's take a look at the example:
Your CSV Data file should look as follows:
John Nelson;nelson@aol.com;25-35;1;0;0;1;United States of America;Married;0;0;1;3;4;5;7;1;1;0;2; ; ; ;8;1;2;2;3;16
Note
- The field 'Comment' of 'Pick One with Comment' question type cannot be imported.
- If your CSV file for dependent survey (Student survey) contains profile codes that do not match the profile codes of the corresponding profile survey (Teacher survey) you will not be able to import these records.
- If there are no profile codes in your CSV file for profile survey (Teacher survey) or the column number has not been indicated new profile codes will be generated and this data file will be imported.
- Use the [Fxxx] tag to insert additional information in your email body text or subject from the import field of your Data File (where xxx is the field number starting from '1'). In the example above [F1] refers to John Nelson. If you use [F4] your respondent will get only number '1' in the email although it corresponds to the text answer 'Hotdog'. Note that you should refer to the fields containing texts but not numbers.
- Use the [ProfileCode] tag to insert a profile code value in your email body text or subject from the import field of your Data File.
- [Back] Takes you back to the 'Home' page.
Tip: Changing Submit Date using the 'Upload Responses' feature.
There is a workaround to change 'Submit Date' in 'View by Respondent' mode using the 'Upload responses' feature along with special HTML tag. To do that you should do the following:
- Create in the survey new question of 'Single Line' or 'Multi Line' type asking about the date of submit.
- Put <submit_time format="yyyy-MM-dd hh:mm"/> tag into answer option field and save your question.
- Create the CSV Data File in accordance with the survey and upload responses. Thus, the 'Submit date' at the top of the 'View by Respondent' page will be changed to the date indicated in the CSV.
Note:
- The 'Upload Responses' feature should be activated;
- You can set the date format in the way you want (e.g dd-MM-yyyy, yyyy-MM-dd, yyyy/MM/dd, yyyy-MM-dd hh:mm etc);
- Please pay attention that MM in format is for months and mm is for minutes;
- Make sure that the date format in the CSV file is the same as in the HTML tag you put.