Mass answer editing of questions

From time to time it may be necessary to have a long list of items in a drop down list. This is grand for one or two, but we have often seen requests for hundreds of items. So to help make life a little easier, we have developed the mass editing system for answer values.

Location:

Main Menu > Database Management > Database - Question Management > Question - Answer Values - Mass Edit > Select the campaign > Select the List / Menu

The text box is filled with the raw data that is used to generate the contents of the list.

Each item in the list is separated by a semi-colon ;

Each value is separated by a comma ,

So an example colour item might be

Blue,field_0_1,field_0_1,Gorm,;

Breaking this down.

• Value 1 = The text display value (Blue)
• Value 2 = The HTML name of the field (field_0_1)
• Value 3 = The HTML id of the field (field_0_1)
• Value 4 = The data storage value of the item (Gorm)
• Value 5 = By default is this item always selected. If used the keyword selected will appear in the value. However this item is rarely filled in.

So if we have three colours in the list of red, green and blue. The data line would read.

Blue,field_0_1,field_0_1,Gorm,;Red,field_0_1,field_0_1,Dearg,;Green,field_0_1,field_0_1,Glas,;

If you have a long list you can prepare a spreadsheet to mass create all the items you require in a list.

The steps to do this.

1. Open Microsoft Excel to a new Excel document
2. Column A will contain the display values.
3. Column B should contain (,field_0_1,field_0_1,) without the parenthesis
4. Column C should contain the data values.
5. Column D should contain (,;) without the parenthesis

Very quickly you can create a lot of items.