Versions Compared

Old Version 2

changes.mady.by.user georg.kotek

Saved on

compared with

New Version Current

changes.mady.by.user Reinhard Mayr

Saved on

Key

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

Table of Contents
maxLevel2

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

import or export trending data open the 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 Valuesvalues button image2020-4-15_13-28-24.pngImage Modified from the toolbar.Image Removed

Content

The page consists of several areas:

...

  • Toolbar

...

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

Image Added

Toolbar functions

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

Function 

Description

Image Removed

Image Added

Add
Refresh

Image Removed

Apply template

Image Removed

Edit folder name

Image Removed

Delete selected element

Image Removed

Copy selected element

Image Removed

Paste copied element

Image Removed

Change to calendar view

Image Removed

Change to list view

Image Removed

Switch to multi-select mode

Image Removed

Export

Image Removed

Import

Image Removed

Import ETS structure

Image Removed

Create template

Import 

...

Image Added

Delete selected trending values

Image Added

Import

Image Added

Export

Import

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

Image Added

  • 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 Added

OptionDescription
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. (warning) 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 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.