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 · Accepted solution]

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

[Christian Burger]

Thanks for posting this. I had to delete the title row to make it work.

[Gain Credit]

try having the hyperlink in the email