yx65q (yx65q) asked a question.
CSV Directory import failure: Csv deactivate header Active doesn't exist
Hi,
I configure CSV Directory, do the mapping and get the following real strange error, when I import the file:
failure: Csv deactivate header Active doesn't exist.
These are the columns in the CSV file, and I verified, that the mapping only is for these variables:
userName,firstName,lastName,email,approval_pm_hw,approval_manager_hw,group_hw_01,group_hw_02,group_hw_03
The first four are the assigned to the base attributes:
login, firstName, lastName, email
The additional attributes to custom attributes
The error message sounds strange, aren't it?
The file is in UTF-8.
Mmh: I found a hint: it is withn the application CSV Directory within the section Inetegration:
CSV field settings
Unique identifier field
emailaddress
Once set, this field cannot be changed
Deactivation field
active
This field provides an explicit way for an admin to designate that a user should be deactivated
Deactivation value
0
If a user's deactivation field contains this value, the user will be deactivated
Seems that Okta is not getting the Column active.
I modified the setting to
String
Now I get the error message
Error while downloading all users: null
CSV Directory: An error occurred during import Error while downloading all users: null
I start again, see below. the main reason is
Within the csv-field setting I defined Unique identifier field login. This should be userName, always. On for very special cases it should be different.
CSV file looks like
login,firstName,lastName,email,approval_pm_hw,approval_manager_hw,group_hw_01,group_hw_02,group_hw_03,active
jonny05@OktaPretest01.germanywestcentral.cloudapp.azure.com,Jonny05,LastName05,jonny05@OktaPretest01.germanywestcentral.cloudapp.azure.com,1,1,1,0,1,1
jonny06@OktaPretest01.germanywestcentral.cloudapp.azure.com,Jonny06,LastName06,jonny06@OktaPretest01.germanywestcentral.cloudapp.azure.com,1,1,0,0,0,1
CSV field settings
Unique identifier field login
Deactivation field active
Deactivation value 0
CSV import filepaths
Full import filepath /mnt/c/Users/hwallus/Documents/csv_fullimport.csv
Incremental import filepath /mnt/c/Users/hwallus/Documents/csv_incimport.csv
To Okta
Schedule import Never
Okta username format Custom
Update application username on Create only
User Creation & Matching
Imported user is an exact match to Okta user if Email matches
Profile & Lifecycle Sourcing
Check for Allow CSV Directory to source Okta users
When a user is reactivated in the app
Reactivate suspended Okta users
Reactivate deactivated Okta users
Then click Force Sync to get the CSV-Data from application host
Mmm,
Go to Profile Editor for CSV Directory third try internal name: csv_directory_v2_9cd75o6
Add Attribute Active active string Customer
appuser.userName from what is getting this?
Seems to be a kind of Standard. Within the csv-field setting I defined Unique identifier field login. This should be userName, always. On for very special cases it should be different.
I added now the login column to my CSV import file, and it works.
The CSV files looks now like this:
login,userName,firstName,lastName,email,approval_pm_hw,approval_manager_hw,group_hw_01,group_hw_02,group_hw_03,active
jonny05@OktaPretest01.germanywestcentral.cloudapp.azure.com,jonny05@OktaPretest01.germanywestcentral.cloudapp.azure.com,Jonny05,LastName05,jonny05@OktaPretest01.germanywestcentral.cloudapp.azure.com,1,1,1,0,1,1
jonny06@OktaPretest01.germanywestcentral.cloudapp.azure.com,jonny06@OktaPretest01.germanywestcentral.cloudapp.azure.com,Jonny06,LastName06,jonny06@OktaPretest01.germanywestcentral.cloudapp.azure.com,1,1,0,0,0,1