GO - Data Export

Difficulty: expert

You can access the Data Export functionality from the Workplace side panel, if for your user reporter role (or admin-role) is enabled.

It is possible to retrieve timeslot data per building or even per floor through this Export functionality in GO. This exported data can be used to rework and import data in any reporting tool of choice.

The export in csv-format includes information on locations, sensor devices and the data (device ID, which kind of data point (humidity, temperature, open, pir etc), the value and the timestamp*, as well as information on Location Grouping (zones).

Open

• The data is exported in a zipped .CSV (comma separated value) format file (not XLS) and can be opened in any text editor or Excel. But mind the restriction in Excel: no more than 1 million rows can be in one file. To process more than 1 million rows in Excel, the exported file must be split on several parts with no more than 1 million rows each (otherwise Excel will throw errors).

• Data can be exported for any given start/stop date and for any given location (per building or floor).

• Your export will not be available immediately. The export job is automatically scheduled to be executed based on the available cloud resources. It might take up to two hours before your export is available.

• Data is only available for export for time-slot data, hence only data for "today - 1 day" can be exported.

The exported files are:

1. Departments: NA

2. Locations: IWMS location information (location ID, location category, location type as well as placement in the location hierarchy (Area > Site > Building > Floor)) and possible link of the location to Workplace Zones (ID)

3. Zones: Workplace Zones (ID) with their display name/reference

4. Sensor Devices: each sensor device (relevant to the linked location) is listed with the different dimensions/channels that he is capturing data for in Workplace

   1. Open

      

5. Sensor Data part...: each value that has been registered in Timeslots will be in these files, stating the device, the dimension/channel that the data was captured for and the timestamp*

* Timestamp in the export file: the offset is mentioned as Z, which means it’s the timestamp in UTC. This can be converted to local time for visualizing data by adding the UTC offset of the local time zone of the linked location from the provided timestamp.

Search