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.

With all this lovely data ready to go just copy and paste it in.
 * In Excel, ctrl and the A key. (Select All)
 * In Excel, ctrl and the C key. (Copy)
 * In BE, ctrl and the A key (Selects all current data).
 * In BE, the backspace key, to delete any data in there.
 * In BE, ctrl and the V key (Paste in all the data from Excel)

BE will intelligently remove all the added Excel tab characters and return characters.

IMPORTANT NOTE

BE at this stage CANNOT filter out your extra commas or semicolons. If you put in mistaken extra commas or semi colons, then your campaign will generate green hamsters. So please be careful with the data you enter.

Also, please please ensure that you change the field_0_1 everywhere to ensure it is the actual field ID, or you're going to get green hamsters.