Technical FAQs

Ask a Question

Modifying a table's column name within a DataLog Viewer in SPM/PME/ION Enterprise Vista

A customer is looking to modify the data log's table column name in Vista.

Product Line
ION Enterprise 5.6
ION Enterprise 6.0
StruxureWare Power Monitoring 7.0
Power Monitoring Expert 7.2
Power Monitoring Expert 8.0

Programming in Vista

This is a result of a customer's requirements to modify the column name in order to show a custom parameter/measurement or to include the site/meter name. 

**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 requires a name modification and change it from:

SELECT     timestamp
        , "kWh del int"
SELECT     timestamp
        , "kWh del int" as "kWh imp@SITE.METERNAME"

as an example. 

This will show "kWh imp@SITE.METERNAME" as the table header. Refer to the screen shot below for an example. 

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

Was this helpful?
What can we do to improve the information ?