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
- Go to Import Data App
- Select Data File Load App
- Select Contacts object
- Upload the CSV file
Cause
The issue occurs because the Boolean values in the CSV file are not correctly formatted.
Resolution
- To pass FALSE to a field, leave the column BLANK, i.e., no need to use any character for FALSE notation.
- TRUE: 'X'
- FALSE: [placeholder for image]
- 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