Anonymous, bureaucrat, administrator
7,528
edits
Changes
From All n One's bxp software Wixi
no edit summary
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 Form Management > Database Form - Question Management > Question - Answer Values - Mass Edit > Select the campaign > Select the List / Menu
* 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,;''
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.:
# Open Microsoft Excel to a new Excel document
# Column C should contain the data values.
# 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)
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.
