SAP Knowledge Base Article - Public

2598774 - Cannot Import User Subscriptions Via Data Workbench

Symptom

You want to import User Subscriptions via Data Workbench, but the import file cannot be used because you don't have the EmployeeExternalKey as the employees were added manually.

Environment

SAP Hybris Cloud for Customer

Reproducing the Issue

  1. Go to the Data Workbench work center.
  2. Select the Import view.
  3. Click on Individual Objects.
  4. Search for Employee User Subscription Assignment object.
  5. Click on Download metadata and see that the csv file asks for EmployeeExternalKey to be filled.

Cause

As the employee was created manually, there is no EmployeeExternalKey maintained.

Resolution

  1. Export User Subscription using Data Workbench.
  2. In the exported .csv file, please fill all the fields and leave fields ParentObjectID, HeaderObjectID and ObjectID as blank.
  3. Export the specific Employee ID using the object Employee and copy the Object ID from the exported file.
  4. Paste the above ID in the place of ParentObjectID and HeaderObjectID in the exported .csv file and keep the ObjectID column as blank.
  5. Upload the User Subscription template using the Update view.

Keywords

Data Workbench, User Subscriptions, Employee, EmployeeExternalKey , KBA , LOD-CRM-INT-DWB , Data Workbench , How To

Product

SAP Cloud for Customer add-ins all versions