CSV Export

There are several possibilities for CSV Export of Energy data:

The workflows ‘CSV Export’ and ‘CSV Export (Cost Centers / Energy Benefits)’ can be quickly applied without major configuration in order to output the data for each measurement. However, if the data of several meteringpoints and / or measurements should be exported, an XML file must be used for the configuration. For this cases see the following description.
The XML file acts as a configuration template and is simply stored in the document archive. Then, the XML document is assigned the CSV Data Export (XML) workflow.

Example

<?xml version="1.0" encoding="utf-8"?>
<configuration version="3.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="configuration.xsd">
  <readings id="Strom">
    <reading id="P+" obis-code="001-001:001.029.000*255" function="SUM" />
    <reading id="Q+" obis-code="001-001:003.029.000*255" function="SUM" />
  </readings>
  <columns id="Standard">
    <column id="MPID" header="ZP-ID" ref="MP.ID" />
    <column id="MPNAME" header="ZP-Name" ref="MP.Name" />
    <column id="MPIP" header="Installationsort" ref="MP.InstallationPoint" />
    <column id="LOCALEND" header="Enddatum" ref="LOCALEND" index="0" format="dd.MM.yyyy HH:mm" />
   <column id="VALUE1" header="P+" ref="VALUE" index="0" format="N3" />
   <column id ="UNIT1" header="Einheit" ref="UNIT" index="0"/>
    <column id="STATUS1" header="Status (P+)" ref="STATUS" index="0" />
    <column id="VALUE2" header="Q+" ref="VALUE" index="1" format="N3" />
   <column id ="UNIT2" header="Einheit" ref="UNIT" index="1"/>
   <column id="STATUS2" header="Status (Q+)" ref="STATUS" index="1" />
  </columns>
  <files delimiter=";" column-headers="true" force-export="true" export-start="C" export-offset="0M" export-duration="2D" export-interval="D" header="Header Example" footer="Footer Example" min-status="1">
    <file filename-pattern="E:\_CSVEport(XML)\TagesWerteExport-${YYYY}${MM}${DD}-${HH}${mm}${ss}.csv" readings-id="Strom" columns-id="Standard">
      <export tag="9 - EVU Bezug" mpid="DE0005819112600009054000000000001" last-export="18.05.2019 00:00:00"/>
	  <export tag="KBR Buchenbach gesamt" mpid="DE99999979256KBRBB000000000000001" last-export="18.05.2019 00:00:00"/>
    </file>
  </files>
</configuration>

Result

Description of Elements