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

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

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 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 Removed

The dialog shows:

• number of records found in the import file.
• the option to update existing data.
• the option to set a time offset. 

Image Added

Disable this option to insert the data into the database. In this case duplicate

Option	Description
Update existing elements

Enable this option to update already existing trending data in the database. Database key for update: Timestamp + trendingID.  

Enabled: Database records with the same timestamp

may appear

as in the

database for this trending.Date values UTC-offset

The timestamps in the export file are stored in local time. Before storing the data in the database the import subtracts the UTC-offset from the export timestamps to get the timestamps in UTC.

Timestamps

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

in

as UTC. The conversion is automatically done during the import.

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

Export

...

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

According to Records matching the current filter , data will be exported to to an xlsx file.Clear the date filter to export all data

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

Delete

...

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