Export allocation object to metering point

Project medium

Specifies a project medium for which the data is to be exported.

OBIS list

Defines the OBIS identifiers of the selected medium that are to be exported.

Minimum status

Selection – Defines the minimum measured value status for a value. If the status is worse than that stated here, no processing will take place.

Time range

Selection

• Daily: Runs each day from the start date to the end date.
• Monthly: Runs each month, starting on the first day of the month containing the start date.
• Annually: Runs each year, starting on 1 January of the start-date year.

Time span

Selection – Defines how the time span for the action is set.

• Cumulative: The time between the last execution and the time of the current execution.
• Specific: Specify the start and end times precisely.

Last [Export / Calculation] date

The timestamp of the record processed by the last successful operation. Only active if “Latest” is selected as the time span.

Target metering point

Defines a metering point at which the data is to be stored. The measured variable is determined automatically by the selected OBIS identifier.

Time span

Defines how the time span of the action is determined.

• Latest: The time elapsed between the last record and the time of execution.
• Complete: The entire time span, starting from the timestamp of the first record.
• Number of days: Full days in the past, counting from the time of execution.
• Time range: Specify the start and end times precisely.

Last [Export / Calculation] date

The timestamp of the record processed by the last successful operation. Only active if “Latest” is selected as the time span.

Directory

• Disabled or SMB share
• Path to the directory (optional)
• Server
• Share
• Authentication
• SMB version
• Transport type
• Authentication method

Disabled / SMB share

Selection

• Disabled – No output directory
• SMB share – Requires details of the shared directory.

Path to the directory

Text (optional) – Path

Server

Text / IP address – FQDN – name or IP address

Share

Text – Name of the share

Authentication

• Anonymous – No user account required
• Domain (optional) – Name of the share domain
• Username – Name of the user with access to the share
• Password – Password of the user with access to the share

SMB version

Can usually be left at the default setting

• 3.1.1 (Default)
• 2.0

Transport type

• Direct over TCP
• NetBIOS over TCP

Authentication method

• Detect automatically (default)
• NTLM V2
• NTLM V1 with enhanced security
• NTLM V1

Target folder

Selection – Select the visual energy folder in which to save the output file.

File name

Text – Specify the name of the output file (without a suffix such as .txt or .pdf).

Note:In workflows that export multiple intervals to separate files during a run, use the “Automatic file name generation” option instead of specifying the file name manually. Otherwise, specifying a file name will result in the generated output file containing only the values from the last time interval.

Email recipient list

Text – Specifies the recipients to whom the email should be sent. Recipients can be separated by semicolons.

Output format

Selection

• CSV – Output as a CSV file
• PDF – Output as a PDF file

Delimiter

Selection

• Semicolon
• Tab

Ignore zero values

Yes / No – When enabled, no data with a value of zero are output.

Table header / header row

Yes / No

• Output parameter: Should the output include a table header (column headings)?
• Input parameter: Does the table have a table header (column headings)?

Flat export

Yes / No – Specifies whether the export includes only the assignments to the metering points (for compatibility with version 4.6.6).

List of fields

Selection – Select the fields for output. Different formats are available for dates and numbers.

• N0–N3 specify the number of decimal places in the number format (e.g. N3: 32.452).
• For S1–S3, the number is displayed with the relevant decimal places, but without any separators (e.g. S3: 32452).
• For some fields, a fixed character length of between 1 and 100 can be defined. If the value is shorter, spaces are added to make up the length; if it is longer, it is truncated to the defined character length. The variable “Value” is an exception. For this variable, the specified character length is achieved using leading zeros. The default value of 0 means that the length of the field is not changed.

The fields:

• MP (ID)
• Start (local)
• End (local)
• Value
• Unit
• Status
• OBIS (code, short)
• OBIS (name, short)
• OBIS (code, long)
• OBIS (name, long)
• MP (name)
• MP (number)
• MP (installation location)
• MP (GUID)
• Location (name)
• Time zone (ID)
• Time zone (display name)
• Time zone (standard name)
• Time zone (base UTC offset)
• Start (UTC)
• End (UTC)
• Constant 1
• Constant 2
• Constant 3
• Constant 4
• Constant 5

Success trigger

Trigger – Specifies the trigger that is executed once the workflow has completed successfully.

Error trigger

Trigger – Specifies the trigger that is executed when the workflow ends with an error.