first rows in csv Files doesn't match

485solar-get protocol http://sourceforge.net/projects/solarget/
Post Reply
didass
Posts: 5
Joined: Thu Mar 26, 2020 1:20 pm

first rows in csv Files doesn't match

Post by didass » Thu Mar 26, 2020 1:57 pm

Hi together,

i used 123solar since 1 year with 7 SMA Inverters. I'm very glad about this application.
It works fine but i have a problem with the mapping
of the inverter with the *csv Files. At the begining of the day, the entries of *.csv files
doesn't match.

Example today:

As you see, the KWHT column doesn't match to the following row.
Starting from 9:30 the lines are correct and the gui looks fine. I have almost every day
this problem, most only the first 2 or 3 lines doesn't match.
I use actually 123Solar Version 1.8.3.3

Has anybody similar problems and can give help?

Thanks

[root@piBfL2 alarm]# head -10 /srv/http/123solar/data/invt*/csv/20200326.csv
==> /srv/http/123solar/data/invt1/csv/20200326.csv <==
Time,I1V,I1A,I1P,I2V,I2A,I2P,I3V,I3A,I3P,I4V,I4A,I4P,G1V,G1A,G1P,G2V,G2A,G2P,G3V,G3A,G3P,FRQ,EFF,INVT,BOOT,SR,KWHT
07:00:01,341,0.286,97.526005,0,0,0,,,,,,,227.400003,0.332000,75.000000,,,,,,,50.009999,77.411973,0,0,,77029.976659
07:25:15,341,0.472,160.952008,0,0,0,,,,,,,228.500003,0.628000,143.000000,,,,,,,49.999999,89.155774,0,0,,77030.020659
07:50:38,352,1.309,460.768022,0,0,0,,,,,,,221.000003,2.002000,442.000000,,,,,,,49.969999,96.022729,0,0,,94233.689476
08:10:22,410,2.098,860.180041,0,0,0,,,,,,,222.100003,3.744000,831.000000,,,,,,,49.999999,96.670745,0,0,,94233.894476
09:20:36,476,4.159,1979.684094,0,0,0,,,,,,,231.200003,8.346000,1929.000000,,,,,,,49.969999,97.46986,0,0,,77031.662659
09:30:00,480,4.51,2164.800103,0,0,0,,,,,,,230.000003,9.174000,2110.000000,,,,,,,49.999999,97.469514,0,0,,77031.979659
09:35:31,480,4.726,2268.480108,0,0,0,,,,,,,230.400003,9.598000,2211.000000,,,,,,,49.989999,97.482862,0,0,,77032.178659
09:40:28,485,4.919,2385.715113,0,0,0,,,,,,,230.000003,9.986000,2297.000000,,,,,,,49.999999,96.272188,0,0,,77032.364659
09:45:23,481,5.097,2451.657116,0,0,0,,,,,,,230.800003,10.356000,2390.000000,,,,,,,49.989999,97.491812,0,0,,77032.555659

==> /srv/http/123solar/data/invt2/csv/20200326.csv <==
Time,I1V,I1A,I1P,I2V,I2A,I2P,I3V,I3A,I3P,I4V,I4A,I4P,G1V,G1A,G1P,G2V,G2A,G2P,G3V,G3A,G3P,FRQ,EFF,INVT,BOOT,SR,KWHT
06:55:17,332,0.363,120.516006,0,0,0,,,,,,,222.500003,0.460000,102.000000,,,,,,,49.979999,84.926484,0,0,,94233.492476
08:30:19,272,1.844,501.568024,0,0,0,,,,,,,229.000000,2.054000,470.000000,,,,,,,49.979999,93.779109,0,0,,57535.940733
08:55:46,480,4.176,2004.480095,0,0,0,,,,,,,226.600003,8.622000,1953.000000,,,,,,,49.989999,97.468931,0,0,,94995.566512
09:30:03,484,6.068,2936.912139,0,0,0,,,,,,,224.400003,12.626001,2833.000000,,,,,,,49.999999,96.471207,0,0,,96253.344572
09:35:34,479,6.377,3054.583145,0,0,0,,,,,,,224.400003,13.266001,2977.000000,,,,,,,49.989999,97.456525,0,0,,96253.612572
09:40:31,479,6.61,3166.19015,0,0,0,,,,,,,223.600003,13.830001,3092.000000,,,,,,,49.999999,97.669061,0,0,,96253.862572
09:45:26,479,6.874,3292.646156,0,0,0,,,,,,,224.000003,14.322001,3208.000000,,,,,,,49.989999,97.43313,0,0,,96254.120572
09:50:05,480,7.092,3404.160162,0,0,0,,,,,,,222.900003,14.880001,3316.000000,,,,,,,49.999999,97.43232,0,0,,96254.374572
09:55:04,478,7.367,3521.426167,0,0,0,,,,,,,222.100003,15.444001,3430.000000,,,,,,,50.009999,97.406916,0,0,,96254.656572

==> /srv/http/123solar/data/invt3/csv/20200326.csv <==
Time,I1V,I1A,I1P,I2V,I2A,I2P,I3V,I3A,I3P,I4V,I4A,I4P,G1V,G1A,G1P,G2V,G2A,G2P,G3V,G3A,G3P,FRQ,EFF,INVT,BOOT,SR,KWHT
06:50:10,331,0.332,109.892005,0,0,0,,,,,,,228.500003,0.396000,90.000000,,,,,,,49.989999,82.340845,0,0,,91658.266354
07:20:38,344,0.557,191.608009,0,0,0,,,,,,,225.100003,0.776000,174.000000,,,,,,,49.979999,91.164045,0,0,,93961.345463
07:45:33,374,1.109,414.76602,0,0,0,,,,,,,225.400003,1.750000,394.000000,,,,,,,49.959999,95.101818,0,0,,91658.441354
08:05:30,411,1.846,758.706036,0,0,0,,,,,,,228.100003,3.208000,731.000000,,,,,,,49.989999,96.446425,0,0,,91658.624354
08:50:24,480,3.885,1864.800089,0,0,0,,,,,,,227.000003,8.004000,1816.000000,,,,,,,49.989999,97.43179,0,0,,94995.398512
09:15:40,479,5.221,2500.859119,0,0,0,,,,,,,225.100003,10.808001,2433.000000,,,,,,,49.959999,97.281807,0,0,,94996.293512
09:30:07,473,6.037,2855.501136,0,0,0,,,,,,,224.000003,12.430001,2784.000000,,,,,,,50.019999,97.507234,0,0,,93964.005463
09:35:00,473,6.283,2971.859141,0,0,0,,,,,,,224.700003,12.894001,2897.000000,,,,,,,49.999999,97.490555,0,0,,93964.234463
09:40:35,477,6.509,3104.793147,0,0,0,,,,,,,224.700003,13.468001,3026.000000,,,,,,,49.999999,97.470577,0,0,,93964.513463

==> /srv/http/123solar/data/invt4/csv/20200326.csv <==
Time,I1V,I1A,I1P,I2V,I2A,I2P,I3V,I3A,I3P,I4V,I4A,I4P,G1V,G1A,G1P,G2V,G2A,G2P,G3V,G3A,G3P,FRQ,EFF,INVT,BOOT,SR,KWHT
06:45:24,336,0.287,96.432005,0,0,0,,,,,,,224.300003,0.332000,74.000000,,,,,,,49.959999,77.222915,0,0,,93961.274463
07:15:02,365,0.482,175.930008,0,0,0,,,,,,,225.800003,0.696000,157.000000,,,,,,,49.979999,89.329166,0,0,,94994.307512
08:25:46,436,1.994,869.384041,0,0,0,,,,,,,229.300003,3.674000,842.000000,,,,,,,49.989999,96.901739,0,0,,77030.446659
09:10:16,479,4.915,2354.285112,0,0,0,,,,,,,225.100003,10.198000,2295.000000,,,,,,,50.009999,97.50603,0,0,,94996.081512
09:30:09,330,5.488,1811.040086,0,0,0,,,,,,,230.000000,7.524000,1730.000000,,,,,,,50.009999,95.553936,0,0,,57537.089733
09:35:03,328,5.741,1883.048089,0,0,0,,,,,,,230.000000,7.828000,1800.000000,,,,,,,49.999999,95.61307,0,0,,57537.235733
09:40:00,322,6.082,1958.404093,0,0,0,,,,,,,230.000000,8.150000,1874.000000,,,,,,,50.009999,95.715695,0,0,,57537.388733
09:45:33,327,6.285,2055.195098,0,0,0,,,,,,,231.000000,8.510000,1966.000000,,,,,,,49.989999,95.650778,0,0,,57537.564733
09:50:12,327,6.507,2127.789101,0,0,0,,,,,,,233.000000,8.740000,2036.000000,,,,,,,49.989999,95.705918,0,0,,57537.719733

==> /srv/http/123solar/data/invt5/csv/20200326.csv <==
Time,I1V,I1A,I1P,I2V,I2A,I2P,I3V,I3A,I3P,I4V,I4A,I4P,G1V,G1A,G1P,G2V,G2A,G2P,G3V,G3A,G3P,FRQ,EFF,INVT,BOOT,SR,KWHT
06:35:06,459,0,0,0,0,0,,,,,,,228.900003,0.000000,0.000000,,,,,,,49.979999,0,0,0,,93961.266463
07:40:51,361,0.976,352.336017,0,0,0,,,,,,,227.300003,1.466000,333.000000,,,,,,,49.979999,94.575009,0,0,,91658.413354
08:00:36,377,1.248,470.496022,0,0,0,,,,,,,226.600003,1.988000,450.000000,,,,,,,49.979999,95.745938,0,0,,77030.178659
08:20:35,437,2.557,1117.409053,0,0,0,,,,,,,222.500003,4.880000,1085.000000,,,,,,,49.979999,97.171225,0,0,,94234.057476
08:45:42,444,2.724,1209.456057,0,0,0,,,,,,,229.300003,5.124000,1175.000000,,,,,,,49.969999,97.145594,0,0,,77030.780659
09:30:13,479,5.941,2845.739135,0,0,0,,,,,,,224.700003,12.348001,2774.000000,,,,,,,50.009999,97.500004,0,0,,94996.924512
09:35:06,475,6.211,2950.22514,0,0,0,,,,,,,225.500003,12.756001,2876.000000,,,,,,,49.999999,97.500294,0,0,,94997.152512
09:40:03,475,6.482,3078.950146,0,0,0,,,,,,,225.500003,13.286001,2995.000000,,,,,,,50.009999,97.305674,0,0,,94997.395512
09:45:36,479,6.695,3206.905152,0,0,0,,,,,,,224.700003,13.910001,3125.000000,,,,,,,49.989999,97.463974,0,0,,94997.681512

==> /srv/http/123solar/data/invt6/csv/20200326.csv <==
Time,I1V,I1A,I1P,I2V,I2A,I2P,I3V,I3A,I3P,I4V,I4A,I4P,G1V,G1A,G1P,G2V,G2A,G2P,G3V,G3A,G3P,FRQ,EFF,INVT,BOOT,SR,KWHT
06:35:28,463,0,0,0,0,0,,,,,,,227.000003,0.000000,0.000000,,,,,,,49.969999,0,0,0,,94233.469476
07:10:18,347,0.454,157.538007,0,0,0,,,,,,,222.900003,0.626000,139.000000,,,,,,,49.989999,88.572536,0,0,,96250.503572
07:35:38,342,0.631,215.80201,0,0,0,,,,,,,226.300003,0.882000,199.000000,,,,,,,49.959999,92.490618,0,0,,77030.050659
08:40:17,440,2.54,1117.600053,0,0,0,,,,,,,230.800003,4.704000,1085.000000,,,,,,,49.989999,97.144168,0,0,,77030.679659
09:05:34,315,4.4,1386.000066,0,0,0,,,,,,,230.000000,5.748000,1322.000000,,,,,,,49.959999,95.385281,0,0,,57536.461733
09:30:16,475,6.159,2925.525139,0,0,0,,,,,,,224.000003,12.736001,2852.000000,,,,,,,50.009999,97.51631,0,0,,94236.354476
09:35:10,471,6.475,3049.725145,0,0,0,,,,,,,223.200003,13.320001,2973.000000,,,,,,,49.999999,97.484988,0,0,,94236.594476
09:40:07,474,6.687,3169.638151,0,0,0,,,,,,,223.200003,13.842001,3089.000000,,,,,,,50.009999,97.472785,0,0,,94236.844476
09:45:01,475,6.939,3296.025157,0,0,0,,,,,,,222.100003,14.434001,3205.000000,,,,,,,49.999999,97.262352,0,0,,94237.099476

==> /srv/http/123solar/data/invt7/csv/20200326.csv <==
Time,I1V,I1A,I1P,I2V,I2A,I2P,I3V,I3A,I3P,I4V,I4A,I4P,G1V,G1A,G1P,G2V,G2A,G2P,G3V,G3A,G3P,FRQ,EFF,INVT,BOOT,SR,KWHT
06:25:24,415,0,0,0,0,0,,,,,,,228.900003,0.000000,0.000000,,,,,,,49.989999,0,0,0,,93961.266463
07:30:13,327,0.749,244.923012,0,0,0,,,,,,,220.600003,1.042000,229.000000,,,,,,,49.999999,93.852028,0,0,,94233.580476
07:55:54,374,1.099,411.02602,0,0,0,,,,,,,225.500003,1.732000,390.000000,,,,,,,49.989999,95.022214,0,0,,77030.145659
08:15:48,424,1.678,711.472034,0,0,0,,,,,,,228.500003,3.002000,685.000000,,,,,,,49.959999,96.413775,0,0,,77030.320659
08:35:05,475,3.167,1504.325071,0,0,0,,,,,,,222.900003,6.564000,1463.000000,,,,,,,50.009999,97.260607,0,0,,94234.365476
09:00:31,464,4.549,2110.7361,0,0,0,,,,,,,230.000003,8.952000,2058.000000,,,,,,,49.949999,97.547018,0,0,,91659.883354
09:30:20,472,6.004,2833.888135,0,0,0,,,,,,,230.400003,11.992001,2763.000000,,,,,,,49.979999,97.497037,0,0,,91661.082354
09:35:13,472,6.248,2949.05614,0,0,0,,,,,,,230.400003,12.482001,2875.000000,,,,,,,49.999999,97.517743,0,0,,91661.309354
09:40:10,470,6.495,3052.650145,0,0,0,,,,,,,230.400003,12.920001,2976.000000,,,,,,,50.009999,97.514227,0,0,,91661.550354

jeanmarc
Posts: 2022
Joined: Thu Aug 29, 2013 7:16 am

Re: first rows in csv Files doesn't match

Post by jeanmarc » Thu Mar 26, 2020 3:38 pm

Hi,
You mean you have empty strings in csv ? I don't clearly see, could you host the files intact elsewhere ?
From what i see the rows match but you have missing data

didass
Posts: 5
Joined: Thu Mar 26, 2020 1:20 pm

Re: first rows in csv Files doesn't match

Post by didass » Thu Mar 26, 2020 6:39 pm

Hi jeanmarc,

thanks for the fast respond.

This is the csv from inv1. As you see, there's data missing till 9:30 and also the
rows 07:50 and 08:10 can't be values from inv1. The KWHT value doesnt match to the other rows!
Its related with the daemon, i think.
I have an other plant with another raspPi, there ist the same Problem.

Any idea?

[root@piBfL2 alarm]# head -10 /srv/http/123solar/data/invt*/csv/20200326.csv
==> /srv/http/123solar/data/invt1/csv/20200326.csv <==
Time,I1V,I1A,I1P,I2V,I2A,I2P,I3V,I3A,I3P,I4V,I4A,I4P,G1V,G1A,G1P,G2V,G2A,G2P,G3V,G3A,G3P,FRQ,EFF,INVT,BOOT,SR,KWHT
07:00:01,341,0.286,97.526005,0,0,0,,,,,,,227.400003,0.332000,75.000000,,,,,,,50.009999,77.411973,0,0,,77029.976659
07:25:15,341,0.472,160.952008,0,0,0,,,,,,,228.500003,0.628000,143.000000,,,,,,,49.999999,89.155774,0,0,,77030.020659
07:50:38,352,1.309,460.768022,0,0,0,,,,,,,221.000003,2.002000,442.000000,,,,,,,49.969999,96.022729,0,0,,94233.689476
08:10:22,410,2.098,860.180041,0,0,0,,,,,,,222.100003,3.744000,831.000000,,,,,,,49.999999,96.670745,0,0,,94233.894476
09:20:36,476,4.159,1979.684094,0,0,0,,,,,,,231.200003,8.346000,1929.000000,,,,,,,49.969999,97.46986,0,0,,77031.662659
09:30:00,480,4.51,2164.800103,0,0,0,,,,,,,230.000003,9.174000,2110.000000,,,,,,,49.999999,97.469514,0,0,,77031.979659
09:35:31,480,4.726,2268.480108,0,0,0,,,,,,,230.400003,9.598000,2211.000000,,,,,,,49.989999,97.482862,0,0,,77032.178659
09:40:28,485,4.919,2385.715113,0,0,0,,,,,,,230.000003,9.986000,2297.000000,,,,,,,49.999999,96.272188,0,0,,77032.364659

jeanmarc
Posts: 2022
Joined: Thu Aug 29, 2013 7:16 am

Re: first rows in csv Files doesn't match

Post by jeanmarc » Thu Mar 26, 2020 6:49 pm

hmm i see 2 problems :problem:
The first is you have connection issue, the second data seem to mess up.

Could you try to wake up early for few test ? Turn off 123s and request each inverter with 485solar-get to check if the data return is ok.
You can also test the connection when you have "Missing 5' sample".

didass
Posts: 5
Joined: Thu Mar 26, 2020 1:20 pm

Re: first rows in csv Files doesn't match

Post by didass » Thu Mar 26, 2020 7:42 pm

I will try tomorow...

didass
Posts: 5
Joined: Thu Mar 26, 2020 1:20 pm

Re: first rows in csv Files doesn't match

Post by didass » Fri Mar 27, 2020 8:43 am

Hallo,

i tested this commands. Always the same inverter but the value for KWTH differ.

[root@piBfL2 alarm]# 485solar-get -d -n2
20200327-07:08:18 327.000000 0.577000 188.679009 0.000000 0.000000 0.000000 225.500003 0.766000 172.000000 49.999999 91.548610 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 95031.799514 0.000000 OK
[root@piBfL2 alarm]# 485solar-get -d -n2
20200327-07:08:50 333.000000 0.428000 142.524007 0.000000 0.000000 0.000000 229.300003 0.546000 125.000000 49.999999 87.843312 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 77058.142660 0.000000 OK
[root@piBfL2 alarm]# 485solar-get -d -n2
20200327-07:09:14 366.000000 0.556000 203.496010 0.000000 0.000000 0.000000 222.900003 0.834000 185.000000 50.009999 91.352460 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 96289.416574 0.000000 OK
[root@piBfL2 alarm]# 485solar-get -d -n2
20200327-07:09:31 365.000000 0.560000 204.400010 0.000000 0.000000 0.000000 223.600003 0.834000 186.000000 50.009999 91.234052 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 96289.417574 0.000000 OK
[root@piBfL2 alarm]# 485solar-get -d -n2
20200327-07:09:52 338.000000 0.431000 145.678007 0.000000 0.000000 0.000000 228.500003 0.564000 128.000000 50.019999 88.464972 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 77058.144660 0.000000 OK
[root@piBfL2 alarm]# 485solar-get -d -n2
20200327-07:10:13 367.000000 0.559000 205.153010 0.000000 0.000000 0.000000 223.200003 0.838000 187.000000 50.019999 91.171761 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 96289.419574 0.000000 OK
[root@piBfL2 alarm]# 485solar-get -d -n2
20200327-07:10:41 342.000000 0.604000 206.568010 0.000000 0.000000 0.000000 228.100003 0.834000 190.000000 49.989999 92.093356 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 91694.738355 0.000000 OK

I tested also this:

[root@piBfL2 485solar-get_1.000]# 485solar-get -i -n2
338 WR8KTL05 SN:2000178569
Software-BFR 2.870000
SMA-SN 2000178569.000000
Default 8.000000 trimmed
Status Mpp
Betriebsart Mpp-Betrieb
485solar-get v1.000 daemon: Down

[root@piBfL2 485solar-get_1.000]# 485solar-get -i -n2
338 WR8KTL05 SN:2000179013
Software-BFR 2.870000
SMA-SN 2000179013.000000
Default 8.000000 trimmed
Status Mpp
Betriebsart Mpp-Betrieb
485solar-get v1.000 daemon: Down
[root@piBfL2 485solar-get_1.000]#

I expected the same SN but that are obviously different inverters.

jeanmarc
Posts: 2022
Joined: Thu Aug 29, 2013 7:16 am

Re: first rows in csv Files doesn't match

Post by jeanmarc » Fri Mar 27, 2020 11:33 am

Thanks for the test :o So you better get in touch with Roland from 485solar-get

didass
Posts: 5
Joined: Thu Mar 26, 2020 1:20 pm

Re: first rows in csv Files doesn't match

Post by didass » Fri Mar 27, 2020 7:58 pm

I agree, Thank you for your support

Post Reply

Who is online

Users browsing this forum: No registered users and 3 guests