• How To Loop Through The Values of AF Table Using AFSDK

    Greetings to my fellow PI Geeks:   I need some help looping through an AF Table. I am not finding answers doing a variety of searches on this topic. In C# I am able to connect to the default AF database and i...
    James Devine
    last modified by James Devine
  • PI Web API Unresponsive for Some PI Tags

    Hi all,   I encountered an issue on PI Web API and below is the issue description.   Whenever I try to plot a trend on PI Vision -2019 for Sinusoid Tag, I could browse and and Plot as usual but whenever I ...
    last modified by PAVAN_HEMAPAVAN
  • Compare 2 DB for differences

    Is there a method to compare 2 DBs for the differences. For example, let's say this databases are the same but there may be new elements. How I can compare these two to find the elements that are one database that are...
    last modified by SantiagoVeraTorres
  • AF SDK :FindElementsByTemplate call and element versioning

    Hi,      We have a custom code that uses FindElementsByTemplate AF SDK call to retrieve elements by template.  We have around 25 templates with 100's of elements based on each template. The p...
    Arti Rajagopalan
    last modified by Arti Rajagopalan
  • Is there a GetPIPoint Function for PI SQL Client?

    Hi PI Community! I recently found about the very handy Table-Valued Function in PI OLEDB Enterprise called GetPIPoint. This is a great way to get all PI points used in a part or the entire AF tree. I than tried to f...
    last modified by Adriano.Arantes
  • Error during fetching data form pi web APi

    I have so sent many requests to pi web API. after sending some requests I am getting the below error. is there anyway way to resolve this issue without using the batch process. Thanks in advance. error messages  ...
    last modified by shajahan
  • Find max value from group of attributes - AF SDK

    Hello,   So, I am writing a minor to find the maximum value from a group of element attributes.  Here's what I am doing so far:   Using an AFElementSearch to find all elements based on a specific elem...
    last modified by Todd.McQuiston
  • Struggeling with Powershell's Set-AfAttribute

    Hi I am using Set-AFAttribute -AFAttribute xxx -Value yyy to write into AF's Attributes. So far so good, it works fine if it is a pure AF Attribute.   Now i am trying to write to an AFAttribute which represent...
    last modified by UKullmann
  • Is there a way to "Retrieve Selected Object" in VBA from the DataLink?

    Is there a way to "Retrieve Selected Object" in VBA from the DataLink? I want to search and get all the pi tags that contain "*-YV*PV*". I know there are other ways to do this (Pi Web API, Pi builder Add In), but i am...
    last modified by Nick_Stom
  • pipc32.xll doesn't work

    Hi to everyone! My problem is: I use Pi DataLink from  1 year but today excel doesn't  recognise PIPC32.xll add-in   Is there anyone that can help me   Thanks
    last modified by Crispo
  • Can AF-ExportXml export entire database?

       We have a need to copy an entire AF database from our Production environment to our Test environment for testing new AF.  We can't use the PI Connector because we want EVERYTHING copied, and PI ...
    last modified by taterhead247
  • AFSDK afDB.FindChangedItems(AFIdentity.EventFrame, false, 1000, dbCookie, out dbNextCookie); is not working

    Hello, I am facing strange issue on AFSDK method "FindChangedItems" for finding changed EventFrames. This function is working perfect one AF Server, but it is not working on other AFServer. Let me explain you in de...
    last modified by SunilGajjarH
  • SDK connections options

    it is possible to set a process in customer authentication parameters as shown in Figure
    last modified by jmparis
  • How to get and send data to PI using Python? Thanks

    Hello, I'm new in PI, I know few things, I want to get data from PI to python scripts and apply machine learning and send results (values) back to PI, like another TAG, and take advantages from PI infrastructure: hist...
    last modified by Adrian_Trujillo
  • PI JDBC query: get archived values for a time frame, outside bounds

    Hello, I'm using PI SDL DAS with OLEDB Ent 2019 (we don't have AF 2018+ so I am unable to use RTQP as this time). What I'm trying to do is query archived values of attributes of a unit during the duration of an EF.&#...
    last modified by narburgh
  • Powershell script for Backfill/Recalculate

    I've been told by quite a few people in tech support that PowerShell is very ... powerfull and can do a lot of different things.  I'm trying to teach myself the capabilities but it seems hard to find good documen...
    last modified by taterhead247
  • Getting results into AFValue for Data Reference

    Hello!   So, I have started writing my Data Reference to pull PI Tag attribute values into AF attributes.  To familiarize myself with the AFSDK, first I wrote a little standalone forms program to do this - ...
    last modified by Todd.McQuiston
  • Create data reference to retrieve tag attributes

    Hello,   I am looking to create a custom data reference which would permit me to populate an AF attribute with the value of a Data Archive tag attribute.  So, I would supply the server, tag, and attribute n...
    last modified by Todd.McQuiston
  • Joining SQL and PI-OLEDB data

    I have a user who needs to do a SQL JOIN query between a table on a SQL server and our Production PI server via OLEDB.  Is that even remotely possible?    He's using Tibco's Spotfire for this, but I ca...
    last modified by Todd.McQuiston
  • Different Time Formats When Using SelectedFields Parameter

    I am querying the web API to get a list of event frames from an asset database (assetdatabases/{webId}/eventframes)   If I query it without the 'selectFields' parameter, the event frame StartTime and EndTime val...
    last modified by rodp