The error "bad value for restricted picklist..." typically means that you are trying to fill in a picklist field, that is set to only allow active predefined values, with a value that doesn't exist or is inactive. Here are some steps to take:
- The first step is always to clear Apsona's cache. Apsona is a browser based application and uses a browser cache to hold Apsona and Salesforce settings. Whenever you make changes in Salesforce (ie: new fields, objects, or user permissions) Apsona won't see them until the cache is cleared.
- Next, go to a record in Salesforce with that picklist field and open up the field to see if it contains the value that you are trying to add. If it is an inactive value, it will not be present.
- You can also look at the field in Salesforce Setup to see whether that value is shown, and whether that value is active or inactive.
- If the value is active, it may be that the value has not been made available to the specific record type set on the record you are trying to update. You can navigate to the Record Type page for that object, and look at the picklist to see if the value has been added.
- Dependent picklists can also throw an error during import of "bad value for restricted picklist" when the dependent picklist has a default value. The issue is that Apsona is trying to add the default value even if in SF the parent picklist would keep that default value from being populated. Example: Parent picklist has YES and NO as option and NO is default value. Child picklist has YES and NO as option and NO is default. If NO is selected for Parent, the child should be blank. If YES is chosen for parent then the child will default to NO but you can choose YES as well. Apsona throws an error during import even if the fields are not included in the import because Apsona is trying to put the default NO into the child picklist even though it should be blank because the parent is gettting the default NO which requires the child to be blank. The solution is to include the child picklist field in your import sheet but leave the value blank. Apsona will force in that null value instead of the default NO.