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.
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.
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.
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.
發佈於: 施耐德電機Taiwan
