Implementing these best practices when bulk loading data reduces the possibility of errors occurring during the bulk load process. Read and understand this section before you start bulk loading data.
Use the following sections to learn about key elements for bulk loading data.
Bulk Loading File Specifications
Learn about the bulk loading files specification to reduce the possibility of errors.
Use a comma as the delimiter between the values
Save the file in a CSV format (*.csv)
Limit file size to 52 MB
Although the system upload limit is 52 MB, as a best practice, segment your bulk load files into small, manageable sets of data. For example, import just one user to familiarize yourself with the process. You can then import a larger set of users, for example, 100 users. If you do not experience any import errors, increase the import file size according to your level of comfort.
|Bulk Load File||Required Column Headings|
|Application Role Membership||
For each account, you create a new row (line) and enter data into each column (field). Each row equals one record.
Important:Whichever application you use to create the file, ensure that you save the file in a valid CSV format.
Spreadsheet applications make it easy to create, edit, and save import files. You can use standard features to add and delete rows of data, edit individual fields, search for records, or sort the list. The following illustration shows an example of group account data defined in a Microsoft Excel file. The layout lets you easily review the data.
When you save your spreadsheet as type CSV (*.csv), a comma separates the values in each row. For example, the following illustration shows the group data from the Microsoft Excel spreadsheet, saved as CSV file, and opened in Notepad.
List of User Attributes for CSV Column Headers
Oracle Identity Cloud Service provides a list of user attributes that you can use as column headers while importing or exporting user accounts using a comma-separated values (CSV) file.
Work Address Street
Work Address Locality
Work Address Region
Work Address Postal Code
Work Address Country
Work Address Formatted
Home Address Street
Home Address Locality
Home Address Region
Home Address Country
Home Address Postal Code
Home Address Formatted
Other Address Street
Other Address Locality
Other Address Region
Other Address Country
Other Address Postal Code
Other Address Formatted
Primary Address Type
Primary Email Type
Work Email Verified
Home Email Verified
Other Email Verified
Recovery Email Verified
Primary Phone Type
To assist you to bulk load data, Oracle provides sample files for you to use. You can download the compressed sample files in the Identity Cloud Service console or from a link provided by Oracle. Whether you download the sample files from the Identity Cloud Service console or from a link provided by Oracle, the sample files are the same.
To download the sample files from the Identity Cloud Service console, click the Download sample file link.
If you’re using the sample file to import application role memberships, then make sure the column headings are Entitlement Value, Grantee Name, and Grantee Type (instead of Display Name, Member, and Member Type). If the column headers aren’t correct, then change them accordingly.
Also, if you exported application role memberships before version 17.2.2 of Oracle Identity Cloud Service, and you want to import them back into Oracle Identity Cloud Service, then you must change the column headers before doing so.
Tip:First import the appropriate sample file with the sample data to familiarize yourself with the process. When you are comfortable with the process, delete the sample data, and then import live data.
Before you start bulk loading data, make sure that you understand the typical bulk loading data workflow.
Workflow is described in Typical Workflow for Bulk Loading Data.
While you are testing, deactivate notifications so that users don’t receive unnecessary notifications.
You can deactivate all notifications or you can choose which notifications are enabled and which notifications are not enabled. See Deactivate Notifications.