Adapter type: dsv_sockout_in. The Socket (as Client) CSV Input adapter receives data in delimited format from outgoing network adapters.
The adapter initiates the connection to an external datasource, and an external program sends out the data. The data does not require a header (accepted by esp_convert). If the file includes a header, the header specifies the field names.
If you use the CCL ATTACH ADAPTER statement to attach an adapter, you must supply the adapter type.
1. hasHeader=true delimiter=, expectStreamNameOpcode=false Ts,ItemID,Price,Quantity,WarehouseZipCode,DeliveryZipCode 2004/06/17 10:00:00.000000,SKU1276532,50.00,1,10012,94086 2004/06/17 10:00:05.000000,SKU6723143,23.00,2,10012,94043 2. expectStreamNameOpcode=true delimiter=, Trades_in,i,2004/06/17 10:00:00.000000,SKU1276532,50.00,1,10012,94086 Trades_in,i,2004/06/17 10:00:05.000000,SKU6723143,23.00,2,10012,94043 3. expectStreamNameOpcode=false timestampFormat=%Y/%m/%d %H:%M:%S delimiter=, 2004/06/17 10:00:00.000000,SKU1276532,50.00,1,10012,94086 2004/06/17 10:00:05.000000,SKU6723143,23.00,2,10012,94043
| Property Label | Property ID | Type | Description |
|---|---|---|---|
| Server | host | string | (Required) Server host name. Default value is localhost. |
| 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 adapter interprets the first two fields as a stream name and opcode respectively. Adapters discard messages with unmatched stream names. Default value is false. |
| Field Count | fieldCount | uint | (Optional) Counts the number of fields in a CSV file, if different from the source stream. Default value is 0. |
| 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) File that contains the server port number, if Port is -1. No default value. |
| Retry Period | retryperiod | uint | (Advanced) Period for trying to re-establish an outgoing connection. In seconds. Default value is 1. |
| Enter Initial State | initial | choice | (Advanced) 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. Converts DELETE to SAFEDELETE. Default value is false. |
| Skip Deletes | skipDels | boolean | (Advanced) Skips the rows with opcodes DELETE or SAFEDELETE. Default value is false. |
| Timestamp Format | timestampFormat | string | (Advanced) Format string for parsing timestamp values. Default value is %Y-%m-%dT%H:%M:%S. |
| Date Format | dateFormat | string | (Advanced) Format string for parsing date values. Default value is %Y-%m-%dT%H:%M:%S. |
| Block Size | blockSize | int | (Advanced) Determines number of records to block into one pseudo-transaction. Default value is 1. |
| Field Mapping | permutation | permutation |
Mapping between Event Stream Processor and external fields, for example: |
PropertySet |
propertyset | string | (Advanced) Specifies the name of the property set 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: