Table of Contents

maxLevel	2

Trending data are stored in the SQL database of the BMS Platform.

The Raw values dialog provides functions to view, filter, import, export, and delete trending data.

To open the Raw values dialog, open the Trending app and click the Raw values button Image Modified from the toolbar.

Content

The page consists of several areas:

Toolbar
List of trending data: the column headers provide functions for sorting and filtering.

Image Modified

Toolbar functions

...

Function	Description
	Refresh
	Delete selected trending values
	Import
	Export

To import values to the current trending, click the Import button Image Modified from the toolbar. The following image shows the import dialog:

Image Modified

Click the Download Excel Template button to download an empty excel file, where to enter data for a later data import.
Click the Select File button to select the file containing the data for the import.

After selecting the import file, the preview dialog appears:

Image RemovedImage Added

Option	Description
Update existing elements	Enabled: Database records with the same timestamp as in the import file will be updated. Disabled: All valid records will be imported, regardless of existing data in the database with same timestamps. This can lead to multiple values at the same time!
Date values UTC-offsetTime zone	The timezone in which the timestamps in the import file are denoted. During import the timestamps are converted and stored in the database in UTC.

Click the Import button to import the values into the database.

To export values of the current trending, click the Export button Image Modified from the toolbar.

Records matching the current filter will be exported to an xlsx file.

To export all records, clear the filters and run the export.

To delete records from the current trending, tick the data rows to delete and click the Delete button from the toolbar.