Difference between revisions of "Mass List Editing"
From All n One's bxp software Wixi
Philip Lacey (talk | contribs) (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 ...") |
Philip Lacey (talk | contribs) |
||
| Line 9: | Line 9: | ||
*Copy the column (Ctrl and C) | *Copy the column (Ctrl and C) | ||
*Don’t worry about spaces, commas or anything else. Leading and trailing spaces will also be removed. | *Don’t worry about spaces, commas or anything else. Leading and trailing spaces will also be removed. | ||
| + | |||
[[File:pic1.png]] | [[File:pic1.png]] | ||
| + | |||
Step 2: Load the list into BE | Step 2: Load the list into BE | ||
| Line 21: | Line 23: | ||
*Delete the entire contents of the Answer Value Data box. | *Delete the entire contents of the Answer Value Data box. | ||
*Paste in your new items (Ctrl and V). It should look something like this | *Paste in your new items (Ctrl and V). It should look something like this | ||
| + | |||
[[File:pic2.png]] | [[File:pic2.png]] | ||
| + | |||
Step 3: Test | Step 3: Test | ||
*Test the load has worked by logging a record in the campaign and checking the contents of the drop down list. | *Test the load has worked by logging a record in the campaign and checking the contents of the drop down list. | ||
| + | |||
[[File:pic3.png]] | [[File:pic3.png]] | ||
Revision as of 11:07, 30 November 2012
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.
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
Step 3: Test
- Test the load has worked by logging a record in the campaign and checking the contents of the drop down list.
