Page Comparison

Versions Compared

Key

This line was added.
This line was removed.
Formatting was changed.

Table of Contents

maxLevel	2

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

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

To import or delete trending data open the Raw values dialog, open the Trending app and click the Raw Valuesvalues button Image Modified from the toolbar.The following image shows the Raw values dialog:

Image Removed

Content

The page consists of several areas:

At the beginning of the page the toolbar appears.
Below, the list Toolbar
List of trending data is shown. The : the column headers provide functions for sorting and filtering data.

Image Added

Toolbar functions

The functions on the page depend on the role of the logged on user.

Function	Description
	Refresh
	Delete selected trending datavalues
	Import data
Image Added	Export

Import

...

To import data values to the current trending, click the Import button Image Modified from the toolbar. The following image shows the import dialog:
Image RemovedImage Added
Click the Export Download Excel Template button to create 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 a , the preview dialog appears:
Image Removed
The dialog shows:
...
Image 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!
Time zone
The timezone in which the timestamps in the import file are denoted.
Note: All timestamps in the database are stored as UTC. The conversion is automatically done during the import.
Click the Import button to run the import.

Export data

Delete data

To delete data of import the values into the database.

Export

To export values of the current trending, click the Export button Image Added 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.

Delete

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