|
You can upload responses from your side and create respondents automatically. This is commonly 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.
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 if necessary and click Back.
- Click the Go button next to the 'Upload responses' on the 'Launch Survey' page.
- Select the 'Send email to respondent' option if your CSV data file contains email addresses and you want to send emails to these addresses.
- Specify the column number of the field in the CSV file where email addresses reside (if this field exists).
- Specify the column number of the 'profile code' field for Teacher/Student surveys.
- Click Browse to locate the CSV data file saved locally on your computer.
- Click the Import to import respondent data in your survey. You will be notified with a pop-up message if the data was uploaded successfully.
Data File Format:
- 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). If one of the fields should be empty, import 0 instead of the blank field. 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.
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:
- 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 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.
|