When am trying to update contacts using Dataloader then multiselect picklist values for existing records gets overridden.I want values to be added to current multiselect picklist without overriding values with what I have on the existing record.Is there a way to do this?

  • 3
    I believe the only option here is to pull the data and merge picklist values – o-lexi Nov 9 '17 at 18:04

You need to create 2 set of csv where the first csv contain those contacts where you want to override picklist values.

And in second csv if the picklist column is still there in the csv file, you will not map this column during update.

Salesforce dataloader doesn't have a provision to decide dynamically which values to be overridden. It just updates ALL values which are getting mapped.

| improve this answer | |
  • Then how do we update new picklist values to existing records. – sfdc Nov 9 '17 at 16:02
  • In the first csv where you want to update picklist. basically if you map the csv column with salesforce fields then during loading it updates the values. – Santanu Boral Nov 9 '17 at 16:34
  • exported data with Id column aad picklist values column

  • Edit exported file and add new value to existing value separated by semicolumn (;)

  • Uploaded edited file back using data loader

| improve this answer | |

As @santanu clearly pointed out, the practical way would be to first get the export of the picklist column alongwith ID column (retrieve the picklist defined in global values set in salesforce). Then create a second CSV file and copy all the picklist coulmns to that file, add the existing values, separated by semi colon and do update operation via data loader. It'll update both the old & new values altogether.

The first exported file, you can use it as a reference for comparison.

| improve this answer | |
  • I've downvoted this answer because I don't think it adds anything beyond what the existing answers cover. If you gain a bit more reputation, you'll be able to upvote questions and answers (and this seems closer to an upvote than an answer in and of itself). – Derek F Jul 17 at 20:46

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.