sync Workflows

Question

I am trying to build a Sync workflows that read a CSV file with employeeID fields and update the EmployeeNumber field. The employeeNumber become letter "A"+ value of employeeID 
 Now most of employeeID are 6 digits but some are 4 or 5 digits. We do not want a employeeNumber of "A1234" we need to add "0"s in front if less than 6 digits so it would become A001234. 
 Since existing employeeId doesn't change much, I could have a script which ignore EmployeeId less than 100000 and fix them manually once or create a script that add includes all scenarios. 
 I tried few thing without success. Any help would be appreciated

Stu.Pollock · Answer

Hi flartigau 
 Depending on the use case, and number of objects, you could instead have a mapping for employeeNumber (in AD) from a PowerShell script 
 Where the script uses $employeeID = $srcObj["EmployeeID"] to retrieve the value from the current employee record, then write your code to manipulate that value to into the format and/or length you require. 
 
 The Active Roles Synchronization Service Admin Guide has some info on accessing Source and Target objects ( Active Roles 7.5.3 - Synchronization Service Administration Guide (oneidentity.com) ), as screenshot below show an example where the City field from the source object is retrieved, then based on the value retrieved, a country will be set in the script, and then returned as a property value for the attribute mapping. 
 
 So when adding your sync rules, from the source item your selecting "PowerShell Script" 
 
 Adding your code into the script editor window (remembering to return a value) 
 
 Then on your Target Item side, you've entering the attribute you wanted your generated value to be written to

Hope this helps 
 
 Stu

Endpoint Privilege Management

sync Workflows