Difference between revisions of "Mass List Editing"

Revision as of 02:59, 22 March 2014

Mass list editing

There is now a quick way of updating drop down lists within a BE campaign.

Step 1: Create your list

• Create your list in Excel. Don’t forget to sort it.
• Select the column you want to add into BE.
• Copy the column (Ctrl and C)
• Don’t worry about spaces, commas or anything else. Leading and trailing spaces will also be removed.

File:pic1.png

Step 2: Load the list into BE

• Log into BE
• Main Menu > Database Management > Database - Question Management > Question – Answer Values – Mass Edit
• Choose the campaign with the List to update
• Choose the list / checkbox / radio question to update
• From the “Processing Type” drop down list choose Excel
• Delete the entire contents of the Answer Value Data box.
• Paste in your new items (Ctrl and V). It should look something like this

File:pic2.png

Step 3: Test

• Test the load has worked by logging a record in the campaign and checking the contents of the drop down list.

File:pic3.png