How to Bulk Modify User Passwords from a CSV File

Question:  Can I use EMU to update user passwords in eDirectory from a csv file exported from our school information system?  Is there anyway to make it a scheduled process?

Answer:  Yes, EMU allows you to select accounts from a .CSV file and you can then manage those user objects.  You can then use the information in Can EMU Automatically Create Accounts? to automate this process.

CSV File:  You need to create a CSV file that has a unique identifier that can be exported from the student management system and is currently recorded in eDirectory.  In this example, eDirectory has been extended to record the StudentID for each student.  You need to create a CSV file that includes sufficient information to select and confirm the users selected by EMU and the desired password.

Steps to Bulk Modify Passwords from a CSV File:

1.  Open EMU.

2.  Select "Tools" > "Account Search Based on Data File"

3.  In the "Account Search Based on Data File" window:

• For "Step 1" click the "Select" button and select the .CSV file to use, e.g. pwd_change.csv.
• For "Step 2" choose the unique identifier field from the drop-down box (these are the column header names from the CSV file).  Choose something that will provide the best possible unique match like "Full Name" or "Login Name", in this example "StudentID".
• Select the eDirectory comparison field that matches the "Identifier Field:" selected in Step 2 above, e.g "studentID".

4.  Click "Next".

5.  In the "User Accounts Search" window, select the eDirectory containers to perform a search for the accounts and click " OK".  EMU will open an "Account Search Based on File" window which will display the search in action.  When the search is complete a results window will open.

6.  In the "Account Search Based on Text File" window, deselect any duplicate accounts that you do not want to manage.  Click the "Continue" button.

7.  In EMU, under the "Report Information" pane, use a combination of CTL+A, CTL+CLICK, or SHIFT+CLICK to select the users to be managed.

8.  Right-click the selected accounts and choose "Select In NDS View".  Those accounts will be highlighted in the "NDS Information" pane throughout the tree view.

9.  Under the "NDS Information" pane, right-click one of the highlighted users and choose "Manage Account(s) from file" and select the CSV file again, and click "Open".

10. Under the "Passwords" tab:

• select the "Change Passwords" option,
• select the "Change NDS Password" option
• select the correct password field from the CSV file, e.g. "Password"
  
  
• if the target users have GroupWise accounts and you need to change those passwords to match, select the "Change GroupWise Password" option, select the correct field from the CSV file, and select "Set Passwords to Lowercase" if required.

11.  Click the "Modify" button to complete the process.