AnsweredAssumed Answered

TO HAVE AN UPDATED TABLE IN PY SYSTEM EXPLORER

Question asked by Omar_Sanchez_TOYOTA on Nov 14, 2019
Latest reply on Nov 19, 2019 by bbregenzer

Like • Show 0 Likes0
Comment • 8

Hi members,

I would like to ask you if you know what is the best method to import a Table from Excel o Access to PI System Explorer Library and have it updated all the time, without the need of "import" every time when we modify one or more cells.

I have been informing myself about the "Table Link" option, instead of using "Table Import" option, but I am not sure of if this option is the appropriate one, according to my goal.

Please, I would be grateful to hear from your helpful comments based on your experience.

Thank you very much in advance,

Regards,

Omar.

No one else has this question

Outcomes

8 Replies

Omar_Sanchez_TOYOTA Nov 14, 2019 11:34 AM
Mark Correct
Correct Answer
In fact, I have tried to follow the steps of https://livelibrary.osisoft.com to link a excel file table to PI system explorer Library, but unfortunately, a window with a error message has popped-up :
"Unable to link to external table: Unexpected Server Error: 'The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.'.
Use Event Viewer to see the PI AF Server log file for more information."

What could be the reason?
Thanks for your support,
Omar.
Like • Show 0 Likes0
Actions
- sraposo @ Omar_Sanchez_TOYOTA on Nov 14, 2019 1:53 PM
  Mark Correct
  Correct Answer
  Hi Omar,
  
  You can create a link table to a Microsoft Access Table or a Microsoft Excel Sheet. You need to install the Access Database engine provider on the PI AF Server (Download Microsoft Access Database Engine 2016 Redistributable from Official Microsoft Download Center ). The bitness of the provider must match that of the PI AF Server. If you are running a 64-bit PI AF Server, choose the 64-bit version of the provider.
  
  In the table general tab you can specify a refresh interval. The refresh interval should match approximately when the table is refreshed.
  
  If this table is large and contains operation time based data, please use the PI Interface for RDBMS to get the data into PI Points. Linked tables aren't meant to be used to bring a large amount operational data into the PI System. They are meant to be used for contextual data or a smaller amount of operational data.
  
  If you are linking to an Excel sheet, make sure the Excel file is shared. Otherwise, if it is opened by another user, an error will be returned to the PI AF Server (and to the AF Clients).
  
  If you want to use Windows authentication, you will need to configure Kerberos delegation and delegate to CIFS on the target machine.
  
  Hope this helps,
  Seb
  2 people found this helpful
  Like • Show 0 Likes0
  Actions
  - Omar_Sanchez_TOYOTA @ sraposo on Nov 14, 2019 3:03 PM
    Mark Correct
    Correct Answer
    Hi Sebastien, first of all, thanks for your support.
    Secondly, let me reply to your points:
    1. Regarding downloading MS Access Database Engine 2016 ... I have some problems because I need the permission from IS department, but anyway, when I get the permission, I will try it.
    2. With the refresh interval you mean --> cache interval, aren't you?
    3. This previous refresh interval is useful to refresh automatically the table? I mean, my goal is for the table to be updated automatically, without anyone has to import the data. So, by means of linking a table and set up a "cache interval", will be I able to meet my objective?
    4. The tables which I want to link are quite small, so, I think this point does not entail any problem.
    5. The last point is not very clear for my (Kerberos and CIFS), but I think this is because I am not an IS expert. Anyway, I can ask to my IS colleagues for that.
    
    Thank you for your time,
    
    Regards,
    Omar.
    Like • Show 1 Like1
    Actions
    - sraposo @ Omar_Sanchez_TOYOTA on Nov 14, 2019 4:30 PM
      Mark Correct
      Correct Answer
      Hey Omar, Answering back your points:
      
      2)Yep the cache interval!
      3) There's no way to have the table in AF refresh exactly when the table is modified in the source. The only way is to have AF Clients fetch a new table when the cache interval expires.
      5) An IT Expert should be familiar with Kerberos authentication and delegation. If you or your team need help setting this up, please call into support!
      1 person found this helpful
      Like • Show 0 Likes0
      Actions
      - Omar_Sanchez_TOYOTA @ sraposo on Nov 19, 2019 10:22 AM
        Mark Correct
        Correct Answer
        Hey Sebastien,
        
        Thank you very much for your support. It is very useful to me. I am going to try to implement your proposals with the support of our IS department. I will keep you informed.
        Regards,
        Omar.
        Like • Show 0 Likes0
        Actions
    - bbregenzer @ Omar_Sanchez_TOYOTA on Nov 14, 2019 6:20 PM
      Mark Correct
      Correct Answer
      Hi, Omar.
      This article can be quite helpful in understanding how AF table caching works:
      https://customers.osisoft.com/s/knowledgearticle?knowledgeArticleUrl=KB00539
      3 people found this helpful
      Like • Show 0 Likes0
      Actions
      - Omar_Sanchez_TOYOTA @ bbregenzer on Nov 19, 2019 10:24 AM
        Mark Correct
        Correct Answer
        Sorry Brent, I have not access to this article ... Is there another way to access? I would like to know more about this topic. Thank you very much for your support!
        Regards,
        Omar.
        Like • Show 0 Likes0
        Actions
        bbregenzer @ Omar_Sanchez_TOYOTA on Nov 19, 2019 3:31 PM
        Mark Correct
        Correct Answer
        Hi, Omar.
        You would need to login to the Customer Portal with your SSO account. For further info, please see links below, and if you need further assistance getting registered, please contact Tech Support.
        What Is OSIsoft Customer Portal
        myOSIsoft
        Like • Show 0 Likes0
        Actions

TO HAVE AN UPDATED TABLE IN PY SYSTEM EXPLORER

Outcomes

Related Content

Recommended Content