3399376 - Error “Invalid Boolean Value” When Importing Data

Error to import data via Data Import tool:

{Entity Name}: Invalid boolean value in field {field name} in row {number}, externalId {X} The expected date format is true/false.

• SAP Service Cloud v2
• SAP Sales Cloud v2

1. Click on the profile button.
2. Select Settings.
3. Go to All settings.
4. Open Monitoring (Data Import and Export) screen.
5. Click on the import button.
6. Fill the details and click on import.
7. Error: {Entity Name}: Invalid boolean value in field {field name} in row {number}, externalId {X} The expected date format is true/false.
8. Note: This error can occur with any entity which has boolean fields.

Invalid data for boolean field.

Please use the following formats for boolean fields:

• true
• True
• TRUE
• false
• False
• FALSE

Help Documentation: Prepare Data

Import, Boolean, True, False, CSV, Excel , KBA , CEC-CRM-IMX , Data Import/Export for SAP Sales/Service Cloud , How To