You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Data Import - "Error Running Query"

Received Response
20
Views
3
Comments
edited Nov 6, 2015 2:48PM in System Admin and Configuration 3 comments

Content

Hi all,

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!