Maropost Marketing Cloud will validate the data types in your import file to ensure proper matching with the data types defined for each column in your relational table.

If a record in your data file does not have the proper matching data type, then it will not be imported.

The rules are as follows:

Relational Table Data Type Import File Data Type Result
Integer Integer, Float Accept
Integer String, Boolean, Date/Time Reject
Boolean True/False, Yes/No, 1/0 Accept
Boolean String, Boolean, Date/Time, Integer, Float Reject
Float Integer, Float Accept
Float String, Boolean, Date/Time Reject
Date/Time Date/Time Accept
Date/Time String, Boolean, Integer, Float Reject