Reuploading to PVOutput

Upload Software SBFspot
#1

Hi, My pi pooped out. Restored from about a week ago from my regular backups. Cleared data from the past week or so from PVO. Ran the following to reset SBFSpot.db values to NULL:

Select * from daydata Where date(TimeStamp, ‘unixepoch’, ‘localtime’) >‘2022-03-01’;
update daydata set PVoutput=NULL where date(TimeStamp, ‘unixepoch’, ‘localtime’) >‘2022-03-01’;

Checked the log and it began sending entries in the as expected, including for yesterday, March 11. While the pi log indicated the March 11 records were uploaded, PVO shows a 1 day gap for that day.

I reran the above and I get the same 1 day gap.

What am I missing, please?

-Alex

#2

The data to upload? If you pi crashed you might not have recorded data for that day

Can you manually upload that data in the live loader

#3

B-man, thanks for your response.

First, I deleted records for Mar1 and later from PVO using the Daily tab, checking Mar1-Mar12 checkboxes, hit DELETE.

Next, I cleared SBFspot records for several days - Mar 1 and later per my SELECT and UPDATE statements, above.

NEXT, I re-polled the router to repopulate SBFspot with records for those 12 or so days worth of entries I deleted via SELECT/UPDATE statements using the following.
/usr/local/bin/sbfspot.3/SBFspot -ad62 -am2 -ae2 -v -finq -nocsv

This would have covered any missing values in 5 minute increments pi/SBFspot.db for the time the pi was misbehaving.
No?

Then I watched as the days of Mar 1, 2, 3 etc, gradually reloaded - the log confirmed that is was sending about 30 records from SBFspot to PVO per minute. It repopulated all days in the UI except for March 11, even though the SBFSpot log showed it was uploaded March 11 records as well as the other deleted days.

So, what have I got wrong about this process?

-Alex

#4

What is your pvo link?
Can you post the important part of the log?

#5

Hi,

Thanks for your reply…

By link I presume you mean system ID?
85662 is where this pi uploads SBFspot to PVO

Here’s a paste of the log - assume this is what you meant by the important part?

[14:45:31.802] INFO: Uploading 30 datapoints, starting with 20220309,14:50,20934235,36 => OK (200)
[14:46:31.827] INFO: Uploading 30 datapoints, starting with 20220310,09:15,20934279,48 => OK (200)
[14:47:31.906] INFO: Uploading 30 datapoints, starting with 20220310,11:45,20934454,108 => OK (200)
[14:48:30.961] INFO: Uploading 30 datapoints, starting with 20220310,14:15,20934889,192 => OK (200)
[14:49:31.030] INFO: Uploading 30 datapoints, starting with 20220310,16:45,20935266,72 => OK (200)
[14:50:31.068] INFO: Uploading 30 datapoints, starting with 20220311,09:40,20935387,120 => OK (200)
[14:51:31.070] INFO: Uploading 30 datapoints, starting with 20220311,12:10,20935920,336 => OK (200)
[14:52:31.111] INFO: Uploading 30 datapoints, starting with 20220311,14:40,20941947,3696 => OK (200)
[14:53:31.157] INFO: Uploading 30 datapoints, starting with 20220311,17:10,20948954,1368 => OK (200)
[14:54:31.198] INFO: Uploading 30 datapoints, starting with 20220312,07:50,20949696,288 => OK (200)
[14:55:31.250] INFO: Uploading 30 datapoints, starting with 20220312,10:20,20955796,3804 => OK (200)
[14

#6

The graph for March 11th looks OK to me, exept that it is missing the voltage line (pink) (same for March 10th and the uncomplete voltage graphs for March 9th and 12th)
https://pvoutput.org/intraday.jsp?sid=85662&dt=20220310&gs=0&da=1&dxa=1&m=1

The inverter doesn’t keep historical (every 5min) voltages, so when your RPi is out, you can’t get the voltages back, only power generation. I think you’re confused by that, no?

The only strange thing I see is you’re a PVO donator, but the upload daemon is sending 30 datapoints at a time. This should be 100, but that’s not a big issue.

#7

Hi,

That may be where my confusion lies.

That said, no matter where I click I cannot seem to get to the daily detail for March 11.
Have tried the link below and its cousins (colored dots below the graph) and I still see 1 day gap where I would expect to see a daily line item option for March 11.
https://pvoutput.org/list.jsp?id=97169&sid=85662&v=2&est=0

So, to get to daily values you went to March 12 details, then went back a day?

How do I get a March 11 $ to calculate - if that is yet possible?
Why would voltage matter to that calculation?

#8

Oh, I see now, it’s in the daily graph. I guess @bankstownbloke can help here.

So, to get to daily values you went to March 12 details, then went back a day?

Yes, or click on “Live” and then select the date

#9

Hope so. FYI, am not whining about a single daily entry, rather that all I have read about upload protocols, db reconstructions, etc, may not jibe with reality. Thanks.

#10

End of day data and 5-minute data is kept separately. The daily data was deleted but not the live data.

Goto https://pvoutput.org/intraday.jsp?id=97169&sid=85662&dt=20220311 and delete the live data.

Any live upload to that date now will update both the live and daily data automatically.

1 Like
#11

Thank you. Won’t get a chance to do this for another day or two… but that makes sense.
And you might be saying to yourself, “of course it does, Alex!”
;o)