This website uses cookies to improve user experience. We assume that you agree. You can also object to the use. All relevant information and settings can be found here

Agree and continue
Suche:

Workflows

Zurück zur Übersicht

visual energy use Workflows for requesting and processing of energy data. They can be customized for every requirement with specific parameter.

  • With the button  the Editor for Workflow association can be opened. The button is in all target objects (Location, Meteringpoint, …) in the toolbar.
  • Usually a Workflow is intended for one or multiple Objects (Location, Location-medium), i.e. that the Workflow runs the the planned task in this target object.
  • A Workflow can be run either by manual, via Trigger or Schedule.
  • A Workflow can, optional and dependent on a event, trigger a trigger.
  • Workflows can be installed in the system, subsequently at every time. That’s why each Workflow contains a version-number. New Workflows can be downloaded here with this site and can be installed in the System configuration subsequently. Should a Workflow be edited, so it has to have a higher version.
  • There are specially administrative Workflows, whose are reserved for the system administrator.
  • In the System configuration can be created a PDF list of all used Workflows in the system, from the system administrator.
  • User defined Workflows are possible and can create by KBR.

List of all currently available Workflows


WorkflowVersionAvailable for
Absolute validation2.2OBIS measurement
Alternate value creation2.8OBIS measurement
Calculate degree day value for day2.1OBIS measurement
Calculation by formula2.2OBIS measurement
CO2 Calculation2.2OBIS measurement
Compress2.2OBIS measurement
Consistency check2.7Location/Location-Medium/Distributing-Plant/Meteringpoint
cos Phi2.1Meteringpoint
Create Dashboard PDF2.5Dashboards
Create permission matrix2.0System
CSV Data export (XML)2.8Documents
CSV Export3.6OBIS measurement
CSV Export (cost center/energy benefit)2.8Cost Center/Energy Benefit
CSV Import2.2OBIS measurement
Cumulated maximas2.2OBIS measurement
Data calculation (medium)2.5Medium
Data calculation (plant)2.3Distribution
Data compression (Energy feed)2.2OBIS measurement
Data compression (load profile)2.2OBIS measurement
Dayly cumulated values2.3OBIS measurement
Dayly sum values2.4OBIS measurement
Delete (older than)2.1OBIS measurement
Delete (time range)2.1OBIS measurement
Excel processor2.7Documents
Execute program2.0System
FTP download2.1System
Gas m³ to kWh2.3OBIS measurement
Hourly sum values2.2OBIS measurement
Limit monitoring2.1OBIS measurement
Load permission matrix2.0SystemDocument
Money calculation2.2OBIS measurement
Monthly sum values from load profile2.6OBIS measurement
MSCONS Export2.6OBIS measurement
OBIS Calculator2.2OBIS measurement
OBIS update2.1System
ORDERS (market location)2.0MarketLocation
ORDERS (metering point)2.0Meteringpoint
Project data generation2.1SystemDocument
Relative validation2.1OBIS measurement
Request data2.1OBIS measurement
Request data (Mobile)2.0OBIS measurement
Sends an e-mail2.2All
Simulation of energy storage2.2Meteringpoint
Switch switchgroup2.1Location
Transformer losses2.2Component
Update multisys_BM2.0Multisys
Weekly sum values2.4OBIS measurement
Writes setpoint values2.4OBIS measurement

Absolute validation

Back
            Version: 2.2  |  File: ValidateAbsolute.xaml  |  Act on: OBIS measurement
            Required user role:  PM | EDM | NDW | NDF 
Job: Monitors an adjustable fixed limit value for overshoot or undercut. Can send an e-mail, enable switch group 244 'Limit violation' and / or trigger a user-defined trigger.
Parameter:
Time range function
(optional)
Defines, how the time range for the validation will be set (number of days or specific timerange)
Days
(optional)
Defines, for how many days in the past the values will be validated
Timerange
(optional)
Defines, for which time range the values will be validated
Validation timespan
(required)
Interval
Limit value
(required)
Limit value
React if
(required)
Defines, if a validation will be determined by undercut or overflow.
Recipient list for e-mail
(optional)
Defines, to which recipients the e-mail will be sent.
Subject of the e-mail
(optional)
Defines the subject of the e-mail message.
Body of the e-mail
(optional)
Defines the body of the e-mail message.
Set switch group
(optional)
Defines if the switch group 244 'Combined fault limit violoation' should be set if any validation errors could be determined.
Finished trigger
(optional)
Defines the trigger which should be executed when the execution of the workflow finishes
Valid trigger
(optional)
Defines the trigger which should be executed when the validation could not determine any errors
Invalid trigger
(optional)
Defines the trigger which should be executed when the validation determined any errors
Requires / creates: nothing
Output
DownloadValidateAbsolute.zip
WF-Changes
05/12/2017, 2.0, Multi-Target workflows
07/24/2017, 2.1, Allow trigger "execute on receive data"
12/06/2018, 2.2, Reload MP-OBIS before setting full time range. Terminate Workflow if automation server settings are null"

Alternate value creation

Back
            Version: 2.8  |  File: CreateAlternateData.xaml  |  Act on: OBIS measurement
            Required user role:  PM | EDM | NDW 
Job: Creates load profile data from energy meter or energy feed values
Parameter:
Time range function
(optional)
Defines, how the time range for the alternate data creation will be set (number of days or specific timerange)
Days
(optional)
Defines, for how many days in the past the values will be calculated
Timerange
(optional)
Defines, for which time range the values will be calculated
Always overwrite values
(optional)
Defines if existing values should be overwritten by the new generated alternate values.
Finished trigger
(optional)
Defines the trigger which should be executed when the workflow was finished
Requires / creates:
006-001:000.130.000*255Wärme, Durchfluss, Lastgang
Output
DownloadCreateAlternateData.zip
WF-Changes
05/12/2017, 2.0, Multi-Target workflows
07/24/2017, 2.1, Allow trigger "execute on receive data"
08/18/2017, 2.2, Merge data before storing alternate values (avoid overwriting of original values)
08/22/2017, 2.3, Parameter TimeRangeChoice changed to type "TimeRangeChoices2" (+newest)
11/29/2017, 2.4, Fix: wrong creation of alternate values if interval of meter values is big (~30 days)
12/14/2017, 2.5, Fix: endless loop if interval of meter values is 1 minute
04/09/2018, 2.6, Update: New parameter ForceOverwrite
04/17/2018, 2.7, Update: Added requirements for medium heat (new OBIS + transformation)
12/19/2018, 2.8, Fix: endless loop if interval of meter values is 1/4h and target interval is 1h

Calculate degree day value for day

Back
            Version: 2.1  |  File: CalculateDegreeDayValue.xaml  |  Act on: OBIS measurement
            Required user role:  PM | EDM | NDW 
Job: Calculates for each day in timespan a degree day value. If the mean outside temperature is higher than heating swell, then this day is a non heating day and degree day value is zero. If the mean outside temperature is lower than heating swell, then this day is a heating day and degree day value is the difference between mean temperature and heating swell
Parameter:
Heating limit
(required)
Heating limit
Time range function
(optional)
Defines, how the time range for the calculation will be set (number of days or specific timerange)
Days
(optional)
Defines, for how many days in the past the values will be calculated
Timerange
(optional)
Defines, for which time range the values will be calculated
Finished trigger
(optional)
Defines the trigger which should be executed when the workflow was finished
Requires / creates:
000-000:134.132.000*255Gradtagszahl
Output
DownloadCalculateDegreeDayValue.zip
WF-Changes
05/30/2017, 1.1, Missing parameter OnFinished added in XAML-Workflow
05/12/2017, 2.0, Multi-Target workflows
12/06/2018, 2.2, Reload MP-OBIS before setting full time range"

Calculation by formula

Back
            Version: 2.2  |  File: CalculateFormula.xaml  |  Act on: OBIS measurement
            Required user role:  NDW 
Job: Calculates data using the formula and writes the results in current OBIS measure. The formula editor handles complex formulas and any meteringpoint can be used as datasource. The status processing uses the worst status of the sources for the result.
Parameter:
Formula
(required)
Mathematic formula
Time range function
(optional)
Defines, how the time range for the calculation will be set (number of days or specific timerange)
Days
(optional)
Defines, for how many days in the past the values will be calculated
Timerange
(optional)
Defines, for which time range the values will be calculated
Finished trigger
(optional)
Defines the trigger which should be executed when the workflow was finished
Requires / creates: nothing
Output
DownloadCalculateFormula.zip
WF-Changes
05/12/2017, 2.0, Multi-Target workflows
01/31/2018, 2.1, UPD: Calculated timerange for TimeRangeChoice=NumDays starts and ends at the full hour instead of full day
02/22/2018, 2.2, FIX: Timerange used if TimeRangeChoice=FullRange is read from target MP-OBIS. Use timerange of source MP-OBIS from formula

CO2 Calculation

Back
            Version: 2.2  |  File: CalculateCo2.xaml  |  Act on: OBIS measurement
            Required user role:  PM | EDM | NDW 
Job: Calculate the sum of CO2 for each period
Parameter:
CO2 weight
(required)
CO2 weight in g
Time range function
(optional)
Defines, how the time range for the calculation will be set (number of days or specific timerange)
Days
(optional)
Defines, for how many days in the past the values will be calculated
Timerange
(optional)
Defines, for which time range the values will be calculated
Finished trigger
(optional)
Defines the trigger which should be executed when the workflow was finished
Requires / creates: nothing
Output
DownloadCalculateCo2.zip
WF-Changes
05/12/2017, 2.0, Multi-Target workflows
07/24/2017, 2.1, Allow trigger "execute on receive data"
12/06/2018, 2.2, Reload MP-OBIS before setting full time range"

Compress

Back
            Version: 2.2  |  File: Compress.xaml  |  Act on: OBIS measurement
            Required user role:  PM | EDM | NDW 
Job: Compresses data into the time interval defined by the feedrate target OBIS. The aggregate function used is specified by a property.
Parameter:
Target OBIS
(required)
Defines the OBIS for the generated data (must be of type energy feed)
Aggregate function
(required)
Defines the aggregate function for the compression
Method
(optional)
Selection of the method for the period
Days
(optional)
Number of days calculated from the time of execution to the past
Timerange
(optional)
Defines the period of time for which the values ​​are to be calculated
Finished trigger
(optional)
Defines the trigger which should be executed when the workflow was finished
Requires / creates: nothing
Output
DownloadCompress.zip
WF-Changes
03/07/2018, 2.0, Created
04/11/2018, 2.1, FIX: Exception if time range choice is set to "NumDays"
12/06/2018, 2.2, Reload MP-OBIS before setting full time range"

Consistency check

Back
            Version: 2.7  |  File: ConsistencyCheck.xaml  |  Act on: Location/Location-Medium/Distributing-Plant/Meteringpoint
            Required user role:  PM | EDM | NDW | NDF 
Job: The workflow checks the status of all subordinate meteringpoints for the specified OBIS in the specified time period. With the parameters Min-Status and Data source type, the selection can be further specified. If conspicuous statuses are found, a group fault can be output by switching group, and / or an e-mail can be send.
Parameter:
OBIS
(required)
Defines the OBIS which should be validated
Minimal status
(optional)
Minimal status for limit violations0-Original value
1-Alternate value
2-Temporary value
3-Invalid value
Data source type
(required)
Restriction on certain data source types.
Condition of metering points
(required)
Restriction on certain conditions of metering points (Control, Damaged, ...).
Time range function
(optional)
Defines, how the time range will be determined (Full, number of days or specific timerange)
Offset (days)
(optional)
Defines the start time of the validation. Starting from the time of execution, the start time will be set to the number of days in the past.
Duration (days)
(optional)
Defines the duration of the validation. Starting from the defined start time the validation will be performed for the number of days.
Timerange
(optional)
Defines the time range for the validation. Start- and end time can be set explicitly.
Recipient list for e-mail
(optional)
Defines, to which recipients the e-mail will be sent.
Subject of the e-mail
(optional)
Defines the subject of the e-mail message.
Body of the e-mail
(optional)
Defines the body of the e-mail message.
Set "Common alert electr. Network"
(optional)
Defines if the switch group 249 'Common alert electr. Network' should be set if any errors could be determined.
Ignore list (metering points)
(optional)
Defines, which metering points should not be validated. The IDs of the meteringpoints can be indicated one by one, seperated by a space.
Finished trigger
(optional)
Defines the trigger which should be executed when the execution of the workflow finishes
Valid trigger
(optional)
Defines the trigger which should be executed when the validation could not determine any errors
Invalid trigger
(optional)
Defines the trigger which should be executed when the validation determined any errors
Requires / creates: nothing
Output
DownloadConsistencyCheck.zip
WF-Changes
05/05/2017, 1.3, Output of OBIS short name and formatting of date/time uses culture info of parent location
05/05/2017, 1.4, Location and medium is written to errors-protocol
05/08/2017, 1.5, Argument TargetObisCode added
05/10/2017, 1.6, Type of argument MinStatus changed to "Enum" to avoid selection of value "4" (Missing)
05/11/2017, 2.0, Multi-Target workflows
06/24/2017, 2.1, Changed logging of parameters (avoid time range if timerangechoice is not "TimeRange")
08/28/2017, 2.2, Changed logging (log message if time range choice is 'full', some other changes")
09/25/2017, 2.3, Change description"
10/10/2017, 2.4, Changed default values"
10/10/2017, 2.5, FIX: Execution for target type 'Metering point' throws an exception
11/16/2017, 2.6, Argument IgnoreList (metering point) added: Metering points with an identification contained in this list will be ignored
12/06/2017, 2.7, Changed description

cos Phi

Back
            Version: 2.1  |  File: CosPhi.xaml  |  Act on: Meteringpoint
            Required user role:  PM 
Job: Calculates the cos(φ) for each period using the formula cos(φ) = P / Sqrt(P*P + Q*Q)
Parameter:
Time range function
(optional)
Defines, how the time range for the calculation will be set (number of days or specific timerange)
Days
(optional)
Defines, for how many days in the past the values will be calculated
Timerange
(optional)
Defines, for which time range the values will be calculated
Finished trigger
(optional)
Defines the trigger which should be executed when the workflow was finished
Requires / creates:
001-000:013.029.000*255Leistungsfaktor, Lastgang, T0
Output
DownloadCosPhi.zip
WF-Changes
05/12/2017, 2.0, Multi-Target workflows
05/25/2018, 2.1, FIX: Workflow defines/uses wrong OBIS (WorkItem #10574)

Create Dashboard PDF

Back
            Version: 2.5  |  File: RenderDashboardPDF.xaml  |  Act on: Dashboards
            Required user role:  PM 
Job: Renders the content of the Dashboard page into a PDF file, which can be saved in the document folder of the evaluation area, or can be sent by e-mail as an attachment
Parameter:
Culture
(optional)
Culture format
Timeout
(optional)
Defines the time (msec) to wait until the PDF is generated.
Number of retries after Timeout
(optional)
Defines the number of retries, if the process ends with a timeout.
Online wait duration
(optional)
Defines the wait time (msec) to wait until printing, from when the dashboard received all the data
Dashboard URL parameters
(optional)
Specifies whether to save the PDF to the Documents folder
Save to document folder
(required)
Specifies whether to save the PDF to the Documents folder
Overwrite document
(required)
Defines whether an existing PDF of the same name should be overwritten in the document folder
Send Mail
(required)
Specifies whether to send an e-mail with the PDF as an attachment
Recipient list for e-mail
(required)
Specifies to which recipients the e-mail should be sent
Recipient list for a copy of e-mail (CC)
(optional)
Defines, to which recipients a copy of the e-mail will be sent (CC)
Recipient list for a blind copy of e-mail (BCC)
(optional)
Defines, to which recipients a blind copy of the e-mail will be sent (BCC)
Subject
(required)
Subject of e-mail
Body
(required)
Body of e-mail (HTML)
Finished trigger
(optional)
Defines the trigger which should be executed when the workflow was finished
Error trigger
(optional)
Defines the trigger which should be executed when the workflow was finished with error
Successful trigger
(optional)
Defines the trigger which should be executed when the workflow was finished successful
Requires / creates: nothing
Output
DownloadRenderDashboardPDF.zip
WF-Changes
05/30/2017, 1.8, Added parameters for CC and BCC
05/30/2017, 2.0, Multi-Target workflows
02/07/2018, 2.1, EN-Translation mistakes eliminated
11/30/2018, 2.2, AdditionalTimeout: description changed
11/30/2018, 2.3, Development intermediate version
12/04/2018, 2.4, Development intermediate version
12/06/2018, 2.5, New parameter Culture

Create permission matrix

Back
            Version: 2.0  |  File: PermissionMatrixCreator.xaml  |  Act on: System
            Required user role: SA 
Job: Creates an Excel file with a permission matrix for a single project or for all projects.
Parameter:
Project
(optional)
Defines the project, whose permissions matrix should be created. If not set, a matrix for all projects will be created!
Requires / creates: nothing
Output
DownloadPermissionMatrixCreator.zip
WF-Changes
07/24/2018, 2.0, Created workflow

CSV Data export (XML)

Back
            Version: 2.8  |  File: CsvExportXml.xaml  |  Act on: Documents
            Required user role:  PM 
Job: Exports data in CSV format. Configuration of export in done with the workflow target (stored XML document).
More Info see: CSV Export
Parameter:
Finished trigger
(optional)
Defines the trigger which should be executed when the workflow was finished
Requires / creates: nothing
Output
DownloadCsvExportXml.zip
WF-Changes
01/11/2018, 2.0, Created workflow
01/12/2018, 2.1, Default parameters TargetType and TargetGuid added to XAML
01/16/2018, 2.2, Bugfixing
01/22/2018, 2.3, Readings and columns can be defined more than once for export of files in with different data
01/22/2018, 2.4, Filter for content type
03/06/2018, 2.5, FIX: Exception if constant field uses formatting for starttimestamp which may be null
10/23/2018, 2.6, Additional option for continual export (attribute export-duration)
11/05/2018, 2.7, Optional definition of culture in XML-Element files (attribute culture)
11/05/2018, 2.8, Fix: Changed workflow for periodic continual export (export until last record instead of last period)

CSV Export

Back
            Version: 3.6  |  File: ExportCsv.xaml  |  Act on: OBIS measurement
            Required user role:  PM | EDM | NDW 
Job: Exports day or month data to CSV files.
Parameter:
ID of assigned workflow
(required)
This hidden parameter will not appear in the UI but is needed to store informations in the assigned workflow after executing the workflow.
Minimal status
(optional)
Minimum status that is still being exported. If the status is worse than indicated here, no output is made.
Export timespan
(optional)
Determines the time period to be exported. The parameter 'Last export date' is decisive. Daily = the day after the last export date. Monthly = The month after the last exported date.
Target directory
(optional)
Output directory where the files are to be exported. The directory must be accessible from the Web server, and the network service must be authorized.
Recipient list for e-mail
(optional)
List of e-mail addresses. Multiple recipients in a recipients list must be separated by semicolons.
Last export date
(optional)
Date of last successful export (not written in test mode).
Test mode
(optional)
Data is exported in the test mode, but the parameter 'Last export date' is not written. This allows the export of a specific period to be executed several times.
Offset for test mode
(optional)
Offset for test mode
Delimiter
(optional)
Defines the delimiter for the columns. ;-Semicolon
TAB-Tabulator
Has header
(optional)
Defines if the header row will be written to the file.
Field set
(optional)
JSON formatted list of output fields. Possible fields: UtcEndTime, UtcStartTime, LocalEndTime, LocalStartTime, Value, Status, Location (ID,Name), ObisCode (ShortName, "F"), Unit, MeteringPoint (MP-ID,ID,Number,Name). Each field is defined as {"Id":"Value"[, "Format":"N3"][,"ConstantValue":""]}. Possible formats are e.g. MM/dd/yyyy HH:mm (date format), N2 (number format).
Finished trigger
(optional)
Defines the trigger which should be executed when the workflow was finished
Requires / creates: nothing
Output
DownloadExportCsv.zip
WF-Changes
05/24/2017, 2.2, Workflow terminates with exception if email settings in automation server settings are not set
05/12/2017, 3.0, Multi-Target workflows
11/13/2017, 3.1, Additional parameter FieldSet
10/23/2017, 3.2, Validation of parameters TargetDirectory/Recipients
02/06/2018, 3.3, FIX: Last day is not exported if data ends exactly with value at end of day (eg. 30.01.2018 23:00).
03/19/2018, 3.4, FIX: Workflow creates invalid files if there is a gap in the source data.
05/23/2018, 3.5, FIX: Workflow creates invalid files if there are no data for a time span.
07/30/2018, 3.6, FIX: Workflow creates invalid files if meter values are exported.

CSV Export (cost center/energy benefit)

Back
            Version: 2.8  |  File: ExportCsvCCEB.xaml  |  Act on: Cost Center/Energy Benefit
            Required user role:  PM | EDM 
Job: Exports day or month data of a cost center/an energy benefit to CSV files.
Parameter:
ID of assigned workflow
(required)
This hidden parameter will not appear in the UI but is needed to store informations in the assigned workflow after executing the workflow.
User defined medium
(required)
Determines the user defined medium for which the data should be exported.
OBIS
(required)
Defines the OBIS which should be exported
Minimal status
(optional)
Minimum status that is still being exported. If the status is worse than indicated here, no output is made.
Export timespan
(optional)
Determines the time period to be exported. The parameter 'Interval offset' and the current timestamp are decisive.
Time range function
(optional)
Defines, how the time range for the export will be set (dynamic or specific timerange)
Last export date
(optional)
Date of last successful export (not written if specific timerange is used).
Timerange
(optional)
Defines, for which time range the values will be exported
Target directory
(optional)
Output directory where the files are to be exported. The directory must be accessible from the Web server, and the network service must be authorized.
Recipient list for e-mail
(optional)
List of e-mail addresses. Multiple recipients in a recipients list must be separated by semicolons.
Delimiter
(optional)
Defines the delimiter for the columns. ;-Semicolon
TAB-Tabulator
Has header
(optional)
Defines if the header row will be written to the file.
Flat export
(required)
Defines, if the export will only contain the assignments of metering points (compatibility to Version 4.6.6)
Field set
(required)
List of output fields.
Success trigger
(optional)
Defines the trigger which should be executed when the execution of the workflow is successful
Error trigger
(optional)
Defines the trigger which should be executed when the execution of the workflow fails
Requires / creates: nothing
Output
DownloadExportCsvCCEB.zip
WF-Changes
09/05/2017, 2.0, Workflow created
05/03/2018, 2.1, Validation of parameters TargetDirectory/Recipients
05/03/2018, 2.2, Permission for NDF removed
05/03/2018, 2.3, FIX: Export with interval 'Monthly' fails with an exception
05/03/2018, 2.4, UPDATE: Additional column with percentual amount of object (cost center/energy benefit)
05/04/2018, 2.5, UPDATE: Additional parameter 'Flat export'
05/08/2018, 2.6, UPDATE: Additional export columns
05/16/2018, 2.7, FIX: Export fails with an exception
05/17/2018, 2.8, FIX: Export of [Meteringpoint.Number] of number of [Target.Number] (If row is of type 'MP')

CSV Import

Back
            Version: 2.2  |  File: ImportCsv.xaml  |  Act on: OBIS measurement
            Required user role:  PM | EDM | NDW 
Job: Imports a CSV file. It must be at least time and value in the CSV. If no status is set in the CSV, the workflow can set a default status.
Parameter:
Filename
(required)
Name of the file which should be imported.
Timestamp is UTC
(optional)
Defines if the timestamps should be interpreted as UTC times.
Delimiter
(optional)
Defines the delimiter for the columns. ;-Semicolon
TAB-Tabulator
Delete file
(optional)
Defines if the CSV file should be deleted after import.
Column index value
(optional)
Defines the index of the column with the value.
Column index timestamp
(optional)
Defines the index of the column with the timestamp.
Column index state
(optional)
Defines the index of the column with the state.
Default state
(optional)
Defines the default state for each data row, if the index of the state column is set to 0.0-Original value
1-Alternate value
2-Temporary value
Has Header
(optional)
Defines if the first row with the column headers should be ignored.
Finished trigger
(optional)
Defines the trigger which should be executed when the workflow was finished
Requires / creates: nothing
Output
DownloadImportCsv.zip
WF-Changes
05/15/2017, 1.3, Avoid import of invalid states, create start timestamp for OBIS of type EnergyFeed
05/19/2017, 1.4, Backup file will be deleted if it already exists
05/24/2017, 1.5, Exception shows number of line in which data could not be parsed
05/12/2017, 2.0, Multi-Target workflows
07/19/2017, 2.1, FIX: Data import with ambigious times (in case of daylight saving time) fails
07/04/2018, 2.2, UPDATE: Workflow will terminate if import file could not be found

Cumulated maximas

Back
            Version: 2.2  |  File: CreateCumulatedData.xaml  |  Act on: OBIS measurement
            Required user role:  PM | EDM | NDW 
Job: Transforms data to cumulated maximum values
Parameter:
Time range function
(optional)
Defines, how the time range for the compression will be set (number of days or specific timerange)
Days
(optional)
Defines, for how many days in the past the values will be calculated
Timerange
(optional)
Defines, for which time range the values will be calculated
Finished trigger
(optional)
Defines the trigger which should be executed when the workflow was finished
Requires / creates: nothing
Output
DownloadCreateCumulatedData.zip
WF-Changes
05/12/2017, 2.0, Multi-Target workflows
07/24/2017, 2.1, Allow trigger "execute on receive data"
12/06/2018, 2.2, Reload MP-OBIS before setting full time range"

Data calculation (medium)

Back
            Version: 2.5  |  File: CalculatePlanData.xaml  |  Act on: Medium
            Required user role:  PM | EDM 
Job: Calculates load profile data of a location medium
Parameter:
Time range function
(optional)
Defines, how the time range for the calculation will be set (number of days or specific timerange)
Days
(optional)
Defines, for how many days in the past the values will be calculated
Timerange
(optional)
Defines, for which time range the values will be calculated
Finished trigger
(optional)
Defines the trigger which should be executed when the workflow was finished
Requires / creates: nothing
Output
DownloadCalculatePlanData.zip
WF-Changes
05/12/2017, 2.0, Multi-Target workflows
07/13/2017, 2.1, TimeRangeChoice.Full implemeted
07/13/2017, 2.2, FIX: Update formulas of plants only once
12/11/2017, 2.3, FIX: Unnecessary reload of distributing plants in ParallelForEach-Activity removed
02/07/2018, 2.4, Workflow will be terminated with message if there are no plants for the location medium
02/07/2018, 2.5, Workflow writes a log entry and continues execution, if argument TimeRangeChoice is set to FullTimeRange and no data could be found in any metering point. In former version workflow terminated with exception.

Data calculation (plant)

Back
            Version: 2.3  |  File: CalculatePlantData.xaml  |  Act on: Distribution
            Required user role:  PM 
Job: Calculates load profile data of a distributing plant
Parameter:
OBIS
(required)
Defines the OBIS which should be calculated
Time range function
(optional)
Defines, how the time range for the calculation will be set (number of days or specific timerange)
Days
(optional)
Defines, for how many days in the past the values will be calculated
Timerange
(optional)
Defines, for which time range the values will be calculated
Finished trigger
(optional)
Defines the trigger which should be executed when the workflow was finished
Requires / creates: nothing
Output
DownloadCalculatePlantData.zip
WF-Changes
05/12/2017, 2.0, Multi-Target workflows
07/13/2017, 2.1, TimeRangeChoice.Full implemeted
07/13/2017, 2.2, FIX: Exception before calcluation of difference
12/11/2017, 2.3, FIX: Unnecessary reload of distributing plants in ParallelForEach-Activity removed

Data compression (Energy feed)

Back
            Version: 2.2  |  File: CompressEnergyFeed.xaml  |  Act on: OBIS measurement
            Required user role:  PM | EDM | NDW 
Job: Compresses data to energy feed values
Parameter:
Target OBIS
(required)
Defines the OBIS for the generated data
Aggregate interval
(required)
Defines the interval for the compression. If the selected target OBIS is of kind load profile, this option is ignored and the period of the target OBIS will be used as interval!
Aggregate function
(required)
Defines the aggregate function for the compression
Time range function
(optional)
Defines, how the time range for the compression will be set (number of days or specific timerange)
Days
(optional)
Defines, for how many days in the past the values will be calculated
Timerange
(optional)
Defines, for which time range the values will be calculated
Finished trigger
(optional)
Defines the trigger which should be executed when the workflow was finished
Requires / creates: nothing
Output
DownloadCompressEnergyFeed.zip
WF-Changes
05/12/2017, 2.0, Multi-Target workflows
07/24/2017, 2.1, Allow trigger "execute on receive data"
12/06/2018, 2.2, Reload MP-OBIS before setting full time range"

Data compression (load profile)

Back
            Version: 2.2  |  File: CompressLoadProfile.xaml  |  Act on: OBIS measurement
            Required user role:  PM | EDM | NDW 
Job: Compresses data to load profile values
Parameter:
Target OBIS
(required)
Defines the OBIS for the generated data
Aggregate function
(required)
Defines the aggregate function for the compression
Time range function
(optional)
Defines, how the time range for the compression will be set (number of days or specific timerange)
Days
(optional)
Defines, for how many days in the past the values will be calculated
Timerange
(optional)
Defines, for which time range the values will be calculated
Finished trigger
(optional)
Defines the trigger which should be executed when the workflow was finished
Requires / creates: nothing
Output
DownloadCompressLoadProfile.zip
WF-Changes
05/12/2017, 2.0, Multi-Target workflows
07/24/2017, 2.1, Allow trigger "execute on receive data"
12/06/2018, 2.2, Reload MP-OBIS before setting full time range"

Dayly cumulated values

Back
            Version: 2.3  |  File: CompressDayCumulate.xaml  |  Act on: OBIS measurement
            Required user role:  PM | EDM | NDW 
Job: Compresses data to dayly cumulated values
Parameter:
Time range function
(optional)
Defines, how the time range for the compression will be set (number of days or specific timerange)
Days
(optional)
Defines, for how many days in the past the values will be calculated
Timerange
(optional)
Defines, for which time range the values will be calculated
Finished trigger
(optional)
Defines the trigger which should be executed when the workflow was finished
Requires / creates: nothing
Output
DownloadCompressDayCumulate.zip
WF-Changes
05/12/2017, 2.0, Multi-Target workflows
07/24/2017, 2.1, Allow trigger "execute on receive data"
11/13/2017, 2.2, Set timestamps of data to timestamp of max value (period instead of timerange hole day)
12/06/2018, 2.3, Reload MP-OBIS before setting full time range"

Dayly sum values

Back
            Version: 2.4  |  File: CompressDaySum.xaml  |  Act on: OBIS measurement
            Required user role:  PM | EDM | NDW 
Job: Compresses periodical data to dayly sums for the media electricity, heat, cold, cold water, warm water, natural gas
Parameter:
Time range function
(optional)
Defines, how the time range for the compression will be set (number of days or specific timerange)
Days
(optional)
Defines, for how many days in the past the values will be calculated
Timerange
(optional)
Defines, for which time range the values will be calculated
Finished trigger
(optional)
Defines the trigger which should be executed when the workflow was finished
Requires / creates:
001-001:001.132.000*255P+, Tagessumme, T0
001-001:002.132.000*255P-, Tagessumme, T0
001-001:003.132.000*255Q+, Tagessumme, T0
001-001:004.132.000*255Q-, Tagessumme, T0
004-000:001.132.000*255Wärme (Kosten), Tagessumme, T0
005-001:099.132.000*255Kälte, Tagessumme, T0
006-001:003.132.000*255Wärme [kg], Tagessumme, T0
006-001:099.132.000*255Wärme [kWh], Tagessumme, T0
007-001:000.132.000*255Gas, Energiewert endgültig, Tagessumme T0
007-001:128.132.000*255Erdgas Betriebskubikmeter, Tagessumme, T0
007-001:129.132.000*255Erdgas, Normkubikmeter, Tagessumme, T0
008-001:099.132.000*255Trinkwasser / Brauchwasser, kalt, Tagessumme, T0
008-001:128.132.000*255Trinkwasser, kalt, Tagessumme, T0
008-001:129.132.000*255Brauchwasser, kalt, Tagessumme, T0
008-001:130.132.000*255VE-Wasser, kalt, Tagessumme, T0
009-001:099.132.000*255Trinkwasser / Brauchwasser, heiß, Tagessumme, T0
009-001:128.132.000*255Trinkwasser, heiß, Tagessumme, T0
009-001:129.132.000*255Brauchwasser, heiß, Tagessumme, T0
009-001:130.132.000*255VE-Wasser, heiß, Tagessumme, T0
016-001:000.132.000*255Heizöl Energiewert, Tagessumme, T0
016-001:128.132.000*255Heizöl [l], Tagessumme, T0
016-001:129.132.000*255Heizöl [m³], Tagessumme, T0
016-020:099.033.017*255Heizöl Energiewert, Lastgang, T0
017-001:128.132.000*255Druckluft, Tagessumme, Betriebskubikmeter, T0
017-001:129.132.000*255Druckluft, Tagessumme, Normkubikmeter, T0
018-001:128.132.000*255Stickstoff, Tagessumme, Betriebskubikmeter, T0
018-001:129.132.000*255Stickstoff, Tagessumme, Normkubikmeter, T0
Output
DownloadCompressDaySum.zip
WF-Changes
05/12/2017, 2.0, Multi-Target workflows
07/24/2017, 2.1, Allow trigger "execute on receive data"
05/22/2018, 2.2, Added OBIS codes"
05/25/2018, 2.3, Added OBIS codes"
12/06/2018, 2.4, Reload MP-OBIS before setting full time range"

Delete (older than)

Back
            Version: 2.1  |  File: Delete.xaml  |  Act on: OBIS measurement
            Required user role:  PM | EDM | NDW 
Job: Deletes data that is older than the specified retention time at the time of execution.
Parameter:
Storage time
(required)
Data will be deleted after expiry of the retention period.
Finished trigger
(optional)
Defines the trigger which should be executed when the workflow was finished
Requires / creates: nothing
Output
DownloadDelete.zip
WF-Changes
05/12/2017, 2.0, Multi-Target workflows
07/24/2017, 2.1, Allow trigger "execute on receive data"

Delete (time range)

Back
            Version: 2.1  |  File: DeleteTimeRange.xaml  |  Act on: OBIS measurement
            Required user role:  PM | EDM | NDW 
Job: Deletes data having a timestamp in the given time range
Parameter:
Time range function
(optional)
Defines, how the time range for the deletion will be set (number of days or specific timerange)
Days
(optional)
Defines, for how many days in the past the values will be calculated
Timerange
(optional)
Defines, for which time range the values will be calculated
Finished trigger
(optional)
Defines the trigger which should be executed when the workflow was finished
Requires / creates: nothing
Output
DownloadDeleteTimeRange.zip
WF-Changes
05/12/2017, 2.0, Multi-Target workflows
07/24/2017, 2.1, Allow trigger "execute on receive data"

Excel processor

Back
            Version: 2.7  |  File: ExcelProcessor.xaml  |  Act on: Documents
            Required user role:  PM 
Job: Processes an Excel file and replaces the user-defined visual energy Excel functions (ve4 _...) with their results. A copy of the processed file will be sent to the defined email recipients.
Parameter:
Time range function
(required)
Defines, how the time range for the processing will be set (dynamic or specific)
Start (dynamic)
(required)
Start (dynamic)
Offset (dynamic)
(required)
Offset (dynamic)
Duration (dynamic)
(required)
Duration (dynamic)
Timerange (specific)
(required)
Defines, for which time range the document will be processing (Timezone of project)
Recipient list for e-mail
(optional)
Defines, to which recipients the e-mail will be sent
Subject
(optional)
Subject of e-mail
Body
(optional)
Body of e-mail (HTML)
Store document(s)
(optional)
Defines if the generated document (and also the generated error log) will be stored in the database.
Culture
(required)
Culture used to create the template file (for comparison of placeholder date).
Finished trigger
(optional)
Defines the trigger which should be executed when the workflow was finished
Requires / creates: nothing
Output
DownloadExcelProcessor.zip
WF-Changes
04/17/2018, 2.0, Created workflow
05/09/2018, 2.1, UPDATE: Added parameter 'StoreDocuments'
05/16/2018, 2.2, UPDATE: Added parameter 'TimeRangeChoice'
05/16/2018, 2.3, UPDATE: Extended argument descriptions
05/16/2018, 2.4, UPDATE: Validation added, the option StoreDocuments and/or the list of recipients must be set
05/17/2018, 2.5, UPDATE: Timezone of project will be used to transfer UTC dates
05/22/2018, 2.6, UPDATE: Added parameter 'Culture'
05/25/2018, 2.7, FIX: Don't send mail if list of recipients is not set

Execute program

Back
            Version: 2.0  |  File: ExecuteProgram.xaml  |  Act on: System
            Required user role: SA 
Job: Executes the program with the given arguments
Parameter:
Filename
(required)
Filename of the program/the executable
Arguments
(optional)
Defines the arguments for the program/executable
Finished trigger
(optional)
Defines the trigger which should be executed when the workflow was finished
Requires / creates: nothing
Output
DownloadExecuteProgram.zip
WF-Changes
05/12/2017, 2.0, Multi-Target workflows

FTP download

Back
            Version: 2.1  |  File: FtpDownload.xaml  |  Act on: System
            Required user role: SA 
Job: Performs a FTP download
Parameter:
Url of file
(required)
Defines the url of the ftp download
User name
(optional)
Defines the user name
Password
(optional)
Defines the password
Filename
(required)
Defines the filename
Finished trigger
(optional)
Defines the trigger which should be executed when the execution of the workflow finishes
Success trigger
(optional)
Defines the trigger which should be executed when the download was successful
Failed trigger
(optional)
Defines the trigger which should be executed when the download fails
Requires / creates: nothing
Output
DownloadFtpDownload.zip
WF-Changes
12/18/2018, 2.0, Created
12/18/2018, 2.1, Added triggers

Gas m³ to kWh

Back
            Version: 2.3  |  File: GasKwhCalculator.xaml  |  Act on: OBIS measurement
            Required user role:  PM | EDM | NDW 
Job: Calculate for Gas, OBIS measurement Standard-m³ ('7-1:129.130.0*255') Energy in kWh and writes values as OBIS measuremnt energy final (007-020:099.033.017*255) in database.
Parameter:
Calorific value
(required)
Calorific value in kWh/m³
Correction factor
(required)
The volume of gas is influenced by the temperature at the delivery point, as well as the altitude, which ensures a certain air pressure. Because of this, the correction factor is used for volume calculation. With it, the standard state (temperature: 0 degrees Celsius, air pressure: 1.013.25 mbar) of the gas delivered can be calculated. If the detected gas volume is already standard cubic meters, then enter value 1 here!
Time range function
(optional)
Defines, how the time range for the calculation will be set (number of days or specific timerange)
Days
(optional)
Defines, for how many days in the past the values will be calculated
Timerange
(optional)
Defines, for which time range the values will be calculated
Finished trigger
(optional)
Defines the trigger which should be executed when the workflow was finished
Requires / creates:
007-001:128.130.000*255Erdgas, Lastgang, Betriebskubikmeter, T0
007-001:129.130.000*255Erdgas, Lastgang, Normkubikmeter, T0
007-020:099.033.017*255Gas, Energiewert endgültig, P+
Output007-020:099.033.017*255
DownloadGasKwhCalculator.zip
WF-Changes
05/12/2017, 2.0, Multi-Target workflows
07/24/2017, 2.1, Allow trigger "execute on receive data"
05/18/2018, 2.2, Workflow extended for standard and norm cubic obis
12/06/2018, 2.3, Reload MP-OBIS before setting full time range"

Hourly sum values

Back
            Version: 2.2  |  File: CompressHourSum.xaml  |  Act on: OBIS measurement
            Required user role:  PM | EDM | NDW 
Job: Compresses data to hourly sums
Parameter:
Time range function
(optional)
Defines, how the time range for the compression will be set (number of days or specific timerange)
Days
(optional)
Defines, for how many days in the past the values will be calculated
Timerange
(optional)
Defines, for which time range the values will be calculated
Finished trigger
(optional)
Defines the trigger which should be executed when the workflow was finished
Requires / creates:
001-001:001.030.000*255P+, Stundensumme, T0
001-001:002.030.000*255P-, Stundensumme, T0
001-001:003.030.000*255Q+, Stundensumme, T0
001-001:004.030.000*255Q-, Stundensumme, T0
Output
DownloadCompressHourSum.zip
WF-Changes
05/12/2017, 2.0, Multi-Target workflows
07/24/2017, 2.1, Allow trigger "execute on receive data"
12/06/2018, 2.2, Reload MP-OBIS before setting full time range"

Limit monitoring

Back
            Version: 2.1  |  File: LimitMonitoring.xaml  |  Act on: OBIS measurement
            Required user role:  PM | EDM | NDW | NDF 
Job: Compares an OBIS-Value with OBIS-B, Channel 129 setvalue for over- or undershoot. Can send an e-mail, enable / disable switch group 244 'Limit violation' and / or trigger a user-defined trigger.
Parameter:
Time range function
(optional)
Defines, how the time range for the validation will be set (number of days or specific timerange)
Days
(optional)
Defines, for how many days in the past the values will be validated
Timerange
(optional)
Defines, for which time range the values will be validated
React if
(required)
Defines, if a validation will be determined by undercut or overflow.
Recipient list for e-mail
(optional)
Defines, to which recipients the e-mail will be sent.
Subject of the e-mail
(optional)
Defines the subject of the e-mail message.
Body of the e-mail
(optional)
Defines the body of the e-mail message.
Set switch group
(optional)
Defines if the switch group 244 'Combined fault limit violoation' should be set if any validation errors could be determined.
Minimal status
(required)
Minimal status for limit violoations
Finished trigger
(optional)
Defines the trigger which should be executed when the execution of the workflow finishes
Status violation trigger
(optional)
Defines the trigger which should be executed when the validation could determine status violoations
Limit violation trigger
(optional)
Defines the trigger which should be executed when the validation could determine limit violoations
Requires / creates: nothing
Output
DownloadLimitMonitoring.zip
WF-Changes
05/12/2017, 2.0, Multi-Target workflows
07/24/2017, 2.1, Allow trigger "execute on receive data"

Load permission matrix

Back
            Version: 2.0  |  File: PermissionMatrixLoader.xaml  |  Act on: SystemDocument
            Required user role: SA 
Job: Processes an Excel file and optionally loads the permission matrix into the database. If the test mode is disabled and the document is valid, a log file showing all changes will be stored into the database. If the document is invalid, a log file with the detected errors will be stored into the database, independend from the test mode.
Parameter:
Test mode
(optional)
Defines if only the system document should be validated (true) or if the permission matrix should be loaded into the database (false).
Requires / creates: nothing
Output
DownloadPermissionMatrixLoader.zip
WF-Changes
07/24/2018, 2.0, Created workflow

Money calculation

Back
            Version: 2.2  |  File: CalculateMoney.xaml  |  Act on: OBIS measurement
            Required user role:  PM | EDM | NDW 
Job: Calculates the sum of money for each period
Parameter:
Costs
(required)
Costs in project currency
Time range function
(optional)
Defines, how the time range for the calculation will be set (number of days or specific timerange)
Days
(optional)
Defines, for how many days in the past the values will be calculated
Timerange
(optional)
Defines, for which time range the values will be calculated
Finished trigger
(optional)
Defines the trigger which should be executed when the workflow was finished
Requires / creates: nothing
Output
DownloadCalculateMoney.zip
WF-Changes
05/12/2017, 2.0, Multi-Target workflows
07/24/2017, 2.1, Allow trigger "execute on receive data"
12/06/2018, 2.2, Reload MP-OBIS before setting full time range"

Monthly sum values from load profile

Back
            Version: 2.6  |  File: compressmonthsum.xaml  |  Act on: OBIS measurement
            Required user role:  PM | EDM | NDW 
Job: Compresses load profile data to monthly sums
Parameter:
Time range function
(optional)
Defines, how the time range for the compression will be set (number of days or specific timerange)
Days
(optional)
Defines, for how many days in the past the values will be calculated
Timerange
(optional)
Defines, for which time range the values will be calculated
Finished trigger
(optional)
Defines the trigger which should be executed when the workflow was finished
Requires / creates:
001-001:001.134.000*255P+, Monatssumme, T0
001-001:001.134.001*255P+, Monatssumme, T1
001-001:001.134.002*255P+, Monatssumme, T2
001-001:002.134.000*255P-, Monatssumme, T0
001-001:002.134.001*255P-, Monatssumme, T1
001-001:002.134.002*255P-, Monatssumme, T2
001-001:003.134.000*255Q+, Monatssumme, T0
001-001:003.134.001*255Q+, Monatssumme, T1
001-001:003.134.002*255Q+, Monatssumme, T2
001-001:004.134.000*255Q-, Monatssumme, T0
001-001:004.134.001*255Q-, Monatssumme, T1
001-001:004.134.002*255Q-, Monatssumme, T2
004-000:001.134.000*255Wärme (Kosten), Monatssumme, T0
005-000:001.134.000*255Kälte, Monatssumme, T0
006-000:001.134.000*255Wärme, Monatssumme, T0
006-001:003.134.000*255Wärme [kg], Monatssumme, T0
007-001:000.134.000*255Gas, Energiewert endgültig, Monatssumme T0
007-001:128.134.000*255Gas, Betriebskubikmeter, Monatssumme T0
007-001:129.134.000*255Gas, Normkubikmeter, Monatssumme T0
008-000:001.134.000*255Trinkwasser / Brauchwasser, kalt, Monatssumme, T0
008-001:128.134.000*255Trinkwasser, kalt, Monatssumme, T0
008-001:129.134.000*255Brauchwasser, kalt, Monatssumme, T0
008-001:130.134.000*255VE-Wasser, kalt, Monatssumme, T0
009-000:001.134.000*255Trinkwasser / Brauchwasser, heiß, Monatssumme, T0
009-001:128.134.000*255Trinkwasser, heiß, Monatssumme, T0
009-001:129.134.000*255Brauchwasser, heiß, Monatssumme, T0
009-001:130.134.000*255VE-Wasser, heiß, Monatssumme, T0
016-001:000.134.000*255Heizöl Energiewert, Monatssumme, T0
016-001:128.134.000*255Heizöl [l], Monatssumme, T0
016-001:129.134.000*255Heizöl [m³], Monatssumme, T0
016-020:099.033.017*255Heizöl Energiewert, Lastgang, T0
017-001:128.134.000*255Druckluft, Monatssumme, Betriebskubikmeter, T0
017-001:129.134.000*255Druckluft, Monatssumme, Normkubikmeter, T0
018-001:128.134.000*255Stickstoff, Monatssumme, Betriebskubikmeter, T0
018-001:129.134.000*255Stickstoff, Monatssumme, Normkubikmeter, T0
Output
Downloadcompressmonthsum.zip
WF-Changes
05/16/2017, 1.18, OBIS for electricity (P+,Q+,P-,Q-), added tariffs T1 and T2
05/12/2017, 2.0, Multi-Target workflows
07/24/2017, 2.1, Allow trigger "execute on receive data"
10/05/2017, 2.2, Added OBIS codes for Natural gas and cold water
10/13/2017, 2.3, Changed OBIS filter for OBIS codes for Natural gas and cold water
05/22/2018, 2.4, Added OBIS codes"
05/25/2018, 2.5, Added OBIS codes"
12/06/2018, 2.6, Reload MP-OBIS before setting full time range"

MSCONS Export

Back
            Version: 2.6  |  File: ExportMscons.xaml  |  Act on: OBIS measurement
            Required user role:  PM | EDM | NDW | NDF 
Job: Exports data into files with MSCONS format
Parameter:
ID of assigned workflow
(required)
This parameter will not appear in the UI but is needed to store informations in the assigned workflow after executing the workflow.
Minimal status
(optional)
Minimum status that is still being exported. If the status is worse than indicated here, no output is made.
Export interval
(optional)
Export interval
Recipient-ID
(optional)
Recipient-ID
Recipient-MemberID
(optional)
Recipient-MemberID
Sender-ID
(optional)
Sender-ID
Sender-MemberID
(optional)
Sender-MemberID
MSCONS OBIS-Format
(optional)
Defines, in which format OBIS will be written to the MSCONS document.
MSCONS version
(optional)
Version of the MSCONS documents
Target directory
(optional)
Output directory where the files are to be exported. The directory must be accessible from the Web server, and the network service must be authorized.
Recipient list for e-mail
(optional)
List of e-mail addresses. Multiple recipients in a recipients list must be separated by semicolons.
Last export date
(optional)
Date of last successful export (not written in test mode).
Test mode
(optional)
Data is exported in the test mode, but the parameter 'Last export date' is not written. This allows the export of a specific period to be executed several times.
Offset for test mode
(optional)
Offset for test mode
Finished trigger
(optional)
Defines the trigger which should be executed when the workflow was finished
Requires / creates: nothing
Output
DownloadExportMscons.zip
WF-Changes
05/12/2017, 2.0, Multi-Target workflows
10/23/2017, 2.1, Validation of parameters TargetDirectory/Recipients
02/06/2018, 2.2, UPD: Default value of parameter MsconsVersion changed to Version 2.2h.
02/06/2018, 2.3, FIX: Last day is not exported if data ends exactly with value at end of day (eg. 30.01.2018 23:00).
03/14/2018, 2.4, FIX: Workflow exports further intervals even if there is an status error.
03/19/2018, 2.5, FIX: Workflow creates invalid files if there is a gap in the source data.
05/23/2018, 2.6, FIX: Workflow creates invalid files if there are no data for a time span.

OBIS Calculator

Back
            Version: 2.2  |  File: ObisCalculator.xaml  |  Act on: OBIS measurement
            Required user role:  PM | EDM | NDW 
Job: Calculates new data from the source OBIS using the operator and the value and stores the data with the target OBIS
Parameter:
Target OBIS
(required)
Target OBIS
Operator
(required)
Operator
Value
(required)
Value
Time range function
(optional)
Defines, how the time range for the calculation will be set (number of days or specific timerange)
Days
(optional)
Defines, for how many days in the past the values will be calculated
Timerange
(optional)
Defines, for which time range the values will be calculated
Finished trigger
(optional)
Defines the trigger which should be executed when the workflow was finished
Requires / creates: nothing
Output
DownloadObisCalculator.zip
WF-Changes
05/12/2017, 2.0, Multi-Target workflows
07/24/2017, 2.1, Allow trigger "execute on receive data"
12/06/2018, 2.2, Reload MP-OBIS before setting full time range"

OBIS update

Back
            Version: 2.1  |  File: ObisUpdate.xaml  |  Act on: System
            Required user role: SA 
Job: Creates or updates OBIS
Parameter:
Requires / creates:
001-129:001.029.000*255P+, Sollwert Lastgang, T0
001-129:001.029.001*255P+, Sollwert Lastgang, T1
001-129:001.029.002*255P+, Sollwert Lastgang, T2
001-129:001.029.003*255P+, Sollwert Lastgang, T3
001-129:001.029.004*255P+, Sollwert Lastgang, T4
001-129:001.030.000*255P+, Sollwert Stunde, T0
001-129:001.132.000*255P+, Sollwert Tag, T0
001-129:001.133.000*255P+, Sollwert Woche, T0
001-129:001.134.000*255P+, Sollwert Monat, T0
001-129:001.136.000*255P+, Sollwert Jahr, T0
001-129:002.029.000*255P-, Sollwert Lastgang, T0
001-129:002.030.000*255P-, Sollwert Stunde, T0
001-129:002.132.000*255P-, Sollwert Tag, T0
001-129:002.133.000*255P-, Sollwert Woche, T0
001-129:002.134.000*255P-, Sollwert Monat, T0
001-129:002.136.000*255P-, Sollwert Jahr, T0
001-129:003.029.000*255Q+, Sollwert Lastgang, T0
001-129:003.030.000*255Q+, Sollwert Stunde, T0
001-129:003.132.000*255Q+, Sollwert Tag, T0
001-129:003.133.000*255Q+, Sollwert Woche, T0
001-129:003.134.000*255Q+, Sollwert Monat, T0
001-129:003.136.000*255Q+, Sollwert Jahr, T0
001-129:004.029.000*255Q-, Sollwert Lastgang, T0
001-129:004.030.000*255Q-, Sollwert Stunde, T0
001-129:004.132.000*255Q-, Sollwert Tag, T0
001-129:004.133.000*255Q-, Sollwert Woche, T0
001-129:004.134.000*255Q-, Sollwert Monat, T0
001-129:004.136.000*255Q-, Sollwert Jahr, T0
016-001:129.130.000*255Heizöl, Lastgang, T0
016-001:129.130.001*255Heizöl, Lastgang, T1
016-001:129.130.002*255Heizöl, Lastgang, T2
016-001:129.130.003*255Heizöl, Lastgang, T3
016-001:129.130.004*255Heizöl, Lastgang, T4
016-130:129.130.000*255Heizöl, Lastgang, T0 [Prognose]
016-130:129.130.001*255Heizöl, Lastgang, T1 [Prognose]
016-130:129.130.002*255Heizöl, Lastgang, T2 [Prognose]
016-130:129.130.003*255Heizöl, Lastgang, T3 [Prognose]
016-130:129.130.004*255Heizöl, Lastgang, T4 [Prognose]
016-131:129.130.000*255Heizöl, Lastgang, T0 [Arbeitstag (max)]
016-131:129.130.001*255Heizöl, Lastgang, T1 [Arbeitstag (max)]
016-131:129.130.002*255Heizöl, Lastgang, T2 [Arbeitstag (max)]
016-131:129.130.003*255Heizöl, Lastgang, T3 [Arbeitstag (max)]
016-131:129.130.004*255Heizöl, Lastgang, T4 [Arbeitstag (max)]
016-132:129.130.000*255Heizöl, Lastgang, T0 [Feiertag (max)]
016-133:129.130.000*255Heizöl, Lastgang, T0 [Arbeitstag (min)]
016-134:129.130.000*255Heizöl, Lastgang, T0 [Feiertag (min)]
016-141:129.130.000*255Heizöl, Lastgang, T0 [Ersatzprofil Arbeitstag]
016-142:129.130.000*255Heizöl, Lastgang, T0 [Ersatzprofil Feiertag]
016-143:129.130.000*255Heizöl, Lastgang, T0 [Geldbetrag]
016-144:129.130.000*255Heizöl, Lastgang, T0 [Geldbetrag Prognose]
016-145:129.130.000*255Heizöl, Lastgang, T0 [CO2 Emission]
016-146:129.130.000*255Heizöl, Lastgang, T0 [CO2 Emission Prognose]
017-001:129.128.000*255Druckluft, Zählerstand, Normkubikmeter, T0
017-001:129.128.001*255Druckluft, Zählerstand, Normkubikmeter, T1
017-001:129.128.002*255Druckluft, Zählerstand, Normkubikmeter, T2
017-001:129.128.003*255Druckluft, Zählerstand, Normkubikmeter, T3
017-001:129.128.004*255Druckluft, Zählerstand, Normkubikmeter, T4
018-001:128.128.000*255Stickstoff, Zählerstand, Betriebskubikmeter, T0
Output
DownloadObisUpdate.zip
WF-Changes
11/13/2017, 2.0, Created for OBIS setpoint values electricity
05/23/2018, 2.1, FIX: wrong names/descriptions in serveral OBIS

ORDERS (market location)

Back
            Version: 2.0  |  File: OrdersMaLo.xaml  |  Act on: MarketLocation
            Required user role:  PM | EDM | NDW 
Job: Sends an EDIFACT message of type ORDERS for the market location to the network operator. The communication data must be defined at the network operator.
Parameter:
Time range function
(optional)
Defines, how the time range for the request will be set (previous day, previous month or specific timerange)
Timerange
(optional)
Defines, for which time range the values will be requested
Finished trigger
(optional)
Defines the trigger which should be executed when the workflow was finished
Requires / creates: nothing
Output
DownloadOrdersMaLo.zip
WF-Changes
12/08/2017, 2.0, Multi-Target workflows

ORDERS (metering point)

Back
            Version: 2.0  |  File: Orders.xaml  |  Act on: Meteringpoint
            Required user role:  PM | EDM | NDW 
Job: Sends an EDIFACT message of type ORDERS for the metering point to the network operator. The communication data must be defined at the network operator.
Parameter:
Time range function
(optional)
Defines, how the time range for the request will be set (previous day, previous month or specific timerange)
Timerange
(optional)
Defines, for which time range the values will be requested
Finished trigger
(optional)
Defines the trigger which should be executed when the workflow was finished
Requires / creates: nothing
Output
DownloadOrders.zip
WF-Changes
05/12/2017, 2.0, Multi-Target workflows

Project data generation

Back
            Version: 2.1  |  File: ProjectTemplateProcessor.xaml  |  Act on: SystemDocument
            Required user role: SA 
Job: Processes an Excel file and optionally synchronizes the objects with the database. If the test mode is disabled and the document is valid, a copy of the processed file as long as a log file showing all changes will be stored into the database. If the document is invalid, a log file with the detected errors will be stored in the database, independend from the test mode.
Parameter:
Test mode
(optional)
Defines if only the document should be validated (true) or if the objects should be synchronized with the database (false).
Requires / creates: nothing
Output
DownloadProjectTemplateProcessor.zip
WF-Changes
07/10/2018, 2.0, Created workflow
07/12/2018, 2.1, UPDATE: German culture of argument TestMode corrected

Relative validation

Back
            Version: 2.1  |  File: ValidateRelative.xaml  |  Act on: OBIS measurement
            Required user role:  PM | EDM | NDW 
Job: Validates data using relative limits
Parameter:
Interval
(required)
Interval
LowerLimit
(required)
LowerLimit
UpperLimit
(required)
UpperLimit
Months
(optional)
Months
Success trigger
(optional)
Defines the trigger which should be executed when the execution of the workflow succeeds
Error trigger
(optional)
Defines the trigger which should be executed when the execution of the workflow fails
Violations
(optional)
Violations
Requires / creates: nothing
Output
DownloadValidateRelative.zip
WF-Changes
05/12/2017, 2.0, Multi-Target workflows
07/24/2017, 2.1, Allow trigger "execute on receive data"

Request data

Back
            Version: 2.1  |  File: Request.xaml  |  Act on: OBIS measurement
            Required user role:  PM | EDM | NDW 
Job: Sends a data request for the OBIS of the metering point
Parameter:
Time range function
(optional)
Defines, how the time range for the request will be set (full, number of days, newest or specific timerange)
Days
(optional)
Defines, for how many days in the past the values will be requested
Timerange
(optional)
Defines, for which time range the values will be requested
Finished trigger
(optional)
Defines the trigger which should be executed when the workflow was finished
Requires / creates: nothing
Output
DownloadRequest.zip
WF-Changes
05/12/2017, 2.0, Multi-Target workflows
05/12/2017, 2.1, FIX: Parameter time range has no effect

Request data (Mobile)

Back
            Version: 2.0  |  File: RequestWithLimit.xaml  |  Act on: OBIS measurement
            Required user role:  PM | EDM | NDW 
Job: Sends a data request for an metering point OBIS (type energy counter) of a mobile metering point and enables the monitoring of the consumption on the mobile device
Parameter:
Validate limit
(required)
Specifies whether to validate the limit or not
Time interval
(required)
Time interval for the validation
Lower limit value
(required)
Lower limit value for the validated interval
Upper limit value
(required)
Upper limit value for one period value
Finished trigger
(optional)
Defines the trigger which should be executed when the workflow was finished
Requires / creates: nothing
Output
DownloadRequestWithLimit.zip
WF-Changes
02/08/2018, 2.0, Workflow created

Sends an e-mail

Back
            Version: 2.2  |  File: SendMail.xaml  |  Act on: All
            Required user role: SA | PM 
Job: Sends a configurable e-mail
Parameter:
Recipient list for e-mail
(required)
Defines, to which recipients the e-mail will be sent
Subject
(required)
Subject of e-mail
Body
(required)
Body of e-mail (HTML)
Recipient list for a copy of e-mail (CC)
(optional)
Defines, to which recipients a copy of the e-mail will be sent (CC)
Recipient list for a blind copy of e-mail (BCC)
(optional)
Defines, to which recipients a blind copy of the e-mail will be sent (BCC)
Finished trigger
(optional)
Defines the trigger which should be executed when the workflow was finished
Requires / creates: nothing
Output
DownloadSendMail.zip
WF-Changes
05/24/2017, 1.4, Added parameters for CC and BCC
05/12/2017, 2.0, Multi-Target workflows
07/03/2017, 2.1, Multi-Target workflows (added parameters TargetGuid/TargetType)
07/30/2018, 2.2, FIX: Permission to workflow for SysAdmin-Role

Simulation of energy storage

Back
            Version: 2.2  |  File: SimulateEnergyStorage.xaml  |  Act on: Meteringpoint
            Required user role:  PM | EDM | NDW 
Job: Simulates the behavior of a battery pack in the network. It is assumed that self-generation is used to cover the demand and is to be optimized with a battery storage. For the assigned (calculated) meteringpoint, five OBIS measured variables are determined for each measurement period: charge energy to storage, discharge energy from storage, selfproduced feed back to the grid, resulting feed from grid and charge state of battery.
Parameter:
External feed
(required)
Select the meteringpoint of of an external feed. The OBIS measure 'Load profile P+, T0' is expected.
Self-generating
(required)
Select the meteringpoint of a self-generating plant. The OBIS measure 'Load profile P+, T0' is expected.
Storage size
(required)
Specification of the storage size in kWh.
Timerange
(optional)
Defines, for which time range the values will be validated
Finished trigger
(optional)
Defines the trigger which should be executed when the execution of the workflow finishes
Requires / creates:
001-002:001.029.000*255P+ Lastgang T0, Kanal 2
001-002:002.029.000*255P- Lastgang T0, Kanal 2
001-003:001.029.000*255P+ Lastgang T0, Kanal 3
Output
DownloadSimulateEnergyStorage.zip
WF-Changes
07/24/2017, 2.0, Created
08/01/2017, 2.1, Changes after testing
07/24/2017, 2.2, Description changed

Switch switchgroup

Back
            Version: 2.1  |  File: SetSwitchGroupState.xaml  |  Act on: Location
            Required user role:  PM 
Job: Switches a defined location switchgroup
Parameter:
Switch group
(required)
Defines the ID of the switchgroup, which state should be set
Target state
(required)
The target state of the switchgroup 1-Off
2-On
3-Auto
2_3-On/Auto
1_3-Off/Auto
4-Flashed
Finished trigger
(optional)
Defines the trigger which should be executed when the workflow was finished
Requires / creates: nothing
Output
DownloadSetSwitchGroupState.zip
WF-Changes
05/12/2017, 2.0, Multi-Target workflows
02/07/2018, 2.1, Argument TargetState changed to type user defined options

Transformer losses

Back
            Version: 2.2  |  File: TransformerLosses.xaml  |  Act on: Component
            Required user role: SA 
Job: Calculates transformer losses for a default of type 'Transformer'
Parameter:
Time range function
(optional)
Defines, how the time range for the calculation will be set (number of days or specific timerange)
Days
(optional)
Defines, for how many days in the past the values will be calculated
Timerange
(optional)
Defines, for which time range the values will be calculated
Finished trigger
(optional)
Defines the trigger which should be executed when the workflow was finished
Requires / creates:
001-200:001.029.000*255P, Trafoverluste, T0
Output
DownloadTransformerLosses.zip
WF-Changes
05/12/2017, 2.0, Multi-Target workflows
10/16/2017, 2.1, Version increased to reflect changes in library Kbr.VisualEnergy4.Definitions
08/09/2018, 2.3, FIX: OBIS codes of type EnergyFeed must define an interval"

Update multisys_BM

Back
            Version: 2.0  |  File: AutomaticUpdate.xaml  |  Act on: Multisys
            Required user role: SA 
Job: Updates all multisys-BM which are configured to perform auto updates
Parameter:
User name
(optional)
User name used to connect to network share on multisys-BM. Leave empty to use the multisys-BM default user.
Password
(optional)
Password used to connect to network share on multisys-BM. Leave empty to use multisys-BM default passwords.
Recipient list for e-mail
(optional)
Defines, to which recipients the e-mail will be sent.
Finished trigger
(optional)
Defines the trigger which should be executed when the workflow was finished
Requires / creates: nothing
Output
DownloadAutomaticUpdate.zip
WF-Changes
12/17/2018, 2.0, Created

Weekly sum values

Back
            Version: 2.4  |  File: CompressWeekSum.xaml  |  Act on: OBIS measurement
            Required user role:  PM | EDM | NDW 
Job: Compresses load profile data to weekly sums
Parameter:
Time range function
(optional)
Defines, how the time range for the compression will be set (number of days or specific timerange)
Days
(optional)
Defines, for how many days in the past the values will be calculated
Timerange
(optional)
Defines, for which time range the values will be calculated
Finished trigger
(optional)
Defines the trigger which should be executed when the workflow was finished
Requires / creates:
001-001:001.133.000*255P+, Wochensumme, T0
001-001:002.133.000*255P-, Wochensumme, T0
001-001:003.133.000*255Q+, Wochensumme, T0
001-001:004.133.000*255Q-, Wochensumme, T0
004-000:001.133.000*255Wärme (Kosten), Wochensumme, T0
005-001:099.133.000*255Kälte, Wochensumme, T0
006-001:003.133.000*255Wärme [kg], Wochensumme, T0
006-001:099.133.000*255Wärme [kWh], Wochensumme, T0
007-001:000.133.000*255Gas, Energiewert endgültig, Wochensumme T0
007-001:128.133.000*255Erdgas, Betriebskubikmeter, Wochensumme, T0
007-001:129.133.000*255Erdgas, Normkubikmeter, Wochensumme T0
008-001:099.133.000*255Trinkwasser / Brauchwasser, kalt, Wochensumme, T0
008-001:128.133.000*255Trinkwasser, kalt, Wochensumme, T0
008-001:129.133.000*255Brauchwasser, kalt, Wochensumme, T0
008-001:130.133.000*255VE-Wasser, kalt, Wochensumme, T0
009-001:099.133.000*255Trinkwasser / Brauchwasser, heiß, Wochensumme, T0
009-001:128.133.000*255Trinkwasser, heiß, Wochensumme, T0
009-001:129.133.000*255Brauchwasser, heiß, Wochensumme, T0
009-001:130.133.000*255VE-Wasser, heiß, Wochensumme, T0
016-001:000.133.000*255Heizöl Energiewert, Wochensumme, T0
016-001:128.133.000*255Heizöl [l], Wochensumme, T0
016-001:129.133.000*255Heizöl [m³], Wochensumme, T0
016-020:099.033.017*255Heizöl Energiewert, Lastgang, T0
017-001:128.133.000*255Druckluft, Wochensumme, Betriebskubikmeter, T0
017-001:129.133.000*255Druckluft, Wochensumme, Normkubikmeter, T0
018-001:128.133.000*255Stickstoff, Wochensumme, Betriebskubikmeter, T0
018-001:129.133.000*255Stickstoff, Wochensumme, Normkubikmeter, T0
Output
DownloadCompressWeekSum.zip
WF-Changes
05/12/2017, 2.0, Multi-Target workflows
07/24/2017, 2.1, Allow trigger "execute on receive data"
05/22/2018, 2.2, Added OBIS codes"
05/25/2018, 2.3, Added OBIS codes"
12/06/2018, 2.4, Reload MP-OBIS before setting full time range"

Writes setpoint values

Back
            Version: 2.4  |  File: WriteSetpointValues.xaml  |  Act on: OBIS measurement
            Required user role:  PM | EDM | NDW | NDF 
Job: Writes setpoint values for selected OBIS measurement, depending on working and non-working days.
Parameter:
Time range function
(optional)
Defines, how the time range for the creation of data will be set (full, number of days or specific timerange)
Days
(optional)
Defines, for how many days in the past the values will be created
Timerange
(optional)
Defines, for which time range the values will be created
Setpoint value working day
(required)
Setpoint value working day
Setpoint value non working day
(required)
Setpoint value non working day
Finished trigger
(optional)
Defines the trigger which should be executed when the execution of the workflow finishes
Requires / creates:
001-129:001.029.000*255P+, Sollwert Lastgang, T0
001-129:001.030.000*255P+, Sollwert Stunde, T0
001-129:001.132.000*255P+, Sollwert Tag, T0
001-129:001.133.000*255P+, Sollwert Woche, T0
001-129:001.134.000*255P+, Sollwert Monat, T0
001-129:001.136.000*255P+, Sollwert Jahr, T0
001-129:002.029.000*255P-, Sollwert Lastgang, T0
001-129:002.132.000*255P-, Sollwert Tag, T0
001-129:002.134.000*255P-, Sollwert Monat, T0
001-129:002.136.000*255P-, Sollwert Jahr, T0
001-129:003.029.000*255Q+, Sollwert Lastgang, T0
001-129:003.132.000*255Q+, Sollwert Tag, T0
001-129:003.134.000*255Q+, Sollwert Monat, T0
001-129:003.136.000*255Q+, Sollwert Jahr, T0
001-129:004.029.000*255Q-, Sollwert Lastgang, T0
001-129:004.132.000*255Q-, Sollwert Tag, T0
001-129:004.134.000*255Q-, Sollwert Monat, T0
001-129:004.136.000*255Q-, Sollwert Jahr, T0
005-129:001.134.000*255Kälte, Sollwert Monat, T0
005-129:001.136.000*255Kälte, Sollwert Jahr, T0
005-129:099.001.000*255Kälte, Sollwert Lastgang, T0
005-129:099.132.000*255Kälte, Sollwert Tag, T0
005-129:099.133.000*255Kälte, Sollwert Woche, T0
006-129:001.134.000*255Wärme, Sollwert Monat, T0
006-129:001.136.000*255Wärme, Sollwert Jahr, T0
006-129:099.001.000*255Wärme, Sollwert Lastgang, T0
006-129:099.132.000*255Wärme, Sollwert Lastgang, Tag, T0
006-129:099.133.000*255Wärme, Sollwert Lastgang, Woche, T0
007-129:099.033.017*255Erdgas, Sollwert Lastgang, Energie, T0
007-129:099.132.017*255Erdgas, Sollwert Tag, Energie, T0
007-129:099.133.017*255Erdgas, Sollwert Woche, Energie, T0
007-129:099.134.017*255Gas, Energiewert endgültig, Sollwert Monat T0
007-129:099.136.017*255Gas, Energiewert endgültig, Sollwert Jahr T0
007-129:128.130.000*255Erdgas, Sollwert Lastgang, Betriebskubikmeter, T0
007-129:128.132.017*255Erdgas, Sollwert Lastgang, Tag, Betriebskubikmeter, T0
007-129:128.133.017*255Erdgas, Sollwert Woche, Betriebskubikmeter, T0
007-129:128.134.000*255Gas, Betriebskubikmeter, Sollwert Monat T0
007-129:128.136.000*255Gas, Betriebskubikmeter, Sollwert Jahr T0
007-129:129.130.000*255Erdgas, Sollwert Lastgang, Normkubikmeter, T0
007-129:129.132.017*255Erdgas, Sollwert Lastgang, Tag, Normkubikmeter, T0
007-129:129.133.017*255Erdgas, Sollwert Woche, Normkubikmeter, T0
007-129:129.134.000*255Gas, Normkubikmeter, Sollwert Monat T0
007-129:129.136.000*255Gas, Normkubikmeter, Sollwert Jahr T0
008-129:001.134.000*255Trinkwasser / Brauchwasser kalt, Sollwert Monat, T0
008-129:001.136.000*255Trinkwasser / Brauchwasser kalt, Sollwert Jahr, T0
008-129:099.001.000*255Trinkwasser / Brauchwasser kalt, Sollwert Lastgang, T0
008-129:099.132.000*255Trinkwasser / Brauchwasser kalt, Sollwert Tag, T0
008-129:099.133.000*255Trinkwasser / Brauchwasser kalt, Sollwert Woche, T0
008-129:128.130.000*255Trinkwasser kalt, Sollwert Lastgang, T0
008-129:128.132.000*255Trinkwasser kalt, Sollwert Tag, T0
008-129:129.130.000*255Brauchwasser kalt, Sollwert Lastgang, T0
009-129:001.133.000*255Trinkwasser / Brauchwasser heiß, Sollwert Woche, T0
009-129:001.134.000*255Trinkwasser / Brauchwasser heiß, Sollwert Monat, T0
009-129:001.136.000*255Trinkwasser / Brauchwasser heiß, Sollwert Jahr, T0
016-020:099.033.017*255Heizöl Energiewert, Lastgang, T0
016-129:000.132.000*255Heizöl Energiewert, Sollwert Tag, T0
016-129:000.133.000*255Heizöl Energiewert, Sollwert Woche, T0
016-129:000.134.000*255Heizöl Energiewert, Sollwert Monat, T0
016-129:000.136.000*255Heizöl Energiewert, Sollwert Jahr, T0
Output
DownloadWriteSetpointValues.zip
WF-Changes
05/12/2017, 2.0, Multi-Target workflows
09/14/2017, 2.1, Correction of OBIS functions and units (set point values)
05/25/2018, 2.2, Added OBIS codes"
08/09/2018, 2.3, FIX: OBIS codes of type LoadProfile must define a period-length"
12/06/2018, 2.4, Reload MP-OBIS before setting full time range. FIX: Message text of exception, thrown if targetObis does not exist, improved."

Diesen Beitrag teilen