FileDataFormat

FileType

Recognized file formats are:

  • CSV for Delimited
  • FIX for Fixed Record
  • DIF for Data Interchange Format
  • _EXCELBIFF for Microsoft Excel (XLS)
  • _EXCELOOXML for Microsoft Excel (XLSX)
  • HTML for HTML
  • QVD for QVD file
  • XML for XML
  • QVX for QVX file
  • JSON for JSON format
  • KML for KML file



Properties

Name Description Type
qType

Type of the file.

One of:

  • CSV or FILE_TYPE_CSV
  • FIX or FILE_TYPE_FIX
  • DIF or FILE_TYPE_DIF
  • EXCEL_BIFF or FILE_TYPE_EXCEL_BIFF
  • EXCEL_OOXML or FILE_TYPE_EXCEL_OOXML
  • HTML or FILE_TYPE_HTML
  • QVD or FILE_TYPE_QVD
  • XML or FILE_TYPE_XML
  • QVX or FILE_TYPE_QVX
  • JSON or FILE_TYPE_JSON
  • KML or FILE_TYPE_KML
 String
qLabel

One of:

  • Embedded labels (field names are present in the file)
  • No labels
  • Explicit labels (for DIFfiles)
 String
qQuote

One of:

  • None (no quotes)
  • MSQ (Modern Style Quoting)
  • Standard (quotes " " or ' ' can be used, but only if they are the first and last non blank characters of a field value)

This property is used for delimited files.

 String
qComment

String that marks the beginning of the comment line. Example: “#” or “//” The engine ignores the commented lines during the data load. This property is only used for delimited files.

 String
qDelimiter

Information about the delimiter. This property is used for delimited files.

 DelimiterInfo
qCodePage

Character set used in the file.

 Integer
qHeaderSize

Size of the header. Example: If the header size is 2, the first two rows in the file are considered as header and not as data. The header can contain the field names.

 Integer
qRecordSize

Record length. Each record (row of data) contains a number of columns with a fixed field size. This property is used for fixed record data files.

 Integer
qTabSize

Number of spaces that one tab character represents in the table file. This property is used for fixed record data files.

 Integer
qIgnoreEOF

Is set to true, the end-of-file character is not taken into account during reload. This property is used for delimited files and fixed record data files.

 Boolean
qFixedWidthDelimiters

Positions of the field breaks in the table. This property is used for fixed record data files.

 String