Active Roles 8.0 LTS - Synchronization Service Administration Guide

Scenario 1: Create users from a .csv file to an Active Directory domain

The following scenario demonstrates how to create user accounts from a Human Resources (HR) database to an Active Directory domain. The HR database is represented by a sample Comma Separated Values (.csv) file. Depending on the user city, accounts will be created in one of the following OUs:

Employees\New York

Employees\Tokyo

Employees\Amsterdam

Employees\OtherCities

This scenario includes the following steps:

This section provides instructions on how to:

Connect Synchronization Service to the source Comma Separated Values (.csv) file and target Active Directory domain.
Add a new creating step and configure its settings, for example, specify the object attributes to create.
Develop a Windows PowerShell script that returns the name of an Active Directory container for created user accounts.
Preview a list of user accounts to be created.

To add a creating step

In the Synchronization Service Administration Console, open the Sync Workflows tab, and then click the sync workflow you created in Step 1: Create a sync workflow.
Click Add synchronization step.
On the Select an action page, select Creation, and then click Next.
On the Specify source and criteria page, click Specify, click Add new connected system, and then step through the wizard to add the sample Comma Separated Values (.csv) file as a connected system:
1. Use the Connection name box to type a descriptive name for the connection being created.
2. In the Use the specified connector list, select Delimited Text File Connector. Click Next.
3. Click Browse to locate and select the sample Comma Separated Values (.csv) file supplied with Synchronization Service. This file is located in the folder
  <Synchronization Service installation folder>\Samples.
4. Step through the wizard until you are on the Specify attributes to identify objects page.
5. In the Available attributes list, select Employee ID, click Add, and then click Finish.
Click Next.
On the Specify target page, click Specify, and then step through the wizard to add the target Active Directory domain as a connected system:
1. Use the Connection name box to type a descriptive name for the connection being created.
2. In the Use the specified connector list, select Active Directory Connector. Click Next.
3. Use the Domain name box to type the FQDN name of the target Active Directory domain. If necessary, adjust other connection settings on this page as appropriate. Click Finish.
Click the down arrow on the button provided next to the Target container option.
In the provided list, click PowerShell Script.
Insert the following script sample into the dialog box, and then click OK:
$userCity = $srcObj["City"]
switch ($userCity)
{
  "New York" {$container = "OU=New York,OU=Employees,DC=mycompany,DC=com"; break}
  "Amsterdam" {$container = "OU=Amsterdam,OU=Employees,DC=mycompany,DC=com"; break}
  "Tokyo" {$container = "OU=Tokyo,OU=Employees,DC=mycompany,DC=com"; break}
  default {$container = "OU=OtherCities,OU=Employees,DC=mycompany,DC=com"; break}
}
$container

NOTE: Before using the script, change the "DC=mycompany",DC=com" string as appropriate to reflect your environment. For example, if you have created the Employees OU in the testlab.ttt domain, use the following string: "DC=testlab,DC=ttt"

Click the down arrow on the leftmost button provided below the Rules to generate unique object name list.
In the provided list, click Attribute.
Select Logon Name, and then click OK. Click Next.

Expand Initial Attribute Population Rules, and then create forward sync rules to synchronize the following pairs of attributes:

Table 127: Initial attribute population rules
CSV file attribute	Synchronization direction	Active Directory attribute
Logon Name	=>	Logon Name (Pre-Windows 2000)
First Name	=>	First Name
Last Name	=>	Last Name
City	=>	City

For information on how to create rules, see Modifying attribute values by using rules.

Expand Initial Password, click Text, and type a password in the Set Password dialog box. Click OK.
Optionally, you can expand User Account Options to modify the default options to create new user accounts.
Click Finish to close the wizard.

Active Roles 8.0 LTS - Synchronization Service Administration Guide

Scenario 1: Create users from a .csv file to an Active Directory domain

Scenario 1: Create users from a .csv file to an Active Directory domain

Step 1: Create a sync workflow

Step 2: Add a creating step

Step 3: Run the configured creating step

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

Active Roles 8.0 LTS - Synchronization Service Administration Guide

Scenario 1: Create users from a .csv file to an Active Directory domain

Scenario 1: Create users from a .csv file to an Active Directory domain

Step 1: Create a sync workflow

Step 2: Add a creating step

Step 3: Run the configured creating step