+ Start a Discussion
MVJMVJ 

Updating a Multi-Selct pick list with the Data Loader

I have a multi-select pick list that tracks when a customer has responded to a survey.  The values available to be selected are:

 

2008 Mid Year

2008 Full Year

2009 Mid Year

2009 Full Year

 

Currently a customer has the 2008 Full Year selected.

 

The customer just tok the 2009 Mid Year.

 

When I use the data loader to update the field I load the following CSV file

 

ID, Survey

"001xxxxxxxxxxxx","2009 Mid Year"

 

When I run the dataloader it does the updae but i do not get the expected result.

 

What happens is that the Survey field now has "2009 Mid Year".

 

I want the field to read "2008 Full Year; 2009 Mid Year"

 

Can this be done with our having to setup the CSV as follows:

ID, Survey

"001xxxxxxxxxxxx","2008 Full Year;2009 Mid Year"

 

 

Thanks in advance.

 

Richie DRichie D

MVJ,

 

What you can do is create a trigger which runs upon update which concatenates the survey values. You would need to be careful to check that the value has changed and filter out any duplicate values.

 

It should be reasonably easy to do I'd have thought.

 

Rich.