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:
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. |