Data import options

The Data import options allow you to configure how the CSV file is imported. The options are grouped into three categories: General, Date and number formatting, and Error handling.

General

Name	Description
File encoding	The encoding that the file was generated with. The default is UTF 8. Note that if the encoding is incorrect, the file will appear empty. No data will be imported, and no errors will be raised.
Delimiter	The delimiter that separates the fields on each row. By default, the delimiter will be auto detected, but you can specify the delimiter explicitly if we fail to detect the correct delimiter.
Quote character	The character used to quote fields. The default value is " (double quote).
Escape character	The character used to handle special characters (like commas, line breaks, or quotes) within a field, ensuring they aren’t mistaken for delimiters or other CSV structure. By default, the system uses the standard CSV format (RFC 4180), which wraps fields in double quotes and doubles any quotes inside a field (e.g., " becomes "") instead of using a separate escape character. You can explicitly choose a double quote (") or backslash () if your CSV file uses one of these to escape special characters.
Validate data types	When this property is enabled, the field values from the file is validated against the data types specified in the Column mappings. If the validation fails, and error handling is set to Log and continue, the record will be stored in the BadData collection. If you only import string (text) values, enabling this property has no effect because all fields values are text by default.
Empty records	Specifies whether or not empty records in the file are skipped.

Date and number formatting

Name	Description
Locale	Specifies the default locale used for parsing dates and numbers (which means converting text to dates or numeric values).
Date / DateTime format	Specifies one or more format strings for parsing text to date or datetime. You can use this option to override the default datetime format string used by the selected Locale, or add additional datetime format strings using a semi-colon separated list, for example yyyy.MM.dd; dd.MM.yyyy; yyyy.MM.ddThh:mm:ss. The most commonly used format strings are: yyyy-MM-dd yyyy.MM.dd yyyy/MM/dd dd.MM.yyyy yyyy-MM-ddThh:mm:ss For more details and examples, please refer to the .NET documentation for custom date and time format strings
Number decimal separator	Specifies the decimal separator. The default value is . (period)
Number group separator	Specifies the number group separator. The default value is , (comma). Examples of numbers using whitespace or comma group separators are 100 000 and 100,000.

Error handling

Name	Description
Bad data	Specifies what happens when bad data is detected. Fail import: Execution of the action fails by throwing an exception. Log and continue: The field(s) with bad data is added to the BadData collection and the row is skipped.
Missing fields	Specifies what happens when a row with missing fields are detected. Fail import: Execution of the action fails by throwing an exception. Log and continue: The field(s) with bad data is added to the BadData collection and the row is skipped.