Skip to Main Content
AVEVA™ PI System™ Feedback Portal

Welcome to our feedback site!


We created this site to hear your enhancement ideas, suggestions and feedback about AVEVA products and services. All of the feedback you share here is monitored and reviewed by the AVEVA product managers.

To start, take a look at the ideas in the list below and VOTE for your favorite ideas submitted by other users. POST your own idea if it hasn’t been suggested yet. Include COMMENTS and share relevant business case details that will help our product team get more information on the suggestion. Please note that your ideas and comments are visible to all other users.


This page is for feedback specifically for AVEVA PI System. For links to our other feedback portals, please see the tab RESOURCES below.

Status No Status
Categories PI Builder
Created by Guest
Created on Aug 20, 2022

Support import/export of AF tables in PI Builder

As a user, I want to be able to import/export AF tables using PI Builder, so that I can make changes as needed.
  • Attach files
  • Guest
    Reply
    |
    Aug 20, 2022
    Hi Todd, as you know, there are two aspects to AFTables: the configuration of the table and the actual table data. We've discussed a few possibilities for how to represent the data in the worksheet, since we can't put an entire table in a single cell. Do you have any thoughts about the best way to represent this? Thanks in advance.
  • MarkGoepel
    Reply
    |
    Aug 20, 2022
    I agree. What would be exceedingly useful would be able to maintain the DESIGN of an AF Table with PI Builder. Right now, it is very easy to copy and paste the actual data contained in the table between Excel and PSE, so this is more about the actual column design (PSE Define Table tab) of the table. OK, just realised I cannot add a screenshot to this feedback form. I will post another feedback entry suggesting that.
  • Guest
    Reply
    |
    Aug 20, 2022
    In PI Builder, a cell is used to represent data. A table is a 2 dimensional object with rows and columns. What would be the desired way to represent a 2 dimensional object with rows and columns into a single cell? We have considered using a different Excel sheet to represent a table and then referencing this sheet from a single cell in PI Builder. Is that acceptable? Other alternatives?
  • Joel Irvine
    Reply
    |
    Aug 20, 2022
    A table is 2 dimensional, and excel itself, is 2 dimensional. Can you set it up so that when you tell Excel to import a table, it grabs the table as a 2 dimensional object? Adds the Top row as the header and that can't be changed at all, the rows and columns show up as such and can be modified then published back to the same Table name under the headers. We have users who right now log into PIAF and update tables from an excel spreadsheet, this would be better to give them the ability to import the table, modify the data entry points, then publish it back.
  • Dan.Louchbaum
    Reply
    |
    Aug 20, 2022
    My OSI EA contacts have suggested that I use an AF table to manage mappings from a PI Connector array locations and the actual AF element attributes. So far this idea is working well, except for the fact that I have thousands of variables to keep mapped. Rolling out my AF to the rest of the facility will be ten's of thousands of mapping. Any time I need to "tweak" some mappings, add, remove, or even shift up or down variables (similar to managing PIPoints in SMT) I find it to be a less-than-ideal management step to have to manually "copy" "Paste" rows. Things could get mapped incorrectly on accident quite easily. Ideal state is to allow PIBuilder to manage the table exactly like we manage tags. Then we can use Excel tricks to build out AF elements and the table all at the same time.