{}

Våra varumärken

Impact-Company-Logo-English Black-01-177x54

Välkommen till Schneider Electrics webbplats

Välkommen till vår webbplats.
Hur kan vi hjälpa dig idag?
Modifying a table's column name within a Data Log Viewer in PME Vista
Issue
How to modify the data log's table column name in Vista.

Product Line
Power Monitoring Expert 7.2.x
Power Monitoring Expert 8.x
Power Monitoring Expert 9.x
Power Monitoring Expert 2020
Power Monitoring Expert 2021
Power Monitoring Expert 2022
Power Monitoring Expert 2023

Environment
Vista

Cause
The Data Log Viewer Configuration window allows for adjustments in the query that the Data Log Viewer runs against the SQL database in order to show a custom parameter/measurement or to include the site/meter name.

Resolution
**Warning: Ensure that the current SQL query file is backed up prior to modifying the query file in the PME directory.

1. Launch the Vista software and navigate to the applicable diagram.
2. From the Options menu, click on 'Show Toolbox'.
3. Locate the data log viewer that requires modification and right-click on the icon to show the 'Data Log Viewer Configuration' window.
4. Navigate to the 'Query' tab and click on 'Edit SQL'.
5. In the "SELECT" function, determine the parameters that require a name modification and change it from:

SELECT     timestamp
, "Voltage A-B"
TO
SELECT     timestamp
, "Voltage A-B" as "Custom Label"

as an example.

This will show "Custom Label" as the table header.

Edit SQL

6. After the required changes have been made click on File > Save, and close Notepad. Click 'OK' to close the Data Log Viewer Configuration window.
7. The table column header should now appear similar to the screenshot below.

Customized Column Headers

Schneider Electric Sverige

Utforska mer
Produkt:
Artiklar som kan vara till nytta
Utforska mer
Produkt: