Overview

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.

Add Users by CSV

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

File requirements

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

  • File format and headers
  • File data or row requirements

File format and headers

  • 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.

Note:

The CSV files that you upload must use commas (",") as the delimiter to separate fields. 

In some regions, the operating system uses a semi-colon (";") as the field delimiter. This causes Microsoft Excel to save the files with the semi-colon as the delimiter that causes processing to fail. You can temporarily update the regional settings to work around this issue.

Workaround

Caution:

The changes described as follows can affect other applications and spreadsheets. Hence, make the required changes in the CSV and then revert these settings. 

Windows 7

  1. Navigate to Control Panel > All Control Panel Items > Region and Language.

  2. In the Format drop-down list, choose English (United Kingdom).

Windows 10

  1. Go to the Windows Settings.

  2. Navigate to Time & Language > Region & Language > Additional date, time  & regional settings > Change date, time & number formats.

  3. In the Format drop-down list, choose English (United Kingdom).

File data or row requirements

The file can contain up to 5000 rows. Ensure that the following requirements are met for each row:

  • It consists of a valid email address.
  • Product profiles (or configurations) if present, are valid.
  • A country, if present, is valid and a country where Adobe does business.
  • Options, if present, are valid.

File processing

When a file is processed, based on the specific domain, each entry is processed individually as follows:

Identity Types Action Exceptions
Federated ID
  • User record is created with the specified user name.
  • Account is added to specified product profiles.
  • Email address is not used except to determine domain.
  • No email is sent to the user.
  • User name exists.
  • A country, if present, is not open for Adobe business.
  • Product profiles are invalid or quota exceeded.
Enterprise  ID
  • An account is created with given email address.
  • Account is added to specified product configurations.
  • A welcome email is sent to the user.
  • Already has an invitation in progress or account with given email exists.
  • A country, if present, is not open for Adobe business.
  • Product profiles are invalid or quota exceeded.
Adobe ID
  • Send an invitation email to user email address.
  • No account is created.
  • The invite is associated with the product profiles listed.
  • If the account exists, add it to product profiles.
  • Already has an invitation in progress or account with given email exists.
  • A country, if present, is not open for Adobe business.
  • Product profiles are invalid or quota exceeded.

When all processing is complete, a summary is emailed to the initiating admins.

If the import operation is canceled, processing stops. However, rows already processed are not rolled back.

Note:

The Import Users feature does not support user nicknames having special characters, such as the comma (,) and the semicolon (;).

Performance details

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 .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.

Troubleshooting

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.

Upload errors

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

Headers (first line of the CSV) are missing or invalid

The error message is shown in the following conditions:

  • The file is not in CSV format.
  • A required column header (for example, Email) is invalid or missing.
  • A required column is missing.
headers_are_missing

Do the following:

  • Use only the .csv file format.
  • Ensure that column headers are valid.
  • Ensure that column values are valid.

For more information on mandatory or optional fields and file format, see the CSV file format table in Manage Users.

Error parsing data (for example, invalid Roles or Product Configurations)

The error message is shown in the following condition:

  • When the required column headers (for example, Email) are present, but the corresponding row values are missing.
error_parsing

Ensure that you enter the corresponding values for each row.

Processing errors

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.

INTERNAL_SERVER_ERROR

The INTERNAL_SERVER_ERROR error is caused by Gateway timeout. It displays INTERNAL_SERVER_ERROR in the STATUS column on the error results screen.

InternalServerError

You can try again later.

User already added

If you upload existing users again without making any changes, it displays User already added in the STATUS column on the error results screen.

User already added

Ensure that you do not upload existing users again. Remove rows that contain existing users' details.

Error parsing data (for example, invalid Roles or Product Configurations)

If the required column headers (for example, Email) are present, but the corresponding row values are missing, the Error parsing data message displays in the STATUS column on the results screen. 

error_parsing_-_fileuploadedbutnotprocessed

Ensure that you enter the corresponding values for each row.

Domain wasn't found in your organization

The error occurs, for Enterprise ID or Federated ID users, if the domain does not meet the following criteria:

  • A valid Domain name in the Domain column
  • Email Id with the valid domain name
  • User name with the valid domain name

The Domain wasn't found in your organization message displays in the STATUS column on the results screen.

domain_was_not_found-fileuploadedbutnotprocessed

Note:

The error occurs when you use the invalid domain name, it means that the domain is not claimed or trusted by your organization.

Do the following:

  • Enter the valid Domain name in the Domain column.
  • Enter the valid email id based on the Identity Type.
  • Enter the valid user name based on the Identity Type.

Country code must be a 2-character ISO-3166 value

The error occurs, for Enterprise ID or Federated ID users, if the Country Code Heading or the data values or both are missing.

The "Country code must be a 2-character ISO-3166 value" message displays in the STATUS column on the results screen.

country_code_-_fileuploadedbutnotprocessed

Ensure that you enter the Country Code column header and the corresponding valid row values.

If you are still facing a problem to bulk upload users, create a case, start a chat, or manage an existing case from the Admin Console Support tab if you are a System or Support administrator.

For more help, see Create a support case

This work is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License  Twitter™ and Facebook posts are not covered under the terms of Creative Commons.

Legal Notices   |   Online Privacy Policy