If you are an identity domain administrator or a user administrator, you can batch import groups using a comma-separated values (CSV) file.
Use these sample files as a starting point.
Extract the compressed file and then open the
Review and then delete any demo data in the
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 live data.
Create an import file using the
Groups.csvfile 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. At a minimum, the file must have these exact column headings.
Tip:Ensure that the fields in these columns are unique. Also, verify that the user names that appear in the User Members column already exist in Oracle Identity Cloud Service.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.
The maximum number of rows in group import file must not exceed 100,000 and the import file size must not exceed 52 MB.
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.
Save your file in a CSV format.
- Open the CSV file with a text editor, such as Notepad.
- Save the file with UTF-8 for encoding. Saving the file in UTF-8 format ensures that non-English characters display properly.
Note:If you do not save the file in a CSV format with UTF-8 encoding, the import fails.
- In the Identity Cloud Service console, expand the Navigation Drawer, and then click Groups.
- Click Import.
- In the Import Groups window, click Browse to locate and select the CSV file that contains the groups to import.
Note:Click Download sample file in the dialog box to download a sample file.
- Verify that the path and name of the CSV file that you selected appear in the Select a file to import field.
- Click Import.The reasons for Oracle Identity Cloud Service not being able to import a group are that the group already exists or the group is missing a required value, such as the group name. If Oracle Identity Cloud Service can't import a group, then it evaluates the next group in the CSV file.
- After Oracle Identity Cloud
Service evaluates all groups, 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.
- On the Jobs page, locate the job that you want to view, and then click View Details.The Job Details page shows how many groups you imported, how many groups imported successfully, and how many groups can't be imported because of a system error. For each group that you imported successfully, this page also shows how many user accounts are assigned to the group.
- To see more information about a group, click View Details.
If the group can be imported into Oracle Identity Cloud Service or the user accounts can be assigned to the group, then a Creation Succeeded or Update Succeeded link appears for the status, depending on whether you imported a new group or modification to an existing group or group membership. To see granular details about the group, click the link.
If a group can’t be imported, then a Creation Failed or Update Failed link appears for the status. To see information about why the group or modification can’t be imported into Oracle Identity Cloud Service, click the link.