Below are possible errors that can occur during the staging step of an import job. The errors are grouped by type and sorted by frequency of occurrence.
Error messages can appear in any of the import stages (Stage, Validate or Import). A single record row in the import file may also be referenced by multiple errors. Make sure to check the log before moving to the next step. Details about Import and Validation error messages can be found in the following articles:
TABLE OF CONTENTS |
Formatting Issues
| Error Message | Description & Resolution |
| For field <FIELD NAME>, defined as <MAPPING>: EL1001E: Type conversion problem, cannot convert from null to boolean. In CSV for <CSV file> for row <number>. | Trying to convert NULL to Boolean type. Resolution: The field name referenced in the error is empty and requires a value. Normally this will occur with required fields and may be accompanied by other error messages for the same row. To resolve, ensure all required fields are satisfied and try the import again |
| Type conversion problem | Trying to convert value to an inappropriate data type, e.g. converting a string to boolean. Resolution: The field name referenced in the error has data in it but the data is in the wrong format for importing. Normally this will occur with required fields and may be accompanied by other error messages for the same row. To resolve, ensure all required fields are in the correct format and try the import again |
Setup and Access Related Issues
| Error Message | Description & Resolution |
| API key is not set | Please contact ACME support to set up the API key that allows for import/export. This error is triggered if impex has trouble authenticating with Acme. Resolution: The importer is not completely set up. Please refer to the getting started guide and steps to set up the importer before trying again. |
| You do not have permissions to perform that operation | User needs to have TENANT_ADMINISTRATION_VIEW permission to do the timezone conversion. This error gets triggered if impex is able to authenticate with Acme, but doesn't have the correct permission to do some operation. Resolution: The user's access to the importer is not completely set up. Please refer to the getting started guide and steps to set up the importer before trying again. |
Related: Import Error Messages - Validation Step; Import Error Messages - Import Step