Skip to Main Content
Data services feedback portal

Welcome to our feedback site!


We created this site to hear your enhancement ideas, suggestions and feedback about CONNECT products and services. All of the feedback you share here is monitored and reviewed by the CONNECT 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 CONNECT data services. For links to our other feedback portals, please see RESOURCES below.

Status Completed
Categories General
Created by Guest
Created on Aug 16, 2022

PI Adapter for Structured Data Files

Create a PI Adapter that supports parsing data from simple file formats (CSV, XML, JSON, plain text) and is capable of writing data to EDS, PI, and OCS.
  • ADMIN RESPONSE
    Aug 16, 2022
    PI Adapter for Structured Data Files 1.0.0.138 is now available. Please reach out to your Account Manager or Customer Success Manager with any licensing inquiries.
  • Attach files
  • Guest
    Reply
    |
    Aug 16, 2022
    It would be great if this PI Adapter had much more native support for XML files. That way, we can browse and parse XML files like a tree as they were intended, rather than as a sequence of lines. I still think that OSIsoft should consider leveraging Power Query, which is a language that already supports many types of data sources and not just text-based ones. See this suggestion: https://feedback.osisoft.com/forums/555139-pi-connectors/suggestions/40518250-pi-connector-for-power-bi-desktop-the-swiss-army
  • Guest
    Reply
    |
    Aug 16, 2022
    It would be nice if this PI Adapter had a way to run code before or after a file is processed. This would be good for resetting variables to some initial value or printing stuff to the log, but I'm sure that there are other use cases for this. With the PI Interface For UFL and the PI Connector For UFL, you would have to get clever with the BOS and EOS functions. The latter is complicated further if you used SkipFile in your code, and both are complicated further if you have many different message sections.
  • Guest
    Reply
    |
    Aug 16, 2022
    The PI UFL interface supports serial port data entry, or virtual serial port data entry. We use this to send gas chromatograph lab data to PI for environmental monitoring. If PI Adaptor for Structured Data Files will be replacing PI UFL interface in the future, then a serial port data transfer method needs to be included among the file formats within PI Adaptor for Structured Data Files, or else something additional needs to be created to support sending serial port data to PI. Will there be continuing support from OSIsoft for some sort of a method (adaptor, interface, connector, etc.) to send serial port data to PI?
  • Guest
    Reply
    |
    Aug 16, 2022
    A problem we have with the current UFL interface is that it cannot read open files, which means that we can only read the content when a batch has finished and the file has closed. This of course means we can't get to "near real time" data ingestion into PI, instead it could be days. So it'd be great if you can consider this for the Adapter - surely we can't be the only ones with this use case!