This project has moved and is read-only. For the latest updates, please go here.

how to (auto) reupload data to pvoutput

Apr 7 at 8:45 AM
Edited Apr 7 at 1:04 PM
So I just deleted a couple of days, because the time settings of the inverters were incorrect, just to see if I could refetch them :

/usr/local/bin/sbfspot.3/SBFspot -v –finq -ad13

Does it take a while for them to upload or am I missing out on something here ?

the command I used does overwrithe the DB with new data right ? but is the flag of being uploaded to pvoutput reset (overwritten to blank again ?)

Thanks in advance !

edit : still no luck, I have even cleaned all daydata (deleted that info) and rerun the ad13 line, but seems it's still not uploading
Apr 8 at 9:03 PM
what's in the log file?
Apr 9 at 9:40 AM
Edited Apr 9 at 10:51 AM
``` [07:43:22] INFO: Stopping Daemon...
[07:43:45] INFO: Starting SBFspotUploadDeamon Version 1.0.1
[07:43:45] INFO: Starting Daemon...
NORMAL UPLOADS
[09:34:31] INFO: Uploading 100 datapoints, starting with 20170326,01:55,9899420,0 => OK (200)
[09:34:32] INFO: Uploading 100 datapoints, starting with 20170326,01:55,8967953,0 => OK (200)
[09:34:34] INFO: Uploading 100 datapoints, starting with 20170326,01:55,12487289,0 => OK (200)
[09:35:31] INFO: Uploading 100 datapoints, starting with 20170326,11:15,9899867,528 => OK (200)
[09:35:33] INFO: Uploading 100 datapoints, starting with 20170326,11:15,8968399,528 => OK (200)
[09:35:34] INFO: Uploading 100 datapoints, starting with 20170326,11:15,12487814,624 => OK (200)
[09:36:31] INFO: Uploading 5 datapoints, starting with 20170326,19:35,9908988,96 => OK (200)
[09:36:32] INFO: Uploading 4 datapoints, starting with 20170326,19:35,8974148,48 => OK (200)
[09:36:34] INFO: Uploading 6 datapoints, starting with 20170326,19:35,12500059,132 => OK (200)
NORMAL UPLOADS
[11:15:43] INFO: Starting SBFspotUploadDeamon Version 1.0.1
[11:15:43] ERROR: Unable to open output file. See syslog for details.
[12:30:42] INFO: Stopping Daemon...
[13:26:45] INFO: Starting SBFspotUploadDeamon Version 1.0.1
[13:26:45] ERROR: Unable to open output file. See syslog for details.
[13:58:45] INFO: Starting SBFspotUploadDeamon Version 1.0.1
[13:58:45] ERROR: Unable to open output file. See syslog for details.
[13:59:38] INFO: Starting SBFspotUploadDeamon Version 1.0.1
[13:59:38] INFO: Starting Daemon...
[13:59:40] INFO: Uploading 100 datapoints, starting with 20170326,01:55,9899420,0 => OK (200)
[13:59:42] INFO: Uploading 100 datapoints, starting with 20170326,01:55,8967953,0 => OK (200)
[13:59:44] INFO: Uploading 100 datapoints, starting with 20170326,01:55,12487289,0 => OK (200)
[17:54:03] INFO: Uploading 100 datapoints, starting with 20170326,11:15,9899867,528 => OK (200)
[17:54:04] INFO: Uploading 100 datapoints, starting with 20170326,11:15,8968399,528 => OK (200)
[17:54:06] INFO: Uploading 100 datapoints, starting with 20170326,11:15,12487814,624 => OK (200)
[17:55:31] INFO: Uploading 100 datapoints, starting with 20170326,19:35,9908988,96 => OK (200)
[17:55:33] INFO: Uploading 100 datapoints, starting with 20170326,19:35,8974148,48 => OK (200)
[17:55:35] INFO: Uploading 100 datapoints, starting with 20170326,19:35,12500059,132 => OK (200)
[17:56:31] INFO: Uploading 100 datapoints, starting with 20170327,16:00,9915605,1308 => OK (200)
[17:56:33] INFO: Uploading 100 datapoints, starting with 20170327,16:05,8980437,72 => OK (200)
[17:56:34] INFO: Uploading 100 datapoints, starting with 20170327,15:55,12508462,2136 => OK (200)
[17:57:32] INFO: Uploading 100 datapoints, starting with 20170328,12:25,9921557,1008 => OK (200)
[17:57:33] INFO: Uploading 100 datapoints, starting with 20170328,12:35,8982247,1080 => OK (200)
[17:57:35] INFO: Uploading 100 datapoints, starting with 20170328,12:20,12516084,1176 => OK (200)
[17:58:31] INFO: Uploading 100 datapoints, starting with 20170329,09:00,9929342,168 => OK (200)
[17:58:33] INFO: Uploading 100 datapoints, starting with 20170329,09:15,8987253,120 => OK (200)
[17:58:34] INFO: Uploading 100 datapoints, starting with 20170329,08:55,12526354,156 => OK (200)
[17:59:32] INFO: Uploading 100 datapoints, starting with 20170329,17:20,9933791,180 => OK (200)
[17:59:33] INFO: Uploading 100 datapoints, starting with 20170329,17:35,8991149,204 => OK (200)
[17:59:35] INFO: Uploading 100 datapoints, starting with 20170329,17:15,12532105,324 => OK (200)
[18:00:32] INFO: Uploading 100 datapoints, starting with 20170330,14:10,9938208,1596 => OK (200)
[18:00:33] INFO: Uploading 100 datapoints, starting with 20170330,14:25,8995806,1620 => OK (200)
[18:00:35] INFO: Uploading 100 datapoints, starting with 20170330,14:00,12537111,1836 => OK (200)
[18:01:31] INFO: Uploading 100 datapoints, starting with 20170331,10:15,9944985,300 => OK (200)
[18:01:33] INFO: Uploading 100 datapoints, starting with 20170331,10:40,8998832,360 => OK (200)
[18:01:34] INFO: Uploading 100 datapoints, starting with 20170331,10:05,12546184,324 => OK (200)
[18:02:32] INFO: Uploading 100 datapoints, starting with 20170331,18:35,9950514,108 => OK (200)
[18:02:33] INFO: Uploading 100 datapoints, starting with 20170331,19:00,9003781,96 => OK (200)
[18:02:35] INFO: Uploading 100 datapoints, starting with 20170331,18:25,12553136,156 => OK (200)
[18:03:31] INFO: Uploading 100 datapoints, starting with 20170401,15:15,9952946,252 => OK (200)
[18:03:33] INFO: Uploading 100 datapoints, starting with 20170401,15:55,9006103,168 => OK (200)
[18:03:34] INFO: Uploading 100 datapoints, starting with 20170401,15:00,12556061,180 => OK (200)
[18:04:32] INFO: Uploading 100 datapoints, starting with 20170402,11:35,9954349,744,,,32.9,0 => OK (200)
[18:04:33] INFO: Uploading 100 datapoints, starting with 20170402,12:15,9007953,1056,,,39.9,0 => OK (200)
[18:04:35] INFO: Uploading 100 datapoints, starting with 20170402,11:10,12557502,636,,,33.1,237.94 => OK (200)
[18:05:31] INFO: Uploading 100 datapoints, starting with 20170402,19:55,9963698,24,,,35.4,0 => OK (200)
[18:05:33] INFO: Uploading 100 datapoints, starting with 20170403,08:40,9013752,60,,,27.5,0 => OK (200)
[18:05:34] INFO: Uploading 100 datapoints, starting with 20170402,19:30,12569420,528,,,40.6,0 => OK (200)
[18:06:31] INFO: Uploading 100 datapoints, starting with 20170403,16:10,9969339,1656,,,50.3,0 => OK (200)
[18:06:33] INFO: Uploading 100 datapoints, starting with 20170403,17:00,9018582,96,,,38.5,0 => OK (200)
[18:06:34] INFO: Uploading 100 datapoints, starting with 20170403,15:45,12575840,2196,,,55.4,239 => OK (200)
[18:07:32] INFO: Uploading 100 datapoints, starting with 20170404,12:15,9975174,324,,,34.8,0 => OK (200)
[18:07:33] INFO: Uploading 100 datapoints, starting with 20170404,13:15,9021558,1308,,,45.5,0 => OK (200)
[18:07:35] INFO: Uploading 100 datapoints, starting with 20170404,11:50,12583476,1092,,,37.5,237.95 => OK (200)
[18:08:31] INFO: Uploading 100 datapoints, starting with 20170405,08:20,9981758,96,,,24.4,0 => OK (200)
[18:08:33] INFO: Uploading 100 datapoints, starting with 20170405,09:30,9025859,96,,,28.7,0 => OK (200)
[18:08:34] INFO: Uploading 100 datapoints, starting with 20170404,20:10,12592113,12,,,33.4,231.7 => OK (200)
[18:09:32] INFO: Uploading 100 datapoints, starting with 20170405,16:40,9987671,900,,,39,0 => OK (200)
[18:09:33] INFO: Uploading 100 datapoints, starting with 20170405,17:50,9031405,288,,,36,0 => OK (200)
[18:09:35] INFO: Uploading 100 datapoints, starting with 20170405,16:10,12599014,744,,,47.3,238.44 => OK (200)
[18:10:31] INFO: Uploading 100 datapoints, starting with 20170406,13:20,9990393,492,,,30.3,0 => OK (200)
[18:10:32] INFO: Uploading 100 datapoints, starting with 20170406,14:50,9033301,528,,,33.5,0 => OK (200)
[18:10:34] INFO: Uploading 100 datapoints, starting with 20170406,12:50,12602725,276,,,31.4,234.11 => OK (200)
[18:11:31] INFO: Uploading 100 datapoints, starting with 20170407,09:25,9993108,252,,,26.4,0 => OK (200)
[18:11:33] INFO: Uploading 86 datapoints, starting with 20170407,11:05,9035634,564,,,31.5,0 => OK (200)
[18:11:34] INFO: Uploading 100 datapoints, starting with 20170407,08:55,12606187,180,,,27.6,233.94 => OK (200)
[18:12:31] INFO: Uploading 6 datapoints, starting with 20170407,17:45,10001775,1176 => OK (200)
[18:12:34] INFO: Uploading 12 datapoints, starting with 20170407,17:15,12616263,1800 => OK (200)

i noticed partial uploads to pvoutput now (on 1 out of 3 inverters, lacking all of april (apart from 7/4 and 26th of march)

thinking of recreating new db atm ... (waiting your reply though)

So all is in the db as I can see (at least I think) but not all is uploaded again (though deleted from pvoutput.org manually)
Apr 10 at 7:44 AM
Looks OK to me... however, to have a better view on it, can you provide the link to your PVO systems?
A copy of the db can help too (via PM)
Apr 10 at 10:58 AM
Edited Apr 10 at 11:48 AM
https://pvoutput.org/list.jsp?id=54165&sid=49259 is the master

with underneath 3 subsystems (each inverter)
https://pvoutput.org/list.jsp?id=54165&sid=49273
https://pvoutput.org/list.jsp?id=54165&sid=49274
https://pvoutput.org/list.jsp?id=54165&sid=49275

copy of db sent (may have ruined it in the mean time, though all is uploading fine atm)
Apr 10 at 2:02 PM
Apr 10 at 2:20 PM
no clue, not sure if that's a perfectly uploaded day though

wouldn't it be better to create a freshly created .db ?
Apr 11 at 7:38 AM
Didn't find any db in my mailbox ;-)
Apr 11 at 8:36 AM
Edited Apr 11 at 8:53 AM
I sent you a pm with my uploaded db in it, I clicked your profile, pushed the contact button and used that form, so i guess it's here on codeplex ?

If not, where to send it to then ?

PS: tried it again ... says it's sent to SBF
Apr 11 at 10:33 AM
don't know, but when you checked my inverters yesterday, did you notice the missing days ? or am I dreaming ? Cause now I do see the missing data, and from the logs I can see it should have been there last week, but I didn't see those dates ????

anyhow, seems solved, though you said something about the strange curves of voltages, i do see that in the sbfspot csv files indeed, there's not always all info that comes along from the inverters it seems, that's something I can fix or ?