I am trying to import targets from SugarCRM into a new install of SuiteCRM but am hitting errors on each attempt.
The first is that SuiteCRM thinks the IDs are more than 36 characters. But having counted them I can see that is not the case.
Secondly (if I discard the IDs) I get an error which states that the email addresses are invalid - which again they are not.
The data is a default CSV export from SugarCRM with commas for delimiters and quotes for qualifiers. I am wondering if the import is including the quotes as part of the field values which would explain these errors - but having checked the import settings where the data preview looks perfect I can’t see why that would be the case.
I tested it and didn’t find some problems. Can you load the csv file into anything program which works with tables. I am using OpenOffice for it usually.
Thanks. I added this code, ran another import and have pulled this from the logs:
Wed May 19 10:30:17 2021 [70022][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Wed May 19 10:30:18 2021 [70022][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Wed May 19 10:30:18 2021 [70022][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Wed May 19 10:31:15 2021 [70466][1][FATAL] Caught error: stat(): stat failed for upload/import/error_1.csv
Wed May 19 10:31:15 2021 [70466][1][FATAL] Caught error: touch(): UploadStream::stream_metadata is not implemented!
Wed May 19 10:31:17 2021 [70466][1][FATAL] Caught error: stat(): stat failed for upload/import/status_1.csv
Wed May 19 10:31:17 2021 [70466][1][FATAL] Caught error: touch(): UploadStream::stream_metadata is not implemented!
Wed May 19 10:31:33 2021 [70597][1][FATAL] Prospect beforeImportSave this->id:
Wed May 19 10:31:33 2021 [70597][1][FATAL] Prospect beforeImportSave this->email1:
Wed May 19 10:31:33 2021 [70597][1][FATAL] Prospect beforeImportSave this->id: Bandar32Menjalara
Wed May 19 10:31:33 2021 [70597][1][FATAL] Prospect beforeImportSave this->email1:
Your csv file has 2 records? The data doesn’t read correctly. Look at id - Bandar32Menjalara. Is this id really or the data from other column?
As variants:
No. Only 2 are being imported. There are 1360 records.
Looking for “Bandar32Menjalara” I found “Bandar Menjalara” in the address field. I’ll remove this record and try again as that may be throwing the whole process.
Removing that record allowed all but 50 records to be imported. Thanks!
I will continue using the debugging script provided to fix these.
I also notice there is no way to import Target Lists - which would be ideal as the Targets were organised across a range of lists in SugarCRM.
I have a full SQL export from my old system. Can I extract the relevant tables and replace them in the database using SQL commands? Or are the table structures for Target Lists different in Suite CRM?