Strange values being uploaded to PVOutput

Topics: 5. Support
Mar 27 at 7:42 PM
Last Saturday I installed a Pi and setup SBFspot on it. The values uploaded Saturday are not complete. I thought that maybe it was because is was in the around 17:00 I set it up.

The values of yesterday and today were also not complete. Today it started at 5:25AM with 0.596kWh and 5 minutes later it was 78.273kWh. This is not good. What can it be?

Also there is a lot of data uploaded with the same Energy value and a Average value of 0W.

Another thing I found out was that the sundown time is to short. The coordinates are set to the right value but sundown time is not correct. Is it possible to make the 3600 offset value larger?

PS: sorry if my English is not that good ;)
Coordinator
Mar 28 at 9:28 AM
Can you give us some more info like logfile and link to your pvoutput system?
Mar 28 at 8:17 PM
Edited Mar 28 at 8:19 PM
Link to the system: https://pvoutput.org/list.jsp?id=56701&sid=51185

Log of today:

``` [01:27:31] WARNING: Belogroep is not yet member of SBFspot Team. Consider joining at http://pvoutput.org/listteam.jsp?tid=613
[03:27:32] WARNING: Belogroep is not yet member of SBFspot Team. Consider joining at http://pvoutput.org/listteam.jsp?tid=613
[05:28:31] WARNING: Belogroep is not yet member of SBFspot Team. Consider joining at http://pvoutput.org/listteam.jsp?tid=613
[07:28:31] WARNING: Belogroep is not yet member of SBFspot Team. Consider joining at http://pvoutput.org/listteam.jsp?tid=613
[07:30:36] INFO: Uploading 3 datapoints, starting with 20170328,05:20,1355645,0 => OK (200)
[07:30:37] INFO: Uploading 3 datapoints, starting with 20170328,05:20,990909,0 => OK (200)
[07:30:38] INFO: Uploading 3 datapoints, starting with 20170328,05:20,991478,0 => OK (200)
[07:30:39] INFO: Uploading 2 datapoints, starting with 20170328,05:25,1595334,0 => OK (200)
[07:45:31] INFO: Uploading 3 datapoints, starting with 20170328,05:35,1355667,132 => OK (200)
[07:45:32] INFO: Uploading 3 datapoints, starting with 20170328,05:35,990923,84 => OK (200)
[07:45:32] INFO: Uploading 4 datapoints, starting with 20170328,05:30,1050703,0 => OK (200)
[07:45:33] INFO: Uploading 3 datapoints, starting with 20170328,05:35,991492,84 => OK (200)
[07:45:34] INFO: Uploading 4 datapoints, starting with 20170328,05:30,1075146,0 => OK (200)
[07:45:34] INFO: Uploading 4 datapoints, starting with 20170328,05:30,1338904,0 => OK (200)
[07:45:35] INFO: Uploading 3 datapoints, starting with 20170328,05:35,1595347,120 => OK (200)
[08:00:36] INFO: Uploading 3 datapoints, starting with 20170328,05:50,1355735,348 => OK (200)
[08:00:37] INFO: Uploading 3 datapoints, starting with 20170328,05:50,990970,240 => OK (200)
[08:00:38] INFO: Uploading 3 datapoints, starting with 20170328,05:50,1050768,300 => OK (200)
[08:00:38] INFO: Uploading 3 datapoints, starting with 20170328,05:50,991539,240 => OK (200)
[08:00:39] INFO: Uploading 3 datapoints, starting with 20170328,05:50,1075225,336 => OK (200)
[08:00:40] INFO: Uploading 3 datapoints, starting with 20170328,05:50,1338967,276 => OK (200)
[08:00:40] INFO: Uploading 3 datapoints, starting with 20170328,05:50,1595402,276 => OK (200)
[08:15:31] INFO: Uploading 3 datapoints, starting with 20170328,06:05,1355862,660 => OK (200)
[08:15:31] INFO: Uploading 3 datapoints, starting with 20170328,06:05,991067,528 => OK (200)
[08:15:32] INFO: Uploading 3 datapoints, starting with 20170328,06:05,1050869,492 => OK (200)
[08:15:33] INFO: Uploading 3 datapoints, starting with 20170328,06:05,991637,564 => OK (200)
[08:15:33] INFO: Uploading 3 datapoints, starting with 20170328,06:05,1075342,600 => OK (200)
[08:15:34] INFO: Uploading 3 datapoints, starting with 20170328,06:05,1339063,468 => OK (200)
[08:15:34] INFO: Uploading 3 datapoints, starting with 20170328,06:05,1595503,492 => OK (200)
[08:30:31] INFO: Uploading 3 datapoints, starting with 20170328,06:20,1356096,1104 => OK (200)
[08:30:31] INFO: Uploading 3 datapoints, starting with 20170328,06:20,991346,1332 => OK (200)
[08:30:32] INFO: Uploading 3 datapoints, starting with 20170328,06:20,1051018,648 => OK (200)
[08:30:33] INFO: Uploading 3 datapoints, starting with 20170328,06:20,991886,1116 => OK (200)
[08:30:33] INFO: Uploading 3 datapoints, starting with 20170328,06:20,1075568,1008 => OK (200)
[08:30:34] INFO: Uploading 3 datapoints, starting with 20170328,06:20,1339206,612 => OK (200)
[08:30:35] INFO: Uploading 3 datapoints, starting with 20170328,06:20,1595656,660 => OK (200)
[08:45:37] INFO: Uploading 3 datapoints, starting with 20170328,06:35,1356615,2700 => OK (200)
[08:45:37] INFO: Uploading 3 datapoints, starting with 20170328,06:35,991873,2388 => OK (200)
[08:45:38] INFO: Uploading 3 datapoints, starting with 20170328,06:35,1051216,852 => OK (200)
[08:45:39] INFO: Uploading 3 datapoints, starting with 20170328,06:35,992363,2184 => OK (200)
[08:45:39] INFO: Uploading 3 datapoints, starting with 20170328,06:35,1076064,2412 => OK (200)
[08:45:40] INFO: Uploading 3 datapoints, starting with 20170328,06:35,1339405,888 => OK (200)
[08:45:40] INFO: Uploading 3 datapoints, starting with 20170328,06:35,1595875,1008 => OK (200)
[09:00:37] INFO: Uploading 3 datapoints, starting with 20170328,06:50,1357418,3432 => OK (200)
[09:00:37] INFO: Uploading 3 datapoints, starting with 20170328,06:50,992594,3120 => OK (200)
[09:00:38] INFO: Uploading 3 datapoints, starting with 20170328,06:50,1051558,1788 => OK (200)
[09:00:39] INFO: Uploading 3 datapoints, starting with 20170328,06:50,993004,2748 => OK (200)
[09:00:39] INFO: Uploading 3 datapoints, starting with 20170328,06:50,1076835,3372 => OK (200)
[09:00:40] INFO: Uploading 3 datapoints, starting with 20170328,06:50,1339687,1296 => OK (200)
[09:00:41] INFO: Uploading 3 datapoints, starting with 20170328,06:50,1596219,1560 => OK (200)
[09:15:36] INFO: Uploading 3 datapoints, starting with 20170328,07:05,1358401,4200 => OK (200)
[09:15:36] INFO: Uploading 3 datapoints, starting with 20170328,07:05,993488,3792 => OK (200)
[09:15:37] INFO: Uploading 3 datapoints, starting with 20170328,07:05,1052211,3192 => OK (200)
[09:15:38] INFO: Uploading 3 datapoints, starting with 20170328,07:05,993847,3672 => OK (200)
[09:15:39] INFO: Uploading 3 datapoints, starting with 20170328,07:05,1077803,4116 => OK (200)
[09:15:39] INFO: Uploading 3 datapoints, starting with 20170328,07:05,1340119,1968 => OK (200)
[09:15:40] INFO: Uploading 3 datapoints, starting with 20170328,07:05,1596706,2196 => OK (200)
[09:28:32] WARNING: Belogroep is not yet member of SBFspot Team. Consider joining at http://pvoutput.org/listteam.jsp?tid=613
[09:30:36] INFO: Uploading 3 datapoints, starting with 20170328,07:20,1359593,5028 => OK (200)
[09:30:37] INFO: Uploading 3 datapoints, starting with 20170328,07:20,994543,4416 => OK (200)
[09:30:37] INFO: Uploading 3 datapoints, starting with 20170328,07:20,1053180,4104 => OK (200)
[09:30:38] INFO: Uploading 3 datapoints, starting with 20170328,07:20,994884,4356 => OK (200)
[09:30:39] INFO: Uploading 3 datapoints, starting with 20170328,07:20,1078950,4836 => OK (200)
[09:30:39] INFO: Uploading 3 datapoints, starting with 20170328,07:20,1340743,2772 => OK (200)
[09:30:40] INFO: Uploading 3 datapoints, starting with 20170328,07:20,1597397,3060 => OK (200)
[09:45:33] INFO: Uploading 3 datapoints, starting with 20170328,07:35,1361000,5892 => OK (200)
[09:45:33] INFO: Uploading 3 datapoints, starting with 20170328,07:35,995762,5100 => OK (200)
[09:45:34] INFO: Uploading 3 datapoints, starting with 20170328,07:35,1054333,4860 => OK (200)
[09:45:35] INFO: Uploading 3 datapoints, starting with 20170328,07:35,996094,5088 => OK (200)
[09:45:35] INFO: Uploading 3 datapoints, starting with 20170328,07:35,1080288,5568 => OK (200)
[09:45:36] INFO: Uploading 3 datapoints, starting with 20170328,07:35,1341588,3684 => OK (200)
[09:45:37] INFO: Uploading 3 datapoints, starting with 20170328,07:35,1598328,4056 => OK (200)
[10:00:31] INFO: Uploading 3 datapoints, starting with 20170328,07:50,1362611,6732 => OK (200)
[10:00:32] INFO: Uploading 3 datapoints, starting with 20170328,07:50,997146,5748 => OK (200)
[10:00:32] INFO: Uploading 3 datapoints, starting with 20170328,07:50,1055662,5544 => OK (200)
[10:00:33] INFO: Uploading 3 datapoints, starting with 20170328,07:50,997476,5748 => OK (200)
[10:00:34] INFO: Uploading 3 datapoints, starting with 20170328,07:50,1081800,6288 => OK (200)
[10:00:34] INFO: Uploading 3 datapoints, starting with 20170328,07:50,1342674,4680 => OK (200)
[10:00:35] INFO: Uploading 3 datapoints, starting with 20170328,07:50,1599519,5136 => OK (200)
[10:15:36] INFO: Uploading 3 datapoints, starting with 20170328,08:05,1364433,7560 => OK (200)
[10:15:37] INFO: Uploading 3 datapoints, starting with 20170328,08:05,998697,6432 => OK (200)
[10:15:37] INFO: Uploading 3 datapoints, starting with 20170328,08:05,1057163,6252 => OK (200)
[10:15:38] INFO: Uploading 3 datapoints, starting with 20170328,08:05,999024,6396 => OK (200)
[10:15:39] INFO: Uploading 3 datapoints, starting with 20170328,08:05,1083498,7068 => OK (200)
[10:15:39] INFO: Uploading 3 datapoints, starting with 20170328,08:05,1344005,5688 => OK (200)
[10:15:40] INFO: Uploading 3 datapoints, starting with 20170328,08:05,1600978,6180 => OK (200)
[10:30:30] INFO: Uploading 3 datapoints, starting with 20170328,08:20,1366441,8280 => OK (200)
[10:30:31] INFO: Uploading 3 datapoints, starting with 20170328,08:20,1000392,6948 => OK (200)
[10:30:32] INFO: Uploading 3 datapoints, starting with 20170328,08:20,1058880,7164 => OK (200)
[10:30:32] INFO: Uploading 3 datapoints, starting with 20170328,08:20,1000720,6948 => OK (200)
[10:30:33] INFO: Uploading 3 datapoints, starting with 20170328,08:20,1085362,7608 => OK (200)
[10:30:34] INFO: Uploading 3 datapoints, starting with 20170328,08:20,1345577,6588 => OK (200)
[10:30:34] INFO: Uploading 3 datapoints, starting with 20170328,08:20,1602697,7212 => OK (200)
[10:45:31] INFO: Uploading 3 datapoints, starting with 20170328,08:35,1368625,8712 => OK (200)
[10:45:32] INFO: Uploading 3 datapoints, starting with 20170328,08:35,1002200,7164 => OK (200)
[10:45:32] INFO: Uploading 3 datapoints, starting with 20170328,08:35,1060774,7548 => OK (200)
[10:45:33] INFO: Uploading 3 datapoints, starting with 20170328,08:35,1002530,7164 => OK (200)
[10:45:34] INFO: Uploading 3 datapoints, starting with 20170328,08:35,1087348,7848 => OK (200)
[10:45:34] INFO: Uploading 3 datapoints, starting with 20170328,08:35,1347367,7236 => OK (200)
[10:45:35] INFO: Uploading 3 datapoints, starting with 20170328,08:35,1604655,7932 => OK (200)
[11:00:31] INFO: Uploading 3 datapoints, starting with 20170328,08:50,1370881,9252 => OK (200)
[11:00:31] INFO: Uploading 3 datapoints, starting with 20170328,08:50,1004038,7500 => OK (200)
[11:00:32] INFO: Uploading 3 datapoints, starting with 20170328,08:50,1062725,7992 => OK (200)
[11:00:33] INFO: Uploading 3 datapoints,
Mar 28 at 8:23 PM
Also when I look in Sunny Explorer sometimes it is more than on pvoutput and sometimes the other way.
Coordinator
Mar 28 at 9:49 PM
It looks like you're sending data of multiple inverters to only 1 pvoutput system. Is that correct?
Can you send me a copy of the .db file? Something weird is going on here.
Mar 29 at 7:44 PM
Yes, that is correct.

I've sent you a PM with a link for the .db file.
Coordinator
Mar 30 at 9:10 AM
Edited Mar 30 at 9:15 AM
You have 7 inverters, so you need 7 systems on pvoutput. To make this possible, you have to donate (http://pvoutput.org/help.html#donations)
In SBFspotUploadDaemon.cfg you can map every inverter to its own SID (Sytem ID) on pvoutput
PVoutput_SID=1901200805:51185,1901201226:51xxx,1901201624:51xxx,1901201243:51xxx,1900752717:51xxx,1901201643:51xxx,1900752193:51xxx

51xxx is a unique SID for each pvoutput system
You can consolidate all systems into 1 "parent" system. See http://pvoutput.org/help.html#general-aggregation for more info on this item
Now you are uploading the data of your inverters to the same system, overwriting each others data.

To get rid of the "WARNING: Belogroep is not yet member of SBFspot Team" in the log, you can join each system to the SBFspot Team. See http://pvoutput.org/listteam.jsp?tid=613 and click the "Join or Leave Team" link

Nice installation BTW
Mar 30 at 2:09 PM
Thanks for your reply! It works now!

How can I overwrite the data from the past days where they are not correct? And is it possible to make the 3600 sunoffset value larger?
Coordinator
Mar 31 at 11:23 AM
To re-upload for a specific day you need to clear the pcoutput flag in the daydata table:

Change the date in the query below (YYYYMMDD)
This is for SQLite:
update daydata
set pvoutput=null
where strftime("%Y%m%d",date(timestamp,'unixepoch','localtime'))='20170329';
To verify the data you can use:
select datetime(timestamp,'unixepoch','localtime') AS Date, power, pvoutput
from daydata
where strftime("%Y%m%d",date(timestamp,'unixepoch','localtime'))='20170329';
Coordinator
Mar 31 at 11:33 AM
To change max value for SunRSoffset you need to modify the GetConfig function in SBFspot.cpp
else if(stricmp(variable, "SunRSOffset") == 0)
{
    lValue = strtol(value, &pEnd, 10);
    if ((lValue >= 0) && (lValue <= 3600) && (*pEnd == 0))
        cfg->SunRSOffset = (int)lValue;
    else
    {
        fprintf(stderr, CFG_InvalidValue, variable, "(0-3600)");
        rc = -2;
    }
}
    
Change the 3600 to the desired value

But I think you might have a misconfiguration in timezone and/or location (latitude/longitude)
Verify the timezone of your host machine (Raspberry Pi?)
Mar 31 at 3:12 PM
SBF wrote:
To re-upload for a specific day you need to clear the pcoutput flag in the daydata table:

Change the date in the query below (YYYYMMDD)
This is for SQLite:
update daydata
set pvoutput=null
where strftime("%Y%m%d",date(timestamp,'unixepoch','localtime'))='20170329';
To verify the data you can use:
select datetime(timestamp,'unixepoch','localtime') AS Date, power, pvoutput
from daydata
where strftime("%Y%m%d",date(timestamp,'unixepoch','localtime'))='20170329';
Is it also possible to delete the entire day in the database? The data in the database in also not correct for the last 6 days.
Coordinator
Apr 3 at 10:35 AM
To delete a full day:
delete
from daydata
where strftime("%Y%m%d",date(timestamp,'unixepoch','localtime'))='20170329';
Use SBFspot -adx to get the old data (x = number of days back)