Table of Contents

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.

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"