Data Import - "Error Running Query"
We were importing Organisations into the system using the Data Import Wizard, and a source CSV file.
When pre-scanning the file an error "Error Running Query" (see attached) displays and forces the abortion of data import.
After breaking down thousands of records we came to find that this was caused by a record which had Organisation Name = "NATIONAL UNION OF METALWORKERS OF SOUTH AFRICA" (all other fields/columns in the CSV were fine).
So we have tried various combinations to find the following:
- "NATIONAL UNION OF METALWORKERS OF SOUTH AFRICA" failed
- "National Union Of Metalworkers Of South Africa", was imported