SAP Knowledge Base Article - Public

2845763 - Numbers Showing With Decimal Points During Upload Via Data Workbench

Symptom

When uploading a CSV/Excel file via Data Workbench, a decimal point is added to any numbers present.

For example:

  • File contains number 88
  • After upload. Number is presented as 88.0

As a result, Data Workbench does not recognize the role code and upload fails.

Environment

  • SAP Cloud For Customer
  • SAP Business ByDesign 

Reproducing the Issue

  1. Go to the Data Workbench workcenter.
  2. Select the Import tab.
  3. Select Complete Business Object.
  4. Select the Insert operation.
  5. Select Standard Object.
  6. Search and select an object. For example: Employee.
  7. Download template.
  8. Enter values in either CSV or Excel.
  9. In the Data Workbench tool, select Next.
  10. Browse for file and select Upload.
  11. After file upload, numbers are represented with a decimal point.

Cause

If contents in the CSV/Excel have been copied from an external system, then a decimal point will be added to any numbers in the file.

Resolution

Values must be entered manually.

Keywords

data workbench, decimal point, number , KBA , LOD-CRM-INT-DWB , Data Workbench , Problem

Product

SAP Business ByDesign all versions ; SAP Cloud for Customer add-ins all versions