Import IdmPassword from CSV file
To import passwords to users you can use ImportIdMPasswordFromCSV long-running task, which is available in the extras module since version 3.2.0.
Configuration
ImportIdMPasswordFromCSV uses the default interface for CSV importing tasks along with a few of its own configuration properties.
- importfile - Drag and drop input csv file
- dateFormatColumn - Date format used in input file. See Java SimpleDateFormat documentation page for more info
- usernameColumn - Name of the column which contains the username of the target identity
- separator - Separator character used in the input csv file
- encoding - Encoding of the input csv file
Input csv file structure
Input csv file must contain at least the "username" column. All possible columns are listed in the table below. Note that if a column is not present in the input csv, the value in IdM will not be changed, but if a column is in the input csv with an empty value, then the value in IdM will be deleted instead.
| Column name | Desription |
|---|---|
| username | Username of target identity |
| password | Value of new password |
| validTill | End date of password validity (see dateFormatColumn) |
| blockLoginDate | Date of login block |
| passwordNeverExpires | True, if password never expires |
| mustChange | True, if user must change password on next logon |
| lastSuccessfulLogin | Date of a last successful login |
| validFrom | Start date of user password validity |
| unsuccessfulAttempts | Number of unsuccessful login attempts |
| verificationSecret | Password verification secret |
Example csv
Csv showed bellow uses date format "yyyyMMdd"
"username";"validTill";"mustChange" "testImportPasswordUser1";"20200203";"true" "testImportPasswordUser2";"20200204";"false" "testImportPasswordUserFake";"20200205";"false"