SAP Knowledge Base Article - Public

2442434 - Error Message: “Upload error; validate CSV headers with fields of the object”, While Uploading File in Data Workbench Work Center

Symptom

You require to Update some fields of Data Workbench Object XYZ(where XYZ represents the Object). Upon trying to upload the file in the Update view, system throws the error:

Upload error; Validate CSV headers with fields of the object

Environment

SAP Hybris Cloud for Customer

Reproducing the Issue

To download the upload template:

  1. Go to Data Workbench workcenter
  2. Go to Import tab
  3. Select the radio button for Individual Object
  4. Go to Insert tab
  5. Select the object XYZ for which you want to update data
  6. Select Download Metadata
  7. Fill data in the fields
  8. Save the file

To upload the file in Update view:

  1. Go to Data Workbench workcenter
  2. Go to Import tab
  3. Select the radio button for Individual Object
  4. Go to Update tab
  5. Select the object XYZ for which you want to update data
  6. Browse for the file
  7. Select Upload

 System throws errors.

Cause

Import template was used in the Update view.

Resolution

For the Update scenario, first Export the data for the respective Data Workbench Object. Thereafter, use the same file and modify data in the respective fields without changing the headers.

The standard behavior in Data Workbench is that, irrespective of whether the all the fields have relevant data to upload or not, all the column headers must be part of the Update file. Do not delete any Column headers. Header check is implemented to ensure the user does not upload a corrupt file or some other object's file.

Steps to export data:

  1. Go to Data Workbench workcenter
  2. Go to Export tab
  3. In the search field, select the Object XYZ for which you want to export
  4. Choose appropriate filters if required
  5. Select Next
  6. Select Export Data

Steps to Downoad the exported file:

  1. Go to Monitor view
  2. Download the exported file from the respective Task
  3. Save the file
  4. Modify the data in the required fields
  5. Save the file

Now update/modify the required fields and perform the Update of the Object XYZ using the same file.

Steps to upload file in the Update view:

  1. Go to Data Workbench workcenter
  2. Go to Import tab
  3. Select the radio button for Individual Object
  4. Go to Update tab
  5. Select the object XYZ for which you want to update data
  6. Select Next
  7. Browse for the file
  8. Select Upload
  9. Choose Next to review the summary of your selection
  10. Select Import
  11. Go to Monitor view to check the status of your import

Keywords

Upload Failed, Validate CSV Headers With Fields of the Object, Upload Error , KBA , upload failed , validate csv headers with fields , LOD-CRM-INT-DWB , Data Workbench , How To

Product

SAP Cloud for Customer add-ins all versions