need calc fields in readMeterProfile

Avatar

pnpscada-user
2013-06-14 15:48

Please see attached the data we have pulled from the meter and the CSV downloaded from pnpscada.
read meter profile call:
https://energydrive.pnpscada.com/readMeterProfile?LOGIN=xxx.xxx&PWD=xxx&eid=8607&startdate=2012-08-24&enddate=2012-08-25
I think what we are looking for is to get these calc fields downloaded in the call to pnpscada since the data does seem to be there, even if calculated at zero, in the CSV and therefor pnpscada.

Avatar

sdg.matiaan
2013-06-14 15:51

if you look at the profile graph at that date, you will see that there was a power down during that time.

So the meter physically did not log any data during that time.
In our database, we also dont have that data.
In the Download however, we fill that up with zeroes.
You can however use the download page as a web service, here is an example that shows your example, converted to use the download page.
https://energydrive.pnpscada.com/_DataDownload?LOGIN=xxx.xxx&PWD=xxx&CSV=Yes&TEMPPATH=../temp/&LOCALTEMPPATH=docroot/temp/&GSTARTH=0&GSTARTN=0&GENDH=0&GENDN=0&GSTARTD=24&GSTARTY=2012&GSTARTM=8&GENDD=25&GENDY=2012&GENDM=8&selGNAME_UTILITY=1520$Electricity&TGIDX=1
There's just 2 catches:
1. this invocation does not return the data in csv, but rather a redirect to the csv that you can download using a second http request.
2. the invocation does not use the entity id of the meter, rather the entity id of the meter account that connects to the meter.

Please log in to post a comment