Import CSV – Multiple metering points

The specified CSV file will be imported. The file can contain multiple columns, each with a metering point ID, an OBIS measured variable and measured values.

If no OBIS measured variable is included, it can be specified as a parameter. The OBIS identifier is then used for all data in the file.

The metering point ID (and, where applicable, the OBIS measured variable) must be specified in the same column above the values. Each column is imported separately using the metering point specified above it and, where applicable, the OBIS measured variable.

At least one column containing a timestamp is required.

If a metering point ID or a measured variable does not exist in the system, the column is skipped during import.

The file name can be specified using a wildcard (*). Only the file name or the source file may be specified.

Example of file content and structure:

Example CSV import with multiple metering points and measured variables

Metering point name

CHP

Utility company feed-in

Metering code

DE9000011000000000000000000100004

DE9000011000000000000000000100004

OBIS code

001-001:001.029.001

001-001:000.029.003 000

Unit

kWh

kWh

01.08.2021 00:15

0.114

2.42

01.08.2021 00:30

0.524

2.89

 

01.08.2021 00:45

 

 

 

01.08.2021 01:00

 

 

 

Where can I find this workflow?

Project configuration => Automation

Parameters

Source file

Select – Select a file from a visual energy evaluation folder.