How to directly query Honeywell Process History Database from JMP?
Apr 4, 2013 7:46 AM(3064 views)
Hello to you out there that also work in process plants that use Honeywell control systems and process data historian (Honeywell PHD)! Like me, you probably spend a lot of time analyzing process data. You probably use the PHD Excel Add-in to get the data into MSExcel and then export to JMP. Has anyone out there figured out how to directly query PHD from JMP and bypass Excel? I've seen this done with Aspen Process Explorer, but not Honeywell PHD.
Message was edited by: Mark Chahl on 20-Jun-2013
Okay, I've been working on this problem in Excel. I've automated the data retrieval from PHD, formatted the data for export to JMP. I tried to Macro Record use of the JMP Add-in to Transfer Data Table to JMP, but Excel does not appear to record any of the JMP Add-in commands. Here is the recorded Macro:
' JMPPush Macro
Sheets("Export to JMP").Select
Does anyone know how to automate the JMP Add-in? Or must I code VBA as described in the JMP Automation Reference?