How to use File Export in Studio

In Studio, under the File Export menu, there are three types of exports you can do:

ExportType.png

  1. Aggregated sensor data
    Example: Export min, max & average temperature or humidity for the past 3 days. Example: Export desk occupancy duration per day for the last week (limited last to 30 days).
  2. Sensor events
    Export raw sensor events, equal to the data sent over the API (limited last to 30 days).
  3. Device list
    Export a list of devices within a project. This can be filtered on device type or set to include all devices.

Important!

Studio will no longer store exports that are older than 100 days. They are automatically deleted after this period.

How to export aggregated sensor data

After clicking Create New Export from the File Export section, there are a few options you can set when creating an aggregated export.

Aggregated.png

You can customize the following options for the aggregated export:

  1. Date Range: Use the predefined ranges from the dropdown or select a custom range from within the past 30 days. 
  2. Aggregation Duration: Can be set to 1 Hour or 1 Day
  3. Export timezone: Choose the time format for your report. Either UTC (same time as in the API) or your local timezone.
  4. Included Device Types: Can be set to one device type or multiple. This determines which aggregated values will be included in the export.
    • If you only want a few specific devices, you can toggle over to the Specific Devices on the right side. This lets you choose devices from your Project. 
  5. Included Device Labels: By default, only the device name label is included. By expanding the menu you will be able to include more. Note that it shows label suggestions based on what labels are found on the included devices.
  6. Export Format: Can be set to either CSV or Excel. Using CSV is recommended for larger exports as Excel is limited to 100 000 rows of data.

After setting your preferred options, click Generate Export. This will take a few seconds, and when the export is ready, click Save on the right-hand side of the export list to download the file. 

How to export sensor events

Studio supports exporting the same sensor events as are sent over the API. This can be a useful getting-started approach before creating a full integration.

Events.png

You can customize the following options for the event export:

  1. Date Range: Use the predefined ranges from the dropdown or select a custom range from within the past 30 days. 
  2. Export timezone: Choose the time format for your report. Either UTC (same time as in the API) or your local timezone.
  3. Included Device Types: Can be set to one device type or multiple. This determines which events are included in the export.
    • If you only want a few specific devices, you can toggle over to the Specific Devices on the right side. This lets you choose devices from your Project. 
  4. Included Events: By default, the chosen device types determine the included events. You can override this by setting this to All Events or Custom. This lets you include extra events such as touch (for relevant sensors) and networkStatus.
  5. Export Format: Can be set to either CSV or Excel. Using CSV is recommended for larger exports as Excel is limited to 100 000 rows of data.

After setting your preferred options, click Generate Export. This will take a few seconds, and when the export is ready, click Save on the right-hand side of the export list to download the file. 

How to export a device list

Use the export feature in Studio to get a list of devices for a project in a spreadsheet format.

  1. Go to Studio.
  2. Open the Project from which you want to export the devices.
  3. Select File Export from the menu on the left.
  4. Select Create New Export.
  5. Select Device List from the three export options.

    DeviceList.png
  6. By default, the export is set to include "Temperature Sensors", you can change this to another type or to "All Device Types" if you want to get all devices in the Project.

    AllDeviceTypes.png

  7. Choose Download Format. It can be set to either CSV or Excel. Using CSV is recommended for larger exports as Excel is limited to 100 000 rows of data.
  8. Click the Generate Export to start the export (this can take a few seconds depending on the size of the export).
  9. When the export is ready click the Save button to download the file. 

    DownloadExport.png