Update authentication policy members in bulk (csv)

Loic Yannou

Hello

I'm trying to move users from the "Applies to all users" authentication policy to another one (linked to Okta).

To do so, I export members in a CSV file (using the GUI) from the "Applies to all users" authentication policy, update a couple of fields (Policy type, Single sign-on, Single sign-on configuration, ...) and then save the data to a new CSV file. The delimiter is unchanged (comma) and data are not double-quoted.

Then I import this CSV to the Okta authentication policy (using the GUI -> Add members -> Bulk entry -> Select CSV file).

I've got a popup saying:
"Unable to read email addresses.
We can't recognize one or more email addresses.
Make sure to enter the correct email addresses and try again."

Is this a syntax issue or characters problem, please ?
Best

Paul Cribdon

Old question, but I found I needed to do the following:

1. Export the CSV from the default policy
2. Open that CSV in Excel and delete all columns except the email column
   • I also deleted the title row, but I'm not sure if that was necessary or not
3. Save that as a new CSV
4. Upload that new CSV in the bulk add members dialog

Although I can't find it documented anywhere, it appears that the bulk add members CSV upload only expects a single column of just email addresses and nothing else, like this:

joe.bloggs@example.com
mrs.example@bloggs.com