Symptom
Your requirement is to upload data for any object using Data Workbench. Upon uploading the file in the Import view in Data Workbench workcenter, system throws error:
Upload error: Use UTF-8 encoded CSV File
Environment
SAP Cloud for Customer
Reproducing the Issue
- Go to Data Workbench workcenter
- Go to Import view
- Select the radio button for Individual Object
- Go to Import tab
- Go to Standard Object tab or Custom Object tab
- Search for the Data Workbench object XYZ (where XYZ represents any object in Data Workbench)
- Select the button Download Comma Separated Values (.csv) to download the template
- Fill the required data in the file
- Select Browse and go to the file location
- Select the file and select Open
- Select Upload
- System throws the mentioned error
Cause
The upload .csv file is not in UTF-8 encoding. There may be characters with umlauts and other special characters (example à, ê, ñ, ó, ï, Ð, ß, etc.) in the upload file.
Resolution
Download the system delivered .csv templates for the Data Workbench objects. Fill data in the templates and use a csv editor to open a .csv file that uses UTF-8 character encoding.
For example, you may use Notepad++ to edit the CSV file by following the below steps:
- Save the csv file on your system
- Right click on the csv file and select Edit with Notepad++
- Select Encoding and select Convert UTF-8-BOM
- Save the file on Menu->File->Save as
- Provide a name for the file and add the extension .csv (Example: filename.csv)
- Upload this file in the Import view in Data Workbench
Note:
You may use any csv editor software which is approved by your organization/IT.
Keywords
Data Workbench, UTF-8 , Upload error, csv file , KBA , csv file , upload error , data workbench , utf-8 , special characters , LOD-CRM-INT-DWB , Data Workbench , Problem