CSV Formatter
The CSV Formatter node writes a data group CSV formated to the out port.
Configuration
Basic
General
- Time Zone
The timezone to be used for writing timestamps.
- Filename Format
This is the format of the filename. In this string you can use the variable
{Timestamp}to use the value of the end timestamp of the data group. It is posible to format the timestamp using a format string ({Timestamp}:<format string>). For formating the timestamp value see Standard date and time format strings and Custom date and time format strings.Default: File_{Timestamp:yyyyMMddHHmm}.txt
CSV Format
- Column Seperator
The character used to seperate the columns.
Default: ;
- Write CSV Header
If enabled a header will be written.
Default: disabled
Fields
Here you can specify the columns to be written file using the Enabled parameter. The order of the columns can be changed by setting the Column Index.
Signal Name
This writes the name of the signal.
- Enabled
If enabled this field will be written.
Default: checked
- Column Index
The zero based column index in the CSV file.
Default: 0
- Header Name
The value of the header to be written if Write CSV Header is enabled.
Default: Signal Name
Timestamp
This writes the timestamp of the datapoint.
- Enabled
If enabled this field will be written.
Default: checked
- Column Index
The zero based column index in the CSV file.
Default: 1
- Header Name
The value of the header to be written if Write CSV Header is enabled.
Default: Timestamp
- Timestamp Format
The format to use for writing timestamps. For formating the timestamp value see Standard date and time format strings and Custom date and time format strings.
Default: yyyyMMddHHmmss
Value
This writes the value of the datapoint.
- Enabled
If enabled this field will be written.
Default: checked
- Column Index
The zero based column index in the CSV file.
Default: 2
- Header Name
The value of the header to be written if Write CSV Header is enabled.
Default: Value
- Decimal Seperator
The character used as the decimal point when writing numeric values.
Default: .
Quality
This writes the quality of the datapoint.
- Enabled
If enabled this field will be written.
Default: checked
- Column Index
The zero based column index in the CSV file.
Default: 3
- Header Name
The value of the header to be written if Write CSV Header is enabled.
Default: Quality
- Quality Good Value
The string that will be written if the quality is good.
Default: 1
- Quality Bad Value
The string that will be written if the quality is bad.
Default: 0
Read Timestamp
This writes the timestamp when the datapoint was read from the source.
- Enabled
If enabled this field will be written.
Default: unchecked
- Column Index
The zero based column index in the CSV file.
Default: 5
- Header Name
The value of the header to be written if Write CSV Header is enabled.
Default: Read Timestamp
- Timestamp Format
The format to use for writing timestamps. For formating the timestamp value see Standard date and time format strings and Custom date and time format strings.
Default: yyyyMMddHHmmss
Write Timestamp
This writes the timestamp when the datapoint was written to the source.
- Enabled
If enabled this field will be written.
Default: unchecked
- Column Index
The zero based column index in the CSV file.
Default: 4
- Header Name
The value of the header to be written if Write CSV Header is enabled.
Default: Write Timestamp
- Timestamp Format
The format to use for writing timestamps. For formating the timestamp value see Standard date and time format strings and Custom date and time format strings.
Default: yyyyMMddHHmmss
UOM
This writes the unit of measurement of the signal.
- Enabled
If enabled this field will be written.
Default: unchecked
- Column Index
The zero based column index in the CSV file.
Default: 6
- Header Name
The value of the header to be written if Write CSV Header is enabled.
Default: UOM
Signals
Define the signals to write to the CSV file.
- Flow Name
The name of the signal in the incomming data group.
- CSV Name (Optional)
The name of the signal in the file. If this field is empty the CSV Name is the same as the Flow Name.
- Match Type
How to match the name of the signal in the incomming data group.
- Full Name
Matching the incomming signal name with the Flow Name.
- Wild Card
Matching the incomming signal name with the Flow Name allowing windcarts (
*and?).- Regular Expression
Matching the incomming signal name with a regular expression specified in the Flow Name. For an overview of the regular expression language see the Microsoft Docs. The regular expression options
Singlelineare used.
Default: Full Name