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

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
  • 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?

Children