Hi there,

I am trying to do my first SugarCRM import and while new to Sugar, I have lots of CRM experience... which is why I suspect that I am doing sometime silly to produce this result:

It seems that any of the values in the field that have spaces get an extra space upon import. But even so, Cancelled seems to be a match for allowed values and still comes up with an error.

Any thoughts?

"Value not in dropDown list. Allowed values are: Life Member,Cirlce Member,Non Take Up,Cancelled,Non-Member","LBL_XLSTATUS (xlstatus_c)","Circle Member",1
"Value not in dropDown list. Allowed values are: Life Member,Cirlce Member,Non Take Up,Cancelled,Non-Member","LBL_XLSTATUS (xlstatus_c)","Non Take Up",2
"Value not in dropDown list. Allowed values are: Life Member,Cirlce Member,Non Take Up,Cancelled,Non-Member","LBL_XLSTATUS (xlstatus_c)",Cancelled,3
"Value not in dropDown list. Allowed values are: Life Member,Cirlce Member,Non Take Up,Cancelled,Non-Member","LBL_XLSTATUS (xlstatus_c)","Life Member",4
"Value not in dropDown list. Allowed values are: Life Member,Cirlce Member,Non Take Up,Cancelled,Non-Member","LBL_XLSTATUS (xlstatus_c)","Life Member",5
"Value not in dropDown list. Allowed values are: Life Member,Cirlce Member,Non Take Up,Cancelled,Non-Member","LBL_XLSTATUS (xlstatus_c)","Life Member",6