====== 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 [[https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html|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"