SAP Knowledge Base Article - Public

3286641 - Invalid Boolean value in row N

Symptom

We are receiving the following error messages while importing the contact in the Data File Load app via CSV.

  • Boolean value in row N is invalid (attribute IS_CONSUMER value N)
  • Boolean value in row N is invalid (attribute IS_CONTACT value Y)

Note: N indicates the Row Number

Environment

  • SAP Marketing Cloud Edition

Reproducing the Issue

  1. Go to Import Data App
  2. Select Data File Load App
  3. Select Contacts object
  4. Upload the CSV file

Cause

The issue occurs because the Boolean values in the CSV file are not correctly formatted.

Resolution

  1. To pass FALSE to a field, leave the column BLANK, i.e., no need to use any character for FALSE notation.
  2. TRUE: 'X'
  3. FALSE: [placeholder for image]
  4. Recommendation: For a Yes enter an X in the EXCEL sheet and for a No leave the value empty.

See Also

Refer to related KBAs for more information.

Keywords

Data file load, Import Data, Boolean value, Contacts Import, Consumer Import , KBA , CEC-MKT-DM-IC , Interaction Contact , Problem

Product

SAP S/4HANA Cloud 2208