Anonymous, bureaucrat, administrator
7,528
edits
Changes
From All n One's bxp software Wixi
Created page with "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 ..."
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]]
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]]
