Show TOC

Socket (As Server) CSV Input AdapterLocate this document in the navigation structure

Adapter type: dsv_sockin_in. The Socket (As Server) CSV Input adapter receives data in Event Stream Processor delimited format from the incoming network adapters.

Another program initiates the connection and then sends the data to the adapter.

It is possible for the data not to have the header, or for the header not to specify the field names.

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

Property Label Description
Port

Property ID: port

Type: int

(Required) Server port. If port is set to -1, the adapter reads from the Ephemeral Port File. Default value is 12345.

Stream name, opcode expected

Property ID: expectStreamNameOpcode

Type: boolean

(Optional) If true, the first two fields are interpreted as stream name and opcode respectively. Messages with unmatched stream names are discarded. Default value is false.

Delimiter

Property ID: delimiter

Type: string

(Advanced) Symbol used to separate the columns. Default value is a comma ( , ).

Has Header

Property ID: hasHeader

Type: boolean

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

Ephemeral Port File

Property ID: epFile

Type: filename

(Advanced) The file that contains the server port number, if port is -1.

Initial Listen Period (seconds)

Property ID: retryperiod

Type: uint

(Advanced) How long to wait for the first incoming connection before switching to the continuous state. Default value is 0.

Enter Initial State

Property ID: initial

Type: choice

(Advanced) Indicates when the adapter enters the initial loading state. Default value is never.

Convert to Safe Opcodes

Property ID: safeOps

Type: boolean

(Advanced) Converts the opcodes INSERT and UPDATE to UPSERT, and DELETE to SAFEDELETE. Default value is False.

Skip Deletes

Property ID: skipDels

Type: boolean

(Advanced) Skips the rows with opcodes DELETE or SAFEDELETE. Default value is false.

SecondDate Format

Property ID: seconddateFormat

Type: string

(Advanced) The format string for parsing seconddate values. Default value is %Y-%m-%dT%H:%M:%S.

MsDate Format

Property ID: msdateFormat

Type: string

(Advanced) The format string for parsing msdate values. Default value is %Y-%m-%dT%H:%M:%S

.
Block Size

Property ID: blockSize

Type: int

(Advanced) Determines the number of records in each block. Applies to transaction and envelope modes. Default value is 1.

Use Envelopes

Property ID: useEnvelopes

Type: boolean

(Advanced) Specify the block type the adapter uses to pass data to the engine. If you specify a blockSize property greater than zero, by default, the adapter packages rows into transaction blocks to send to the engine. To get the adapter to package rows into envelope blocks instead, set this property to true. Default value is false.

Field Mapping

Property ID: permutation

Type: permutation

Mapping between Event Stream Processor and external fields, for example:

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.

Known limitations:
  • The stream name in the file rows is ignored.
  • All the data is sent to the same stream.
  • Supports only one network connection.