• OMF v1.1: An AF element template is created for each PI tag

    Hi,    We have been exploring OMF with PI web API. This results in an AF element template to be created for each PI tag.   Message formats are as shown below followed by the screenshots of AF template...
    created by Jyotig02
  • Connecting PI Processbook with SQL Server Automatically

    Good morning there!   Is there any way to immediately sign in to a protected database when opening a PI display?   Right now I have PI Calculations performing sql queries and pulling back specific TOP 1 ...
    last modified by PeteHerz
  • I want to build a list in ProcessBook VBA and export to an Excel file?

    I would like to create a list of tagnames on a display and export them to an Excel file.  I suppose a generic .txt file would work too.  I cannot figure out how to open Excel via ProcessBook VBA however, muc...
    last modified by gfmalek
  • PI Generic Names Installer Needed By PI SMT?

    I am not installing PI ICU with PI System Management Tools 2015 R2.  Do I still need to install PI Generic Names .MSI (PI GenericNamesSetup.msi)?
    Marc Dunivan
    last modified by Marc Dunivan
  • What happens behind the scenes when you change the Point Type of a long established Point?

    Hypothetical situation:   Lets say you have a Pi point that has had a Point Type of Int32 since it's creation X months ago and you change that Point Type to Float32 in the PI SMT; what happens behind the scenes?...
    last modified by Ahlywog
  • Which bitness version of PI SQL programs does 32-bit Excel use on 64-bit Windows?

    I have spreadsheets that use Power Query in Excel to get data from PI using PI OLEDB Provider, PI OLEDB Enterprise, and/or PI SQL Client. I use 32-bit Excel on 64-bit Windows. When I refresh the queries, is Power Quer...
    last modified by Kenneth_Barber
  • 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
  • Help with Python and PI Web API for a batch call to update PI Tag attributes

    I am working on automating this workflow rather than append in Excel. I have to set point and data security for some set of users or provide access to Analysis service. Got a great head-start from OSIsoft's Github. Ad...
    last modified by jagdish.konathala
  • 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
  • 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
  • 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
  • SDK connections options

    it is possible to set a process in customer authentication parameters as shown in Figure
    last modified by jmparis