Importing CSV w/ numerical values into a FIELD with ENUM values-in this case Revenue

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • LeadBurner
    Junior Member
    • Mar 2021
    • 3

    Importing CSV w/ numerical values into a FIELD with ENUM values-in this case Revenue

    When I import contacts some of them have information like "Monthly Revenue" , for this the options I want are 0-5000,5000-10000,etc etc and I have this field defined as Revenue (ENUM) with drop downs. which works manually when making calls but when I import it I am running into problems:

    Many wont import the revenue, some will but they wont be in the options I created for the drop down. 23000 is 23000 when I look at list or detail , not 20000-30000.

    Is there a way to make it automatically either understand or prompt me for the correct Fields if it can't figure it out?
Working...