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.

When this field is in use, it is important to input a field reference(s) in the File Name field to create unique file names.

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.