Multi select import

[madhrishi]

Hi All,
I need to import a multi select field. I have an excel sheet saved as comma separated file. It works if i give only one value for the multiselect field. But how to input data in excel to give more than one value for the same field?

I get the following error on import.

NOTICE: [8] Undefined index: LBL_ERROR_INVALID_MULTIENUM on line 329 in file D:\Sugar\htdocs\sugarcrm\modules\Import\views\view .step4.php

In the excel sheet i have something like this... the second column is multiselect.

B Corporate,Business Defence/Government Legal

Thanks,
Madhu

[andopes]

Hi Madhu

You need to set the multi select options into import file this way:

option1^,^option2^,^option3

Using the options keys (which is stored into database) instead of their values (which is displayed).

Cheers

[madhrishi]

I did that ... still i am getting errors... attached are the screen shots for the same ... pls help...

Thanks,
Madhu

[madhrishi]

any one pls ? I just need to know how to import multiselect fields ?

[ecrypt]

Hi Madhu,

Just try disable the Notice error in your php.ini, if its works then we can simply do the debugging,

Feel free to contact me for further discussions ecrypt@gmail.com

Best
Sen

[madhrishi]

Hi Sen,
php.ini already has this line

error_reporting = E_ALL & ~E_NOTICE

Which means notice errors are disabled, i think. I have attached the error screen shots in the previous message. Dont they give an idea about is going wrong? I am pretty sure its something to do with the
input file.

Thanks,
Madhu

[kodikarthi]

Hi Madhu,
the same problem i am facing. I did not get the solutions. If u get the answer please post your answer else mail me.

Karthikeyan Thirugnanasambandam
karthikeyan.t@insoft.com
kodikarthi@gmail.com

[crmsiva]

Check this thread. This solution only applies to 5.0.* versions

[madhrishi]

but i am using Version 5.2.0a only. Still i am not able to import multiselect fields from excel. Is there a document explaining how to import multiselect fields? I am sure this is something to do with the way i input data in excel.... i have already attached screen shots... anyone?

[kuske]

It is very simple,
you can see it on the screen where the 1st line is displayed.

You must not user a csv separator "," (Comma) if you use multiselect fields if you do not use field qualifying Quotes.

So your input.csv-file should look like
"name","sel1^,^sel2",...
and not like
name,sel1^,^sel2,...