MultipleFileCreatorUnit

Class name

com.ebd.hub.datawizard.iu.MultipleFileCreatorUnit


This Integration Unit is able to create several different files from the target data and pack them all into a ZIP archive. To do so, each target node is assigned to a particular output file by setting a distinct Integer value (> 0) in each node's "Opt. settings" attribute. Nodes having the same value for the "Opt. settings" attributes belong to the same output file. The Integration Unit's parameter "File name bindings" has to assign a filename (and other parameters, see below) to each existing integer value appearing in "Opt. settings" attributes.

Parameters


Parameter name

Allowed values

Default value

Description

CSV&FixRecord: line break (0=\r\n, 1=\n, 2=\r)

0, 1, 2

0

Specifies the type of line breaks in CSV and FixRecord files.

CSV&FixRecord: no linebreak at end

true, false

true

If true, no line break is added at the end of the file (mandatory).

CSV: always quote data

true, false

false

If true, each value is enclosed in quotes (mandatory).

CSV: delimiter char


,

The field delimiter character for CSV files.

CSV: do not quote data at all

true, false

false

If true, no values are quoted at all (and parameters CSV: always quote data a nd CSV: only quote alphanumeric data are ignored).

CSV: only quote alphanumeric data

true, false

false

Only values of string fields are quoted (mandatory). Please note the hints below.

CSV: quote char


"

The quote character.

CSV: write content Excel conform

true, false

false

Produces an Excel compliant CSV file (mandatory).

CSV: suppress header creation

true, false

true

If true, no header is created.

CSV: use normalized header names

true, false

true

If true, then a header field name field#3 becomes field.

Excel: sheet names (use semicolon to delim names)



Spreadsheet names in Excel, separated by semicolons.

File name bindings



This parameter is composed of tokens that are separated by the pipe delimiter |. Each token describes a single output file. Each token itself contains multiple values delimited by semicolons ; (for details see 'Notes on parameter "File name bindings"' below).

XML: with empty fields

true, false

false

Write XML elements for all fields, even if they are empty (mandatory).

XML: write empty mandatory fields

true, false

true

Write XML elements for mandatory fields, even if they are empty (mandatory).

Notes:

  • Certain parameters depend on the document type. In addition, there is also an interdependence of parameters. If for CSV documents the option CSV: only quote alphanumeric data is active, then the following options have no effects: CSV: write content Excel conform, CSV: always quote data and CSV&FixRecord: no linebreak at end.

  • If for file format Excel the file name suffix is .xlsx, the created file will be an XLSX file.

Notes on parameter "File name bindings"


The general structure of a token is:


<key>;<encoding>;<file format>;<file name>;<template>;<start row>;<start column>


Example:


1;8859_1;csv;file1.csv


Token component

Allowed values

Default value

Description

key



The attribute Optional Settings of the corresponding node.

encoding


8859_1

The file encoding.

file format

csv, excel, fixrecord, xml


The file format.

file name



The file name in the ZIP file.

template



Path to the template file. Necessary for XML, possible for Excel.

start row



Indicates in which row to start.

start column



Indicates in which column to start.