2618144 - "Error Occurred Processing the CSV File(Startline 1) EOF Reached Before Encapsulated Token Finished" Error in Data Workbench

When trying to upload a file to import complete business objects in Data Workbench, the following error message appears:

"Error occurred processing the CSV file(startline 1) EOF reached before encapsulated token finished."

SAP Hybris Cloud for Customer 1802 and above.

1. Enter the Data Workbench work center.
2. Navigate to the Import view.
3. Select the radio button for Complete Business Objects.
4. Select the object which will be imported, and click on Next.
5. In the next screen, upload the zip file with the object data.
6. When trying to upload the file, the error message appears.

This error message appears because there are spare commas in the file data. This causes the system to expect a new data that needs to be addressed, however the system does not find enough headers to map this data.

For example:

Field A, Field B, Field C          <- the headers of the CSV file

12345, ABCD, WXYZ,          <- the data to be imported

In this case, the system will map "12345" to the Field A, "ABCD" to the field B and "WXYZ" to the field C. However the system assumes that there is another field which needs to be populated with a blank value (because of the comma in the end of the row). In this case, the system will raise the error  "Error occurred processing the CSV file(startline 1) EOF reached before encapsulated token finished".

To solve this issue make sure that all the data in the CSV is being mapped to the correct field from the header, and that there are no spare commas neither in the headers or the data rows.

data workbench, upload file, complete business objects, simulation , KBA , LOD-CRM-INT-DWB , Data Workbench , How To

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