I got an error when trying to import users or organizations into my Zendesk account.
The majority of errors related to user or organization import are a result of formatting issues in the CSV file. See this article for more information on proper formatting: What is the proper CSV format when importing users or organizations into Zendesk?
If you have a specific error message you are looking for, check the following table for potential solutions:
|Your CSV file request frequency limit has been exceeded. Try again later||CSV exports are limited to 100,000 results per hour and per user. See this article for more details: Your CSV file request frequency limit has been exceeded. Try again later.|
|UTF-8 Errors||This error is created when the uploaded file is not in a UTF-8 format. See this article for more detail: How can I fix the UTF-8 error when bulk uploading users?|
|Upload failed. File type is not supported.||The file must be a CSV (comma separated values) file. If you are using a CSV but still get this error, consider passing the file through Google Sheets as described in the tip below to fix any potential encoding issues.|
|Failed to process row. Import aborted.||This error occurs because of an issue with the formatting of the CSV file. See more in this article: Bulk import error: "Failed to process row. Import aborted."|
|Column 'user_id' cannot be null||This error is caused by the same issues as above. See the article: Bulk import error: "Failed to process row. Import aborted."|
|User_id is invalid||Include the user_id field in the header of one of the columns of your CSV file.|
|Missing mandatory field in header: name||The name field is required when bulk importing new users via a CSV file. See the article: Bulk importing users.|
|403 error||See: Why do I receive a 403 error when trying to bulk import users?|
If you still experience an error when importing, try these common troubleshooting steps:
- Check the first row of your file to make sure you have all the required headers for importing.
- Check your CSV file for any formatting issues or unsupported characters.
- Copy and paste your data into a new CSV file to avoid formatting issues.
These general resources should also help you get your users and organizations imported smoothly: