This add-in automates data extraction tasks from Aspentech IP.21 and Osisoft PI (Aveva) historians.
This way, you can use JMP to diagnose manufacturing problems and monitor several tags daily and weekly. See our review for more industrial data science applications.
If you would like JMP to support historians natively, give it a thumbs up in the wishlist.
Requirements
Functionalities
The interface allows users to:
The extraction is done tag by tag with a high limit of rows (100,000) per tag to not saturate the server.
You can check the log to track the progress of the data extraction. It should be fast enough for most cases unless limited by connectivity speed (e.g., VPN). Please notify in advance your OT/IT team if you are planning for massive data extractions.
After you extract data for both IP21/PI servers, you can UPDATE, REFRESH, and ADD new tags to the table with one click.
The timestamp in UTC format (TS_UTC column) will be used, so keep it in your table. Likewise, if you want to change the names of your tag columns, we recommend creating new columns using formulas to refer to them.
What’s the difference between update() and refresh()?
Both will automatically obtain recent data from MES.
Use update() to keep track of all new and old data.
How can I organize all the tags (columns) after the extraction?
You can easily group and ungroup the tags with our Column Organizer add-in
License
This add-in is open-source (BSD clause 3). The code is available in the GitHub repository.
https://github.com/industrial-data/JMP-MES-connector
Serverlist
If you have a list of servers, you can load it using the example provided on GitHub. Notice the “MES_serverlist.csv” should have “;” instead of “,” to work.
To have as a new default your own server list, change the address in the GUI editor within the source code.
Creating your add-in
You can modify the source code and GUI at your will. The requisite is to keep the specific ID as “MES_Addin”. The steps to go from source code to add-in can be seen below.
Roadmap
We have several improvements in mind.
Meanwhile, suggestions, issues, and pull requests are more than welcome.
If you are only using PI, you should check a similar add-in with some of these features already developed.
Aveva/OSISoft PI Tools from @ih
https://community.jmp.com/t5/JMP-Add-Ins/Aveva-OSISoft-PI-Tools/ta-p/224525