topic Re: How to import binary Pi Tags from web server into JMP in Discussions

How to import binary Pi Tags from web server into JMP

Theresa3003 — Tue, 04 Jun 2024 13:24:09 GMT

We are trying to import binary PI tags from our PI web server into JMP which does not work however.

The PI tag is character and has the names "Open" and "Closed" and values 1 and 0 respectively.

We verified that this binary PI tag is being populated in the web server:

When using the integrated "Import from PI Server" or our own application which is similar, the columns of the data table are not populated.: no data in columns 3 and 4 which present the binary PI tag-

We have no clue as to why we cannot see the PI tag values in our data table.

Your help is much appreciated!

Best,

Theresa

Re: How to import binary Pi Tags from web server into JMP

Craige_Hales — Tue, 04 Jun 2024 22:13:10 GMT

need more info. It looks like you should be importing a .json file you've downloaded, but I don't see the relationship between the two pictures...the column names don't match the json key-value pairs. What does the JSL open statement look like?

I'd start by saving a .json file and opening it with the json wizard and using the best guess, then refining the import using the wizard. Once you get the shape you want, you can save the script to reproduce it with fresh data.

Re: How to import binary Pi Tags from web server into JMP

Theresa3003 — Thu, 06 Jun 2024 13:49:59 GMT

@Craige_Hales Thank you for your reply!

In the meantime we found the reason. We have defined the AF path of the PI web server down to the "Value" and expect an actual value to be present which is then displayed in the data table. With continuous or character data that is not binary, the actual value comes right after "Value:" (see screenshot). With binary variables, there is not a value but a list with "Name", "Value" and "IsSystem" and we run into an error retrieving the actual value.

Long story short, we will need to adapt the structure of our PI web server to record only the values 0 and 1 and no descriptive names as it was the case.