Exports

The Exports feature allows you to export raw device data from the platform. It replaces the previous simple CSV report inside of the Reports and provides more flexibility for exporting data manually or automatically.

Exports can be used for:

• Debugging device data

• Creating manual backups

• Generating recurring data backups

• Exporting specific device fields or semantic data

You can access the feature from the Exports section in the left-side navigation menu.

Overview

The Exports page contains two main tabs:

1. Export Configurations

This tab is used to create and manage export configurations.

Export configurations define:

• Which devices should be included

• Which fields should be exported

• The timezone

• Whether the export is manual or automatic

• The schedule (for automatic exports)

• For automatic exports, the next run is also shown

2. Generated Exports

This tab lists all exports that have already been generated.

From here you can:

• View previously generated export files

• Download exported data

You can multi-select and download exports.

Create Export

Manual Exports

Manual exports allow you to export device data for a specific timeframe.

This is useful when you want to:

• Debug device reporting issues

• Check whether data was written correctly to the database

• Export historical data for analysis

• Create a one-time backup for a specific time period

How Manual Exports Work

When creating a manual export, first set your Export's name. This will help you identify it in the future.

Devices

Then you need to choose the device selection. You can choose between:

• All devices: will include the data from all of your devices in your workspace. If there's more than 100 devices, each file will represent maximal 100 devices,

• Devices by tag: this is the default selection. Filter the devices to be included by tags, or

• Devices by name: you can filter your devices by name. You don't need to type in the whole name, but parts of the name will filter all devices that contain certain words.

You can click on "Show included devices" to make sure your device selection worked properly.

Timeframe

Then select the data timeframe of your interest. You can do so using the calendar selector. Depending on your package, you will have a certain number of days into the past that you can manually download data from.

Timezone

Then you can select your timezone. That will make sure the timestamps included in the report are in your timezone.

Fields

The next step is to select the Fields from the chosen devices. For that, you can choose between three options:

• All fields: this will automatically select all fields from the chosen devices. Choose these option carefully. The bigger the amount of fields, the longer it will take to generate your export.

• Field names: this option will enable a drop-down-list with your device's fields. You can manually select the fields you are interested in. Please make sure you select ALL desired fields manually. Sometimes, if your devices selected belong to different products, there might be more than one field of interested (for example, if one device has a field TEMP and the other a field called TEMPERATURE, you need to manually select both fields to appear in the export).

• Semantics: they allow you to select the semantic of interest. This option avoids having to select all fields manually. In the example mentioned in the point before, if you select the semantic TEMPERATURE, all temperatures will be included in the export, regardless of their name.

Format

Finally, you can select between CSV or Excel (XLSX) format.

Excel format is only available in packages starting in the Light plan.

If you selected CSV as format, you have two more options to chose from:

• Select the CSV date format: Year-Month-Day Hour:Minute:Second or ISO 8601

• Finally, select the CSV file delimiter: Comma-delimited CSV or Semicolon-delimited CSV

Once you click on "Create Export", you should be able to see the created export directly inside of the "Generated Exports" section. You can go ahead and download it from there.

The exported file will include:

• Timestamp

• Raw data points stored in the database for all fields included in the export

This allows you to inspect exactly what data was recorded during the selected time period.

Example Use Case

If a device stopped reporting data or behaved unexpectedly, you can export the raw data for that device during the affected time window and analyse the recorded values.

Manual exports are available to all users.

Automatic Exports

Automatic exports allow you to generate recurring backups of your device data.

Instead of manually exporting data, the system will generate exports automatically based on a schedule.

The same as for the manual exports, the automatic exports allow you to select which devices and fields should be included in your exports.

Devices

You can choose between:

• All devices: will include the data from all of your devices in your workspace. If there's more than 100 devices, each file will represent maximal 100 devices,

• Devices by tag: this is the default selection. Filter the devices to be included by tags, or

• Devices by name: you can filter your devices by name. You don't need to type in the whole name, but parts of the name will filter all devices that contain certain words.

You can click on "Show included devices" to make sure your device selection worked properly.

Scheduling Options

Automatic exports can run on a:

• Daily

• Weekly

• Monthly

basis.

Availability: Automatic exports are available only on paid plans, starting with the Light plan. For Light and Standard plans you have daily and weekly exports available. For Plus and Enterprise plans you also have monthly exports available.

Each scheduled export will generate a file containing the selected device data for the defined time interval.

You can specify the time zone used for the timestamps in the export file. This ensures exported timestamps match your preferred timezone.

Fields

You can choose between three options:

• All fields: this will automatically select all fields from the chosen devices. Choose these option carefully. The bigger the amount of fields, the longer it will take to generate your export.

• Field names: this option will enable a drop-down-list with your device's fields. You can manually select the fields you are interested in. Please make sure you select ALL desired fields manually. Sometimes, if your devices selected belong to different products, there might be more than one field of interested (for example, if one device has a field TEMP and the other a field called TEMPERATURE, you need to manually select both fields to appear in the export).

• Semantics: Using semantics allows the system to normalize data across different device types, making exports easier to analyze and compare.

Depending on the export frequency, the next export will be scheduled to run on the "Next run", pointed at the right corner of the "Export Configurations" tab. You will receive

Email notifications

Set one or more recipients. They will receive a notification that the export was generated (NOT THE EXPORT DIRECTLY). To download it, you need to go to "Generated exports" and manually download the files.

Format

You can select between CSV or Excel (XLSX) format.

Excel format is only available in packages starting in the Light plan.

If you selected CSV as format, you have two more options to chose from:

• Select the CSV date format: Year-Month-Day Hour:Minute:Second or ISO 8601

• Finally, select the CSV file delimiter: Comma-delimited CSV or Semicolon-delimited CSV

Once you click on "Create Export", you should be able to see the created export directly inside of the "Generated Exports" section. You can go ahead and download it from there.

The exported file will include:

• Timestamp

• Raw data points stored in the database for all fields included in the export

This allows you to inspect exactly what data was recorded during the selected time period.