Import multiselect error

[Amadeus7]

When importing multiselect field empty value, we get error in sugar ce 5.1 and 5.2. This is a bug.

NOTICE: [8] Array to string conversion on line 329 in file \modules\Import\ImportFieldSanitize.php
NOTICE: [8] Undefined index: LBL_ERROR_INVALID_MULTIENUM on line 328 in file \modules\Import\views\view.step4.php
NOTICE: [8] Array to string conversion on line 227 in file \modules\Import\ImportFile.php

[maus]

same problem here

[roblaus]

Did you guys report the bug? Or at least check whether there is already a bug report? I think this is important.

[Amadeus7]

Well we have checked it is a bug reported. No official fix so far 5.2.

[lionel.ibis]

I had the same problem. It seems that an empty value in a multi selection field produce an array with one null value instead of a simple empty value.
I solved the proble by modifying modules/import/view/view.step4.php. I changed
this (around line 297):
// If the field is empty then there is no need to check the data
if( !empty($rowValue) ) {
to :
if (is_array($rowValue) && count($rowValue) == 1 && trim($rowValue[0]) == '') $rowValue = '';
// If the field is empty then there is no need to check the data
if( !empty($rowValue) ) {
(I've added the first line)

[Amadeus7]

That is a solution!


case 'multienum':
if ( $rowValue[0] != "" )
{
$fieldDef['type']='enum';
$returnValue = $ifs->multienum($rowValue,$fieldDef);
if ( !$returnValue )
{
$importFile->writeError(
$mod_strings['LBL_ERROR_NOT_IN_ENUM']
. implode(",",$app_list_strings[$fieldDef['options']]),
$fieldTranslated,
$rowValue);
$do_save = 0;
}
else
$rowValue = $returnValue;
}
else
$rowValue="";
break;