Auto Export

Video Tutorial

All export options are summarised in this video. This video is currently only available in German.

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.

Export trigger: Defines the trigger of the export.

• "When all meters have values", triggers as soon as all data is available. If they are never complete (e.g. because the start value was before installation), this will never trigger.

•  "12h after the enddate", triggers 12 hours later, regardless of whether all data is available or not.

• Note: Auto export starts between 0:00 to 1:00 and can go up to 3h.

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.

mscons 2.4a: mscons (Metered Services Consumption report message) version 2.4a.

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:

 Test Files

• mscons 2.2e 

• IS-E

• ISE-Load profile

• csv The CSV file can be configured individually. The test file was configured as «1-0: 1.8.0 * 255; 1-0: 1.8.1 * 255; 1-0: 1.8.2 * 255; 1-0: 2.8.0 * 255; 1-0 : 2.8.1 * 255; 1-0: 2.8.2 * 255; ».

Obis Codes

OBIS Codes are used to describe a (meter) value. 

Obis Codes (Excel)

Upload Type

Currently these upload types are available:

FTP FTP Upload (unencrypted ).

FTPs Encrypted FTP Upload.

• The port can be explicitly indicated by a :. e.g. ftp.smart-com:990

sFTP (with username and password): Encrypted FTP upload.

• Username and password

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

• Example for the creation of an sFTP key file with openssl

• openssl genrsa -out key.pem 2048

• openssl rsa -in key.pem -DES-EDE3-CBC -traditional -out enc_key.pem

• Example: enc_key.pem

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.8.3 (1-5:1.8.<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 the export type "IS-E". 

Obis Codes

OBIS Codes are used to describe a (meter) value. 

Obis Codes (Excel)