Scenario 2: Use a .csv file to update user accounts in an Active Directory domain
Scenario 2: Use a .csv file to update user
accounts in an Active Directory domain
This scenario demonstrates how to update user accounts in an Active Directory domain when the information on employees is changed in the Human Resource (HR) database held in a Comma Separated Values (.csv) file.
NOTE: This scenario can be used only if the Employees OU already contains user accounts created with the creating scenario described earlier in this document. Only accounts for previously created employees will be updated.
This scenario has the following steps:
Step 1: Create an updating step
This section explains how to create a step that updates user accounts from the HR database to the target Active Directory domain.
To add an updating step to your existing sync workflow
- In the Administration Console, open the Sync Workflows tab, and then click the sync workflow you have created in Step 1: Create a sync workflow.
- Click Add synchronization step.
- On the Select an action page, select Update, and then click Next.
- On the Specify source and criteria page, do the following:
- Click Specify, click Select existing connected system, and then select the Comma Separated Values (.csv) file you connected in Scenario 1: Create users from a .csv file to an Active Directory domain. Click Finish.
- Make sure that the object type specified in the Source object type box is csv-Object.
- Click Next.
- On the Specify target page, do the following:
- Click Specify, and then select the Active Directory domain you connected in Scenario 1: Create users from a .csv file to an Active Directory domain.
- Make sure that the object type specified in the Target object type box is User (user).
- Click Next.
- Expand Rules to Modify Object Attributes, and then create forward sync rules to synchronize the following pairs of attributes:
Table 127: Rules to modify object attributes
|
City |
=> |
City |
|
Department |
=> |
Department |
|
First Name |
=> |
First Name |
|
Last Name |
=> |
Last Name |
|
Telephone Number |
=> |
Telephone Number |
For information on how to create rules, see Modifying attribute values by using rules.
- Click Finish.
Step 2: Run the created updating step
To run the updating step
- On the Sync Workflows tab, click Run now.
- In the Select sync workflow steps to run dialog box, select the check box next to the step you created, and then click OK to run the step.
After the synchronization step run completes, the Administration Console displays a report that provides information about the objects that participated in the updating step. At this stage, the application does not commit changes to the target Active Directory domain.
|
|
TIP: To view a list of user accounts to be updated in the Employees OU, in the update report, click the number next to Objects to be updated. |
Step 3: Commit changes to Active Directory
Step 3: Commit changes to Active Directory
To commit changes to the target Active Directory domain
