GZIP CSV Input
Description
GZIP CSV Input is a step in the Input Plugin for Process Studio Workflows. This step is similar to CSV file input step. It is used to read data from a delimited file in compressed format. The GZIP CSV Input step does not have the provision for error handling in the step.
Configurations
| No. | Field Name | Description |
|---|---|---|
| 1 | Step Name | Specify the name of the step. This name has to be unique in a single workflow. |
| 2 | Filename OR The filename field (data from previous steps) | Specify the name of the GZIP CSV file to read from. Or Select the fieldname that will contain the filename(s) to read from. If this step receives data from a previous step, this option is enabled as well as the option to include the filename in the output. |
| 3 | Delimiter | Specify the file delimiter character used in the target file. Special characters (e.g. CHAR HEX01) can be set with the format $[value], e.g. $[01] or $[6F,FF,00,1F]. |
| 4 | Enclosure | Specify the enclosure character used in the target file. Special characters (e.g. CHAR HEX01) can be set with the format $[value], e.g. $[01] or $[6F,FF,00,1F]. |
| 5 | NIO buffer size | Specify the size of the read buffer. It is the number of bytes read from the disk at one time. |
| 6 | Lazy conversion | The lazy conversion algorithm tries to avoid unnecessary data type conversions. This could result in significant performance improvements if possible. |
| 7 | Header row present? | Enable this option if the target file contains a header row containing column names. |
| 8 | Add filename to result | Enable checkbox to adds the filename(s) read to the result of the workflow. Filenames in result is a unique list being kept in memory that can be used in the next steps or parent workflow steps or parent process entries. |
| 9 | The row number field name (optional) | The name of the Integer field that will contain the row number in the output of this step. |
| 10 | Running in parallel? | Check this box if you will have multiple instances of this step running (step copies) and if you want each instance to read a separate part of the file(s). |
| 11 | File Encoding | Specify the encoding of the file being read. |
| 12 | Fields Table | This table contains an ordered list of fields to be read from the file. |
| 13 | Preview button | Click to preview the data coming from the target file. |
| 14 | Get Fields button | Click to get all the fields from the file based on the current settings (i.e. Delimiter, Enclosure, etc.). All fields identified will be added to the Fields Table. |