Symptom
When you try to import the main employee file via data import and export tool, you receive one of the errors below:
'The employee type information for employee X is missing'
'Lifecycle Status Is Initial. Please Provide A Value.'
Environment
- SAP Service Cloud v2
- SAP Sales Cloud v2
Reproducing the Issue
- Go to data import and export view
- Click on import button
- Select employee
- Uncheck complete entity
- Select the file type
- Upload the affected file
- Click on import data.
- Result: The task will fail with completed with error status. When you open the error file you see the error.
Cause
The error is triggered because in order to import an employee, you should import the file 'Employee types' as well, together with the main employee file.
Resolution
In order to correctly import an employee, you can follow the below steps:
- Open Data Import and Export screen.
- Click on import button.
- Select employee entity.
- Uncheck the complete entity toggle button.
- Select employee types
- Select a file type
- Now upload a zip file which contains the Employee main file and the Employee Types file.
- Click on import data.
You can refer to below example on how to fill the employee type file:
- parent_external_key: Test_0001 (here you should fill the value with the external key maintained in the main 'Employee' file)
- internal employee: true
- valid from: 2023-08-22 (this can be the date you are importing the employee)
- valid to: 9999-12-31
Note: The Validity fields should be set as text fields in Excel, so it keeps the correct format.
Keywords
Data Import and Export, Employee, Lifecycle Status , KBA , CEC-CRM-EMP , Employee for SAP Sales/Service Cloud , How To