Importing accounts from a csv file generates the following error => "Array to string conversion on line 159 in file"

💬 General Discussion
1

Hello. I’m getting the error shown on the attached file when I run the importer to import accounts from a csv file. The importer still imports the records (at least, most of them).

The error message is:

NOTICE: [8] Array to string conversion on line 159 in file.
/opt/bitnami/apps/suitecrm/htdocs/modules/AOD_Index/AOD_Index.php

NOTICE: [8] Undefined property:
Account::$Array on line 159 in file

2

Hi there,

What version of SuiteCRM are you running?

Thanks,

Will.

3

Try and import your csv file into Excel (or OpenOffice Calc). File should import with data cells in the relevant column and not missing anything. Same as original source file (if any).

If the data is in under the wrong columns, or split up, mangled, etc., then there’s something wrong in the csv file., for example the commas in the cell data can get interpreted incorrectly by the importer as field separators. To counteract this, you need to tick the option for the CSV exporter to surround the cells with quote marks…

4

Hi Will … Sorry about the tardy reply. Version 7.1.4 // Sugar Version 6.5.18 (Build 1110)

5

Dear,

did you get a solution for this issue?
I run into the same problem.

6

Found a work around.
The import generates Notices, not errors.

to solve it just
Open your php.ini file, find the line;
error_reporting = E_ALL & ~E_DEPRECATED

Replace it with;
error_reporting = E_ALL & ~E_NOTICE & ~E_DEPRECATED

7

Fixed the issue. Thanks. :whistle: