MultipleFileCreatorUnit

Group

Integration Units

Class name

com.ebd.hub.datawizard.iu.MultipleFileCreatorUnit

Function

This unit is able to create several different files from the destination data and pack them into a ZIP archive.

Description

Introduction: Integration Units.

The MultipleFileCreatorUnit is able to create several different files from the destination data and pack them all into a ZIP archive. To do so, each destination node is assigned to a particular output file by setting a distinct Integer value (> 0) in each node's Optional Settings attribute. Nodes having the same value for the Optional 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 Optional Settings attributes.

Parameter Description

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: 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).

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).

Hints:

  • 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.