Export Boss’nX analytics measurements to CSV

In the Trends tab of the Analytics page, the Export to CSV button downloads the values of the generated Boss’nX chart: a spreadsheet file with timestamp, location, datapoint, address, value and unit. It is intended for users authorized to view analytics, as well as administrators and installers. This export is the one from the Boss’nX chart, separate from the export commands of the Chart’nX tab.

Prepare the chart to export

1. Open the analytics of the relevant building.
2. In Datapoints, choose the datapoints to export, or apply a favorite selection. To start from scratch, go back to All, clear the search, click Deselect all, then check the datapoints you want.
3. Choose the period, aggregation and precision you need.
4. Click Generate chart and wait for the result. Check the series and the period shown under Chart preview.

Download the CSV file

1. Click Export to CSV, the button with a download arrow, near Configuration.
2. Find the file in your browser’s downloads or in the location chosen in its dialog box. Its name starts with “analytics” and normally includes the local dates and times of the applied period.
3. Open the CSV in your spreadsheet. If needed, choose the UTF-8 encoding and the semicolon separator.

The download deletes neither the measurements nor the selection.

Export exactly the datapoints and period you want

The file contains the series of the last generated chart. Changing the checkboxes or the dates without regenerating does not replace this result: the button can therefore remain available even though you have unchecked all the datapoints. Settings changed · generate to apply them flags this gap.

Hiding a series with the legend or zooming in on an hour does not restrict the CSV. To export only certain datapoints or a particular time slot, define this selection and this period, then generate the chart before exporting.

The exported values are those received for the chart’s request, with its parameters, not all the raw measurements or archives of the installation. Check the rows if you need strict time boundaries.

Read the columns and timestamps

In English, the columns are Timestamp, Building part, Floor, Zone, Component, Datapoint, Address, Value and Unit. Some location information may be empty. Depending on the datapoint type, the Address column does not necessarily contain a KNX address.

The timestamps in the file are in UTC, recognizable by the final “Z”. The interface and the file name use the browser’s local times: compare an apparent time difference taking the time zone and the date into account. Keep the original timestamps rather than changing them to make them match visually.

A zero value is kept. A missing value produces no row: the lines that bridge an interval without data or extend the last value do not become measurements in the CSV. A file may contain only its headers if the received series contain no usable value.

Check the result

Open the file and check the first rows: the datapoints, timestamps and values must match the generated chart.

Troubleshooting

Symptom	Action
Export to CSV grayed out	Generate a chart that contains series. Choosing datapoints alone is not enough.
The file contains datapoints you removed	Go back to All without a search, check the selection, regenerate and download a new file.
The file covers another period or goes beyond the zoom	Check the period applied to the chart. Choose the boundaries you want in the calendar and regenerate. Zooming does not limit the export.
Everything appears in a single column	Import the file specifying the semicolon as the separator.
Accented characters are unreadable	Reopen or import the file as UTF-8.
File cannot be found	Check the browser’s download list and any message saying the download was blocked.
Expected rows are missing	Check the datapoint, the period and the request parameters. Bridging periods without data does not recreate measurements.

Contact support

If these checks are not enough, write to support@can-nx.com with the product, the building, the datapoints, the period, the aggregation, the precision and the symptom. Prepare an anonymized extract only if support asks for it, and do not send sensitive data.

French labels: Générer le graphique, Exporter en CSV; columns Horodatage, Partie de bâtiment, Étage, Zone, Composant, Point de données, Adresse, Valeur, Unité.