Skip to main content

Data Table

- PI Vision Widget -​

Revision History​

Revision No.DateAuthorDocument IDDescription of changes
9.3October 2025RSEW_DataTable_v9.3With the start date and end time set to the same date, the specific values of the attributes ​​are exported to the .csv .xlsx file.
9.2June 2025RSEW_DataTable_v9.2Added select REST provider
9.1May 2025RSEW_DataTable_v9.1Added feature Get Support
9.0March 2025ALEW_DataTable_v9.0Compatibility with PIVision 2024 and new widget style introduced
8.1August 2023MDCEW_DataTable_v8.1BugFix
8.0August 2023FMEW_DataTable_v8.0Compatibility PI Vision 2023
7.2March 2023MDCEW_DataTable_v7.2Added 1 month interval
7.1October 2022MDCEW_DataTable_v7.1English language default
7.0August 2022AMEW_DataTable_v7.0Compatibility PI Vision 2022
6.5June 2022MDCEW_DataTable_v6.5Label management improvement
6.4April 2022MDCEW_DataTable_v6.4WebAPI management on a different server
6.3March 2022MDCEW_DataTable_v6.3BugFix
6.2March 2022MDCEW_DataTable_v6.2Introduction of "Simple" and "Advanced" modes
6.1November 2021CCEW_DataTable_v6.1New features
6.0October 2021MDCEW_DataTable_v6.0Compatibility PI Vision 2021
5.2July 2021MDCEW_DataTable_v5.2Special characters management
5.1April 2021MDCEW_DataTable_v5.1BugFix
5.0March 2021MDCEW_DataTable_v5.0New graphic release and possibility to save a different time range
4.0October 2020OSEW_DataTable_v4.0Compatibility PI Vision 2020
2.3.1August 2020MDVEW_DataTable_v2.3Revision of documentation
2.3December 2019PCEW_DataTable_v2.3Support to data expiration
2.2May 2019PCEW_DataTable_v2.2Support to &, # and + in element name
2.1March 2019GIEW_DataTable_v2.1Restyle and revision of documentation
2.1March 2018GTTQS_DataTable_v2.1Modification of the installation procedure following the modification of the libraries used to download the data in Excel format
2.0.1January 2018PCTQS_DataTable_v2.0.1Review and add some configuration parameters
2.0November 2017GTTQS_DataTable_v2.0Restyle widget configuration; Change to the installation procedure
1.0September 2017GTTQS_DataTable_v1.0First version documentation

Document References​

DocumentDescription
PI Vision Installation and Administration GuidePI Vision™ user manual from AVEVA

Introduction​

The EW Data Table widget displays sampled data in PI Vision, similar to the Sample Data function of PI Datalink, which shows data at regular time intervals starting from the current data in the archive over a time range independent of the display.

This widget lets you set the following parameters:

  • Start Time (selectable with a calendar and a clock)
  • End Time (selectable with a calendar and a clock)
  • Interval (selectable via a combo box)

PI Vision from AVEVA , available since 2017, enables viewing real‑time data from the PI Data Archive and data organized in assets from the AVEVA Asset Framework (PI-AF).
To access PI Vision displays, navigate to:
https://webServer/PIVision (replace “webServer” with the correct name of the webserver machine)

The widget is supported by modern HTML5-compatible browsers on computers, tablets, and phones running Android and iOS.
Configuration is intuitive – simply drag and drop the control into the display.

Definitions, Acronyms And Abbreviations​

Acronyms and definitions that are used in the current manual are listed below.

TermDefinition

Operating Principles And Use​

To insert the Data Table, select the corresponding icon and navigate to the asset you want to view. Then, drag the control into the display area.

Figure 1 – PI Vision Menu​

When you release the mouse, the table is displayed with the same time range as the PI Vision display and an interval of 1 hour.

Figure 2 – Inserting the Data Table​

By opening the contextual menu (right-click), further customizations and configurations are available.

​
Figure 3 – Contextual Menu​

Functionality and use​

To view the data, set the widget parameters:

  • Start Time: selectable with a calendar and clock
  • End Time: selectable with a calendar and clock
  • Interval: selectable via a combo box
    Then, confirm your selections with the provided button.

The table displays the timestamp in the first column. Starting from the start time, each subsequent row adds the defined interval until reaching the end time.
Hovering over a column header displays the full context path of the data; clicking the “x” next to a header removes that column. Columns can be resized by dragging. A vertical scroll bar appears if necessary.

​
Figure 4 – Data Table​

The Download button lets you generate an XLSX or CSV file (as configured) with the table data. The file is automatically saved in your download folder with a name formatted as DataTable_YYYYMMDDhhmmss.

Using the button shown in Figure 5, you can sort the rows by time in ascending or descending order.

​
Figure 5 – Sort by time ascending/descending​

Customization and configuration​

The widget configuration allows you to change appearance elements such as colours, text size, and language.

Language​

In the Language section, select the language for labels and configuration parameters.

​
Figure 6 – Language choice​

Title​

Modify the table title by specifying a string in the Title section.

Figure 7 – Customization of the table title​

Settings​

  • Decimals: Customize the number of decimal places to display.
  • WebAPI Server: Specify the WebAPI server if it differs from the PI Vision server.

Figure 8 – Settings​

Table sizes​

Customize the maximum height of the table.

​
Figure 9 – Table sizes​

Save interval in configuration​

Select this option so that the widget is independent of the display’s time range; it will then use the dates defined in the widget.

​
Figure 10 – Save interval in configuration​

Items​

Choose to display the element name in the header of each column.

​
Figure 11 – Show element name​

Mode selection for managing times​

  • Simple mode: The table’s time range is directly linked to the display’s timebar; only the interval can be changed.
  • Advanced mode: (Default) provides additional configuration options.


Figure 12 – Simple mode​

Figure 13 - Advanced mode​

Export file format​

Choose the export format (XLSX or CSV) for the table data.

​
Figure 14 – Export file format​

If the same Start and End Time are chosen for the export the generated file will contain the punctual values of the datasources.

Figure 15 - Same start/end date​

Figure 16 - Generated .csv file​

Date format​

Customize how timestamps are displayed in the table.

​
Figure 17 – Date Format​

REST Provider​

Allows the user to select between default or custom protocol for api requests.

Figure 18 - REST Provider selection​

Sorting columns and changing labels​

Configure the sorting order of columns and modify header labels as needed.

Figure 19 – Sort columns and change label​

Text size​

Customize the font size of the table text and title.

Figure 20 – Text size​

Contacts​

Get Support button (read Get Support documentation)

Link to e-matica.com (click on the icon)

Link to widget online documentation (click on link)

​
Figure 21 – Contacts​

Installation​

Requirements​

In order to install the product, minimum requirements are listed in the table below:

SoftwareVersionNote
PI Vision2024 (*)Requirements are linked to the PI Vision correct functioning
Table 1 - Installation prerequisites​

(*)This widget is also compatible with PI Vision 2023, 2022, 2021, 2020 and 2019.

​

We suggest using Google Chrome for full compatibility with the widget.

Installation procedure​

The installation procedure involves copying files and folders into the predefined PI Vision path.

  1. Copy Files:
    Copy the following files into the folder:
    ..\PIPC\PIVision\Scripts\app\editor\symbols\ext

    • sym-EWDataTable.js
    • sym-EWDataTable-config.html
    • sym-EWDataTable-template.html

  2. Copy Folders:
    In the folder ..\PIPC\PIVision\Public, copy the following:

    • Images: Contains the control icon EWDataTable.png
    • Libs: Contains the libraries: EWClasses.js, moment.js, and xlsx.min.js

Notes And References​

For more information about Vision PI refer to documentation on AVEVA © portal.
For information about the web service to refer to the specific documentation.