This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
Aveva/OSISoft PI Tools
ih
Super User (Alumni) ih
Super User (Alumni)
Created: Aug 20, 2021 09:11 AM  |  Last Modified: Jan 5, 2023 04:50 PM
JMPOSIPITools.jmpaddin

A graphical interface to bring data from Aveva's PI Historian (formerly OSISoft) directly into JMP, or generate JSL scripts to pull that data in custom scripts.  Combine this with the copy column script in the Scripting Tools add-in to quickly recreate analyses using up-to-date data.  This requires PI Web API version 2021 SP3 or higher.

 

This add-in queries pi point data directly.  To access data in PI AF, use the new functionality in JMP 17. Note that this add-in pages results so it might be better able to handle large amounts of data than 17.0 can.

 

Click on any question mark in the interface for detailed instructions on each function:          

          ih_0-1672955033750.png

 

Data is automatically opened as a JMP table:

          ih_1-1629462386759.png

 

You can

  • Search for PI tags
  • Pull every value stored in the archive
  • Pull interpolated values at evenly spaced intervals
  • Retrieved summarized values, such as hourly averages, or 5-minute averages every 2 hours.

Information about how the value was retrieved is stored in column properties.

          ih_0-1629462315253.png

The resulting JSL is easy copied into other script windows and can be called as long as the user has the add-in installed:

          ih_1-1672955113076.png

 

A script to pull new data is automatically added to the data table:

          ih_3-1629462523883.png

'Friendly' names can be used instead of or with the pi tag name.

          ih_4-1629462767829.png

 

Find this project over on GitHub, feel free to submit issues or pull requests there.

 

Comments
Emmanuel_Romeu
‎10-05-2021 05:15 AM

great tool !! thanks for sharing Isaac

andreacoombs1
‎10-07-2021 08:50 AM

Thanks for the add-in and the excellent paper at JMP Discovery Summit!

 

Check out Isaac use this tool to pull data from PI, build multivariate models, and score models on-demand and online. Optimizing Multivariate Models: From Data Collection to Optimal Conditions and Scoring Models (2021-... 

 

 

FN
‎05-10-2023 10:34 AM

This is a great add-in. I noticed the license is GPL-3. Any chance this can be changed to MIT or BSD?

In the past, we released a similar add-in here:
https://github.com/industrial-data/JMP-MES-connector

ih
‎05-24-2023 02:59 PM

@FN I will need to look into this, that will likely take some time.  I assume you are considering using the code in another project, or is that a limitation to make improvements to this add-in?

FN
‎06-07-2023 11:35 AM

Hi @ih,

 

We are always trying to improve our add-in here:

https://github.com/industrial-data/JMP-MES-connector

 

Something we would like to do is to transition to web API, similar to this other add-in:
https://github.com/equinor/tagreader-python