Symptom
Using Data Workbench, you require to update any Indicator field of type Boolean to True or False. Therefore, you Export the object XYZ (where XYZ represents the object in Data Workbench)from the Export view and update the Indicator field value to T or F (where T represents True and F represents False). On uploading the file in the Update view, system throws the error:
Cannot import the data file. Please correct the following errors:
CSVHeader: PQRIndicator (where PQRIndicator represents the column header of the Indicator field)
Error Information: Invalid boolean type entered
Correct format - Valid boolean values are true/false, TRUE/FALSE or X/""
Environment
SAP Hybris Cloud for Customer
Reproducing the Issue
- Login to the HTML5 client
- Go to Data Workbench workcenter
- Go to Export tab
- In the search field, select the object XYZ
- Select Data
- Select field
- Select Next
- Export Data
- Go to the Monitor tab
- Download the exported file
- Update the field Sales Support Block with T or F
To Upload the file:
- Login to the HTML5 client
- Go to Data Workbench workcenter
- Go to the Import tab
- Select the radio button Individual Objects
- Go to the Update tab
- Select the object XYZ
- Select Next and Browse for the file
- Select Upload
- Choose Next
System throws error regarding Boolean type.
Cause
1. You entered the values T or F
or
2. You left the Boolean field empty
Resolution
Data Workbench accepts Boolean types as True/False or X/" ". If the field is mandatory then ensure that you provide the input.
Keywords
Boolean, Indicator, Boolean type , KBA , boolean , indicator , boolean type , LOD-CRM-INT-DWB , Data Workbench , How To