Importing Responses

It is possible to import response options for questions and question tables, from Microsoft Word documents formatted in a variety of different layouts. A custom Word format can be specified and saved as a default import template for future questions.

Importing from Clipboard

  1. Select, and Copy, the responses from the Microsoft Word document or other text document.

6.5 - DatStat Illume Survey Manager - Using the Survey Designer - Working with Questions - Importing Responses 1

  1. On the Response Options tab of the Question Editor Click on the Import button and select Import From Clipboard.

6.5 - DatStat Illume Survey Manager - Using the Survey Designer - Working with Questions - Importing Responses 2

  1. The copied responses will be listed with automatically generated values starting with “1” unless a starting value is specifically set.

6.5 - DatStat Illume Survey Manager - Using the Survey Designer - Working with Questions - Importing Responses 3

  1. Select a response to edit the value or text if desired.

Importing from Clipboard Special

There may be times when responses in a MS Word document will not conform to the standard layout. The values may be on the right, the values may have specific numerical significance or other formatting differences.

  1. Select, and Copy, the responses from the Microsoft Word document or other text document.

6.5 - DatStat Illume Survey Manager - Using the Survey Designer - Working with Questions - Importing Responses 4

  1. On the Response Options tab of the Question Editor Click on the Import button and select Import From Clipboard Special.

6.5 - DatStat Illume Survey Manager - Using the Survey Designer - Working with Questions - Importing Responses 5

  1. The Import Response Options From Clipboard Editor window will open.

6.5 - DatStat Illume Survey Manager - Using the Survey Designer - Working with Questions - Importing Responses 6

  1. For the example in the graphic above, select Right from Value Position.
  1. The values will be replaced with the ones copied.
  1. Click Save as Default if there will be more responses imported with this format.
  1. Click Import to add.

6.5 - DatStat Illume Survey Manager - Using the Survey Designer - Working with Questions - Importing Responses 76.5 - DatStat Illume Survey Manager - Using the Survey Designer - Working with Questions - Importing Responses 8

Other Examples of Special Layouts

Likert/Top Response Type
DS_ImportClipboardSpecialLikertTop.gif

Likert/Bottom Response Type
DS_ImportClipboardSpecialLikertBottom.gif

Importing Response Options from another Question

There are two ways to import the responses from one question to another.

  • Import response options from one question to another question while preserving the corresponding logic.
  • Import response options and add show-if to each option only if the option is answered for the selected prior question.

Steps to Import from another Question

  1. While in the Response Options tab of the new question, click the Import Button and select Import From Question.

6.5 - DatStat Illume Survey Manager - Using the Survey Designer - Working with Questions - Importing Responses 9

  1. Select the Question to import from in the top pane.
  1. Select the Import Options.
  1. Click Import.

6.5 - DatStat Illume Survey Manager - Using the Survey Designer - Working with Questions - Importing Responses 10

Importing Responses

There are four different options that can be selected in combination when importing responses from another question within a survey:

  • Preserve response option Show-if: Option is selected by default – Will bring over all responses and the Show-if logic on those responses.  It does not bring any Headers from the earlier question.
  • Add Show-If to only show imported response if answered/unanswered for the selected question: Does not include Group Headers – Will put Show-If logic on each response to only show it if that response was checked in the earlier question.
  • Add Show-If from Selected Question: Will apply the Show-If logic that is used on the earlier question to each of the responses.
  • Include Group Headers (Show-If will not be applied to Group Headers): Option is selected by default – Will bring the Headers with the responses.  No logic will be applied to a Header.

When importing from a Check All That Apply question type, it is possible to check the Prefix for new checkbox variable names to ad a prefix to each of the responses in the second question.

Importing across Display Types

It is possible to import responses across Select One and Check All that Apply display types.

Check All that Apply to a Select One: All of the responses will come over with the logic option.  The Values will be set in a sequential order starting at 1.

Select One to a Check All that Apply: All or the responses will come over with the logic options. The names of the responses will be the Prefix with sequential numbering e.g. C1, C2, C3… – if C was the prefix set.