Problem with addbatchstatus


#1

I am consolidating data from PG&E and Sunrun manually, and then submitting data (hourly readings) using batch api ( addbatchstatus.jsp ) .I get energy used and energy produced which I use to generate the data points.

Since I collect data every few days, my data points will be more than 30. So I am batching the requests in set of 30 each to send. (about 4-5 total number of requets).
I don’t get any error (response indicates 1 as accepted for data points, as below) , however data is not showing up in pvoutput.
what am I doing wrong ? Is addbatchstatus.jsp right api to use to send hourly data ? Is there a different format I need to use ?

My requests are formatted such –

20200413,02:00,0,,312;20200413,03:00,0,,372;20200413,04:00,0,,325;...

Tried adding -1 too

20200413,02:00,0,-1,312;20200413,03:00,0,-1,372;20200413,04:00,0,,325;...

Still data doesn’t show up.
Here is responses I get

  '20200410,00:00,1;20200410,01:00,1;20200410,02:00,1;20200410,03:00,1;20200410,04:00,1;20200410,05:00,1;20200410,06:00,1;20200410,07:00,1;20200410,08:00,1;20200410,09:00,1;20200410,10:00,1;20200410,11:00,1;20200410,12:00,1;20200410,13:00,1;20200410,14:00,1;20200410,15:00,1;20200410,16:00,1;20200410,17:00,1;20200410,18:00,1;20200410,19:00,1;20200410,20:00,1;20200410,21:00,1;20200410,22:00,1;20200410,23:00,1;20200411,00:00,1;20200411,01:00,1;20200411,02:00,1;20200411,03:00,1;20200411,04:00,1;20200411,05:00,1'

#2

i am answering my own question. I found that the both generation and consumption data needs to be cumulative. i.e. data needs to be added upto that time of day starting at 0 hours.
in simpler terms, if your production is 1 unit each hour of day, then you need to send data as such

  1. 00 hours - 1 unit
  2. 01 hours - 2 units
  3. 02 hours - 3 units
  4. 03 hours - 4 units

    and so on…
    same for consumption.