Purpose
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 add-in to quickly recreate analyses using up-to-date data. This requires PI Web API version 2021 SP3 or higher.
How to Use
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:
Data is automatically opened as a JMP table:
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.
The resulting JSL is easy copied into other script windows and can be called as long as the user has the add-in installed:
A script to pull new data is automatically added to the data table along with a separate script that can be pasted into the refresh script window inJMP Live. Remember that in both cases this script does not include any modifications to the table or reports.
'Friendly' names can be used instead of or with the pi tag name.
Find this project over on GitHub, feel free to submit issues or pull requests there.
