Mass answer editing of questions - Revision history

Philip Lacey at 10:26, 6 October 2016

2016-10-06T10:26:15Z

Philip Lacey at 02:27, 22 March 2014

2014-03-22T02:27:21Z

Philip Lacey at 01:59, 22 March 2014

2014-03-22T01:59:31Z

Philip Lacey at 16:23, 28 March 2012

2012-03-28T16:23:10Z

Philip Lacey at 16:15, 28 March 2012

2012-03-28T16:15:02Z

Philip Lacey at 16:13, 28 March 2012

2012-03-28T16:13:39Z

Philip Lacey at 16:13, 28 March 2012

2012-03-28T16:13:05Z

Philip Lacey: Created page with "Category:Campaign 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 f..."

2012-03-28T15:58:10Z

Created page with "Category:Campaign 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 f..."

New page

[[Category:Campaign]]

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.

# 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.

← Older revision		Revision as of 10:26, 6 October 2016
Line 3:		Line 3:
	Location:		Location:

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

← Older revision		Revision as of 02:27, 22 March 2014
Line 1:		Line 1:
−	~~[[Category:Campaign]]~~
−
	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.

← Older revision		Revision as of 01:59, 22 March 2014
Line 64:		Line 64:

	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.		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]]

← Older revision		Revision as of 16:23, 28 March 2012
Line 11:		Line 11:


−	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 19: @@
 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 32: @@
 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,;''
@@ Line 48: / Line 48: @@
 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 C key.  (Copy)

@@ Line 37: / Line 37: @@
 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
@@ Line 44: / Line 44: @@
 # Column C should contain the data values.
 # Column D should contain (,;) without the parenthesis
 Very quickly you can create a lot of items.
@@ Line 61: / Line 62: @@
 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.

← Older revision		Revision as of 16:13, 28 March 2012
Line 46:		Line 46:

	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.
		+	* 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.