Troubleshoot bulk user CSV upload | Adobe Admin Console

The Add users by CSV feature available on the Users page allows an administrator to create multiple user accounts in the Admin console using a CSV file. The status and progress of the user account creation process are displayed on the Bulk Operations Results page. You can cancel the processing of the User account creation at any time.

For more details on working with users in the Admin Console, see Manage users.

The following are processing requirements that the admin has to fulfill before uploading a file:

• File format and headers
• File data or row requirements

• The file is in Comma-Separated Values (CSV) format and has the .csv suffix. Each record is on a separate line, delimited by a line break (CRLF). For example, aaa,bbb,ccc CRLF. For more details, see RFC 4180 (CSV file specification). 
• Column Header is valid. The Header row is mandatory. For more information on mandatory or optional fields and file format, see the CSV file format table in Manage Users.

Ensure that the following requirements are met for each data row:

• It consists of a valid email address.
• Product profiles (or configurations) if present, are valid.

• Options, if present, are valid.
  

Your CSV file can contain up to 25,000 rows (5,000 for optimal performance). If the  file exceeds 5000 rows, you will experience performance issues when the file is being processed on the Admin Console (see the following section, File processing). However, we will reject any CSV file that exceeds 25,000 rows.

If you have a requirement to upload more than 25,000 users, we recommend one of the following:

1. Split your CSV into multiple files of 25,000 rows (max).  For optimal performance, use 5000 rows or less.
   
2. Use Adobe's User Sync Tool. A command-line tool that moves user and group information from your organization’s enterprise directory system (such as an Active Directory or other LDAP system) to your organization’s directory in the Adobe Admin Console.
   
3. Use Adobe's User Management REST API. You can integrate this API into your organization’s administrative applications and processes.
4. If you've set-up Federated IDs on the Admin Console with Microsoft Azure or Google Google federation, use their Admin Console connectors. See Set up Google federation for SSO with Adobe or Set up SSO with Azure AD Connector.
5. If you're unable to use any of the above methods to bulk upload users, sign in to the Admin Console, navigate to Support, and contact Adobe Customer Care.

When a file is processed, based on the specific domain, each entry is processed individually as described in the following table.

Once all processing is completed, a summary is emailed to the initiating admin. If the import operation is canceled, processing stops. However, rows already processed are not rolled back.

* Adobe services and software are controlled by U.S. export laws which restrict the export and use of Adobe services and software in certain regions, including but not limited to, Cuba, Iran, North Korea, Sudan, Syria and the Crimea region of Ukraine.

To avoid overloading, a 66.6% duty cycle rule is part of processing.  If the time to process an entry differs from the rolling average by more than 10%, then the throttle is adjusted so that request processing consumes only 2/3 of real time.

In addition, an operation team-managed throttling control also limits the processing rate.  If the throttling control is explicitly set, then the duty cycle control is disabled. There is an API call to switch back to duty cycle-based throttling.

It displays the number of requests processed per second to you to provide feedback on performance.

The target rate for creation of 1000 accounts with each added to 2 product configurations is 1 account/second, not counting the 66.6% duty cycle, so the apparent processing rate can be 0.66 account/second or about 40 accounts/minute.  Creation of 1000 accounts at this rate takes 25 minutes.  Creation of 5000 accounts at this rate takes two hours and five minutes.

The Troubleshooting section helps you to troubleshoot error conditions or other problems that can arise while using the bulk import functionality with the Adobe Admin Console.

Sometimes, the file upload fails if certain conditions are not satisfied.

A processing error occurs if the system is unable to process data rows in the uploaded file. To view the details, see Bulk Operation Results.