Symptom
Your requirement is to Delete some records for any Object using Data Workbench. You have added the column To Be Deleted to indicate which row should be deleted and marked it as True. While uploading the CSV file in the Update tab, system throws error:
No spaces allowed (only alphabets, numbers & underscore allowed)
Environment
SAP Hybris Cloud for Customer 1802 and higher.
Reproducing the Issue
To delete records of any Object in Data Workbench, follow the below steps:
- Logon to the HTML5 client;
- Go to Data Workbench work center;
- Go to Export tab;
- In the search field, select the Object;
- Select Data;
- Select Next;
- Export Data;
- Go to the Monitor tab;
- Download the exported file.
Add column To Be Deleted to indicate which row should be deleted and mark it as True and then follow the below steps:
- Logon to the HTML5 client;
- Go to Data Workbench work center;
- Go to the Update tab;
- Select the Object;
- Select Next and Browse for the file;
- Select Upload;
- System throws error.
Cause
You have added the column header To Be Deleted with spaces.
Resolution
The column header should not contain spaces. Add the column header ToBeDeleted without spaces.
This is valid for all headers in Data Workbench.
Keywords
tobedeleted, data workbench, delete records, error message, no spaces allowed , KBA , to be deleted , tobedeleted , LOD-CRM-INT-DWB , Data Workbench , How To