Symptom
You are trying to import leads into C4C using Data Workbench and you see messages like 'Status is not valid' or 'Invalid code; maintain correct Status code'.
Environment
SAP Cloud for Customer
Reproducing the Issue
- Go to the Data Workbench Work center.
- Select the Import view.
- Select the Complete Business Object option.
- Select Insert.
- Select Standard object.
- Select Lead.
- Click in the Next button.
- Upload your file.
- Select option "Simulation mode".
- Click in the next button until the last step.
- You will see the warning: "Invalid code; maintain correct Status code."
- Click in the Simulate button.
- Go to the Monitor View.
- Find your newly created task.
- Check that all records raised errors.
- Open the error file.
- You will see the error "Status is not valid".
Cause
You cannot import leads with status Accepted or Declined directly.
Resolution
You need to first import them as Qualified to then change them to Accept or Declined.
- Create the Leads via DWB with Status Qualified.
- Export the Leads via DWB to get the ID or UUID, e.g. select by Creation Date Time = Today.
- Create CSV File only sending Object ID & Status (e.g. 04 = Accepted) -->
- Import Leads via DWB Import, Individual Object, Lead Update (Blank Fields = Ignore: This is important).
Keywords
Import ; Lead ; Leads ; Excel ; CSV ; Accepted ; Declined ; Status is not valid ; Invalid code; maintain correct Status code ; , KBA , LOD-CRM-LM , Lead Management , LOD-CRM-INT-DWB , Data Workbench , How To
Product
SAP Cloud for Customer add-ins all versions