Suche:

Workflows

Back to the overview

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

Absolute validation

Back
            Version: 2.7  
File: ValidateAbsolute.xaml
Act on: OBIS measurement Required user role: PM
EDM
NDW
NDF
Job: Monitors a configurable limit value for overshoot or undershoot within a definable validation timespan. All load profile data and energy feed data of all media can be used. If a limit value is violated, an e-mail can be sent. The switching group 244 'Collective fault limit value violation' can be activated. A user-defined trigger can be activated.
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.
Time range function
(optional)
Defines, how the time range for the validation will be set.

newest: Time between the last validation date and the time of execution.

full: The total time period, starting from the timestamp of the first record.

number of days: Whole days in the past whithout the day of execution.

specific timerange: Precise specification of start and end time.
Last validation date
(optional)
Last date for which an absolute validation was performed. Only active if 'newest' is selected as the time range function.
Days
(optional)
Specifies the number of days for which the validation is to be performed in the past. The execution day is not validated. Only active if 'number of days' is selected as the time range function.
Timerange
(optional)
Defines the time range for which the values are validated. Only active if 'timerange' is selected as the time range function.
Validation timespan
(required)
Defines the monitoring period for which a validation of the limit value is to be performed.
Limit value
(required)
Sets the limit value for validation.
React if
(required)
Defines, if a limit violation will be determined by undercut or overflow the limit value.
Recipient list for e-mail
(optional)
Defines, to which recipients the e-mail will be sent. The recipients can be separated by semicolons.
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 'Combined fault limit violoation'
(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.
04/30/2019, 2.3, Usable with Version newer than 4.7 Release 1 Build 12518. Add the "newest" time range function. Update of description.
07/23/2019, 2.4, Correct the time range of the 'newest' function.
08/22/2019, 2.5, Correct the end date of time range of the 'newest' function to utc.
06/14/2021, 2.6, Extended SMTP-Options
07/07/2021, 2.7, Update of description.

Alternate value creation

Back
            Version: 2.10  
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. The intervals of the energy meter or energy feed data are broken down to the defined interval of the load profile OBIS identifier and distributed evenly.
Parameter:
Time range function
(optional)
Defines, how the time range for the alternate value creation will be set.

newest: Time between the last alternate value creation and the time of execution.

full: The total time period, starting from the timestamp of the first record.

number of days: Whole days in the past starting at the time of the execution.

specific timerange: Precise specification of start and end time.
Days
(optional)
Defines the number of days for which alternate value creation is performed in the past. Start at the execution time. Only active if 'number of days' is selected as the time range function.
Timerange
(optional)
Defines the timerange for which the alternate values are calculated. Only active if 'timerange' is selected as the time range function.
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.
05/23/2019, 2.9, Update of description.
06/03/2019, 2.10, Fix: For several energy meter in one measurement period, the load profile is not calculated correctly. Load profile data is not calculated in the past if some load profile data already exists. Usable with Version newer than 4.7 Release 1 Build 12518.

Calculate degree day value for day

Back
            Version: 2.2  
File: CalculateDegreeDayValue.xaml
Act on: OBIS measurement Required user role: PM
EDM
NDW
Job: For each day in the execution interval, a degree day value is calculated and stored as a new OBIS identifier. The daily mean temperature is calculated and compared with the definable heating limit. If the daily mean temperature during the day is higher than the heating swell, then this day is a non heating day and the degree day value is zero. If the daily mean temperature during the day is lower than the heating swell, then this day is a heating day and the degree day value is the difference between mean temperature and heating swell. The calculation is only applicable to the OBIS identifier 'temperature (average)' (000-000:128.128.000*255). A user-defined finished trigger can be executed.
Parameter:
Heating limit
(required)
Defines the heating limit in the temerature unit.
Time range function
(optional)
Defines, how the time range for the calculation will be set.

full: The total time period, starting from the timestamp of the first record.

number of days: Whole days in the past whithout the day of execution.

specific timerange: Precise specification of start and end time.
Days
(optional)
Defines the number of days for which the calculation is performed in the past. The execution day is not calculated. Only active if 'number of days' is selected as the time range function.
Timerange
(optional)
Defines the timerange for which the values are calculated. Only active if 'timerange' is selected as the time range function.
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.1, Reload MP-OBIS before setting full time range.
05/08/2019, 2.2, Update of description.

Calculation by formula

Back
            Version: 2.7  
File: CalculateFormula.xaml
Act on: OBIS measurement Required user role: NDW
Job: Calculates data using the specified formula and writes the results to the OBIS identifier currently used. The formula editor handles complex formulas and the data can derive from any metering points and any OBIS measured variables. The status processing always uses the worst status of the source for the result. The calculation using the formula can be applied to all OBIS identifiers of all media. A user-defined finished trigger can be executed.
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.
Calculation formula
(required)
Definition of the mathematical formula used for the calculation. A metering point must be included.
Time range function
(optional)
Defines, how the time range for the calculation will be set.

newest: Time between the last calculation date and the time of execution.

full: The total time period, starting from the timestamp of the first record.

number of days: Whole days in the past starting at the hour of the execution.

specific timerange: Precise specification of start and end time.
Last calculation date
(optional)
Last date for which the formula was calculated. Only active if 'newest' is selected as the time range function.
Days
(optional)
Defines the number of days for which the calculation is performed in the past. Starts from the full hour of execution. Only active if 'number of days' is selected as the time range function.
Timerange
(optional)
Defines the timerange for which the values are calculated. Only active if 'timerange' is selected as the time range function.
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.
05/15/2019, 2.3, Usable with Version newer than 4.7 Release 1 Build 12518. Add the "newest" time range function and set it as default. Update of description.
07/17/2019, 2.4, UPD: Add the min- and max-function.
07/23/2019, 2.5, Correct the time range of the 'newest' function.
08/22/2019, 2.6, Correct the end date of time range of the 'newest' function to utc.
03/04/2021, 2.7, Correct the update of the time range 'newest' function and set the correct last calculation date.

CO2 Calculation

Back
            Version: 2.6  
File: CalculateCo2.xaml
Act on: OBIS measurement Required user role: PM
EDM
NDW
Job: For each measured value, of the specified OBIS measurand, the CO2 emission is calculated using the definable CO2 weight and stored as a new OBIS number plate. The calculation can be carried out for all load profile and energy feed data of all media for which a CO2 emission OBIS identifier is defined. A user-defined finished trigger can be executed.
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.
CO2 weight
(required)
CO2 weight in grams (g).
Time range function
(optional)
Defines, how the time range for the CO2 calculation will be set.

newest: Time between the last calculation date and the time of execution.

full: The total time period, starting from the timestamp of the first record.

number of days: Whole days in the past whithout the day of execution.

specific timerange: Precise specification of start and end time.
Last calculation date
(optional)
Last date for which a CO2 calculation was performed. Only active if 'newest' is selected as the time range function.
Days
(optional)
Defines the number of days for which the calculation is performed in the past. The execution day is not calculated. Only active if 'number of days' is selected as the time range function.
Timerange
(optional)
Defines the timerange for which the CO2 values are calculated. Only active if 'timerange' is selected as the time range function.
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.
05/17/2019, 2.3, Usable with Version newer than 4.7 Release 1 Build 12518. Add the "newest" time range function and set it as default. Update of description.
07/23/2019, 2.4, Correct the time range of the 'newest' function.
08/14/2019, 2.5, Add default-date for last calculation date.
08/22/2019, 2.6, Correct the end date of time range of the 'newest' function to utc.

Compress

Back
            Version: 2.3  
File: Compress.xaml
Act on: OBIS measurement Required user role: PM
EDM
NDW
Job: Compresses data from an OBIS identifier into a time interval using a definable aggregation function. The interval used to compress the data (for example, hours, days, ...) corresponds to the defined interval of the target OBIS. Compression can be performed for all data in all media. However, the results can only be stored in a previously defined energy feed OBIS identifier. A user-defined finished trigger can be executed.
Parameter:
Target OBIS
(required)
Specifies the OBIS flag where the generated data will be stored. The compression interval corresponds to the interval of the selected target OBIS identifier. The OBIS has to be of the energy feed type.
Aggregate function
(required)
Determines the function used to compress the data.
Time range function
(optional)
Defines, how the time range for the compression will be set.

full: The total time period, starting from the timestamp of the first record.

number of days: Whole days in the past whithout the day of execution.

specific timerange: Precise specification of start and end time.
Days
(optional)
Defines the number of days for which the compression is performed in the past. The execution day is not compressed. Only active if 'number of days' is selected as the time range function.
Timerange
(optional)
Defines the timerange for which the compression is calculated. Only active if 'timerange' is selected as the time range function.
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.
05/09/2019, 2.3, Update of description.

Consistency check

Back
            Version: 2.11  
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. The target object can be location, medium, distribution or metering point. A user-defined trigger can be activated.
Parameter:
OBIS
(required)
Defines the OBIS which should be validated.
Minimal status
(optional)
Defines the minimal status for a limit violations.0-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 for the consistency check will be set.

full: The total time period, starting from the timestamp of the first record.

number of days with duration: Whole days in the past whithout the day of execution.

specific timerange: Precise specification of start and end time.
Offset (days)
(optional)
Defines the start time of the validation. Starting from the day 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 timerange for which the consistency check is performed. Only active if 'timerange' is selected as the time range function.
Recipient list for e-mail
(optional)
Defines, to which recipients the e-mail will be sent. The recipients can be separated by semicolons.
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 consistency 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 verification could not determine any errors.
Invalid trigger
(optional)
Defines the trigger which should be executed when the verification 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.
05/20/2019, 2.8, Update of description.
07/16/2019, 2.9, Adapted log file.
06/14/2021, 2.10, Extended SMTP-Options
07/07/2021, 2.11, Update of description.

cos Phi

Back
            Version: 2.4  
File: CosPhi.xaml
Act on: Meteringpoint Required user role: PM
Job: Calculates the cos(φ) for each period for a specified metering point using the formula cos(φ) = P / Sqrt(P*P + Q*Q). The result is written to the OBIS identifier 'Power factor, load profile, T0' (001-000:013.029.000*255). The workflow is only usable for the medium electricity. A user-defined finished trigger can be executed.
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.
Time range function
(optional)
Defines, how the time range for the cos(φ) calculation will be set.

newest: Time between the last calculation date and the time of execution.

full: The total time period, starting from the timestamp of the first record.

number of days: Whole days in the past whithout the day of execution.

specific timerange: Precise specification of start and end time.
Last calculation date
(optional)
Last date for which a cos(φ) calculation was performed. Only active if 'newest' is selected as the time range function.
Days
(optional)
Defines the number of days for which the calculation is performed in the past. The execution day is not calculated. Only active if 'number of days' is selected as the time range function.
Timerange
(optional)
Defines the timerange for which the values are calculated. Only active if 'timerange' is selected as the time range function.
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).
05/21/2019, 2.2, Usable with Version newer than 4.7 Release 1 Build 12518. Add the "newest" time range function. Update of description.
07/23/2019, 2.3, Correct the time range of the 'newest' function.
08/22/2019, 2.4, Correct the end date of time range of the 'newest' function to utc.

Create Dashboard PDF

Back
            Version: 2.7  
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)
Defines extended URL parameters to be passed to the dashboard (example: v1=value of V1&v2=value of V2).
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
04/24/2019, 2.6, Update of description
06/14/2021, 2.7, Extended SMTP-Options

Create permission matrix

Back
            Version: 2.1  
File: PermissionMatrixCreator.xaml
Act on: System Required user role: SA
Job: Creates an Excel file that contains a permission matrix for each user for a single project or for all projects. The file is saved under system documents.
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
05/21/2019, 2.1, Update of description.

CSV Data export (XML)

Back
            Version: 2.12  
File: CsvExportXml.xaml
Act on: Documents Required user role: PM
Job: Exports data in CSV format. The configuration and structure of the file to be exported is defined in the XML file, that is stored in the target object documents.
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).
05/20/2019, 2.9, Update of description.
10/28/2019, 2.10, Fix: Continual export for intervals unequal to 'Period'.
10/29/2019, 2.11, Write name of location to column using ref='Location'.
04/23/2020, 2.12, Fix: Correction of the time at time change.

CSV Export

Back
            Version: 3.9  
File: ExportCsv.xaml
Act on: OBIS measurement Required user role: PM
EDM
NDW
Job: Exports daily or monthly data from an OBIS identifier to CSV files. You can determine which data status must be minimal for the export to be successful. Using the test mode, additional special data can be exported without without changing the last export date. An output directory can be defined for the CSV file and / or an e-mail recipient list can be specified. The parameters, which are written into the file, can be determined individually.
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)
Defines the lowest status of a value so that an export is still performed. If the status is worse than specified here, there is no export!
Export timespan
(optional)
Determines the time period to be exported. The parameter 'Last export date' is decisive.

Daily: From the day after the last export date. A CSV-file is created for each day.

Monthly: An entire month from the last exported date. A CSV-file is created for each month.
Last export date
(optional)
Date of last successful export. Not updated in test mode.
Test mode
(optional)
In test mode, data is exported starting from the execution time. The time span is calculated using the 'offset for test mode' parameter. The 'last export date' parameter is ignored and is not updated. This means that the export of a time period can be executed several times.
Offset for test mode
(optional)
Specifies the time span for the 'test mode', depending on the 'export timespan' parameter.

Daily 'export timespan': Number of days in the past, starting from the current day.

Monthly 'export timespan': Number of whole months in the past, starting from the current month.
Target directory
(optional)
Specifies the output directory as the absolute path (e.g. C:\ExportData) to which the file is to be exported. The directory must be accessible from the web server, and the network service must have write access to the folder.
Recipient list for e-mail
(optional)
Defines, to which recipients the e-mail with the CSV-file will be sent. The recipients can be separated by semicolons.
Delimiter
(optional)
Defines the delimiter for the columns in the CSV-file. ;-Semicolon
TAB-Tabulator
Has header
(optional)
Defines if the header row will be written to the file.
Field set
(optional)
Provides a list of possible output fields. Configures which parameters and in which format the parameters are written to the output file. Different formats are possible for date and numbers.
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.
05/15/2019, 3.7, Update of description.
06/14/2021, 3.8, Extended SMTP-Options
07/07/2021, 3.9, Update of description.

CSV Import

Back
            Version: 2.4  
File: ImportCsv.xaml
Act on: OBIS measurement Required user role: PM
EDM
NDW
Job: Imports a CSV file and saves the values in an OBIS identifier. The file must contain at least one column with a time stamp (end time) and a value. The status can also be read in. If no status is contained in the CSV file, a default status can be set for all values.
Parameter:
Filename
(required)
Specifies the absolute path and the name of the file to be imported (e.g. C:\ImportData\Example.csv). The directory must be accessible from the web server and the network service must be authorized to access the folder.
Delete file
(optional)
Defines if the CSV file should be deleted after import. If the file is not deleted, a 'Done' folder is created in the specified path and the file is moved into this folder. The network service requires write access to the folder.
Delimiter
(optional)
Specifies the delimiter that separates the columns in the CSV file. ;-Semicolon
TAB-Tabulator
Timestamp is UTC
(optional)
Defines if the timestamps in the CSV file should be interpreted as UTC times.
Column index timestamp
(optional)
Defines the index of the column with the timestamp. The column index starts at 1.
Column index value
(optional)
Defines the index of the column with the value. The column index starts at 1.
Column index state
(optional)
Defines the index of the column with the state. The column index starts at 1. If there is no status in the CSV file, set the column index to 0. This defines a 'default state' for the values.
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)
Specifies whether a header is included in the CSV file so that it can 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.
05/09/2019, 2.3, Update of description.
02/25/2021, 2.4, FIX: Workflow terminates on empty columns.

Cumulated maximas

Back
            Version: 2.5  
File: CreateCumulatedData.xaml
Act on: OBIS measurement Required user role: PM
EDM
NDW
Job: For a selected OBIS measured variable, the hourly value is determined for each period value and stored in a new OBI identifier. This transformation can be carried out for all load profile and energy feed data of all media whose channel definition is encoder-specific (OBIS group B: 0-127). A user-defined Exit Trigger can be triggered.
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.
Time range function
(optional)
Defines, how the time range for the cumulated maximas will be set.

newest: Time between the last cumulation and the time of execution.

full: The total time period, starting from the timestamp of the first record.

number of days: Whole days in the past whithout the day of execution.

specific timerange: Precise specification of start and end time.
Last cumulation date
(optional)
Last date for which a cumulation was carried out. Only active if 'newest' is selected as the time range function.
Days
(optional)
Defines the number of days for which the cumulation is performed in the past. The execution day is not cumulated. Only active if 'number of days' is selected as the time range function.
Timerange
(optional)
Defines the timerange for which the cumulation is calculated. Only active if 'timerange' is selected as the time range function.
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.
05/17/2019, 2.3, Usable with Version newer than 4.7 Release 1 Build 12518. Add "newest" time range function and set it as default. Update of description.
07/23/2019, 2.4, Correct the time range of the 'newest' function.
08/22/2019, 2.5, Correct the end date of time range of the 'newest' function to utc.

Data calculation (medium)

Back
            Version: 2.9  
File: CalculatePlanData.xaml
Act on: Medium Required user role: PM
EDM
Job: Calculates load profile data of a location medium. The load profile data of a medium is determined on the basis of the sum of receipts, issues, internal supply, external supply, consumption sum and the difference amount. A user-defined finished trigger can be executed.
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.
Time range function
(optional)
Defines, how the time range for the calculation will be set.

newest: Time between the last calculation date and the time of execution.

full: The total time period, starting from the timestamp of the first record.

number of days: Whole days in the past whithout the day of execution.

specific timerange: Precise specification of start and end time.
Last calculation date
(optional)
Last date for which an data calculation was performed. Only active if 'newest' is selected as the time range function.
Days
(optional)
Defines the number of days for which the calculation is performed in the past. The execution day is not calculated. Only active if 'number of days' is selected as the time range function.
Timerange
(optional)
Defines the timerange for which the values are calculated. Only active if 'timerange' is selected as the time range function.
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.
05/21/2019, 2.6, Usable with Version newer than 4.7 Release 1 Build 12518. Add the "newest" time range function. Update of description.
07/23/2019, 2.7, Correct the time range of the 'newest' function.
08/22/2019, 2.8, Correct the end date of time range of the 'newest' function to utc.
02/25/2021, 2.9, Fix: 'newest' time range.

Data calculation (plant)

Back
            Version: 2.5  
File: CalculatePlantData.xaml
Act on: Distribution Required user role: PM
Job: Calculates load profile data of a distributing plant. The sums of the entries, the exits, the own generation and the energy suppliers are calculated in parallel, as well as the difference of the specified distribution. The newly calculated data is written to the specific OBIS identifier of the distribution. A user-defined finished trigger can be executed.
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.
OBIS
(required)
Defines the OBIS identifier for which the data calculation should be calculated for the distribution.
Time range function
(optional)
Defines, how the time range for the calculation will be set.

newest: Time between the last calculation date and the time of execution.

full: The total time period, starting from the timestamp of the first record.

number of days: Whole days in the past whithout the day of execution.

specific timerange: Precise specification of start and end time.
Last calculation date
(optional)
Last date for which an data calculation was performed. Only active if 'newest' is selected as the time range function.
Days
(optional)
Defines the number of days for which the calculation is performed in the past. The execution day is not calculated. Only active if 'number of days' is selected as the time range function.
Timerange
(optional)
Defines the timerange for which the values are calculated. Only active if 'timerange' is selected as the time range function.
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.
05/21/2019, 2.4, Usable with Version newer than 4.7 Release 1 Build 12518. Add the "newest" time range function. Update of description.
08/22/2019, 2.5, Correct the end date of time range of the 'newest' function to utc.

Data compression (Energy feed)

Back
            Version: 2.3  
File: CompressEnergyFeed.xaml
Act on: OBIS measurement Required user role: PM
EDM
NDW
Job: Compresses data from an OBIS identifier into a time interval using a definable aggregation function. The interval used to compress the data (e.g. hours, days, ...) is determined. Compression can be performed for all data in all media. However, the results can only be stored in a previously defined energy feed OBIS identifier. A user-defined finished trigger can be executed.
Parameter:
Target OBIS
(required)
Specifies the OBIS flag where the generated data will be stored. The OBIS has to be of the energy feed type.
Aggregate interval
(required)
Defines the interval for the compression.
Aggregate function
(required)
Determines the function used to compress the data.
Time range function
(optional)
Defines, how the time range for the compression will be set.

full: The total time period, starting from the timestamp of the first record.

number of days: Whole days in the past whithout the day of execution.

specific timerange: Precise specification of start and end time.
Days
(optional)
Defines the number of days for which the compression is performed in the past. The execution day is not compressed. Only active if 'number of days' is selected as the time range function.
Timerange
(optional)
Defines the timerange for which the compression is calculated. Only active if 'timerange' is selected as the time range function.
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"
05/14/2019, 2.3, Update of description.

Data compression (load profile)

Back
            Version: 2.3  
File: CompressLoadProfile.xaml
Act on: OBIS measurement Required user role: PM
EDM
NDW
Job: Compresses data from an OBIS identifier into a time interval using a definable aggregation function. Sets individual values of the data in an interval of the target OBIS. Compression can be performed for all data in all media. However, the results can only be stored in a previously defined load profile OBIS identifier. A user-defined finished trigger can be executed.
Parameter:
Target OBIS
(required)
Specifies the OBIS flag where the generated data will be stored. The compression interval corresponds to the interval of the selected target OBIS identifier. The OBIS has to be of the load profile type.
Aggregate function
(required)
Determines the function used to compress the data.
Time range function
(optional)
Defines, how the time range for the compression will be set.

full: The total time period, starting from the timestamp of the first record.

number of days: Whole days in the past whithout the day of execution.

specific timerange: Precise specification of start and end time.
Days
(optional)
Defines the number of days for which the compression is performed in the past. The execution day is not compressed. Only active if 'number of days' is selected as the time range function.
Timerange
(optional)
Defines the timerange for which the compression is calculated. Only active if 'timerange' is selected as the time range function.
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.
05/13/2019, 2.3, Update of description.

Dayly cumulated values

Back
            Version: 2.4  
File: CompressDayCumulate.xaml
Act on: OBIS measurement Required user role: PM
EDM
NDW
Job: For a selected OBIS measured variable, daily maximum values are determined from the period values and hourly values are generated from them. These are stored with the period timestamp of the daily maximum value as a new OBIS identifier. This transformation can be carried out for all load profile and energy feed data of all media whose channel definition is encoder-specific (OBIS group B: 0-127). A user-defined finished trigger can be triggered.
Parameter:
Time range function
(optional)
Defines, how the time range for the dayly cumulated values will be set.

full: The total time period, starting from the timestamp of the first record.

number of days: Whole days in the past whithout the day of execution.

specific timerange: Precise specification of start and end time.
Days
(optional)
Defines the number of days for which the cumulation is performed in the past. The execution day is not cumulated. Only active if 'number of days' is selected as the time range function.
Timerange
(optional)
Defines the timerange for which the cumulation is calculated. Only active if 'timerange' is selected as the time range function.
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.
05/17/2019, 2.4, Update of description.

Dayly sum values

Back
            Version: 2.5  
File: CompressDaySum.xaml
Act on: OBIS measurement Required user role: PM
EDM
NDW
Job: Compresses periodical load profile data to dayly sums for the media electricity, heat, cold, cold water, warm water, natural gas. Stores the results in the energy feed OBIS identifier sum of day. A user-defined finished trigger can be executed.
Parameter:
Time range function
(optional)
Defines, how the time range for the calculation will be set.

full: The total time period, starting from the timestamp of the first record.

number of days: Whole days in the past whithout the day of execution.

specific timerange: Precise specification of start and end time.
Days
(optional)
Defines the number of days for which the calculation is performed in the past. The execution day is not calculated. Only active if 'number of days' is selected as the time range function.
Timerange
(optional)
Defines the timerange for which the values are calculated. Only active if 'timerange' is selected as the time range function.
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.
05/13/2019, 2.5, Update of description.

Delete (older than)

Back
            Version: 2.2  
File: Delete.xaml
Act on: OBIS measurement Required user role: PM
EDM
NDW
Job: Deletes the data of an measuring poin OBIS identifiers that is older than the specified storage time at the time of execution. Data of all measuring point OBIS identifiers can be deleted from all media. A user-defined finished trigger can be executed.
Parameter:
Storage time
(required)
Specifies how long the data will be stored. After this time has elapsed, the data will be deleted at execution time.
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".
05/13/2019, 2.2, Update of description.

Delete (time range)

Back
            Version: 2.2  
File: DeleteTimeRange.xaml
Act on: OBIS measurement Required user role: PM
EDM
NDW
Job: Deletes data of an measuring point OBIS identifiers that lies in a specified time span. Data of all measuring point OBIS identifiers can be deleted from all media. A user-defined finished trigger can be executed.
Parameter:
Time range function
(optional)
Defines, how the time range for deletion will be set.

full: The total time period, starting from the timestamp of the first record.

number of days: Whole days in the past starting at the time of the execution.

specific timerange: Precise specification of start and end time.
Days
(optional)
Defines the number of days for which the deletion is performed in the past. The period begins with the execution time. Only active if 'number of days' is selected as the time range function.
Timerange
(optional)
Defines the timerange for which the values are deleted. Only active if 'timerange' is selected as the time range function.
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".
05/20/2019, 2.2, Update of description.

Excel processor

Back
            Version: 2.10  
File: ExcelProcessor.xaml
Act on: Documents Required user role: PM
Job: Processes an Excel file created by the excel plug-in and replaces the user-defined visual energy Excel functions (ve4 _...) with their results. The excel file must be saved in the documents folder of the evaluation area. A copy of the processed file can be saved in the documents folder of the evaluation area and / or sent to defined e-mail recipients. The selected timespan and the selected time period within the workflow only have an influence if there is no cell reference in the excel file!
Parameter:
Time range function
(required)
Defines, how the time range for the processing will be set.

Dynamic: The 'Start' and the 'Offset' determined the start time, the 'Duration' the ende time of processing.

Specific: Precise specification of start and end time.

The selected time range function and the selected period are only active if there is no cell reference in the excel file!
Start
(required)
Defines the timestamp for the offset. Set the start date to ...

Hour: ... the day and time of execution.

Week: ... the last monday of execution day and the time to 00:00.

Day: ... the day of exection and the time to 00:00.

Month: ... the first day of the execution month and the time to 00:00.

Year: ... 01.01 of the year and the time to 00:00.
Offset
(required)
Specifies the time offset to the past for the resulting date from 'Start'.
Duration
(required)
Determines by specifying the duration the end date, starting from the calculated start date from 'Start' and 'Offset'.
Timerange
(required)
Defines, for which specific time range the excel document will be processing (Timezone of project).
Recipient list for e-mail
(optional)
Defines, to which recipients the e-mail will be sent. The recipients can be separated by semicolons.
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.
Store document(s)
(optional)
Defines if the generated document (and also the generated error log) will be stored in the database and in the document directory.
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.
05/22/2019, 2.8, Usable with Version newer than 4.7 Release 1 Build 12518. Add 'Week' to Start, Duration and Offset. Update of description.
06/14/2021, 2.9, Extended SMTP-Options
07/07/2021, 2.10, Update of description.

Execute program

Back
            Version: 2.1  
File: ExecuteProgram.xaml
Act on: System Required user role: SA
Job: Executes the given program or executable file with the given arguments.
Parameter:
Filename
(required)
Filename of the program or the executable file.
Arguments
(optional)
Defines the arguments for the program or executable file.
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
05/21/2019, 2.1, Update of description.

Export cost center / energy benefit

Back
            Version: 2.12  
File: ExportCsvCCEB.xaml
Act on: Cost Center/Energy Benefit Required user role: PM
EDM
Job: Exports daily or monthly data of an OBIS identifier of a cost center/an energy benefit to CSV files. You can determine which data status must be minimal for the export to be successful. An output directory can be defined for the CSV file and / or an e-mail recipient list can be specified. The parameters, which are written into the file, can be determined individually. A user-defined trigger can be activated.
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 an OBIS identifier of the selected medium 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)
Specifies the time period to export.

Daily: Exports every day from the start date to the end date.

Monthly: Exports the data monthly, starting from the 1st of the month of the start date.
Time range function
(optional)
Defines, how the time range for the CSV export will be set.

Continuous: Time between the last limit export date and the time of execution.

Specific: Precise specification of start and end time.
Last export date
(optional)
Date of last successful export. Not updated if specific timerange function is used. Only active if 'continuous' is selected as the time range function.
Timerange
(optional)
Defines, for which time range the data will be exported. Only active if 'specific' is selected as the time range function.
Target directory
(optional)
Specifies the output directory as the absolute path (e.g. C:\ExportData) to which the file is to be exported. The directory must be accessible from the web server, and the network service must have write access to the folder.
Recipient list for e-mail
(optional)
Defines, to which recipients the e-mail with the CSV-file will be sent. The recipients can be separated by semicolons.
Output format
(optional)
Defines the format of the output file. CSV-CSV file
TXT-Textfile
Delimiter
(optional)
Defines the delimiter for the columns in the CSV-file. ;-Semicolon
TAB-Tabulator
Ignore zero values
(optional)
If this option is activated, no data whose variable "Value" is zero are not written to the file.
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)
Configures which parameters and in which format the parameters are written to the output file. Different formats are possible for date and numbers. N0-N3 indicate the decimal places in number format (e.g. N3: 32,452). For S1-S3, the number is displayed with the respective decimal places, but without separators (e.g. S3: 32452). A fixed character length between 1 and 100 can be defined for some fields. If the value is shorter, the length is filled with blanks. If the value is longer, it is reduced to the defined character length. An exception is the variable "Value". In this case, the defined character length is reached by leading zeros. The default value 0 means that the length of the field is not changed.
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').
05/20/2019, 2.9, Update of description.
08/05/2019, 2.10, UPDATE: Usable in Version newer than 4.7.1 Build 12810. Name change from 'CSV export (cost center/energy benefit)' to 'Export cost center / energy benefit'. Add output as textfile without delimiter. Add variable for fix length of field set parameter. Add parameter 'Ignore zero values'.
06/14/2021, 2.11, Extended SMTP-Options
07/07/2021, 2.12, Update of description.

FTP download

Back
            Version: 2.3  
File: FtpDownload.xaml
Act on: System Required user role: SA
Job: Performs the download of a file which is stored on an FTP server. The URL of the desired file on the FTP server as well as a user name and password for access to the FTP server must be specified. The storage location and the file name can be freely selected.
Parameter:
Url of file
(required)
Specifies the URL of the file to downloaded from an FTP server (e.g. 'ftp://UrlFTPServer/FileName.txt').
User name
(optional)
Defines the user name for access to the FTP server. For an anonymous login to the FTP server, the user name is 'anonymous'.
Password
(optional)
Set the password for the username.
Filename
(required)
Specifies the absolute path and the file name (e.g. C:\FTPData\example.txt) where the document should be stored locally. The directory must be accessible from the web server, and the network service must have write access to the folder.
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.
05/21/2019, 2.2, Update of description.
07/18/2019, 2.3, Update of description.

Gas m³ to kWh

Back
            Version: 2.7  
File: GasKwhCalculator.xaml
Act on: OBIS measurement Required user role: PM
EDM
NDW
Job: Calculates the energy in kWh from m³, the defined correction factor and the specified calorific value and writes the value as OBIS identifier 'Gas, energy final, P+' (007-020:099.033.017*255) in the database. The calculation can only be carried out for the medium gas and the OBIS indicators 'Natural gas, load profile, standard cubic meters, T0' (007-001:129.130.000*255) or 'Natural gas, load profile, cubic meters, T0' (007-001:128.130.000*255). A user-defined finished trigger can be executed.
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.
Calorific value
(required)
Defines the 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.

newest: Time between the last calculation date and the time of execution.

full: The total time period, starting from the timestamp of the first record.

number of days: Whole days in the past starting at the time of the execution.

specific timerange: Precise specification of start and end time.
Last calculation date
(optional)
Last date for which an calculation from m³ to kWh was performed. Only active if 'newest' is selected as the time range function.
Days
(optional)
Defines the number of days for which the calculation is performed in the past. Start at the execution time. Only active if 'number of days' is selected as the time range function.
Timerange
(optional)
Defines the timerange for which the calculation is performed. Only active if 'timerange' is selected as the time range function.
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"
05/20/2019, 2.4, Usable with Version newer than 4.7 Release 1 Build 12518. Add "newest" time range function. Update of description.
07/23/2019, 2.5, Correct the time range of the 'newest' function.
08/22/2019, 2.6, Correct the end date of time range of the 'newest' function to utc.
03/29/2021, 2.7, Fix: Workflow failed on measured variable 'Natural gas, load profile, cubic meters, T0'.

Hourly sum values

Back
            Version: 2.3  
File: CompressHourSum.xaml
Act on: OBIS measurement Required user role: PM
EDM
NDW
Job: Compress periodic load profile data into hourly sums for the medium electricity. Stores the results in the energy feed OBIS identifier sum of hour. A user-defined finished trigger can be executed.
Parameter:
Time range function
(optional)
Defines, how the time range for the calculation will be set.

full: The total time period, starting from the timestamp of the first record.

number of days: Whole days in the past whithout the day of execution.

specific timerange: Precise specification of start and end time.
Days
(optional)
Defines the number of days for which the calculation is performed in the past. The execution day is not calculated. Only active if 'number of days' is selected as the time range function.
Timerange
(optional)
Defines the timerange for which the values are calculated. Only active if 'timerange' is selected as the time range function.
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.
05/13/2019, 2.3, Update of description.

Limit monitoring

Back
            Version: 2.7  
File: LimitMonitoring.xaml
Act on: OBIS measurement Required user role: PM
EDM
NDW
NDF
Job: Compares the selected OBIS measured variable with a previously created setpoint OBIS identifier (OBIS group B = 129) for overshoot or undershoot. The setpoints can previously created via the 'Write setpoint values' workflow or via an excel file. The limit monitoring can be carried out with all load profile and energy feed of the media (electricity, cold, heating, gas, cold water, warm water and oil) whose channel definition is encoder-specific (OBIS group B: 0-127) An e-mail can be sent in the event of a limit violation. The switching group 224 'Collective fault limit value violation' can be activated. User-defined triggers can be triggered.
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.
Time range function
(optional)
Defines, how the time range for the limit value check will be set.

newest: Time between the last limit monitoring date and the time of execution.

full: The total time period, starting from the timestamp of the first record.

number of days: Whole days in the past whithout the day of execution.

specific timerange: Precise specification of start and end time.
Last limit monitoring date
(optional)
Last date for which an limit value check was performed. Only active if 'newest' is selected as the time range function.
Days
(optional)
Specifies the number of days for which values are checked in the past. The execution day is not checked. Only active if 'number of days' is selected as the time range function.
Timerange
(optional)
Defines the timerange for which the values are checked. Only active if 'timerange' is selected as the time range function.
React if
(required)
Defines, if a limit violation will be determined by undercut or overflow the setpoint limit value.
Recipient list for e-mail
(optional)
Defines, to which recipients the e-mail will be sent. The recipients can be separated by semicolons.
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 'Combined fault limit violoation'
(optional)
Defines if the switch group 244 'Combined fault limit violoation' should be set if any validation errors could be determined.
Minimal status
(required)
Minimum status required by a measurement that is checked for a limit value violation.
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 limit monitoring could determine status violoations.
Limit violation trigger
(optional)
Defines the trigger which should be executed when the monitoring 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"
30/04/2019, 2.2, Usable with Version newer than 4.7 Release 1 Build 12518. Add the "newest" time range function. Update of description.
07/23/2019, 2.3, Correct the time range of the 'newest' function.
08/22/2019, 2.4, Correct the end date of time range of the 'newest' function to utc.
10/15/2020, 2.5, Change filter to support OBIS of GroupA=0 (abstract, temperatures).
06/14/2021, 2.6, Extended SMTP-Options
07/07/2021, 2.7, Update of description.

Load permission matrix

Back
            Version: 2.1  
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)
Activated: The system document of permission matrix will be validated.

Deactivated: The system document of permission matrix will be validated and loaded in the database.
Requires / creates: nothing
Output
DownloadPermissionMatrixLoader.zip
WF-Changes
07/24/2018, 2.0, Created workflow
05/21/2019, 2.1, Update of description.

Money calculation

Back
            Version: 2.6  
File: CalculateMoney.xaml
Act on: OBIS measurement Required user role: PM
EDM
NDW
Job: Calculates the sum of the amount of money for the specified OBIS flag using the specified costs. A new OBIS identifier is created for the amount of money. The calculation can be carried out for all load profile and energy feed data of all media for which a sum currency OBIS identifier is defined. A user-defined finished trigger can be executed.
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.
Costs
(required)
Defines the costs for a unit of the OBIS indicator in the project currency (e.g. costs for 1 kWh of electricity).
Time range function
(optional)
Defines, how the time range for the calculation will be set.

newest: Time between the last calculation date and the time of execution.

full: The total time period, starting from the timestamp of the first record.

number of days: Whole days in the past whithout the day of execution.

specific timerange: Precise specification of start and end time.
Last calculation date
(optional)
Last date for which a money calculation was performed. Only active if 'newest' is selected as the time range function.
Days
(optional)
Defines the number of days for which the calculation is performed in the past. The execution day is not calculated. Only active if 'number of days' is selected as the time range function.
Timerange
(optional)
Defines the timerange for which the values are calculated. Only active if 'timerange' is selected as the time range function.
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"
05/15/2019, 2.3, Usable with Version newer than 4.7 Release 1 Build 12518. Add the "newest" time range function. Update of description.
07/23/2019, 2.4, Correct the time range of the 'newest' function.
08/14/2019, 2.5, Add default-date for last calculation date.
08/22/2019, 2.6, Correct the end date of time range of the 'newest' function to utc.

Monthly sum values from load profile

Back
            Version: 2.7  
File: compressmonthsum.xaml
Act on: OBIS measurement Required user role: PM
EDM
NDW
Job: Compresses periodical load profile data to monthly sums for the media electricity, heat, cold, cold water, warm water, natural gas. Stores the results in the energy feed OBIS identifier sum of month. A user-defined finished trigger can be executed.
Parameter:
Time range function
(optional)
Defines, how the time range for the compression will be set.

full: The total time period, starting from the timestamp of the first record.

number of days: Whole days in the past whithout the day of execution.

specific timerange: Precise specification of start and end time.
Days
(optional)
Defines the number of days for which the compression is performed in the past. The execution day is not compressed. Only active if 'number of days' is selected as the time range function.
Timerange
(optional)
Defines the timerange for which the values are compressed. Only active if 'timerange' is selected as the time range function.
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.
05/13/2019, 2.7, Update of description.

MSCONS Export

Back
            Version: 2.10  
File: ExportMscons.xaml
Act on: OBIS measurement Required user role: PM
EDM
NDW
NDF
Job: Exports daily or monthly data from an OBIS identifier to MSCONS files. You can determine which data status must be minimal for the export to be successful. Using the test mode, additional special data can be exported without changing the last export date. An output directory can be defined for the MSCONS file and / or an e-mail recipient list can be specified. The OBIS format and the MSCONS version can be determined individually.
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)
Defines the lowest status of a value so that an export is still performed. If the status is worse than specified here, there is no export!
Export timespan
(optional)
Determines the time period to be exported. The parameter 'Last export date' is decisive.

Daily: From the day after the last export date. A CSV-file is created for each day.

Monthly: An entire month from the last exported date. A CSV-file is created for each month.
Last export date
(optional)
Date of last successful export. Not updated in test mode.
Test mode
(optional)
In test mode, data is exported starting from the execution time. The time span is calculated using the 'offset for test mode' parameter. The 'last export date' parameter is ignored and is not updated. This means that the export of a time period can be executed several times.
Offset for test mode
(optional)
Specifies the time span for the 'test mode', depending on the 'export timespan' parameter.

Daily 'export timespan': Number of days in the past, starting from the current day.

Monthly 'export timespan': Number of whole months in the past, starting from the current month.
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. s = Standard, without leading zeros (short: 1-1:1.29, medium: 1-1:1.29.0, long: 1-1:1.29.0*255)

S = Standard, with leading zeros (short: 001-001:001.029, medium: 001-001:001.029.000, long: 001-001:001.029.000*255)

f = Complete (always all 6 values), without leading zeros (1-1.1.29.0*255)

F = Complete (always all 6 values), with leading zeros (001-001:001.029.000*255)
MSCONS version
(optional)
Version of the MSCONS documents.
Target directory
(optional)
Specifies the output directory as the absolute path (e.g. C:\ExportData) to which the file is to be exported. The directory must be accessible from the web server, and the network service must have write access to the folder.
Recipient list for e-mail
(optional)
Defines, to which recipients the e-mail with the MSCONS-file will be sent. The recipients can be separated by semicolons.
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.
05/15/2019, 2.7, Update of description.
06/16/2020, 2.8, FIX: Last export date is updatetd for energy counter despite gaps.
06/14/2021, 2.9, Extended SMTP-Options
07/07/2021, 2.10, Update of description.

OBIS Calculator

Back
            Version: 2.6  
File: ObisCalculator.xaml
Act on: OBIS measurement Required user role: PM
EDM
NDW
Job: Calculates new data from the selected source OBIS identifier using the selected operator and a definable value. The newly calculated data is stored in a selectable target OBIS identifier. A user-defined finished trigger can be executed.
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.
Target OBIS
(required)
Specifies the target OBIS identifier in which the calculated data will be stored.
Operator
(required)
Specifies the operator ( + , - , * , / ) used in the calculation.
Value
(required)
Defines the value used for the calculation in conjunction with the operator.
Time range function
(optional)
Defines, how the time range for the OBIS calculation will be set.

newest: Time between the last calculation date and the time of execution.

full: The total time period, starting from the timestamp of the first record.

number of days: Whole days in the past starting at the time of the execution.

specific timerange: Precise specification of start and end time.
Last calculation date
(optional)
Last date for which an OBIS calculator was performed. Only active if 'newest' is selected as the time range function.
Days
(optional)
Defines the number of days for which the calculation is performed in the past. Start at the execution time. Only active if 'number of days' is selected as the time range function.
Timerange
(optional)
Defines the timerange for which the data is calculated. Only active if 'timerange' is selected as the time range function.
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.
05/20/2019, 2.3, Usable with Version newer than 4.7 Release 1 Build 12518. Add the "newest" time range function and set it as default. Update of description.
07/23/2019, 2.4, Correct the time range of the 'newest' function.
08/07/2019, 2.5, Add error messege if no data contained.
08/22/2019, 2.6, Correct the end date of time range of the 'newest' function to utc.

OBIS update

Back
            Version: 2.3  
File: ObisUpdate.xaml
Act on: System Required user role: SA
Job: Creates or updates OBIS identifier.
Parameter:
Requires / creates:
000-129:128.128.000*255Temperatur Sollwert (Mittelwert)
000-129:128.129.000*255Temperatur Sollwert (Minimum)
000-129:128.130.000*255Temperatur Sollwert (Maximum)
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.
05/21/2019, 2.2, Update of description.
10/15/2020, 2.3, New set point OBIS for temperatures.

ORDERS (market location)

Back
            Version: 2.1  
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. A user-defined finished trigger can be executed.
Parameter:
Time range function
(optional)
Defines, how the time range for the calculation will be set.

previous day: The whole day before the day of execution.

previous month: The entire month, beginning on the 1st of the month, before the day of execution.

specific timerange: Precise specification of start and end time.
Timerange
(optional)
Defines the timerange for which the data is requested. Only active if 'timerange' is selected as the time range function.
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
05/20/2019, 2.1, Update of description.

ORDERS (metering point)

Back
            Version: 2.1  
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. A user-defined finished trigger can be executed.
Parameter:
Time range function
(optional)
Defines, how the time range for the calculation will be set.

previous day: The whole day before the day of execution.

previous month: The entire month, beginning on the 1st of the month, before the day of execution.

specific timerange: Precise specification of start and end time.
Timerange
(optional)
Defines the timerange for which the data is requested. Only active if 'timerange' is selected as the time range function.
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
05/20/2019, 2.1, Update of description.

Project data generation

Back
            Version: 2.2  
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)
Activated: The system document will be validated.

Deactivated: The system document will be validated and the objects will be synchronized with the database.
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.
05/22/2019, 2.2, Update of description.

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"

Reorganize or rebuild indexes

Back
            Version: 2.3  
File: ReorganizeOrRebuildIndexes.xaml
Act on: System Required user role: SA
Job: Reorganizes or rebuilds indexes of all datatables depending on the fragmentation level F.
F < 10%: No action
10% <= F <= 30%: Reorganize indexes
F > 30%: Rebuild indexes
Parameter:
Write the log
(required)
Specifies whether to save the log as system document.
Execution timeout
(required)
Defines the length of time (seconds) until the execution will be terminated.
Requires / creates: nothing
Output
DownloadReorganizeOrRebuildIndexes.zip
WF-Changes
09/16/2019, 2.0, Create workflow.
09/17/2019, 2.1, Add parameter Timeout, write log.
09/17/2019, 2.2, Change description of argument 'Timeout'.
09/18/2019, 2.3, Add missing reference to 'Kbr.VisualEnergy4.Definitions'.

Request data

Back
            Version: 2.2  
File: Request.xaml
Act on: OBIS measurement Required user role: PM
EDM
NDW
Job: Sends a data request for the OBIS measured variable of metering point according to the defined time span. The data are automatically written to the OBIS identifier. The data request can be applied to all OBIS identifiers of all media that obtain the data via the bus master or are defined as mobile counting point. A user-defined finished trigger can be executed.
Parameter:
Time range function
(optional)
Defines, how the time range for the data request will be set.

newest: Time between the last request date and the time of execution.

full: The total time period, starting from the timestamp of the first record.

number of days: Whole days in the past starting at the time of the execution.

specific timerange: Precise specification of start and end time.
Days
(optional)
Defines the number of days for which the data request is performed in the past. Start at the execution time. Only active if 'number of days' is selected as the time range function.
Timerange
(optional)
Defines the timerange for which the data is requested. Only active if 'timerange' is selected as the time range function.
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.
05/20/2019, 2.2, Usable with Version newer than 4.7 Release 1 Build 12518. Update of description.

Request data (Mobile)

Back
            Version: 2.1  
File: RequestWithLimit.xaml
Act on: OBIS measurement Required user role: PM
EDM
NDW
Job: Sends a data request from a mobile metering point for an metering point OBIS identifier of type energy counter. The data are automatically written to the energy counter OBIS identifier. It is possible that the input, in relation to the resulting consumption, is monitored via parameters on the mobile meter reader. The data request can be applied to all OBIS identifiers of the category energy counter of all media that are defined as mobile metering point. A user-defined finished trigger can be executed.
Parameter:
Validate limit
(required)
Specifies whether the inputs are to be checked for limit value violations.
Time interval
(required)
Defines the time interval for the validation of the limit values.
Lower limit value
(required)
Defines the lower limit value for the validation of the selected time interval.
Upper limit value
(required)
Defines the upper limit value for the validation of the selected time interval.
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
05/10/2019, 2.1, Update of description.

Sends an e-mail

Back
            Version: 2.5  
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. The recipients can be separated by semicolons.
Subject of the e-mail
(required)
Defines the subject of the e-mail message.
Body of the e-mail
(required)
Defines the body of the e-mail message.
Recipient list for a copy of e-mail (CC)
(optional)
Defines, to which recipients a copy of the e-mail will be sent (CC). The recipients can be separated by semicolons.
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). The recipients can be separated by semicolons.
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
05/16/2019, 2.3, Update of description.
06/14/2021, 2.4, Extended SMTP-Options
07/07/2021, 2.5, Update of description.

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.2  
File: SetSwitchGroupState.xaml
Act on: Location Required user role: PM
Job: Switches a defined location switchgroup to a selected target state. A user-defined finished trigger can be executed.
Parameter:
Switch group
(required)
Defines the ID of the switchgroup, which state should be set.
Target state
(required)
Defines 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.
05/20/2019, 2.2, Update of description.

Transformer losses

Back
            Version: 2.5  
File: TransformerLosses.xaml
Act on: Component Required user role: SA
Job: Calculates transformer losses for a component specification of type 'Transformer'. For the calculation, the OBIS indicators 'real energy consumption (+), load profile, T0' (001-001:001.029.000*255) and 'reactive power consumption (+), load profile, T0' (001-001:003.029.000*255) are used. Writes the results to the OBIS flag 'P, Losses, T0' (001-200:001.029.000*255). The period duration of the OBIS identifiers used for the transformer must be the same.
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.
Time range function
(optional)
Defines, how the time range for the transformer losses calculation will be set.

newest: Time between the last calculation date and the time of execution.

full: The total time period, starting from the timestamp of the first record.

number of days: Whole days in the past starting at the time of the execution.

specific timerange: Precise specification of start and end time.
Last calculation date
(optional)
Last date for which an transformer losses calculation was performed. Only active if 'newest' is selected as the time range function.
Days
(optional)
Defines the number of days for which the transformer losses calculation is performed in the past. Start at the execution time. Only active if 'number of days' is selected as the time range function.
Timerange
(optional)
Defines the timerange for which the calculation is performed. Only active if 'timerange' is selected as the time range function.
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.2, FIX: OBIS codes of type EnergyFeed must define an interval.
05/21/2019, 2.3, Usable with Version newer than 4.7 Release 1 Build 12518. Add the "newest" time range function. Update of description.
07/23/2019, 2.4, Correct the time range of the 'newest' function.
08/22/2019, 2.5, Correct the end date of time range of the 'newest' function to utc.

Update multisys_BM

Back
            Version: 2.3  
File: AutomaticUpdate.xaml
Act on: Multisys Required user role: SA
Job: Updates all multisys-BM which are configured to perform auto updates. A user-defined finished trigger can be executed.
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. The recipients can be separated by semicolons.
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
05/20/2019, 2.1, Update of description.
06/14/2021, 2.2, Extended SMTP-Options
07/07/2021, 2.3, Update of description.

Weekly sum values

Back
            Version: 2.5  
File: CompressWeekSum.xaml
Act on: OBIS measurement Required user role: PM
EDM
NDW
Job: Compresses periodical load profile data into weekly sums for the media electricity, heat, cold, cold water, warm water, natural gas. Stores the results in the feed OBIS identifier sum of week. A user-defined finished trigger can be executed.
Parameter:
Time range function
(optional)
Defines, how the time range for the calculation will be set.

full: The total time period, starting from the timestamp of the first record.

number of days: Whole days in the past whithout the day of execution.

specific timerange: Precise specification of start and end time.
Days
(optional)
Defines the number of days for which the calculation is performed in the past. The execution day is not calculated. Only active if 'number of days' is selected as the time range function.
Timerange
(optional)
Defines the timerange for which the values are calculated. Only active if 'timerange' is selected as the time range function.
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.
05/13/2019, 2.5, Update of description.

Writes setpoint values

Back
            Version: 2.7  
File: WriteSetpointValues.xaml
Act on: OBIS measurement Required user role: PM
EDM
NDW
NDF
Job: Creates a new OBIS identifier with setpoints for the selected OBIS measured variable. The setpoints can be defined depending on working days and non-working days. Setpoints can be written for all load profile and energy feed of the media (electricity, cold, heating, gas, cold water, warm water and oil) whose channel definition is encoder specific (OBIS group B: 0-127). A user-defined finished trigger can be executed.
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.
Time range function
(optional)
Defines, how the time range for the creation of the setpoints will be set.

newest: Time between the last setpoint date and the time of execution.

full: The total time period, starting from the timestamp of the first record.

number of days (future): Whole days in the future, starting the day after execution.

number of days (past): Whole days in the past whithout the day of execution.

specific timerange: Precise specification of start and end time.
Last setpoint date
(optional)
Last date for which setpoints were written. Only active if 'newest' is selected as the time range function.
Days
(optional)
Defines the number of days for which the setpoints are written. The execution day is not written. Only active if 'number of days (future)' or 'number of days (past)' is selected as the time range function.
Timerange
(optional)
Defines, for which time range the setpoints are written. Only active if 'timerange' is selected as the time range function.
Setpoint value working day
(required)
Defines the setpoint during the working days.
Setpoint value non working day
(required)
Defines the setpoint during the non working days.
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.
05/15/2019, 2.5, Usable with Version newer than 4.7 Release 1 Build 12518. Add the "newest" and "number of days (future)" time range function. Update of description.
07/23/2019, 2.6, Correct the time range of the 'newest' function.
08/22/2019, 2.7, Correct the end date of time range of the 'newest' function to utc.

Share this post