CSV Writer
The CSV Writer transform writes a dataset to a specified Character Separated Value (CSV) file.
Transform > File Layout
The file layout tab is where the details for the creation of the file - such as its target, line and field delimiters - are configured.
Transform Id
The unique user-defined name for the transform.
Data Source
The controller type is defined here. This is the source from where the CSV data will be written, which can be Email, File or Http.
See Input/Output Controllers (IO Controller) for more information.
Controller Options
This is the expandable options section beneath the Data Source drop-down. These options change according to the data source selected.
See Input/Output Controllers (IO Controller) for more information.
Field Delimiter
The character(s) used to separate each of the fields within a record line.
The delimiter may be 1 or more characters.
For tab delimited files enter ‘\t’.
Line Delimiter
The character(s) to separate each record line.
The line delimiter is selected from a fixed list of:
Name |
Character(s) |
Unicode Value |
---|---|---|
Windows |
CRLF |
U+000D & U+000A |
Unix |
LF |
U+000D |
Mac (up Os 9) |
CR |
U+000A |
Form Feed |
FF |
U+000C |
Next Line |
NEL |
U+0085 |
Paragraph Separator |
PS |
U+2029 |
Line Separator |
LS |
U+2028 |
Quote String Fields
Controls how double quotes (“) are placed around any Text data type fields.
- No Quotes
- No quotes will be placed around any Text fields
- Quote And Escape
- Places quotes around any Text fields. If the field value itself contains a double quote, the double quote will be 'escaped' by replacing it with two double quotes.
- Quote Do Not Escape
- Places quotes around any Text fields. A field containing a double quote will not be escaped.
Write Header Rows
When selected will write out the field names at the start of the file.
Hierarchical datasets will produce a separate line of headers, one for each transaction type.
If no fields are selected to export for the transaction type (in field mapping below), the header record will not be written.
Create File When No Data
When set to true will create a file irrespective of whether there is an empty dataset. When there’s an empty dataset the created file will only include field headers.
Generate File Per Transaction
When a transaction Id is selected here, a file will be generated for each instance of that transaction, e.g. if an invoice transaction is selected, a file will be created for every invoice generated.
When the field is left blank a single file containing the whole dataset will be created.
Transform > Field Mapping
Current Transaction Id
The transaction type being edited.
Field Name
The field name within IMan.
Export
When set to True, field will be included in resultant file.
Field Heading
The Field Header if fields heading are exported.
Up/Down Arrows
Used to control the ordering of the fields within the file.
Top record will become first on the left of grid in Preview screen.