Importing Survey data can be used when dealing with a large number of questions or from an existing library.
The following Survey elements are supported for import:
- Choice Option Set (see below)
- Question Category
- Question Library
Importing a Choice Option Set
- If necessary, first create a new Choice Option Set
- Administration → Survey → Choice Options → New button
- Prepare a spreadsheet with the data
- One column called "Name"
- One column called "Order"
- One column called "Value"
- One row for each option to be imported. Note that there are no resource keys presently defined on survey choice options, so take care not to create duplicates.
- Select Import Spreadsheet to start a new import
- Wizard page 1:
- Upload the file created in step 2
- Wizard page 2:
- On the "Select Object" screen, leave the import type as Objects
- Open the object picker
- In the analyser, set "Advanced objects" to Yes, and apply.
- Select the row named "Choice Option"
- Wizard page 3:
- On the "Select Columns" screen, the Name, Order and Value columns should map automatically. If not, map them as usual.
- Click on the "Fixed Value" link in the top-right corner.
- When the window opens, change the "Fixed Value" setting to the name of the Choice Option Set that you want to import into (e.g. the one created in step 1), and press OK
- Observe there is a new mapping row.
- Set the "Object Field" drop down for the new row to "Choice Option Set"
- Proceed with remainder of import as normal.