Change columns in CSV spot file? #652

GeStenZ · 2023-06-17T17:03:35Z

GeStenZ
Jun 17, 2023

Because this morning my old smaspot2210 version suddenly stopped to reach the SMA inverter by speedwire, I had to change to the most recent version, where I could specify the IP address. This version finds the inverter and reads the data.

I noticed that in the spot file there are some differences in the columns:

Old:

dd/MM/yyyy HH:mm:SS;Watt;Watt;Amp;Amp;Volt;Volt;Watt;Watt;Watt;Amp;Amp;Amp;Volt;Volt;Volt;Watt;Watt;%;kWh;kWh;Hz;Hours;Hours;%;;
16/06/2023 08:32:36;725,000;628,000;1,841;1,908;394,460;329,770;457,000;457,000;461,000;1,947;1,943;1,958;234,940;235,340;235,510;1353,000;1375,000;101,626;0,954;69177,622;50,010;42403,041;41194,704;0,000;OK;Closed

New:

dd/MM/yyyy HH:mm:ss;DeviceName;DeviceType;Serial;Pdc1;Pdc2;Idc1;Idc2;Udc1;Udc2;Pac1;Pac2;Pac3;Iac1;Iac2;Iac3;Uac1;Uac2;Uac3;PdcTot;PacTot;Efficiency;EToday;ETotal;Frequency;OperatingTime;FeedInTime;BT_Signal;Condition;GridRelay;Temperature
17/06/2023 16:48:27;SN: 304635765;STP 5000TL-20;304635765;1437,000;1470,000;4,086;4,171;352,210;352,910;962,000;960,000;957,000;4,050;4,036;4,026;239,930;240,210;240,130;2907,000;2877,000;99,037;29,961;69237,504;49,970;42426,970;41218,493;N/A;Ok;Closed;69,880

The additional leading columns after the time stamp with device name, type and serial prevents the correct reading by my monitoring software (SolarAnalyzer). Is there a possibility to tweak the CSV content?

Answered by GeStenZ

Jun 19, 2023

Finally, good news: With the ExtendedHeader setting and enabling WebboxHeader, the csv is compatible with my old version.

View full answer

silliewimons · 2023-06-17T19:36:15Z

silliewimons
Jun 17, 2023

dear GeStenZ, the spot format that you refer to as "old SMAspot2210" dates back to version 2.2.y, which was released before <<2014,
since <<2.4.y all SBFspot-files do include, after DateTime, the 3additional columns for device-name | Type | Ser#

there is no option to configure the csv-contents === format 2.2.10 (or . . )

kr sillie

4 replies

GeStenZ Jun 17, 2023
Author

Hi Sillie

I just looked into the source file CSVexport.cpp and found, that the config-option "WebboxHeader=1" removes these additional columns. Will see tomorrow, when sun is back, if it provides a compatible file.

silliewimons Jun 17, 2023

dear GeStenZ - i will catch your message after your evaluation, after adapting the config
?? in your information you included no details about conditions, . . . that your system was not longer able to communic with inverter
no fault-code, eg from log-file . . . .
?? just to make certain about status - please identify the sw-version that you do refer to as SMAspot2210

if the result does not match your expectatons  -  please include the "old"  and  "new"  configuration that you apply

kr sillie

GeStenZ Jun 17, 2023
Author

Hi Sillie, I was running this version since 2013 without any problems. For unknown reasons, the STP5000TL20 just stopped from one minute to the other to respond over speedwire. It came up normally in the morning from sleep until it suddenly stopped responding.

Here is the log of a failed connection process:

SMAspot V2.2.10
Yet another tool to read power production of SMA solar inverters
(c) 2012-2013, SBF (http://code.google.com/p/sma-spot)
Compiled for Linux 32 bit

Commandline Args: -cfg/home/pi/pv-logger/SMAspot-min.cfg -nocsv -finq -v -d2
Sat Jun 17 12:52:39 2023: INFO: Starting...
Connecting to Local Network...
Initializing...
SUSyID: 125 - SN: 862016389 (0x33615385)
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 53 4D 41 00 00 04 02 A0 FF FF
00000010: FF FF 00 00 00 20 00 00 00 00
20 Bytes sent to IP [239.12.255.254]
--------: 00 01 02 03 04 05 06 07 08 09
Inverter IP address: 0.0.0.0
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 53 4D 41 00 00 04 02 A0 00 00
00000010: 00 01 00 26 00 10 60 65 09 A0
00000020: FF FF FF FF FF FF 00 00 7D 00
00000030: 85 53 61 33 00 00 00 00 00 00
00000040: 01 80 00 02 00 00 00 00 00 00
00000050: 00 00 00 00 00 00 00 00
58 Bytes sent to IP [0.0.0.0]
ethGetPacket()
MAX_CommBuf is now 58 bytes
Received 58 bytes from IP [127.0.0.1]
logoffSMAInverter()
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 53 4D 41 00 00 04 02 A0 00 00
00000010: 00 01 00 22 00 10 60 65 08 A0
00000020: FF FF FF FF FF FF 00 03 7D 00
00000030: 85 53 61 33 00 03 00 00 00 00
00000040: 02 80 0E 01 FD FF FF FF FF FF
00000050: 00 00 00 00
54 Bytes sent to IP [0.0.0.0]
logonSMAInverter()
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 53 4D 41 00 00 04 02 A0 00 00
00000010: 00 01 00 3A 00 10 60 65 0E A0
00000020: FF FF FF FF FF FF 00 01 7D 00
00000030: 85 53 61 33 00 01 00 00 00 00
00000040: 03 80 0C 04 FD FF 07 00 00 00
00000050: 84 03 00 00 7C 90 8D 64 00 00
00000060: 00 00 BE BB BA F2 F0 C1 C0 BA
00000070: E0 88 88 88 00 00 00 00
78 Bytes sent to IP [0.0.0.0]
ethGetPacket()
Received 54 bytes from IP [127.0.0.1]
ethGetPacket()
MAX_CommBuf is now 78 bytes
Received 78 bytes from IP [127.0.0.1]
Logon OK
SetInverterTime() not executed! We're still testing...
getInverterData(2048)
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 53 4D 41 00 00 04 02 A0 00 00
00000010: 00 01 00 26 00 10 60 65 09 A0
00000020: FF FF FF FF FF FF 00 00 7D 00
00000030: 85 53 61 33 00 00 00 00 00 00
00000040: 04 80 00 02 00 58 00 34 82 00
00000050: FF 34 82 00 00 00 00 00
58 Bytes sent to IP [0.0.0.0]
ethGetPacket()
Received 58 bytes from IP [127.0.0.1]
getInverterData(512)
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 53 4D 41 00 00 04 02 A0 00 00
00000010: 00 01 00 26 00 10 60 65 09 A0
00000020: FF FF FF FF FF FF 00 00 7D 00
00000030: 85 53 61 33 00 00 00 00 00 00
00000040: 05 80 00 02 00 58 00 1E 82 00
00000050: FF 20 82 00 00 00 00 00
58 Bytes sent to IP [0.0.0.0]
ethGetPacket()
Received 58 bytes from IP [127.0.0.1]
SUSyID: 125 - SN: 862016389
Device Name:
Device Class:
Device Type:
Software Version:
Serial number:    862016389
getInverterData(16384)
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 53 4D 41 00 00 04 02 A0 00 00
00000010: 00 01 00 26 00 10 60 65 09 A0
00000020: FF FF FF FF FF FF 00 00 7D 00
00000030: 85 53 61 33 00 00 00 00 00 00
00000040: 06 80 00 02 00 51 00 5A 29 00
00000050: FF 5A 29 00 00 00 00 00
58 Bytes sent to IP [0.0.0.0]
ethGetPacket()
Received 58 bytes from IP [127.0.0.1]
getInverterData(32768)
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 53 4D 41 00 00 04 02 A0 00 00
00000010: 00 01 00 26 00 10 60 65 09 A0
00000020: FF FF FF FF FF FF 00 00 7D 00
00000030: 85 53 61 33 00 00 00 00 00 00
00000040: 07 80 00 02 00 51 00 1E 49 00
00000050: FF 5D 49 00 00 00 00 00
58 Bytes sent to IP [0.0.0.0]
ethGetPacket()
Received 58 bytes from IP [127.0.0.1]
getInverterData(4096)
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 53 4D 41 00 00 04 02 A0 00 00
00000010: 00 01 00 26 00 10 60 65 09 A0
00000020: FF FF FF FF FF FF 00 00 7D 00
00000030: 85 53 61 33 00 00 00 00 00 00
00000040: 08 80 00 02 80 51 00 48 21 00
00000050: FF 48 21 00 00 00 00 00
58 Bytes sent to IP [0.0.0.0]
ethGetPacket()
Received 58 bytes from IP [127.0.0.1]
SUSyID: 125 - SN: 862016389
Device Status:      ?
getInverterData(64)
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 53 4D 41 00 00 04 02 A0 00 00
00000010: 00 01 00 26 00 10 60 65 09 A0
00000020: FF FF FF FF FF FF 00 00 7D 00
00000030: 85 53 61 33 00 00 00 00 00 00
00000040: 09 80 00 02 00 51 00 1E 41 00
00000050: FF 20 41 00 00 00 00 00
58 Bytes sent to IP [0.0.0.0]
ethGetPacket()
Received 58 bytes from IP [127.0.0.1]
getInverterData(128)
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 53 4D 41 00 00 04 02 A0 00 00
00000010: 00 01 00 26 00 10 60 65 09 A0
00000020: FF FF FF FF FF FF 00 00 7D 00
00000030: 85 53 61 33 00 00 00 00 00 00
00000040: 0A 80 00 02 00 51 00 2A 83 00
00000050: FF 2A 83 00 00 00 00 00
58 Bytes sent to IP [0.0.0.0]
ethGetPacket()
Received 58 bytes from IP [127.0.0.1]
SUSyID: 125 - SN: 862016389
Pac max phase 1: 0W
Pac max phase 2: 0W
Pac max phase 3: 0W
getInverterData(1)
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 53 4D 41 00 00 04 02 A0 00 00
00000010: 00 01 00 26 00 10 60 65 09 A0
00000020: FF FF FF FF FF FF 00 00 7D 00
00000030: 85 53 61 33 00 00 00 00 00 00
00000040: 0B 80 00 02 00 54 00 01 26 00
00000050: FF 22 26 00 00 00 00 00
58 Bytes sent to IP [0.0.0.0]
ethGetPacket()
Received 58 bytes from IP [127.0.0.1]
getInverterData(1024)
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 53 4D 41 00 00 04 02 A0 00 00
00000010: 00 01 00 26 00 10 60 65 09 A0
00000020: FF FF FF FF FF FF 00 00 7D 00
00000030: 85 53 61 33 00 00 00 00 00 00
00000040: 0C 80 00 02 00 54 00 2E 46 00
00000050: FF 2F 46 00 00 00 00 00
58 Bytes sent to IP [0.0.0.0]
ethGetPacket()
Received 58 bytes from IP [127.0.0.1]
SUSyID: 125 - SN: 862016389
Energy Production:
        EToday: 0.000kWh
        ETotal: 0.000kWh
        Operation Time: 0.00h
        Feed-In Time  : 0.00h
getInverterData(2)
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 53 4D 41 00 00 04 02 A0 00 00
00000010: 00 01 00 26 00 10 60 65 09 A0
00000020: FF FF FF FF FF FF 00 00 7D 00
00000030: 85 53 61 33 00 00 00 00 00 00
00000040: 0D 80 00 02 80 53 00 1E 25 00
00000050: FF 1E 25 00 00 00 00 00
58 Bytes sent to IP [0.0.0.0]
ethGetPacket()
Received 58 bytes from IP [127.0.0.1]
getInverterData(4)
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 53 4D 41 00 00 04 02 A0 00 00
00000010: 00 01 00 26 00 10 60 65 09 A0
00000020: FF FF FF FF FF FF 00 00 7D 00
00000030: 85 53 61 33 00 00 00 00 00 00
00000040: 0E 80 00 02 80 53 00 1F 45 00
00000050: FF 21 45 00 00 00 00 00
58 Bytes sent to IP [0.0.0.0]
ethGetPacket()
Received 58 bytes from IP [127.0.0.1]
SUSyID: 125 - SN: 862016389
DC Spot Data:
        String 1 Pdc:   0.000kW - Udc:   0.00V - Idc:  0.000A
        String 2 Pdc:   0.000kW - Udc:   0.00V - Idc:  0.000A
getInverterData(8)
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 53 4D 41 00 00 04 02 A0 00 00
00000010: 00 01 00 26 00 10 60 65 09 A0
00000020: FF FF FF FF FF FF 00 00 7D 00
00000030: 85 53 61 33 00 00 00 00 00 00
00000040: 0F 80 00 02 00 51 00 40 46 00
00000050: FF 42 46 00 00 00 00 00
58 Bytes sent to IP [0.0.0.0]
ethGetPacket()
Received 58 bytes from IP [127.0.0.1]
getInverterData(16)
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 53 4D 41 00 00 04 02 A0 00 00
00000010: 00 01 00 26 00 10 60 65 09 A0
00000020: FF FF FF FF FF FF 00 00 7D 00
00000030: 85 53 61 33 00 00 00 00 00 00
00000040: 10 80 00 02 00 51 00 48 46 00
00000050: FF 52 46 00 00 00 00 00
58 Bytes sent to IP [0.0.0.0]
ethGetPacket()
Received 58 bytes from IP [127.0.0.1]
getInverterData(256)
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 53 4D 41 00 00 04 02 A0 00 00
00000010: 00 01 00 26 00 10 60 65 09 A0
00000020: FF FF FF FF FF FF 00 00 7D 00
00000030: 85 53 61 33 00 00 00 00 00 00
00000040: 11 80 00 02 00 51 00 3F 26 00
00000050: FF 3F 26 00 00 00 00 00
58 Bytes sent to IP [0.0.0.0]
ethGetPacket()
Received 58 bytes from IP [127.0.0.1]
SUSyID: 125 - SN: 862016389
AC Spot Data:
        Phase 1 Pac :   0.000kW - Uac:   0.00V - Iac:  0.000A
        Phase 2 Pac :   0.000kW - Uac:   0.00V - Iac:  0.000A
        Phase 3 Pac :   0.000kW - Uac:   0.00V - Iac:  0.000A
        Total Pac   :   0.000kW
getInverterData(32)
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 53 4D 41 00 00 04 02 A0 00 00
00000010: 00 01 00 26 00 10 60 65 09 A0
00000020: FF FF FF FF FF FF 00 00 7D 00
00000030: 85 53 61 33 00 00 00 00 00 00
00000040: 12 80 00 02 00 51 00 57 46 00
00000050: FF 57 46 00 00 00 00 00
58 Bytes sent to IP [0.0.0.0]
ethGetPacket()
Received 58 bytes from IP [127.0.0.1]
SUSyID: 125 - SN: 862016389
Grid Freq. : 0.00Hz
SUSyID: 125 - SN: 862016389
********************
* ArchiveDayData() *
********************
startTime = 648CDB60 -> 17/06/2023 00:00:00
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 53 4D 41 00 00 04 02 A0 00 00
00000010: 00 01 00 26 00 10 60 65 09 E0
00000020: 7D 00 85 53 61 33 00 00 7D 00
00000030: 85 53 61 33 00 00 00 00 00 00
00000040: 13 80 00 02 00 70 34 DA 8C 64
00000050: B4 2B 8E 64 00 00 00 00
58 Bytes sent to IP [0.0.0.0]
ethGetPacket()
Received 58 bytes from IP [127.0.0.1]
**********************
* ArchiveMonthData() *
**********************
startTime = 64787A30 -> 01/06/2023 13:00:00
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 53 4D 41 00 00 04 02 A0 00 00
00000010: 00 01 00 26 00 10 60 65 09 E0
00000020: 7D 00 85 53 61 33 00 00 7D 00
00000030: 85 53 61 33 00 00 00 00 00 00
00000040: 14 80 00 02 20 70 30 D7 75 64
00000050: 30 AA A2 64 00 00 00 00
58 Bytes sent to IP [0.0.0.0]
ethGetPacket()
Received 58 bytes from IP [127.0.0.1]
logoffSMAInverter()
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 53 4D 41 00 00 04 02 A0 00 00
00000010: 00 01 00 22 00 10 60 65 08 A0
00000020: FF FF FF FF FF FF 00 03 7D 00
00000030: 85 53 61 33 00 03 00 00 00 00
00000040: 15 80 0E 01 FD FF FF FF FF FF
00000050: 00 00 00 00
54 Bytes sent to IP [0.0.0.0]
Sat Jun 17 12:52:44 2023: INFO: Done.

And here is a successful one from 10 years ago:

SMAspot V2.2.10
Yet another tool to read power production of SMA solar inverters
(c) 2012-2013, SBF (http://code.google.com/p/sma-spot)
Compiled for Linux 32 bit

Commandline Args: -cfg/home/pi/pv-logger/SMAspot-min.cfg -nocsv -finq -v -d2
Wed Dec  4 19:50:54 2013: INFO: Starting...
Connecting to Local Network...
Initializing...
SUSyID: 125 - SN: 869333578 (0x33D0FA4A)
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 53 4D 41 00 00 04 02 A0 FF FF 
00000010: FF FF 00 00 00 20 00 00 00 00 
20 Bytes sent to IP [239.12.255.254]
MAX_CommBuf is now 54 bytes
Received 54 bytes from IP [192.168.1.22]
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 53 4D 41 00 00 04 02 A0 00 00 
00000010: 00 01 00 02 00 00 00 01 00 04 
00000020: 00 10 00 01 00 01 00 04 00 20 
00000030: 00 00 00 01 00 04 00 30 C0 A8 
00000040: 01 16 00 04 00 40 00 00 00 01 
00000050: 00 00 00 00 
Inverter IP address: 192.168.1.22
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 53 4D 41 00 00 04 02 A0 00 00 
00000010: 00 01 00 26 00 10 60 65 09 A0 
00000020: FF FF FF FF FF FF 00 00 7D 00 
00000030: 4A FA D0 33 00 00 00 00 00 00 
00000040: 01 80 00 02 00 00 00 00 00 00 
00000050: 00 00 00 00 00 00 00 00 
58 Bytes sent to IP [192.168.1.22]
ethGetPacket()
MAX_CommBuf is now 98 bytes
Received 98 bytes from IP [192.168.1.22]
logoffSMAInverter()
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 53 4D 41 00 00 04 02 A0 00 00 
00000010: 00 01 00 22 00 10 60 65 08 A0 
00000020: FF FF FF FF FF FF 00 03 7D 00 
00000030: 4A FA D0 33 00 03 00 00 00 00 
00000040: 02 80 0E 01 FD FF FF FF FF FF 
00000050: 00 00 00 00 
54 Bytes sent to IP [192.168.1.22]
logonSMAInverter()
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 53 4D 41 00 00 04 02 A0 00 00 
00000010: 00 01 00 3A 00 10 60 65 0E A0 
00000020: FF FF FF FF FF FF 00 01 7D 00 
00000030: 4A FA D0 33 00 01 00 00 00 00 
00000040: 03 80 0C 04 FD FF 07 00 00 00 
00000050: 84 03 00 00 8E 79 9F 52 00 00 
00000060: 00 00 B8 B8 B8 B8 88 88 88 88 
00000070: 88 88 88 88 00 00 00 00 
78 Bytes sent to IP [192.168.1.22]
ethGetPacket()
Received 78 bytes from IP [192.168.1.22]
Logon OK
SetInverterTime() not executed! We're still testing...
getInverterData(2048)
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 53 4D 41 00 00 04 02 A0 00 00 
00000010: 00 01 00 26 00 10 60 65 09 A0 
00000020: FF FF FF FF FF FF 00 00 7D 00 
00000030: 4A FA D0 33 00 00 00 00 00 00 
00000040: 04 80 00 02 00 58 00 34 82 00 
00000050: FF 34 82 00 00 00 00 00 
58 Bytes sent to IP [192.168.1.22]
ethGetPacket()
Received 98 bytes from IP [192.168.1.22]
INV_SWVER   : '02.50.06.R' Wed Dec  4 12:46:09 2013
getInverterData(512)
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 53 4D 41 00 00 04 02 A0 00 00 
00000010: 00 01 00 26 00 10 60 65 09 A0 
00000020: FF FF FF FF FF FF 00 00 7D 00 
00000030: 4A FA D0 33 00 00 00 00 00 00 
00000040: 05 80 00 02 00 58 00 1E 82 00 
00000050: FF 20 82 00 00 00 00 00 
58 Bytes sent to IP [192.168.1.22]
ethGetPacket()
MAX_CommBuf is now 218 bytes
Received 218 bytes from IP [192.168.1.22]
INV_NAME    : 'SN: 304635765' Wed Dec  4 08:03:13 2013
INV_CLASS   : 'Solar Inverter' Wed Dec  4 08:03:13 2013
INV_TYPE    : 'STP 5000TL-20' Wed Dec  4 08:03:13 2013
INV_TYPE    : 'STP 5000TL-20' Wed Dec  4 08:03:13 2013
SUSyID: 181 - SN: 304635765
Device Name:      SN: 304635765
Device Class:     Solar Inverter
Device Type:      STP 5000TL-20
Software Version: 02.50.06.R
Serial number:    304635765
getInverterData(16384)
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 53 4D 41 00 00 04 02 A0 00 00 
00000010: 00 01 00 26 00 10 60 65 09 A0 
00000020: FF FF FF FF FF FF 00 00 7D 00 
00000030: 4A FA D0 33 00 00 00 00 00 00 
00000040: 06 80 00 02 00 51 00 5A 29 00 
00000050: FF 5A 29 00 00 00 00 00 
58 Bytes sent to IP [192.168.1.22]
ethGetPacket()
Received 58 bytes from IP [192.168.1.22]
getInverterData(32768)
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 53 4D 41 00 00 04 02 A0 00 00 
00000010: 00 01 00 26 00 10 60 65 09 A0 
00000020: FF FF FF FF FF FF 00 00 7D 00 
00000030: 4A FA D0 33 00 00 00 00 00 00 
00000040: 07 80 00 02 00 51 00 1E 49 00 
00000050: FF 5D 49 00 00 00 00 00 
58 Bytes sent to IP [192.168.1.22]
ethGetPacket()
Received 58 bytes from IP [192.168.1.22]
getInverterData(4096)
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 53 4D 41 00 00 04 02 A0 00 00 
00000010: 00 01 00 26 00 10 60 65 09 A0 
00000020: FF FF FF FF FF FF 00 00 7D 00 
00000030: 4A FA D0 33 00 00 00 00 00 00 
00000040: 08 80 00 02 80 51 00 48 21 00 
00000050: FF 48 21 00 00 00 00 00 
58 Bytes sent to IP [192.168.1.22]
ethGetPacket()
Received 98 bytes from IP [192.168.1.22]
INV_STATUS  : 'OK' Wed Dec  4 19:50:33 2013
SUSyID: 181 - SN: 304635765
Device Status:      OK
getInverterData(8192)
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 53 4D 41 00 00 04 02 A0 00 00 
00000010: 00 01 00 26 00 10 60 65 09 A0 
00000020: FF FF FF FF FF FF 00 00 7D 00 
00000030: 4A FA D0 33 00 00 00 00 00 00 
00000040: 09 80 00 02 80 51 00 64 41 00 
00000050: FF 64 41 00 00 00 00 00 
58 Bytes sent to IP [192.168.1.22]
ethGetPacket()
Received 98 bytes from IP [192.168.1.22]
INV_GRIDRELAY: '?' Wed Dec  4 16:56:58 2013
SUSyID: 181 - SN: 304635765
GridRelay Status:      ?
getInverterData(64)
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 53 4D 41 00 00 04 02 A0 00 00 
00000010: 00 01 00 26 00 10 60 65 09 A0 
00000020: FF FF FF FF FF FF 00 00 7D 00 
00000030: 4A FA D0 33 00 00 00 00 00 00 
00000040: 0A 80 00 02 00 51 00 1E 41 00 
00000050: FF 20 41 00 00 00 00 00 
58 Bytes sent to IP [192.168.1.22]
ethGetPacket()
Received 142 bytes from IP [192.168.1.22]
INV_PACMAX1 : 5000 (W) Wed Dec  4 19:50:33 2013
INV_PACMAX2 : 5000 (W) Wed Dec  4 19:50:33 2013
INV_PACMAX3 : 5000 (W) Wed Dec  4 19:50:33 2013
SUSyID: 181 - SN: 304635765
Pac max phase 1: 5000W
Pac max phase 2: 5000W
Pac max phase 3: 5000W
getInverterData(1)
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 53 4D 41 00 00 04 02 A0 00 00 
00000010: 00 01 00 26 00 10 60 65 09 A0 
00000020: FF FF FF FF FF FF 00 00 7D 00 
00000030: 4A FA D0 33 00 00 00 00 00 00 
00000040: 0B 80 00 02 00 54 00 01 26 00 
00000050: FF 22 26 00 00 00 00 00 
58 Bytes sent to IP [192.168.1.22]
ethGetPacket()
Received 90 bytes from IP [192.168.1.22]
SPOT_ETOTAL : 3579.720 (kWh) Wed Dec  4 16:56:53 2013
SPOT_ETODAY : 11.909 (kWh) Wed Dec  4 19:50:33 2013
getInverterData(1024)
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 53 4D 41 00 00 04 02 A0 00 00 
00000010: 00 01 00 26 00 10 60 65 09 A0 
00000020: FF FF FF FF FF FF 00 00 7D 00 
00000030: 4A FA D0 33 00 00 00 00 00 00 
00000040: 0C 80 00 02 00 54 00 2E 46 00 
00000050: FF 2F 46 00 00 00 00 00 
58 Bytes sent to IP [192.168.1.22]
ethGetPacket()
Received 90 bytes from IP [192.168.1.22]
SPOT_OPERTM : 2223.144 (h) Wed Dec  4 16:56:53 2013
SPOT_FEEDTM : 2037.144 (h) Wed Dec  4 16:56:53 2013
SUSyID: 181 - SN: 304635765
Energy Production:
	EToday: 11.909kWh
	ETotal: 3579.720kWh
	Operation Time: 2223.14h
	Feed-In Time  : 2037.14h
getInverterData(2)
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 53 4D 41 00 00 04 02 A0 00 00 
00000010: 00 01 00 26 00 10 60 65 09 A0 
00000020: FF FF FF FF FF FF 00 00 7D 00 
00000030: 4A FA D0 33 00 00 00 00 00 00 
00000040: 0D 80 00 02 80 53 00 1E 25 00 
00000050: FF 1E 25 00 00 00 00 00 
58 Bytes sent to IP [192.168.1.22]
ethGetPacket()
Received 114 bytes from IP [192.168.1.22]
SPOT_PDC1   : 0 (W) Wed Dec  4 16:56:58 2013
SPOT_PDC2   : 0 (W) Wed Dec  4 16:56:58 2013
getInverterData(4)
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 53 4D 41 00 00 04 02 A0 00 00 
00000010: 00 01 00 26 00 10 60 65 09 A0 
00000020: FF FF FF FF FF FF 00 00 7D 00 
00000030: 4A FA D0 33 00 00 00 00 00 00 
00000040: 0E 80 00 02 80 53 00 1F 45 00 
00000050: FF 21 45 00 00 00 00 00 
58 Bytes sent to IP [192.168.1.22]
ethGetPacket()
Received 170 bytes from IP [192.168.1.22]
SPOT_UDC1   : 0.00 (V) Wed Dec  4 16:56:58 2013
SPOT_UDC2   : 0.00 (V) Wed Dec  4 16:56:58 2013
SPOT_IDC1   : 0.000 (A) Wed Dec  4 16:56:58 2013
SPOT_IDC2   : 0.000 (A) Wed Dec  4 16:56:58 2013
SUSyID: 181 - SN: 304635765
DC Spot Data:
	String 1 Pdc:   0.000kW - Udc:   0.00V - Idc:  0.000A
	String 2 Pdc:   0.000kW - Udc:   0.00V - Idc:  0.000A
getInverterData(8)
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 53 4D 41 00 00 04 02 A0 00 00 
00000010: 00 01 00 26 00 10 60 65 09 A0 
00000020: FF FF FF FF FF FF 00 00 7D 00 
00000030: 4A FA D0 33 00 00 00 00 00 00 
00000040: 0F 80 00 02 00 51 00 40 46 00 
00000050: FF 42 46 00 00 00 00 00 
58 Bytes sent to IP [192.168.1.22]
ethGetPacket()
Received 142 bytes from IP [192.168.1.22]
SPOT_PAC1   : 0 (W) Wed Dec  4 16:56:58 2013
SPOT_PAC2   : 0 (W) Wed Dec  4 16:56:58 2013
SPOT_PAC3   : 0 (W) Wed Dec  4 16:56:58 2013
getInverterData(16)
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 53 4D 41 00 00 04 02 A0 00 00 
00000010: 00 01 00 26 00 10 60 65 09 A0 
00000020: FF FF FF FF FF FF 00 00 7D 00 
00000030: 4A FA D0 33 00 00 00 00 00 00 
00000040: 10 80 00 02 00 51 00 48 46 00 
00000050: FF 52 46 00 00 00 00 00 
58 Bytes sent to IP [192.168.1.22]
ethGetPacket()
MAX_CommBuf is now 226 bytes
Received 226 bytes from IP [192.168.1.22]
SPOT_UAC1   : 0.00 (V) Wed Dec  4 16:56:58 2013
SPOT_UAC2   : 0.00 (V) Wed Dec  4 16:56:58 2013
SPOT_UAC3   : 0.00 (V) Wed Dec  4 16:56:58 2013
SPOT_IAC1   : 0.000 (A) Wed Dec  4 16:56:58 2013
SPOT_IAC2   : 0.000 (A) Wed Dec  4 16:56:58 2013
SPOT_IAC3   : 0.000 (A) Wed Dec  4 16:56:58 2013
getInverterData(256)
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 53 4D 41 00 00 04 02 A0 00 00 
00000010: 00 01 00 26 00 10 60 65 09 A0 
00000020: FF FF FF FF FF FF 00 00 7D 00 
00000030: 4A FA D0 33 00 00 00 00 00 00 
00000040: 11 80 00 02 00 51 00 3F 26 00 
00000050: FF 3F 26 00 00 00 00 00 
58 Bytes sent to IP [192.168.1.22]
ethGetPacket()
Received 86 bytes from IP [192.168.1.22]
SPOT_PACTOT : 0 (W) Wed Dec  4 16:56:58 2013
SUSyID: 181 - SN: 304635765
AC Spot Data:
	Phase 1 Pac :   0.000kW - Uac:   0.00V - Iac:  0.000A
	Phase 2 Pac :   0.000kW - Uac:   0.00V - Iac:  0.000A
	Phase 3 Pac :   0.000kW - Uac:   0.00V - Iac:  0.000A
	Total Pac   :   0.000kW
getInverterData(32)
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 53 4D 41 00 00 04 02 A0 00 00 
00000010: 00 01 00 26 00 10 60 65 09 A0 
00000020: FF FF FF FF FF FF 00 00 7D 00 
00000030: 4A FA D0 33 00 00 00 00 00 00 
00000040: 12 80 00 02 00 51 00 57 46 00 
00000050: FF 57 46 00 00 00 00 00 
58 Bytes sent to IP [192.168.1.22]
ethGetPacket()
Received 86 bytes from IP [192.168.1.22]
SPOT_FREQ   : 0.00 (Hz) Wed Dec  4 16:56:58 2013
SUSyID: 181 - SN: 304635765
Grid Freq. : 0.00Hz
SUSyID: 181 - SN: 304635765
Current Inverter Time: 04/12/2013 19:50:33
Inverter Wake-Up Time: 04/12/2013 08:03:13
Inverter Sleep Time  : 04/12/2013 16:56:58
********************
* ArchiveDayData() *
********************
startTime = 529E6270 -> 04/12/2013 00:00:00
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 53 4D 41 00 00 04 02 A0 00 00 
00000010: 00 01 00 26 00 10 60 65 09 E0 
00000020: B5 00 75 5F 28 12 00 00 7D 00 
00000030: 4A FA D0 33 00 00 00 00 00 00 
00000040: 13 80 00 02 00 70 44 61 9E 52 
00000050: C4 B2 9F 52 00 00 00 00 
58 Bytes sent to IP [192.168.1.22]
ethGetPacket()
MAX_CommBuf is now 526 bytes
Received 526 bytes from IP [192.168.1.22]
ethGetPacket()
Received 526 bytes from IP [192.168.1.22]
ethGetPacket()
Received 526 bytes from IP [192.168.1.22]
ethGetPacket()
Received 526 bytes from IP [192.168.1.22]
ethGetPacket()
Received 526 bytes from IP [192.168.1.22]
ethGetPacket()
Received 526 bytes from IP [192.168.1.22]
ethGetPacket()
Received 130 bytes from IP [192.168.1.22]
**********************
* ArchiveMonthData() *
**********************
startTime = 529B16B0 -> 01/12/2013 12:00:00
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 53 4D 41 00 00 04 02 A0 00 00 
00000010: 00 01 00 26 00 10 60 65 09 E0 
00000020: B5 00 75 5F 28 12 00 00 7D 00 
00000030: 4A FA D0 33 00 00 00 00 00 00 
00000040: 14 80 00 02 20 70 B0 73 98 52 
00000050: B0 46 C5 52 00 00 00 00 
58 Bytes sent to IP [192.168.1.22]
ethGetPacket()
Received 118 bytes from IP [192.168.1.22]
logoffSMAInverter()
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 53 4D 41 00 00 04 02 A0 00 00 
00000010: 00 01 00 22 00 10 60 65 08 A0 
00000020: FF FF FF FF FF FF 00 03 7D 00 
00000030: 4A FA D0 33 00 03 00 00 00 00 
00000040: 15 80 0E 01 FD FF FF FF FF FF 
00000050: 00 00 00 00 
54 Bytes sent to IP [192.168.1.22]
Wed Dec  4 19:50:55 2013: INFO: Done.

Nothing has changed in the network. The inverter firmware has not been updated, as the inverter has no internet access.

silliewimons Jun 18, 2023

dear GeStenz, thanks for your added information,
-it might be that you hit a limit / bug related to date-evolution, ?? from information found in 4dec 2013,
it seems likely that your inverter went in operation around 17june 2013, which is 10years ago

-if that is the case then -> issue SMAspot "suddenly stopped to reach" inverter
might be related to a limit-overrun in either inverter-fw or SBFspot,
with the installation of SBFspot (latest edition) you might have cleared that condition / or eleminated the bug,

i look foreward on the result of your test with e webbox parameter kr sillie

sbf- · 2023-06-18T10:26:09Z

sbf-
Jun 18, 2023
Collaborator

The difference between good/bad behaviour is this:

20 Bytes sent to IP [239.12.255.254]
Received 54 bytes from IP [192.168.1.22]
Inverter IP address: 192.168.1.22

and

20 Bytes sent to IP [239.12.255.254]
Inverter IP address: 0.0.0.0

It seems you have an ip_address=0.0.0.0 in your config. If your inverter has a static ip address, it's better (faster) to specify that in the config.

Can't tell you why your inverter doesn't respond to the identification request, but something must have been changed in your network (just a guess)

This identification routine has been changed a few times since your ancient version, so I recommend using the latest SBFspot.

2 replies

GeStenZ Jun 18, 2023
Author

In the 2.2.10 version there was no possibility to specify a speedwire IP address. This feature has been added much later. But, it has worked so far without flaws.
When setting
CSV_Spot_WebboxHeader=1
the spot data table is compatible. The remaining problem is the header compatibility. I need to modify this probably and compile it with this change, if the config settings would not work.
Thanks for the support.

GeStenZ Jun 19, 2023
Author

Finally, good news: With the ExtendedHeader setting and enabling WebboxHeader, the csv is compatible with my old version.

Answer selected by GeStenZ

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Change columns in CSV spot file? #652

{{title}}

{{editor}}'s edit

{{editor}}'s edit

Replies: 2 comments 6 replies

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{editor}}'s edit

{{editor}}'s edit

Select a reply

Change columns in CSV spot file? #652

GeStenZ Jun 17, 2023

Replies: 2 comments · 6 replies

silliewimons Jun 17, 2023

GeStenZ Jun 17, 2023 Author

silliewimons Jun 17, 2023

GeStenZ Jun 17, 2023 Author

silliewimons Jun 18, 2023

sbf- Jun 18, 2023 Collaborator

GeStenZ Jun 18, 2023 Author

GeStenZ Jun 19, 2023 Author

GeStenZ
Jun 17, 2023

Replies: 2 comments 6 replies

silliewimons
Jun 17, 2023

GeStenZ Jun 17, 2023
Author

GeStenZ Jun 17, 2023
Author

sbf-
Jun 18, 2023
Collaborator

GeStenZ Jun 18, 2023
Author

GeStenZ Jun 19, 2023
Author