Exports

General

Exports are used to get data out of the platform to some place. There are many possible export configurations like for example JSON TXT file to some FTP server every hour.

Creation

An export can be created in a workspace. When created a task should be set to schedule when the export should run.

The offset is the setting where you can choose how far back you want to fetch measurements to be exported. So for example to get the last hour of data set the offset type to hour and the offset value to 1.

Configuration

After creation of an export, you can attach tags to the export that you want to be exported as configured.

In the task panel you can configure the schedule of the export and next runtime. So to export every 15 minutes set the interval type to minutes and the interval value to 15.

To add tags to be exports click the + icons shown above. After this you will be taken to the page shown below where you can checkbox tags and then click bulk action attach to add them to the export.

Measurements period to export

With the offset you can decide how much data you want to export backwards from now. With offset type month and offset value 1 you will export measurement data from 1 month back till now.

Sending types

The export type field dictates the sending method. There are various ways of exporting data each with individual settings.

• Email

• FTP server

• Downloadable, this will create a table with downloadable files in the export page

Output format

In the form of the export you can select what the output should be. Currenly the following outputs are implemented;

Excel

For use in excel use the format 'standard-csv'

device_name;device_serial;tag_name;tag_code;tag_unit;measurement_value;measurement_timestamp
deviceA;1234;ADC1;ADC1;V;12;2020-12-29 13:00:01
deviceA;1234;GSM signal;GSM-signal;%;12;2020-12-29 13:00:01
deviceB;4567;ADC1;ADC1;V;12;2020-12-29 13:00:01
deviceB;4567;ADC1;ADC1;V;12;2020-12-29 13:00:01
deviceB;4567;ADC1;ADC1;V;12;2020-12-29 13:00:01
deviceB;4567;GSM signal;GSM-signal;%;12;2020-12-29 13:00:01
deviceB;4567;GSM signal;GSM-signal;%;12;2020-12-29 13:00:01
deviceB;4567;GSM signal;GSM-signal;%;12;2020-12-29 13:00:01
deviceC;7890;Altoel;Tank A;mA;12;2020-12-29 13:00:01
deviceC;7890;Altoel;Tank B;mA;12;2020-12-29 13:00:01
deviceC;7891;Emulsion;Tank C;mA;12;2020-12-29 13:00:01
deviceC;7892;GSM signal;S%;%;12;2020-12-29 13:00:01

Standard JSON

Depending on the sending type the standard JSON will be put into an email body or some text file. The standard JSON is an array of devices for the selected tags. Tags data is placed in the sensors in the device. The content of is as follows;

[
  {
    "name": "Device123",
    "serial": "4742300",
    "type": "m844",
    "sensors": [
      {
        "name": "GSM signal",
        "code": "QSS",
        "unit": "",
        "measurements": []
      },
      {
        "name": "Max cycle",
        "code": "MAXCi",
        "unit": "mA",
        "measurements": [
          {
            "value": 76,
            "timestamp": "2018-08-31 18:30:06"
          }
        ]
      }
    ]
  },
  {
    "name": "Device567",
    "serial": "47443222",
    "type": "m422",
    "sensors": [
      {
        "name": "Humidity",
        "code": "HUMID",
        "unit": "Percent",
        "measurements": [
          {
            "value": 73.55,
            "timestamp": "2018-08-31 18:40:00"
          },
          {
            "value": 12.55,
            "timestamp": "2018-08-30 17:40:00"
          }
        ]
      }
    ]
  }
]

Starting the export manually/Directly

If you want to start the export directly you can set the task next action date ien the past, like yesterday, this will make the task run within a few minutes.