Import User Accounts

If you are an identity domain administrator or a user administrator, you can batch import user accounts using a comma-separated values (CSV) file.

Before you can import user accounts, first create a CSV file that is properly formatted for the import process. To create and prepare a file for import, follow these steps.

1. Use these sample files as a starting point.

2. Extract the compressed file and then open the Users.csv file.

3. Review and then delete any demo data in the Users.csv file.

   Tip:

   To familiarize yourself with the import process, consider importing just the demo data. You can then delete the unwanted demo data from Oracle Identity Cloud Service before you begin importing production data.

4. Create an import file using the Users.csv file. The Users.csv file is a simple text file in a tabular format (rows and columns). The first row in the file defines the columns (fields) in your table.

   Note:

   • The maximum number of rows in the user import file must not exceed 100,000 and the import file size must not exceed 52 MB.

   • At a minimum, the file must have these exact column headings and the fields in these columns must be unique.

     • User ID

     • Last Name

     • First Name

     • Work Email

     • Primary Email

     • Primary Email Type

   • For each account, you create a new row (line) and enter data into each column (field). Each row equals one record.

   • The IDs of the users that you want to import into Oracle Identity Cloud Service must contain at least three characters. The names of the groups that you want to import into Oracle Identity Cloud Service must contain at least five characters.

   • The telephone numbers of the users that you want to import must meet the requirements of the RFC 3966 specification.

   • When importing users, the attribute Recovery cannot be specified as one of valid values for Primary Email Type. The valid values for Primary Email Type are home, work, or other.

   • If you want users to use their federated accounts to sign in to Oracle Identity Cloud Service, then you must set the Federated column to TRUE for those users. When the federated flag is set, Oracle Identity Cloud Service no longer manages the federated user’s password. This prevents Oracle Identity Cloud Service from forcing a password change for these imported user accounts.

   • If you don't want users to be notified that Oracle Identity Cloud Service created accounts for them, then you must set the ByPass Notification column to TRUE for those users. The ByPass Notification flag determines whether an email notification is sent after creating or updating a user.

   • To create a CSV file, you can use a standard spreadsheet application, such as Microsoft Excel or Google Sheets, or you can use a text editor, such as Notepad or TextPad.

5. Save your file in a CSV format.

   1. Open the CSV file with a text editor, such as Notepad.
   2. Save the file with UTF-8 for encoding.

   Note:

   If you do not save the file in a CSV format with UTF-8 encoding, the import fails. Saving the file in UTF-8 format ensures that non-English characters display properly.

To import user accounts:

1. In the Identity Cloud Service console, expand the Navigation Drawer, and then click Users.
2. Click Import.
3. In the Import Users dialog box, click Browse to locate and select the CSV file that contains the user accounts to import.

   Note:

   Click Download sample file in the dialog box to download a sample file.
4. Verify that the path and name of the CSV file that you selected appear in the Select a file to import field.
5. Click Import.
   If a user account is missing a required value, such as the user's first name, last name, or user name, then Oracle Identity Cloud Service can't import it. If Oracle Identity Cloud Service can't import a user account, then it evaluates the next account in the CSV file.
6. After Oracle Identity Cloud Service evaluates all user accounts, review the job results.
   • If the job can be processed immediately, then a dialog box appears with the Job ID link for your import job. Click the link and review the details that appear on the Jobs page.
   • If the job cannot be processed immediately, then a message appears with a Schedule ID in it. Copy that Schedule ID, and use it to search for the job on the Jobs page. The job will appear when processing completes. Go to Step 7.

   Tip:

   Oracle Identity Cloud Service assigns a job ID to each file that's imported or exported, for auditing purposes.
7. On the Jobs page, locate the job that you want to view, and then click View Details.
   A table displays the first names, last names, email addresses, user names, and statuses of the user accounts that you imported into Oracle Identity Cloud Service.

   Note:

   If a user account can be imported into Oracle Identity Cloud Service, then a Creation Succeeded or Update Succeeded link appears for the status, depending on whether you imported a new account or modification to an existing account. To see granular details about the account, click the link.

   If a user account can’t be imported, then a Creation Failed or Update Failed link appears for the status. To see information about why the account or modification can’t be imported into Oracle Identity Cloud Service, click the link.

8. Review the details that appear on the Jobs page.
   This page shows how many accounts you imported, how many accounts imported successfully, and how many accounts can't be imported because of a system error.