Auto Export

You can export your data automatically into another system. This requires a Professional subscription.

Requirements

To use Auto Export, you must purchase a smart-me Professional License.

Assignment

Define the following key elements:

Meter point ID: Defines the ID. This is used in some export formats such as MSCONS.

Meter or Folder: Chose the meter or file of which the data should be exported.

Export format: Define the export format.

Upload type; Define the upload type.

Export interval: Chose how often your date should be uploaded.

Last export: Date of the next export of data. If the date is in the past, all data up to now will be exported.

Start date next export: The start date for the next export of the data. If the date is in the past, all data up to the current date will be exported.

Measured values to be exported : If you select a folder with virtual tariffs, you can choose whether you want to export the normal measured values or the virtual tariffs.

Export Format

The Export Format defines the file format for the export. The following formats are currently supported (more are in planning):

mscons 2.2e: mscons (Metered Services Consumption report message) version 2.2e.

IS-E: export to the "innosolv Energie" System by Innosolv Inc

IS-E Load profile: Export in "time series" format to the "innosolv Energie" system by Innosolv Inc

CSV: Export to CSV format, which can be processed (for instance) with Excel. The export of meter values with the following Obis codes is supported:

Obis Code IS-E

1-1:1.8.0: Active Energy Total Import

1-1:1.8.1: Active Energy Tariff 1 Import

1-1:1.8.2: Active Energy Tariff 2 Import

1-1:2.8.0: Active Energy Total Export

1-1:2.8.1: Active Energy Tariff 1 Export

1-1:2.8.2: Active Energy Tariff 2 Export

1-1:5.8.0: Reactive Energy Q1

1-1:6.8.0: Reactive Energy Q2

1-1:7.8.0: Reactive Energy Q3

1-1:8.8.0: Reactive Energy Q4

5-1:1.0.0: Cold (Energie)

6-1:1.0.0: Heat (Energie)

8-1:1.0.0: Cold water (m3)

9-1:1.0.0: Hot water (m3)


Obis Code mscons

1-1:1.29.0*255: Active Energy Total Import (load profile)

1-1:2.29.0*255: Active Energy Total Export (load profile)

1-1:5.29.0*255: Reactive Energy Q1 (load profile)

1-1:6.29.0*255: Reactive Energy Q2 (load profile)

1-1:7.29.0*255: Reactive Energy Q3 (load profile)

1-1:8.29.0*255: Reactive Energy Q4 (load profile)

5-1:1.29.0*255: Cold (load profile)

6-1:1.29.0*255: Heat (load profile)

8-1:1.29.0*255: Cold water (load profile)

9-1:1.29.0*255: Hot water (load profile)


Obis Code CSV

1-0:1.8.0*255: Active Energy Total Import

1-0:1.8.1*255: Active Energy Tariff 1 Import

1-0:1.8.2*255: Active Energy Tariff 2 Import

1-0:2.8.0*255: Active Energy Total Export

1-0:2.8.1*255: Active Energy Tariff 1 Export

1-0:2.8.2*255: Active Energy Tariff 2 Export

1-1:5.8.0*255: Reactive Energy Q1

1-1:6.8.0*255: Reactive Energy Q2

1-1:7.8.0*255: Reactive Energy Q3

1-1:8.8.0*255: Reactive Energy Q4

6-0:1.0.0*255: Heat Energy

5-0:1.0.0*255: Cold Energy

8-0:1.0.0*255: Cold Water Volume

9-0:1.0.0*255: Hot Water Volume

Test Files

Upload Type

Currently these upload types are available:

FTP FTP Upload (unencrypted ).

FTPs Encrypted FTP Upload.

sFTP (with Key File) Encrypted FTP Upload. Key files are used instead of a password.

Shared Settings

If a user is assigned to a partner (e.g. utility company), the user is shown the already defined "Upload Types" and "Export Formats" of the partner in addition to his own "Upload Types" and "Export Formats". For example, the FTP settings only need to be made in the partner account and are not visible and changeable for the normal user.

For better identification, the passed settings are marked in blue

Export virtual tariffs

If you have set up virtual tariffs in smart-me Billing, you can export them to IS-E.

Set up

Create the virtual tariffs in smart-me Billing. Make sure that you set the tariff number of the virtual tariff correctly. This will be encoded as "tariff" in the Obis Code when exported. Example: Tariff number 3 results in Obis: 1-5:1.9.3 (1-5:1.9.<tariff number>)

In the "Auto Export" under Assignment, select the folder with the virtual tariffs and choose "Virtual tariffs" under "Measured values to be exported".

-> Attention: This function only works with an export type "IS-E".


------------------------------------------------------------------