CSV importer Properties

This topic lists the properties of CSV importer.

Sample File Path

Specifies the path to the file to use for detecting and evaluating the schema structure.

Sample Row Limit

Specifies the number of rows to process in the specified sample file when detecting and evaluating the schema settings.

Has Header

Indicates the first line in the data is header line when it is set to true.

Logging

Specifies the level of logging to use. The default is Off. The value Informational means log informational, the value Errors Only means log error messages only, and the value Verbose means log debug and trace level messages along with the informational and error messages.

Format

Specifies the data format. Default is Strict CSV. The other data format is Custom.

Line Break

Specifies the line break (end of the line). Default is CR LF (Carriage Return Line Feed). Other options are as follows:
  • LF: Line Feed
  • CR: Carriage Return
  • Newline: Platform Specific

Delimiter

Specifies the field delimiter. Default is Comma. Other options are as follows:
  • Pipe
  • Colon
  • Semicolon
  • Exclamation Mark
  • Equals Sign
  • Tilde
  • Space
  • Tab
  • Null
  • Custom

Quote

Specifies the enclosing character. Default is Double Quote. Other options are Single Quote and None.

Escape

Specifies the escape release character. Default is Double Quote. Other options are as follows:
  • Backslash
  • Exclamation
  • Single Quote
  • Null
  • None
  • Custom