Difference between revisions of "Mass answer editing of questions"
From All n One's bxp software Wixi
Philip Lacey (talk | contribs) |
Philip Lacey (talk | contribs) |
||
| (5 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
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. | 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: | Location: | ||
| − | Main Menu > | + | Main Menu > Form Management > Form - Question Management > Question - Answer Values - Mass Edit > Select the campaign > Select the List / Menu |
| Line 11: | Line 9: | ||
| − | Each item in the list is separated by a semi-colon ; | + | * Each item in the list is separated by a semi-colon ; |
| − | Each value is separated by a comma , | + | * Each value is separated by a comma , |
| Line 19: | Line 17: | ||
So an example colour item might be | So an example colour item might be | ||
| − | Blue,field_0_1,field_0_1,Gorm,; | + | ''Blue,field_0_1,field_0_1,Gorm,;'' |
| Line 32: | Line 30: | ||
So if we have three colours in the list of red, green and blue. The data line would read. | 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,; | + | ''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. | 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 | + | The steps to do this: |
# Open Microsoft Excel to a new Excel document | # Open Microsoft Excel to a new Excel document | ||
| Line 44: | Line 42: | ||
# Column C should contain the data values. | # Column C should contain the data values. | ||
# Column D should contain (,;) without the parenthesis | # Column D should contain (,;) without the parenthesis | ||
| + | |||
Very quickly you can create a lot of items. | Very quickly you can create a lot of items. | ||
| − | With all this lovely data just copy and paste it in. | + | 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 A key. (Select All) | ||
* In Excel, ctrl and the C key. (Copy) | * In Excel, ctrl and the C key. (Copy) | ||
| Line 61: | Line 60: | ||
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. | 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. | ||
| − | + | ||
| + | |||
| + | [[Category:Module Specific:Form Management]] | ||
Latest revision as of 11:26, 6 October 2016
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 > Form Management > Form - 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:
- Open Microsoft Excel to a new Excel document
- Column A will contain the display values.
- Column B should contain (,field_0_1,field_0_1,) without the parenthesis
- 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)
- 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.
