CSV Import References

Additional hints to help you analyze your CSV Import

Based on your CSV file, users and groups in your app, different types of exceptions can happen when performing a CSV Import.

All warnings and errors will be gathered and stated in the response after running an import with dry=true on the /users/import/csv/update endpoint.

Errors

The following cases will lead to the CSV import being stopped or denied.

CodeNotes & Examples
CSV_INVALID_CSV_DATAInvalid CSV file, e.g. unable to parse cells or rows of the file.
CSV_MISSING_EXTERNAL
_ID_MAPPING
The mapping of the import does not contain the required user identifier externalID.
CSV_STATE_IMPORT_IS_COMPLETEDCSV Import is already completed.
CSV_STATE_IMPORT_IS_RUNNINGCSV Import is already running.
CSV_STATE_WRONG_IMPORT_OWNERToken used in import step does not match token used in previous request.
CSV_UNABLE_TO_ASSIGN
_MAPPING_TWICE
Inconsistent mapping, a value has occurred more than once.
CSV_UPLOAD_INVALID_IMPORT_TAGThe partial import tag namespace does not begin with csv_import.
CSV_UPLOAD_NO_DATAEmpty CSV file.
CSV_UPLOAD_TOO_BIGCSV file is too big. Full error message does contain the maximum allowed file size.

Warnings

The following cases will lead to warnings, however the faulty CSV rows will just be skipped and the import continues.

CodeNotes & Examples
CSV_ACCESS_CODE_TOO_LONGThe given access code exceeds the maximum length. Full error message does contain the maximum allowed length.
CSV_DUPLICATE_EXTERNAL_IDDuplicate externalID. CSV row will be ignored.
CSV_EMAIL_INVITE_FAILEDUnable to invite user by email. Generating a one time code instead.
CSV_GROUP_NO_ACCESSUser has no access to group with given ID.
CSV_GROUP_NOT_FOUNDGroup with specified ID does not exist.
CSV_INVALID_COL_MAPPINGInvalid column mapping, e.g. a profile field inside the CSV file does not exist in your app.
CSV_INVALID_EMAILUser has an invalid email address.
CSV_INVALID_EXPIRY_DATE
  • Can't set an expiry date for a non existing recovery code on user.
  • Expiry date is not a valid timestamp or ISO 8601 date.
  • The recovery code for user will be invalid as the expiry date is in the past.
CSV_MISSING_EXTERNAL_IDCSV row will be skipped, because of the missing identifier externalID value.
CSV_SKIP_CURRENT_USERCSV Import will skip current user. This can happen for deactivation or deletion.
CSV_SKIP_USERS_WITHOUT
_EXTERNAL_ID
User will be ignored from deactivation, because of missing identifier externalID.
CSV_UNABLE_TO_ASSIGN_ACCESS
_CODE_DUPLICATE
Unable to assign access code to user because it's already assigned to another user.
CSV_UNABLE_TO_ASSIGN
_EMAIL_CONFLICT
Unable to assign email to user because it's already assigned to another user in the same branch.
CSV_UNABLE_TO_ASSIGN
_EMAIL_DUPLICATE
Unable to assign email to user because it's already assigned to another user.
CSV_UNABLE_TO_CHANGE
_PRIMARY_EMAIL
Unable to assign email to user because the user's current primary email address was not set by an admin.
CSV_UNABLE_TO_CREATE_USERUnable to create a specific user. Full error message does contain the cause.
CSV_UNABLE_TO_DELETE_USERUnable to delete a specific user. Full error message does contain the cause.
CSV_UNABLE_TO_UPDATE_USERUnable to invite, update or deactivate a specific user. Full error message does contain the cause.
CSV_UPLOAD_USERNAME
_CONFLICT
Unable to assign user name to user because it's already assigned to another user in the same branch.
CSV_UPLOAD_USERNAME
_DUPLICATE
Unable to assign user name to user because it's already used in this import file.