Configure the CSV directory integration profile attributes
- In the Admin Console, go to Directory > Profile Editor.
- Find your CSV application and select Mappings.
- Map the CSV application's user profile attributes to user attributes in the Okta User Profile. For an import to be successful, the following fields are mandatory:
You can also use the following default mappings by entering them as your headers within the CSV file (CSV app user => Okta user). These attribute headers are case-sensitive.
- userName => login
- firstName => firstName
- lastName => lastName
- email => email
As an admin, you can update the attributes you want to map by using the Okta Expression Language.
- Optional. Use the Profile Editor to map alternative attributes from your CSV file instead of using the Okta default attributes, or you can import additional fields as custom attributes. In either case, complete these steps:
- Find your CSV application in the Profile Editor page and select Profile.
- Select Add Attribute, add the new attribute, and save.
- Select Map Attributes, and map the new attribute which will replace the Okta default.
- You can delete the Okta default attribute.
- Save your changes.
The new attribute appears under Filters > Custom.
- Okta queries the name you specify when determining which headers in the CSV file correspond to the attribute.
- Okta only supports non-array attributes (i.e., string, boolean, integer, number).
- You must add the attribute that corresponds to your Unique User Field Name. This is required.
- Mapping a Unique Identifier from the CSV file is not required. If you would prefer that the Unique Identifier be populated on the user profile, access the mappings and configure it there.
- If there are additional attributes you want to import from the CSV file, they must be added to your schema. If your CSV file has attributes or headers that are not configured within your user profile, Okta ignores them and their associated values for each user.
- If a CSV column is not included as an attribute in a CSV user profile, the data from that column is ignored. For example, if you’ve configured userName, firstName, lastName, email, and employeeId within the Profile Editor, but your CSV includes an additional attribute with the Address header, Okta will not import Address or any values populated for a user with an address.
- Plain text password migration is not supported.
For example, to change the lastName attribute in Okta with your CSV file's familyName header, you would do the following:
- Create a new attribute on the CSV Directory app user profile with a variable name of familyName.
- In the Profile Editor, map appuser.familyName to the lastName attribute on the Okta user profile.
- You can delete the default attribute, appuser.lastName. However, if you choose to retain it, it is no longer mapped.