Details about this thread
  • State Verified Answer
  • Replies 5 replies
  • Subscribers 293 subscribers
  • Views 917 views
  • Users 0 members are here
Related content from around SugarClub

Import Leads does not work with dropdown field values, only labels (keys)

Ishani Vardhan

We are on SugarCRM Sell Advanced v12.3.0

I have only recently discovered that when using "Import" function to import new Leads into the system, it throws error at Dropdown fields saying it needs the labels (key) rather than the value that the CSV file has.

If I'm importing 300+ records, its a massive time consuming job to change each of those fields from "Value" to its corresponding "Label".

Has anyone come across this issue and is there a setting that can be changed to allow Import process to use "values" for dropdown fields?

Many thanks in advance

Parents Reply Children
  • 0 in reply to Andre Serrazina

    Thanks for your response  !  For me, the key doesn't work.

    I had just 1 record for testing import with the key or the bold part from above screenshot in the field. However, the import process throws error like the below for all dropdown fields.

    "Value not in dropDown list. Allowed values are:Submitted,Withdrawn,Pending,Not Completed,New Expression of Interest Administration Status (administration_status_c) administration_status_c"

    This means, I'd have to heavily edit my CSV to change all keys to label values which would be an extremely tedious job when its hundreds of records to import.

    Is there a setting I'm missing?