Adapter type: dsv_out. The File CSV Output adapter writes data as a file in Event Stream Processor delimited format.
The file does not require a header. If the file includes a header, it specifies the field names. This adapter does not support schema discovery.
If you use the CCL ATTACH ADAPTER statement to attach an adapter, you must supply the adapter type.
| Property Label | Property ID | Type | Description |
|---|---|---|---|
| Directory | dir | directory | (Required) Specify the absolute path to the data files you want the adapter to read. For example, <username>/<folder name>. No default value.Use a forward slash for both UNIX and Windows paths. |
| File (in Directory) | file | tables | (Required) File to which the adapter writes data. No default value. |
| Include Base Content | outputBase | boolean | (Optional) Records the initial contents of the stream, not just the updates. Default value is false. |
| Only Base Content | onlyBase | boolean | (Optional) Sends a one-time snapshot of initial contents in a stream. Default value is false. |
| Prepend StreamNameOpcode | prependStreamNameOpcode | boolean | (Optional) If true, each merge starts the stream name and the opcode. 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. |
| Directory (runtime) | runtimeDir | runtimeDirectory | (Advanced) Location of the data files at runtime, if different from discovery time. No default value. |
| File Pattern | filePattern | string | (Advanced) Pattern used to look up files for discovery. Default value is *.csv. |
| Date Format | dateFormat | string | (Advanced) Format string to parse data values. Default value is %Y-%m-%dT%H:%M:%S. |
| Timestamp Format | timestampFormat | string | (Advanced) Format string to parse timestamp values. Default value is %Y-%m-%dT%H:%M:%S. |
| Field Mapping | permutation | permutation |
Mapping between Event Stream Processor and external fields, for example: <esp_columnname>=<database_columnname>:<esp_columnname>=<database_columnname>. No default value. |
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. |