Show TOC

CSV String to ESP Formatter Module ConfigurationLocate this document in the navigation structure

The CSV String to ESP formatter translates CSV strings to AepRecord objects. Set values for this formatter in the adapter configuration file.

This formatter is row-based and can connect two row-based transporters rather than stream-based transporters.
XML Element Description
ExpectStreamNameOpcode

Type: boolean

(Required) If set to true, the adapter interprets the first two fields of the incoming CSV line as stream name and opcode respectively. The adapter discards messages with unmatched stream names.

The accepted opcodes are:
  • i or I: INSERT
  • d or D: DELETE
  • u or U: UPDATE
  • p or P: UPSERT
  • s or S: SAFEDELETE

The default value is false.

Delimiter

Type: string

(Advanced) The symbols used to separate the column. The default value is a comma (,).

HasHeader

Type: boolean

(Advanced) Determines whether the first line of the file contains field descriptions. Default value is false.

SecondDateFormat

Type: string

(Advanced) The format string for parsing SecondDate values.

For example, yyyy-MM-dd'T'HH:mm:ss is the default value.

MSDateFormat

Type: string

(Advanced) Format string for parsing MsDate values.

For example, yyyy-MM-dd'T'HH:mm:ss.SSS is the default value.