Show TOC

Socket CSV Input Adapter Studio PropertiesLocate this document in the navigation structure

Adapter type: toolkit_socket_csv_input. Set these properties for the Socket CSV Input adapter in the ESP Studio adapter properties dialog. The Socket CSV Input adapter uses SimpleDateFormat formatting codes.

If you use the CCL ATTACH ADAPTER statement to attach an adapter, you must supply the adapter type.

Property Label Description
Server

Property ID: host

Type: string

(Required) Server host name.
Port

Property ID: port

Type: int

(Required) Server port. To read from the Ephemeral Port File, set to -1.
Ephemeral Port File

Property ID: epFile

Type: filename

(Advanced) File that will contain the server port number if Port is -1. If sandboxing is enabled, this file must reside in the <sandbox-base-directory>/adapters/<workspace-name> or $STREAMING_HOME/adapters/framework directory or one of their subdirectories. If the file is in a different location, the adapter will not be able to successfully connect to Event Stream Processor.

Has Header

Property ID: csvHasHeader

Type: boolean

(Advanced) Indicate whether the first line of the file contains the description of the CSV fields.
Retry Period (seconds)

Property ID: retryperiod

Type: uint

(Advanced) Period for trying to re-establish an outgoing connection.
Buffer Size

Property ID: inputBufferSize

Type: uint

(Advanced) The buffer size of the socket connection (bytes).
Enable TCP keepalive

Property ID: keepAlive

Type: boolean

(Advanced) Enable TCP keepalive on the socket connection.
Charset Name

Property ID: charsetName

Type: string

(Advanced) Specify the name of a supported charset.
Column Delimiter

Property ID: csvDelimiter

Type: string

(Advanced) Specify the symbol used to separate the columns.
SecondDate Format

Property ID: csvSecondDateFormat

Type: string

(Advanced) Specify the format for parsing seconddate values.

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

Property ID: csvMsDateFormat

Type: string

(Advanced) Specify the format for parsing msdate values.

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

Property ID: csvTimeFormat

Type: string

(Advanced) Specify the format for parsing time values.

For example, HH:mm:ss is the default value.
Has Header

Property ID: csvHasHeader

Type: boolean

(Advanced) Indicate whether the first line of the file contains the description of the CSV fields.
Stream name, opcode expected

Property ID: csvExpectStreamNameOpcode

Type: boolean

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

PropertySet

Property ID: propertyset

Type: string

(Advanced) Specifies the name of the property set. Property sets are reusable sets of properties that are stored in the project configuration file. Using these sets allows you to move adapter configuration properties out of the CCL file and into the CCR file. If you specify the same properties in the project configuration file and the ATTACH ADAPTER statement, the values in the property set override the values defined in the ATTACH ADAPTER statement. No default value.