function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Rick MacGuiganRick MacGuigan 

Importing picklist value from Data Wizard

I am not able to import records due to a failed import of a text value into a (target) picklist field when using the Data Wizard. Getting this error:

Error received from salesforce.com.  Fields [Vehicle_Make__c].  Status code [INVALID_OR_NULL_FOR_RESTRICTED_PICKLIST].  Message [bad value for restricted picklist field: Opel].

I verified and even reformatted the source column for Vehicle Make as text. Still getting error. Seems to only be failing on 4 records that prevent the entire source to be imported. 

Aby ideas ? 
Deepak GulianDeepak Gulian
You need to make sure the value of 4 records should be same as those value which you defined for picklist.
For example in below screenshot:- Group is a picklist field and having 4 values One, Two, Three, Four. So while importing the data you need to make sure that all records should contain only one of those 4 values only.
User-added image
BRTRAJBRTRAJ
If the source data was imported from a different source, spaces can create problem. Copy the source column values (all records preferably) into a new excel, and use 'remove duplicates' option on the column. If the same value is still appearing more than once, there could be spaces involved which you should address before importing. Following is an example scenario where the problem is not directly visible, but the system detected it. 

User-added image