Data in SQL incorrect timestamp

Topics: 1. General
Feb 1, 2015 at 4:15 AM
I had SBF spot running fine in windows, bought a raspberry and when i was getting it setup i didi a sync before i set the time or locale properly and i have this data that should be in the day time now in the evening for one day. http://www.pvoutput.org/intraday.jsp?id=37637&sid=34432&dt=20150130

I tried to delete the data and re import it, but it never works.

I tried delete * from daydata; that didnt work.

How will i get the proper data from the invert into my DB?
Feb 2, 2015 at 7:35 AM
OK i used pvbc to grab the data from the inverter again and its still messed up. why would the inverter think its making 4000w at 11.30pm ?
Coordinator
Feb 2, 2015 at 9:05 AM
Depending on config settings, SBFspot will set inverter time. So if your system time was wrong, your inverter will have wrong time.
Try to check it with SunnyExplorer.

Delete daydata in your SBFspot db for that day and re-import the data. You will need to specify -adxx where xx is the number of days to import
Coordinator
Feb 2, 2015 at 9:27 AM
Check also your settings on pvoutput (timezone to begin with)
In normal circumstances, pvoutput should deny data after sunset
Feb 2, 2015 at 9:32 AM
Thanks, i had switched to new raspberrypi and i had the time wrong for a while, sbf synced the time to the inverter and bck again when i fixed the locale/timezone on the rpi. so does this mean the inverter has recorded these entries wrong and i cant really fixed without manually editing the csv?

Its not the end of the world , i guess i could look at the csv and estimate the daily amount and edit the days totals in pvoutput?
Coordinator
Feb 2, 2015 at 11:02 AM
The timesetting by SBFspot has been introduced to set the time for devices without real-time clock. Sunny Explorer does the same, but in most cases, pc time is correct.
You can manually adjust pvodata:
Live data (14 days back) http://pvoutput.org/loadlive.jsp
Day data (no limit) http://pvoutput.org/load.jsp