attr Ladestation_xxx readingList single(jsonPath('$.additionalInfo'),'location','?') single(jsonPath('$.numberOfChargePoints'),'cports') single(jsonPath('$.availableChargePoints'),'cports_avail') single(jsonPath('$.unknownStateChargePoints'),'cports_unknown') multi(jsonPath('$.chargePoints.[*]'),concat('port_',count()),concat(property('state.value'),'|',property('connectors.0.maxPowerInKw'),'|',property('connectors.0.tariffInfo.tariffGroup'),'|',property('connectors.0.tariffInfo.tariffDescription')))
attr Ladestation_xxx stateFormat {my $n=ReadingsVal("$name","cports",0);;my $ret="<table border=\"1\"><tr><td>Status</td><td>Leistung</td><td>Typ</td><td>Preis ab</td></tr>";;for(my $i=0;;$i<$n;;$i++){my @s=split('\|',ReadingsVal("$name","port_$i","UNKNOWN|||"));;my $t1=($s[0]=~/^A/)?"frei":(($s[0]=~/^O/)?"belegt":"?");;my $t2=$s[1].'kW';;my $t3=($s[2]=~/^D/)?"DC":(($s[2]=~/^A/)?"AC":"?");;$s[3]=~/(\d,\d\d) €/;;my $t4="$1 €";;$ret.="<tr><td>$t1</td><td>$t2</td><td>$t3</td><td>$t4</td></tr>\n"};;$ret.="</table>";;$ret}Zitat von: freetz am 08 März 2026, 17:03:24Ohne Deinen 6700er _defs.h-Eintrag zu kennen, noch zu wissen, wie Du die Anbindung an HA umgesetzt hast (Auto-Discovery? Eigene YAML?), kann man logischerweise nichts Hilfreiches sagen.
BSB-LAN sendet die Daten so, wie sie von der Heizung kommen. Wenn Parameter 6700 bei Dir die Command-ID 0x053D009A hat, dann besteht da die Payload aus mehreren Informationen, weswegen der wahrscheinlich bei Dir als VT_UNKNOWN hinterlegt ist. Da wird dann die gesamte Datenreihe als Hex-String übermittelt. Die müsstest Du dann in HA selber wieder zerlegen, um an die entsprechenden Infos zu kommen, die Du haben willst. Vermutlich nimmt Dein jetziger Workflow das als Nummer entgegen, was nur dann stimmt(e), wenn keine Hex-Buchstaben (A-F) enthalten waren. Aber wie gesagt, alles nur Vermutungen...
Internals:
COLUMNS field length used for Device: 64, Type: 64, Event: 512, Reading: 64, Value: 128, Unit: 32
CONFIGURATION ./db.conf
DEF ./db.conf .*:(PV_DC|pvIn).*
FD 5
FUUID 6939d7ae-f33f-3e5d-3524-8475f9b5bfd5e436
FVERSION 93_DbLog.pm:v5.11.0-s29401/2024-12-05
MODE asynchronous
MODEL MYSQL
NAME csl_debian_DbLog
NR 2
NTFY_ORDER 50-csl_debian_DbLog
PID 164125
REGEXP .*:(PV_DC|pvIn).*
SBP_PID 164126
SBP_STATE running
STATE connected
TYPE DbLog
UTF8 1
dbconn mysql:database=fhem;host=localhost;port=3306
dbuser fhemuser
eventCount 612
HELPER:
COLSET 1
DEVICECOL 64
EVENTCOL 512
OLDSTATE connected
PACKAGE main
READINGCOL 64
TC current
TH history
TYPECOL 64
UNITCOL 32
VALUECOL 128
VERSION 5.11.0
OLDREADINGS:
READINGS:
2026-03-08 19:19:56 CacheOverflowLastNum 0
2026-03-08 15:14:57 CacheOverflowLastState normal
2026-03-08 19:20:07 CacheUsage 4
2026-03-08 19:19:56 NextSync 2026-03-08 19:20:26 or when CacheUsage 500 is reached
2026-03-08 19:20:07 notify_processing_time 0.0003
2026-03-08 19:19:56 state connected
Attributes:
DbLogType Current/History
asyncMode 1
room LOG
showNotifyTime 1
verbose 2
MariaDB [fhem]> SHOW GRANTS FOR 'fhemuser'@'localhost';
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Grants for fhemuser@localhost |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------+
| GRANT SELECT, INSERT, UPDATE, INDEX, CREATE VIEW, SHOW VIEW ON *.* TO `fhemuser`@`localhost` IDENTIFIED BY PASSWORD '*0A00846A5F41FFFFE0EAE0BFBF930679977C41F4' |
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON `fhem`.* TO `fhemuser`@`localhost` |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------+
2026-03-08 19:23:36 I_AC-Power 0.28871
2026-03-08 19:23:36 I_AC_Current 1.38
2026-03-08 19:23:36 I_AC_Energy_WH 1374.734
2026-03-08 19:23:36 I_DC_Power 0.2931
2026-03-08 19:23:36 I_Status On
2026-03-08 19:23:36 I_Temp_SF -2
2026-03-08 19:23:36 I_Temp_Sink 39.06
2026-03-08 19:23:36 M_AC_POWER 0.00
2026-03-08 19:23:36 M_AC_POWER_FeedIn 0
2026-03-08 19:23:36 M_AC_POWER_Purchased 0
2026-03-08 19:23:36 M_Energy_W_SF -3
2026-03-08 19:23:36 M_Exported 186.17
2026-03-08 19:23:36 M_Imported 951.46
2026-03-08 19:23:36 NetzHaus 0.000
2026-03-08 19:23:36 PV_DC 0.000
2026-03-08 19:23:36 pvIn 0.000
2026-03-08 19:23:36 pvOut 0.000
2026-03-08 18:54:24 state opened
2026-03-08 19:28:21 ModbusAttr SE_10k PV_DC: 0.000
2026-03-08 19:28:21 ModbusAttr SE_10k BatNet: 0.360
2026-03-08 19:28:21 ModbusAttr SE_10k BatExport: 0.000
2026-03-08 19:28:21 ModbusAttr SE_10k BatHaus: 0.360
2026-03-08 19:28:21 ModbusAttr SE_10k PV_Export: 0.000
2026-03-08 19:28:21 ModbusAttr SE_10k PV_Haus: 0.005
2026-03-08 19:28:21 ModbusAttr SE_10k NetzHaus: 0.000
2026-03-08 19:28:21 DbLog csl_debian_DbLog notify_processing_time: 0.0021
2026-03-08 19:28:21 DbLog csl_debian_DbLog notify_processing_time: 0.0003
....
2026-03-08 19:30:34 ModbusAttr SE_10k WR_Effizienz: 0.985
2026-03-08 19:30:34 ModbusAttr SE_10k PV_DC: 0.000
2026-03-08 19:30:34 ModbusAttr SE_10k BatNet: 0.360
.....
2026-03-08 19:31:31 ModbusAttr SE_10k PV_Haus: 0.000
2026-03-08 19:31:31 ModbusAttr SE_10k NetzHaus: 0.000
2026-03-08 19:31:32 DbLog csl_debian_DbLog notify_processing_time: 0.0018
2026-03-08 19:31:32 DbLog csl_debian_DbLog notify_processing_time: 0.0002
+---------------------+---------------------+------------------+-----------+
| TIMESTAMP | DEVICE | READING | VALUE |
+---------------------+---------------------+------------------+-----------+
| 2026-03-08 18:38:35 | SE_10k | state | CONNECTED |
| 2026-03-08 14:58:00 | SE_10k | vom_Dach | 2.712 |
| 2026-03-08 14:58:00 | YieldDay_M_Imported | state | 951.13 |
| 2026-03-08 14:58:00 | YieldDay_M_Exported | state | 183.90 |
| 2026-03-08 14:58:00 | SE_10k | pvOut | 2.420 |
| 2026-03-08 14:58:00 | SE_10k | etotal | 646.419 |
| 2026-03-08 14:58:00 | SE_10k | dc2ac | 0.000 |
| 2026-03-08 14:58:00 | SE_10k | ac2dc | 0.000 |
| 2026-03-08 14:58:00 | SE_10k | WR_Effizienz | 0.985 |
| 2026-03-08 14:58:00 | SE_10k | PV_Leistung-temp | 5.09 |
+---------------------+---------------------+------------------+-----------+
10 rows in set (0,001 sec)
Zitat von: elektron-bbs am 07 März 2026, 17:13:32Reicht dir das so?get FritzBox_7390_Test callApifromList tr064
API Call: tr064 for TR064 Available no
Hosts:1
WLANConfiguration:4
X_AVM-DE_WANMobileConnection:1
API Call: tr064 for IGD Available no
WANIPv6FirewallControl:1
$gestern_PV_Abweichung = [FHEM::SolarForecast::]CircularVal (<SF-Devicename>, 99, 'ydayDvtn', undef);
$gestern_CO_Abweichung = [FHEM::SolarForecast::]CircularVal (<SF-Devicename>, 99, 'ydayConDvtn', undef);