Importing data into multiselect field

[jendove]

I'm testing some basic data importing (CSV file) and have only had one issue I can't seem to resolve. I have created a multi-select custom field and wanted to import into that field using the Import Account feature.

When I map to that field, I don't get an error after import, but I end up with a successful import with that multi-select field empty (all other fields imported fine). I've tried testing this import mapping with a single value into the multi-select field and multiple values (spaces separating them), same results. I've tried putting values into that field that don't exist in the multi-select list and I still end up with a successful import and no data imported into that field.

I tested changing that field back to a basic dropdown list and the mapping worked correct.

Is there some sort of special way multi-select data needs to be represented in a CSV file in order to be imported correctly using Import Accounts? Or is it the case where you cannot import into a multi-select field?

Thanks so much,
JD

[eitrix]

input matches your fields exactly? think you need match the key case sensitive. Please post what was problem in end

[animuscrm]

Same problem here with Sugarcrm 6.0.3
When importing ACCOUNTs, everytings is imported fine except a multiselect field.
I have tried several times, without success.
I always get a blank in this multiselect field.
Any idea?

[jendove]

I discoverd after a very frustrating few days of random attempts that the problem was two fold, they really should add this to their documentation:

1) make sure all spacing and upper/lower case matches the field name exactly (note, not the displayed value, it must match the hidden value of the pair)
2) There CANNOT be a space before or after each comma separator in your CSV file, for example:
"one, two" will load empty
"one,two" will load two values into the multiselect field

Hope this helps!

[animuscrm]

great advice! it works :-)
David

[lijith]

Hello,

How can I import multiple email addresses to Accounts. I am using Sugar Pro 6 version.