(Legacy) CSV Import References

Additional hints to help you analyze your (Legacy) CSV Imports.

Employee App
Staffbase Intranet

Based on your 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.

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

Code Notes & Examples
CSV_INVALID_CSV_DATA Invalid 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_COMPLETED CSV Import is already completed.
CSV_STATE_IMPORT_IS_RUNNING CSV Import is already running.
CSV_STATE_WRONG_IMPORT_OWNER Token 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_TAG The partial import tag namespace does not begin with csv_import.
CSV_UPLOAD_NO_DATA Empty CSV file.
CSV_UPLOAD_TOO_BIG CSV file is too big. Full error message does contain the maximum allowed file size.

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

Code Notes & Examples
CSV_ACCESS_CODE_TOO_LONG The given access code exceeds the maximum length. Full error message does contain the maximum allowed length.
CSV_DUPLICATE_EXTERNAL_ID Duplicate externalID. CSV row will be ignored.
CSV_EMAIL_INVITE_FAILED Unable to invite user by email. Generating a one time code instead.
CSV_GROUP_NO_ACCESS User has no access to group with given ID.
CSV_GROUP_NOT_FOUND Group with specified ID does not exist.
CSV_INVALID_COL_MAPPING Invalid column mapping, e.g. a profile field inside the CSV file does not exist in your app.
CSV_INVALID_EMAIL User 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_ID CSV row will be skipped, because of the missing identifier externalID value.
CSV_SKIP_CURRENT_USER CSV 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_USER Unable to create a specific user. Full error message does contain the cause.
CSV_UNABLE_TO_DELETE_USER Unable to delete a specific user. Full error message does contain the cause.
CSV_UNABLE_TO_UPDATE_USER Unable 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.