Symptom
You want to migrate Employee Organizational Assignment by using Data Workbench but EmployeeInternalID is missing from the template.
Business Requirement: You do not have an EmployeExternalKey and without the EmployeeInternalID in the template an import is not possible.
Cause
The EmployeeID is currently only enabled Read-Only at all Sub-Entities of the underlying ODATA-Service for Employee and User, therefore this Use Case cannot be handled via Import mode.
Resolution
Use Update mode for the requirement and follow the steps below:
- Go to People workcenter and check in Employee view for All employee.
- Identify the Employees that should get additional OrgUnitAssignments, EmployeeID XXX (where XXX represents Employee ID).
- Go to Data Workbench workcenter and select Export view.
a. Search for Employee and Employee Organizational Unit Assignment, filter for required EmployeeIDs.
b. In case Employee does not yet have an existing OrgUnitAssignment , export Employee (Root) records in addition. - Complete the selected data export via Export Data and find results (CSV-file) in Monitor screen.
- Exported file for OrgUnitAssignments 3.a. can be locally updated and used to Create OrgUnitAssignments via Update mode.
a. Go to Update view in Data Workbench.
b. Prepare CSV-File for Update based on Export File.
Delete not required columns EmployeeID/RoleCodeText etc. including content.
Delete content of field ObjectID but leave column existing, this leads to implicit Create instead of Update.
Keep parent information in HeaderObjectID and ParentObjectID or add it manually from exported Root-File 3.b. in case of first OrgUnitAssignment (both fields contain the same Employee)UUID as reference.
Fill other fields as required OrgUnitID/JobID , defaulting exists for RoleCode, StarDate, EndDate.
c. Process the OrgUnit Create via Update view. - Check results in Monitor view again.
Keywords
Employee Organizational Assignment, Data Workbench, , KBA , LOD-CRM-INT-DWB , Data Workbench , How To