3165388 - Unwanted Records Are Created In The System Via Data Workbench

You have imported some data using data workbench and even though the file had X records, much more records are shown as processed and created in the system.

SAP Cloud for Customer

1. Go to Data Workbench Work Center.
2. Enter Import View.
3. Select any object and method.
4. Click next.
5. Upload your file.
6. Click on Next until last screen.
7. Click on Import data.
8. Go to Monitor View.
9. Check your created task.

Result: Even though the file had 10 records, for example, the monitor shows 50 records processed. If you check in the system additional records were created.

This can occur when the user selects the rows and deletes through keyboard. This deletes the records but keeps the empty rows. You can confirm this is the cause by following below steps:

1. Open the file used for the import with Notepad or other text editor.
2. Check the rows. 
3. You should find rows filled with "," commas. These rows are responsible for the additional records created in the system.

1. Open the Excel file.
2. Select the rows to be deleted.
3. Right click.
4. Delete the empty rows.

You could delete directly from the text editor as well.

 2204393 - Common Issues With CSV Files in Data Workbench and Mass Data Maintenance

Excel, Records, Empty, Row, Data Workbench, Import , KBA , LOD-CRM-INT-DWB , Data Workbench , How To

SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications 2202