Socket (As Server) CSV Input Adapter

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. The type for this adapter is dsv_sockin_in.

Property Label Property ID Type Description
Port port 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 expectStreamNameOpcode 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 delimiter string (Advanced) Symbol used to separate the columns. Default value is a comma ( , ).
Has Header hasHeader boolean (Advanced) Determines whether the first line of the file contains the description of the fields. Default value is false.
Ephemeral Port File epFile filename (Advanced) The file that contains the server port number, if port is -1.
Initial Listen Period (seconds) retryperiod uint (Advanced) How long to wait for the first incoming connection before switching to the continuous state. Default value is 0.
Enter Initial State initial choice (Advanced) Indicates when the adapter enters the initial loading state. Default value is never.
Convert to Safe Opcodes safeOps boolean (Advanced) Converts the opcodes INSERT and UPDATE to UPSERT, and DELETE to SAFEDELETE. Default value is False.
Skip Deletes skipDels boolean (Advanced) Skips the rows with opcodes DELETE or SAFEDELETE. Default value is false.
Date Format dateFormat string (Advanced) The format string for parsing date values. Default value is %Y-%m-%dT%H:%M:%S.
Timestamp Format timestampFormat string (Advanced) The format string for parsing timestamp values. Default value is %Y-%m-%dT%H:%M:%S.
Block Size blockSize int (Advanced) The number of records to block into one pseudo-transaction. Default value is 1.
Field Mapping permutation permutation (Advanced) Mapping between the in-platform and external fields. No default value.

PropertySet

propertyset string

(Advanced) Specifies the name of the property set (a group of properties and values) you want to use from the project configuration 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.