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