PI Developer Technologies

Welcome to the PI Developer Technologies feature suggestion box. This forum covers the PI AF SDK, PI Web API, PI OPC DA and HDA Servers, and the PI SQL family. We created this forum to hear your ideas, suggestions and feedback.

Please suggest your most important features and design change ideas on this site! Also vote for your favorite features now! We welcome your feedback.

  • NOTE: for documentation feedback and bugs, please report to Documentation@osisoft.com rather than entering them on this site.

How can we improve PI Developer Technologies for you?

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. PI ODBC driver for linus

    There is a pi JDBC driver for linux, but not an ODBC driver. This means that tools built around ODBC do not fully exploit the tools functionality. For example, RStudio has great database navigation tools that require ODBC.

    1 vote
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI ODBC Driver  ·  Flag idea as inappropriate…  ·  Admin →
  2. Missing Open API (Swagger) specification for the Search controller

    The swagger specs for the search controller are not available. This will be useful in the client libs for searching

    1 vote
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →
  3. Have Status of an analysis

    I would like to have status of analysis (Enabled, Disabled, Running, Error or Warning) via PI AF SDK with the attribute 'Status' or the method 'GetStatus'.
    In the library, we already have in AFStatus all the Status declared but not used.

    Thanks to that it will be possible to see all analysis in error and try to resolve analysis in error with AF SDK.
    Morever, We won't do backfilling on analysis in error and create other error, it will be clean to do backfilling on all analysis Enabled if we know which analysis are in error.

    Sorry for my english…

    1 vote
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  PI AF SDK  ·  Flag idea as inappropriate…  ·  Admin →
  4. Option to verify PI Data Archive connection during PI SDK installation

    During PI SDK installation, there is currently no option to verify the connection to the PI Data Archive. This can lead to complications if, for example, PI Interface Configuration Utility (which includes PI SDK) is the first piece of PI software installed on the machine and an invalid PI Data Archive name has been entered during the installation. Because there is no verification in the installer, the PI SDK and anything that relies on the Known Servers table entry such as interface.bat files must be corrected post-installation.

    1 vote
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Installation  ·  Flag idea as inappropriate…  ·  Admin →
  5. 1 vote
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →
  6. Search on multiple Categories in AFSearch

    Several customers have asked for ability to search on multiple categories.  I understand from developers that a generic OR in AFSearch can be quite expensive, but allowing for search filter Category to support Equal or IN should not be expensive.

    1 vote
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI AF SDK  ·  Flag idea as inappropriate…  ·  Admin →
  7. 1 vote
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI AF SDK  ·  Flag idea as inappropriate…  ·  Admin →
  8. Configurable message sizes for PI Channels

    See https://pisquare.osisoft.com/message/112944-is-there-a-way-to-limit-the-size-of-pi-channel-messages for the originating question.

    Clients connecting via PI Channels have limits on the size of messages they can receive, for security reasons.  It is possible for PI Channel message sizes to exceed these limits.  There should be a way to configure the max message size for PI Channels.

    1 vote
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →
  9. Allow applying PI AF attribute categories via the PowerShell commandlets

    We need to be able to apply PI AF attribute categories via PowerShell! We can do this today via the AF SDK, by referencing it within PowerShell, but it's a pretty convoluted solution to move back and forth in between command-lets and direct AF SDK references!

    1 vote
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  10. Specify Negative Time Offsets in SQL Commander

    Customer would like to write a query to return a time column with a negative offset in the PI OLEDB Provider such as:

    SELECT time, (time - 1d) as datekey
    FROM piarchive]..[picomp2]
    WHERE tag='sinusoid'

    This query works

    SELECT time, (time + 1d) as datekey
    FROM piarchive]..[picomp2]
    WHERE tag='sinusoid'

    A similar query can be written using a linked server but requires the additional overhead of a sql server or ssms.

    SELECT time, DATEADD(day, -1, time) as datekey
    FROM [PI_DA].[piarchive]..[picomp2]
    WHERE tag='sinusoid'

    1 vote
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI OLEDB Driver  ·  Flag idea as inappropriate…  ·  Admin →
  11. Add 'Time Zone = Server' to PI OLEDB Enterprise

    'Time Zone = Server' is available in PI OLEDB Provider, but has not been added to 'PI OLEDB Enterprise'.
    We have PI Data Archives in multiple time zones and require the ability to select the data in the server time zone.

    1 vote
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI OLEDB Enterprise  ·  Flag idea as inappropriate…  ·  Admin →
  12. Automatically update Transpose Function in SQL Commander when referenced Element Template name is updated

    In PI SQL Commander, users can create Transpose Functions that are linked to Element Templates in AF. When the referenced Element Template is renamed in PI System Explorer, the Transpose Function in PI SQL Commander is no longer able to find the Element Template which breaks the Function and underlying Data Table.

    Users are not aware that the Transpose Function or the underlying Transpose Data Table are broken until they attempt to query the Table or Transpose Function. It would be ideal if the Transpose function could either update this reference automatically or if the function referenced the GUID of…

    1 vote
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI OLEDB Enterprise  ·  Flag idea as inappropriate…  ·  Admin →
  13. Add Ability to Create Item Groups on the PI OPC DA Server

    As a PI OPC DA Server User, I would like to be able to create groups of tags (items) on the OPC Server, so that when I look for a specific tag in an OPC Client tool I don't have to search through the thousands of other tags that exist on my PI Server. This will make using the PI OPC DA Server more efficient and enjoyable.

    1 vote
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI OPC DA & HDA Servers  ·  Flag idea as inappropriate…  ·  Admin →
  14. Custom forms with PI Web API using Infopath

    How to use infopath with web API the same way it was documented how to use infopath with web services.

    1 vote
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →
  15. AF Dependency Removal

    Can the PI Web API be configured to store its configuration information in a flat file or some other (non AF) mechanism?

    1 vote
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →
  16. Permanently show descriptions underneath check boxes in PI SDK Utility → KST Cleanup

    In PI SDK Utility → KST Cleanup, there are 3 check boxes and 1 text box. When a check box is checked, the check box's label and description are added to the text box.

    Since there are only 3 check boxes, just eliminate the text box and have each check box description show underneath its corresponding check box. This would look a lot neater.

    1 vote
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  17. Powershell - Add the ability to get Attributes or Elements by Category

    Add the ability to retrieve Attributes and Elements by category for Powewhell command-lets.

    Example 1:

    $cat = Get-AFCategory -Name "Product A Manufacturing" -Element -AFDatabase $afDB

    get-AFElement -category $cat -AFDatabase $afDB

    Get a list of all the elements in category "Product A Manufacturing"

    Example 2:

    $cat = Get-AFCategory -Name "KPIs" -Attribute -AFDatabase $afDB

    Get-AFAttribute -category $cat

    Get a list of all attributes in category "KPIs"

    0 votes
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  18. Allow inputs to be defined for calls to stream values

    The stream endpoints should allow passing input attributes/values if the attribute's Data Reference supports it (refer to the AFDataReference.GetValues method in the AF SDK).

    For example this could look something like:

    .../stream/{WebId}/recorded?input.myInput1=myValue1&input.myInput2=myValue2

    One strong use-case for this would be an attribute configured as a Table Lookup Data Reference that returns a time series but allows a parameter to be defined.

    0 votes
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →
  19. Recalculate an Event Frame after a manual entry through PI Vision.

    Recalculate an Event Frame after a manual entry through PI Vision.
    So after inserting data in a manual manner, I want to be able to automatically recalculate the EF. In new AF version this works for analysis but not for EF. There is a way to do program it by using PI AF SDK? I would be happy if this can be done already from PI Vision with PIweb API.

    0 votes
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI AF SDK  ·  Flag idea as inappropriate…  ·  Admin →
  20. CreatePIPoints, FindPIPointsByPath, and other related functions should have the same return type.

    Currently, a method like PIServer.CreatePIPoints returns AFListResults<String, PIPoint>. Very similarly, PIPoint.FindPIPointsByPath will return AFKeyedResults<String, PIPoint>. The functionality of each result is essentially the same; they even have, for most practical purposes, the same associated properties and methods and thus; they should not be different object types.

    Sharing an object type across all of these PIPoint-related functionalities would allow developers to more easily share methods for these related functions (Such as error handling methods).

    0 votes
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI AF SDK  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base

Posted ideas will have one of the following statuses.
Full definition of these statuses can be found on the Home Page.
No status
NEEDS MORE DISCUSSION
RESEARCHING/EVALUATING
DECLINED
PLANNED
STARTED/IN DEVELOPMENT
IN BETA
COMPLETED