Get profile data from PNPSCADA in excel

Avatar

sdg.matiaan
2020-11-03 10:03

You can download the profile data you are looking at on the Profile Graph as a CSV file by clicking on View->Download CSV.
This file you can open in Excel.
Alternatively you can follow these steps to get the data into excel using web services:

Here are steps without scripting:

1) go to data

2) From Web



3) in the window that opens, type URL and put your full login, password and meter's serial:

https://adam.pnpscada.com:445/readMeterProfile?LOGIN=SUBDOMAIN.USERNAME&PWD=YOURPASSWORD&key1=METERSERIAL&startdate=2020-10-01&enddate=2020-11-01

4) then click Go

5) and import





Tags: excel
Please log in to post a comment