Domoticz plugins

1. SMA

ssh domoticz@srv030.d01.net # xx
curl -s https://raw.githubusercontent.com/sbfspot/sbfspot-config/master/sbfspot-config | sudo bash

grep -v '#' /usr/local/bin/sbfspot.3/SBFspot.cfg

IP_Address=10.1.1.12
Password=Passw0rd <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
Plantname=SMA
OutputPath=/home/domoticz/smadata/%Y
OutputPathEvents=/home/domoticz/smadata/%Y/Events
CSV_Export=1
CSV_ExtendedHeader=1
CSV_Header=1
CSV_SaveZeroPower=1
CSV_Delimiter=semicolon
CSV_Spot_TimeSource=inverter
CSV_Spot_WebboxHeader=0
Timezone=Europe/London
Latitude=51.51
Longitude=-0.13
Locale=en-US
DateTimeFormat=%d/%m/%Y %H:%M:%S
DateFormat=%d/%m/%Y
TimeFormat=%H:%M:%S
DecimalPoint=comma
CalculateMissingSpotValues=0
SQL_Database=/home/domoticz/smadata/SBFspot.db

/usr/local/bin/sbfspot.3/SBFspot -v -finq -nocsv

SBFspot V3.5.2
Yet another tool to read power production of SMA solar inverters
(c) 2012-2018, SBF (https://github.com/SBFspot/SBFspot)
Compiled for Linux (LE) 32 bit with SQLite support
Commandline Args: -v -finq -nocsv
Reading config '/usr/local/bin/sbfspot.3/SBFspot.cfg'
Thu May  7 22:05:17 2020: INFO: Starting...
sunrise: 05:21
sunset : 20:32
Connecting to Local Network...
Initializing...
SUSyID: 125 - SessionID: 925318201 (0x37273C39)
Inverter IP address: 10.1.1.12 from SBFspot.cfg
Logon OK
SUSyID: 342 - SN: 1992060525
Device Name:      SB5.0-1AV-40 525
Device Class:     Solar Inverters
Device Type:      Sunny Boy 5.0 AV-40
Software Version: 01.03.17.R
Serial number:    1992060525
SUSyID: 342 - SN: 1992060525
Device Status:      Ok
SUSyID: 342 - SN: 1992060525
Device Temperature: 0.0°C
SUSyID: 342 - SN: 1992060525
GridRelay Status:      Information not available
SUSyID: 342 - SN: 1992060525
Pac max phase 1: 5000W
Pac max phase 2: 0W
Pac max phase 3: 0W
SUSyID: 342 - SN: 1992060525
Energy Production:
        EToday: 36.925kWh
        ETotal: 12090.904kWh
        Operation Time: 9004.65h
        Feed-In Time  : 8893.65h
SUSyID: 342 - SN: 1992060525
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
SUSyID: 342 - SN: 1992060525
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
SUSyID: 342 - SN: 1992060525
Grid Freq. : 0.00Hz
SUSyID: 342 - SN: 1992060525
Current Inverter Time: 07/05/2020 22:05:17
Inverter Sleep Time  : 07/05/2020 22:05:17
********************
* ArchiveDayData() *
********************
startTime = 5EB34170 -> 07/05/2020 00:00:00
**********************
* ArchiveMonthData() *
**********************
startTime = 5EAC0F40 -> 01/05/2020 13:00:00
Reading events: 2020-May-01
Thu May  7 22:05:18 2020: INFO: Done.

echo ".tables" | sqlite3 smadata/SBFspot.db

Config            MonthData         vwBatteryData     vwMonthData
Consumption       SpotData          vwConsumption     vwPvoData
DayData           SpotDataX         vwDayData         vwSpotData
EventData         vwAvgConsumption  vwEventData
Inverters         vwAvgSpotData     vwInverters

echo "select * from Inverters" | sqlite3 smadata/SBFspot.db

1992060525|SB5.0-1AV-40 525|Sunny Boy 5.0 AV-40|01.03.17.R|1588891734|0|36925|12090904|9004.65|8893.65|OK|N/A|0.0

echo "select * from vwSpotData" | sqlite3 smadata/SBFspot.db