SolarForecast: Mehrere Readings AllPVforecastsToEvent mit geichem Timestamp

Rewe2000 · 17 Oktober 2024, 14:23:13

Hallo Heiko,

meine "Probleme" zu SolarForecast nun in einem neuen Beitrag, damit das Hauptthema übersichtlicher bleibt und mit den Anfängerfragen nicht zu sehr wächst.

Mir ist noch folgendes aufgefallen, als ich meine Visualisierung über die solare Vorhersage und reale Erzeugung (gemäß WIKI) über DBLog und eine SVG Chart erstellt habe.
Die Readings AllPVforecastsToEvent werden bei mir immer in der Nacht, für den aktuellen Tag und den Folgetag erstellt. Nachdem diese am Tag darauf wieder erstellt werden, sind für den aktuellen Tag immer zwei gleiche Readings mit gleichen Timestamps aber unterschiedlichen Werten vorhanden.

Code Auswählen

TIMESTAMP;DEVICE;TYPE;EVENT;READING;VALUE;UNIT
2024-10-17 00:59:59;SolarForecast;SOLARFORECAST;AllPVforecastsToEvent: 0 Wh;AllPVforecastsToEvent;0;Wh
2024-10-17 07:59:59;SolarForecast;SOLARFORECAST;AllPVforecastsToEvent: 0 Wh;AllPVforecastsToEvent;0;Wh
2024-10-17 08:59:59;SolarForecast;SOLARFORECAST;AllPVforecastsToEvent: 286 Wh;AllPVforecastsToEvent;286;Wh
2024-10-17 08:59:59;SolarForecast;SOLARFORECAST;AllPVforecastsToEvent: 277 Wh;AllPVforecastsToEvent;277;Wh
2024-10-17 09:59:59;SolarForecast;SOLARFORECAST;AllPVforecastsToEvent: 591 Wh;AllPVforecastsToEvent;591;Wh
2024-10-17 09:59:59;SolarForecast;SOLARFORECAST;AllPVforecastsToEvent: 1233 Wh;AllPVforecastsToEvent;1233;Wh
2024-10-17 10:59:59;SolarForecast;SOLARFORECAST;AllPVforecastsToEvent: 1252 Wh;AllPVforecastsToEvent;1252;Wh
2024-10-17 10:59:59;SolarForecast;SOLARFORECAST;AllPVforecastsToEvent: 2573 Wh;AllPVforecastsToEvent;2573;Wh
2024-10-17 11:59:59;SolarForecast;SOLARFORECAST;AllPVforecastsToEvent: 2552 Wh;AllPVforecastsToEvent;2552;Wh
2024-10-17 11:59:59;SolarForecast;SOLARFORECAST;AllPVforecastsToEvent: 2953 Wh;AllPVforecastsToEvent;2953;Wh
2024-10-17 12:59:59;SolarForecast;SOLARFORECAST;AllPVforecastsToEvent: 3076 Wh;AllPVforecastsToEvent;3076;Wh
2024-10-17 12:59:59;SolarForecast;SOLARFORECAST;AllPVforecastsToEvent: 3665 Wh;AllPVforecastsToEvent;3665;Wh
2024-10-17 13:59:59;SolarForecast;SOLARFORECAST;AllPVforecastsToEvent: 1230 Wh;AllPVforecastsToEvent;1230;Wh
2024-10-17 13:59:59;SolarForecast;SOLARFORECAST;AllPVforecastsToEvent: 4233 Wh;AllPVforecastsToEvent;4233;Wh
2024-10-17 14:59:59;SolarForecast;SOLARFORECAST;AllPVforecastsToEvent: 1067 Wh;AllPVforecastsToEvent;1067;Wh
2024-10-17 14:59:59;SolarForecast;SOLARFORECAST;AllPVforecastsToEvent: 4042 Wh;AllPVforecastsToEvent;4042;Wh
2024-10-17 15:59:59;SolarForecast;SOLARFORECAST;AllPVforecastsToEvent: 1648 Wh;AllPVforecastsToEvent;1648;Wh
2024-10-17 15:59:59;SolarForecast;SOLARFORECAST;AllPVforecastsToEvent: 3226 Wh;AllPVforecastsToEvent;3226;Wh
2024-10-17 16:59:59;SolarForecast;SOLARFORECAST;AllPVforecastsToEvent: 1003 Wh;AllPVforecastsToEvent;1003;Wh
2024-10-17 16:59:59;SolarForecast;SOLARFORECAST;AllPVforecastsToEvent: 1442 Wh;AllPVforecastsToEvent;1442;Wh
2024-10-17 17:59:59;SolarForecast;SOLARFORECAST;AllPVforecastsToEvent: 549 Wh;AllPVforecastsToEvent;549;Wh
2024-10-17 17:59:59;SolarForecast;SOLARFORECAST;AllPVforecastsToEvent: 455 Wh;AllPVforecastsToEvent;455;Wh
2024-10-17 18:59:59;SolarForecast;SOLARFORECAST;AllPVforecastsToEvent: 71 Wh;AllPVforecastsToEvent;71;Wh
2024-10-17 18:59:59;SolarForecast;SOLARFORECAST;AllPVforecastsToEvent: 43 Wh;AllPVforecastsToEvent;43;Wh
2024-10-17 19:59:59;SolarForecast;SOLARFORECAST;AllPVforecastsToEvent: 0 Wh;AllPVforecastsToEvent;0;Wh
2024-10-17 19:59:59;SolarForecast;SOLARFORECAST;AllPVforecastsToEvent: 0 Wh;AllPVforecastsToEvent;0;Wh

Ist das so gewollt?

Dadurch werden dann auch bei der Chartdarstellung zwei Werte für eine Stunde dargestellt. Nachdem aber der Zeitstempel gleich ist, fällt mir hier die Interpretation schwer.

Du darfst diesen Dateianhang nicht ansehen.

Übersehe ich da etwas oder wende ich die Infos im Chart falsch an?

Gruß Reinhard

ch.eick · 17 Oktober 2024, 16:08:09

Moin,
wenn man mit der Datenbank arbeiten möchte, was in diesem Modul zuerst nicht gewollt war, dann sollte man die Loggings z.B. so formatieren. Damit kann man sie geziehlt mit einem generierten TIMESTAMP wieder ansprechen.
Das fc1 vom 17.10 wurde bereits gestern geschrieben und das fc1 mit 18.10 ist heute geschrieben worden.
fc0 wird mit jeder neuen Prognose von heute neu überschrieben.

Code Auswählen

TIMESTAMP,READING,VALUE
"2024-10-17 06:00:00",Yield_fc0,0
"2024-10-17 07:00:00",Yield_fc0,0
"2024-10-17 08:00:00",Yield_fc0,433
"2024-10-17 09:00:00",Yield_fc0,1430
"2024-10-17 10:00:00",Yield_fc0,2414
"2024-10-17 11:00:00",Yield_fc0,3313
"2024-10-17 12:00:00",Yield_fc0,3511
"2024-10-17 13:00:00",Yield_fc0,2892
"2024-10-17 14:00:00",Yield_fc0,2253
"2024-10-17 15:00:00",Yield_fc0,1598
"2024-10-17 16:00:00",Yield_fc0,1017
"2024-10-17 17:00:00",Yield_fc0,494
"2024-10-17 18:00:00",Yield_fc0,165
"2024-10-17 19:00:00",Yield_fc0,80
"2024-10-17 20:00:00",Yield_fc0,45
"2024-10-17 06:00:00",Yield_fc1,0
"2024-10-17 07:00:00",Yield_fc1,0
"2024-10-17 08:00:00",Yield_fc1,350
"2024-10-17 09:00:00",Yield_fc1,1352
"2024-10-17 10:00:00",Yield_fc1,2509
"2024-10-17 11:00:00",Yield_fc1,3103
"2024-10-17 12:00:00",Yield_fc1,3285
"2024-10-17 13:00:00",Yield_fc1,3400
"2024-10-17 14:00:00",Yield_fc1,2984
"2024-10-17 15:00:00",Yield_fc1,2102
"2024-10-17 16:00:00",Yield_fc1,1322
"2024-10-17 17:00:00",Yield_fc1,572
"2024-10-17 18:00:00",Yield_fc1,151
"2024-10-17 19:00:00",Yield_fc1,0
"2024-10-17 20:00:00",Yield_fc1,0
"2024-10-18 06:00:00",Yield_fc1,0
"2024-10-18 07:00:00",Yield_fc1,0
"2024-10-18 08:00:00",Yield_fc1,908
"2024-10-18 09:00:00",Yield_fc1,2289
"2024-10-18 10:00:00",Yield_fc1,3517
"2024-10-18 11:00:00",Yield_fc1,4141
"2024-10-18 12:00:00",Yield_fc1,4163
"2024-10-18 13:00:00",Yield_fc1,3833
"2024-10-18 14:00:00",Yield_fc1,2759
"2024-10-18 15:00:00",Yield_fc1,1811
"2024-10-18 16:00:00",Yield_fc1,1171
"2024-10-18 17:00:00",Yield_fc1,469
"2024-10-18 18:00:00",Yield_fc1,101
"2024-10-18 19:00:00",Yield_fc1,50
"2024-10-18 20:00:00",Yield_fc1,26

EDIT:
Für Devices, die ihre READINGS anders aufbauen habe ich auch eine Perl Funktion für das userReadings, die dann bei einem Trigger die Einträge formatiert und diese mit einem DbRep Device mit MySQL in die Datenbank schreibt. Das gefällt zwar den Meisten nicht, aber man kann das natürlich auch in die MyUtils packen. Das EVU_Tibber_connect wäre z.B. solch ein Device.

VG Christian

Rewe2000 · 17 Oktober 2024, 19:12:03

Hallo Christian,

danke für die Erklärung.
Ich benötige die Readings nicht zwingend, ich wollte nur den Forecast Chart nachbauen, so wie ihn Heiko im Wiki beschrieben hat. Habe mich nur gewundert, dass dieser bei mir anders aussieht als im Artikel.

Wenn ich das Reading AllPVforecastsToEvent abbilden will, so werde ich dann einfach über userreadings gehen und die Daten selbst aufbereiten, so wie du vorgeschlagen hast.

Gruß Reinhard

DS_Starter · 18 Oktober 2024, 00:18:50

Hallo Reinhard,

es wundert mich dass deine Timestamps der Tage identisch sind.
Schau mal meinen Auszug der DB im Anhang. Die Tagesstempel werden immer fortgeschrieben.
Da stimmt bei dir etwas nicht. Können wir mal genauer schauen wieso.
Es wäre hilfreich entweder einen Auszug vom Eventmonitor für die Zeit ca. 5 Minuten - 6 Minuten nach Mitternacht zu haben oder ein DbLog verbose 4 Log für diese Zeit.
Man braucht normal keinerlei Umkodierungen usw.

Grüße,
Heiko

Rewe2000 · 18 Oktober 2024, 09:40:31

Hallo Heiko,

so wie bei dir habe ich mir die Readings auch vorgestellt, denn Readings mit unterschiedlichen Werten aber gleichen Timestamp geben für mich wenig Sinn.
Ich estelle die Logs und melde mich wieder, in der Hoffnung den Verursacher zu finden.

Gruß Reinhard

DS_Starter · 18 Oktober 2024, 09:48:38

Moin Reinhard,

poste mal bitte die Ausgabe von get ... nextHours.
Sieht etwa so aus:

Code Auswählen

NextHour00 => starttime: 2024-10-18 09:00:00, hourofday: 10, today: 1
              pvapifc: 1116, pvaifc: -, pvfc: 1116, aihit: 0, confc: 668
              confcEx: 668, DoN: 1, wid: 2, wcc: 62, rr1c: 0.00, temp=10.30
              rad1h: 390, sunaz: 127, sunalt: 15
              rrange: 0.00, crange: -, correff: 1.00/0.58
NextHour01 => starttime: 2024-10-18 10:00:00, hourofday: 11, today: 1
              pvapifc: 2004, pvaifc: -, pvfc: 2004, aihit: 0, confc: 880
              confcEx: 880, DoN: 1, wid: 2, wcc: 63, rr1c: 0.00, temp=11.70
              rad1h: 630, sunaz: 141, sunalt: 21
              rrange: 0.00, crange: -, correff: 1.00/0.67
NextHour02 => starttime: 2024-10-18 11:00:00, hourofday: 12, today: 1
              pvapifc: 2856, pvaifc: -, pvfc: 2856, aihit: 0, confc: 1277
              confcEx: 1277, DoN: 1, wid: 2, wcc: 64, rr1c: 0.00, temp=12.90
              rad1h: 840, sunaz: 156, sunalt: 26
              rrange: 0.00, crange: -, correff: 1.00/0.80
NextHour03 => starttime: 2024-10-18 12:00:00, hourofday: 13, today: 1
              pvapifc: 3311, pvaifc: -, pvfc: 3311, aihit: 0, confc: 896
              confcEx: 896, DoN: 1, wid: 2, wcc: 63, rr1c: 0.00, temp=13.70
              rad1h: 940, sunaz: 172, sunalt: 29
              rrange: 0.00, crange: -, correff: 1.00/0.76
NextHour04 => starttime: 2024-10-18 13:00:00, hourofday: 14, today: 1
              pvapifc: 3119, pvaifc: -, pvfc: 3119, aihit: 0, confc: 841
              confcEx: 841, DoN: 1, wid: 2, wcc: 58, rr1c: 0.00, temp=14.70
              rad1h: 890, sunaz: 189, sunalt: 28
              rrange: 0.00, crange: -, correff: 1.00/0.87
NextHour05 => starttime: 2024-10-18 14:00:00, hourofday: 15, today: 1
              pvapifc: 2705, pvaifc: -, pvfc: 2705, aihit: 0, confc: 956
              confcEx: 956, DoN: 1, wid: 2, wcc: 56, rr1c: 0.00, temp=15.00
              rad1h: 800, sunaz: 206, sunalt: 26
              rrange: 0.00, crange: -, correff: 1.00/0.89
NextHour06 => starttime: 2024-10-18 15:00:00, hourofday: 16, today: 1
              pvapifc: 1785, pvaifc: -, pvfc: 1785, aihit: 0, confc: 691
              confcEx: 691, DoN: 1, wid: 1, wcc: 55, rr1c: 0.00, temp=15.30
              rad1h: 570, sunaz: 221, sunalt: 20
              rrange: 0.00, crange: -, correff: 1.00/0.87
NextHour07 => starttime: 2024-10-18 16:00:00, hourofday: 17, today: 1
              pvapifc: 960, pvaifc: -, pvfc: 960, aihit: 0, confc: 683
              confcEx: 683, DoN: 1, wid: 2, wcc: 59, rr1c: 0.00, temp=15.20
              rad1h: 340, sunaz: 234, sunalt: 14
              rrange: 0.00, crange: -, correff: 1.00/0.99
NextHour08 => starttime: 2024-10-18 17:00:00, hourofday: 18, today: 1
              pvapifc: 291, pvaifc: -, pvfc: 291, aihit: 0, confc: 685
              confcEx: 685, DoN: 1, wid: 2, wcc: 62, rr1c: 0.00, temp=14.80
              rad1h: 120, sunaz: 247, sunalt: 6
              rrange: 0.00, crange: -, correff: 1.00/0.51
NextHour09 => starttime: 2024-10-18 18:00:00, hourofday: 19, today: 1
              pvapifc: 0, pvaifc: -, pvfc: 0, aihit: 0, confc: 761
              confcEx: 761, DoN: 1, wid: 2, wcc: 65, rr1c: 0.00, temp=14.20
              rad1h: 0, sunaz: 259, sunalt: -4
              rrange: 0.00, crange: -, correff: 1.00/0.00
NextHour10 => starttime: 2024-10-18 19:00:00, hourofday: 20, today: 1
              pvapifc: 0, pvaifc: -, pvfc: 0, aihit: 0, confc: 767
              confcEx: 767, DoN: 0, wid: 102, wcc: 69, rr1c: 0.00, temp=13.00
              rad1h: 0, sunaz: 270, sunalt: -13
              rrange: 0.00, crange: -, correff: 1.00/-
NextHour11 => starttime: 2024-10-18 20:00:00, hourofday: 21, today: 1
              pvapifc: 0, pvaifc: -, pvfc: 0, aihit: 0, confc: 803
              confcEx: 803, DoN: 0, wid: 102, wcc: 69, rr1c: 0.00, temp=12.10
              rad1h: 0, sunaz: 282, sunalt: -22
              rrange: 0.00, crange: -, correff: 1.00/-
NextHour12 => starttime: 2024-10-18 21:00:00, hourofday: 22, today: 1
              pvapifc: 0, pvaifc: -, pvfc: 0, aihit: 0, confc: 613
              confcEx: 613, DoN: 0, wid: 102, wcc: 68, rr1c: 0.00, temp=11.70
              rad1h: 0, sunaz: 295, sunalt: -31
              rrange: 0.00, crange: -, correff: 1.00/-
NextHour13 => starttime: 2024-10-18 22:00:00, hourofday: 23, today: 1
              pvapifc: 0, pvaifc: -, pvfc: 0, aihit: 0, confc: 610
              confcEx: 610, DoN: 0, wid: 102, wcc: 68, rr1c: 0.00, temp=11.50
              rad1h: 0, sunaz: 311, sunalt: -39
              rrange: 0.00, crange: -, correff: 1.00/-
NextHour14 => starttime: 2024-10-18 23:00:00, hourofday: 24, today: 1
              pvapifc: 0, pvaifc: -, pvfc: 0, aihit: 0, confc: 617
              confcEx: 617, DoN: 0, wid: 102, wcc: 72, rr1c: 0.00, temp=11.40
              rad1h: 0, sunaz: 329, sunalt: -45
              rrange: 0.00, crange: -, correff: 1.00/-
NextHour15 => starttime: 2024-10-19 00:00:00, hourofday: 01, today: 0
              pvapifc: 0, pvaifc: -, pvfc: 0, aihit: 0, confc: 497
              confcEx: 497, DoN: 0, wid: 102, wcc: 73, rr1c: 0.00, temp=11.30
              rad1h: 0, sunaz: 350, sunalt: -48
              rrange: 0.00, crange: -, correff: 1.00/-
NextHour16 => starttime: 2024-10-19 01:00:00, hourofday: 02, today: 0
              pvapifc: 0, pvaifc: -, pvfc: 0, aihit: 0, confc: 453
              confcEx: 453, DoN: 0, wid: 103, wcc: 74, rr1c: 0.00, temp=11.30
              rad1h: 0, sunaz: 12, sunalt: -48
              rrange: 0.00, crange: -, correff: 1.00/-
NextHour17 => starttime: 2024-10-19 02:00:00, hourofday: 03, today: 0
              pvapifc: 0, pvaifc: -, pvfc: 0, aihit: 0, confc: 436
              confcEx: 436, DoN: 0, wid: 103, wcc: 67, rr1c: 0.00, temp=11.30
              rad1h: 0, sunaz: 33, sunalt: -44
              rrange: 0.00, crange: -, correff: 1.00/-
NextHour18 => starttime: 2024-10-19 03:00:00, hourofday: 04, today: 0
              pvapifc: 0, pvaifc: -, pvfc: 0, aihit: 0, confc: 435
              confcEx: 435, DoN: 0, wid: 102, wcc: 66, rr1c: 0.00, temp=11.30
              rad1h: 0, sunaz: 51, sunalt: -38
              rrange: 0.00, crange: -, correff: 1.00/-
NextHour19 => starttime: 2024-10-19 04:00:00, hourofday: 05, today: 0
              pvapifc: 0, pvaifc: -, pvfc: 0, aihit: 0, confc: 446
              confcEx: 446, DoN: 0, wid: 102, wcc: 62, rr1c: 0.00, temp=11.40
              rad1h: 0, sunaz: 66, sunalt: -30
              rrange: 0.00, crange: -, correff: 1.00/-
NextHour20 => starttime: 2024-10-19 05:00:00, hourofday: 06, today: 0
              pvapifc: 0, pvaifc: -, pvfc: 0, aihit: 0, confc: 475
              confcEx: 475, DoN: 0, wid: 102, wcc: 57, rr1c: 0.00, temp=11.20
              rad1h: 0, sunaz: 79, sunalt: -21
              rrange: 0.00, crange: -, correff: 1.00/-
NextHour21 => starttime: 2024-10-19 06:00:00, hourofday: 07, today: 0
              pvapifc: 0, pvaifc: -, pvfc: 0, aihit: 0, confc: 634
              confcEx: 634, DoN: 0, wid: 102, wcc: 59, rr1c: 0.00, temp=11.20
              rad1h: 0, sunaz: 91, sunalt: -12
              rrange: 0.00, crange: -, correff: 1.00/-
NextHour22 => starttime: 2024-10-19 07:00:00, hourofday: 08, today: 0
              pvapifc: 0, pvaifc: -, pvfc: 0, aihit: 0, confc: 975
              confcEx: 975, DoN: 0, wid: 102, wcc: 56, rr1c: 0.00, temp=11.10
              rad1h: 0, sunaz: 103, sunalt: -3
              rrange: 0.00, crange: -, correff: 1.00/0.70
NextHour23 => starttime: 2024-10-19 08:00:00, hourofday: 09, today: 0
              pvapifc: 271, pvaifc: -, pvfc: 271, aihit: 0, confc: 638
              confcEx: 638, DoN: 1, wid: 2, wcc: 59, rr1c: 0.00, temp=11.30
              rad1h: 110, sunaz: 115, sunalt: 6
              rrange: 0.00, crange: -, correff: 1.00/0.68
NextHour24 => starttime: 2024-10-19 09:00:00, hourofday: 10, today: 0
              pvapifc: 1080, pvaifc: -, pvfc: 1080, aihit: 0, confc: 668
              confcEx: 668, DoN: 1, wid: 2, wcc: 61, rr1c: 0.00, temp=12.40
              rad1h: 380, sunaz: 127, sunalt: 14
              rrange: 0.00, crange: -, correff: 1.00/0.58
NextHour25 => starttime: 2024-10-19 10:00:00, hourofday: 11, today: 0
              pvapifc: 2195, pvaifc: -, pvfc: 2195, aihit: 0, confc: 880
              confcEx: 880, DoN: 1, wid: 2, wcc: 54, rr1c: 0.00, temp=13.70
              rad1h: 690, sunaz: 141, sunalt: 21
              rrange: 0.00, crange: -, correff: 1.00/0.67
NextHour26 => starttime: 2024-10-19 11:00:00, hourofday: 12, today: 0
              pvapifc: 3060, pvaifc: -, pvfc: 3060, aihit: 0, confc: 1277
              confcEx: 1277, DoN: 1, wid: 1, wcc: 54, rr1c: 0.00, temp=15.10
              rad1h: 900, sunaz: 156, sunalt: 26
              rrange: 0.00, crange: -, correff: 1.00/0.80
NextHour27 => starttime: 2024-10-19 12:00:00, hourofday: 13, today: 0
              pvapifc: 3469, pvaifc: -, pvfc: 3469, aihit: 0, confc: 896
              confcEx: 896, DoN: 1, wid: 1, wcc: 53, rr1c: 0.00, temp=16.50
              rad1h: 990, sunaz: 172, sunalt: 28
              rrange: 0.00, crange: -, correff: 1.00/0.76
NextHour28 => starttime: 2024-10-19 13:00:00, hourofday: 14, today: 0
              pvapifc: 3259, pvaifc: -, pvfc: 3259, aihit: 0, confc: 841
              confcEx: 841, DoN: 1, wid: 1, wcc: 55, rr1c: 0.00, temp=17.70
              rad1h: 930, sunaz: 189, sunalt: 28
              rrange: 0.00, crange: -, correff: 1.00/0.87
NextHour29 => starttime: 2024-10-19 14:00:00, hourofday: 15, today: 0
              pvapifc: 2623, pvaifc: -, pvfc: 2623, aihit: 0, confc: 956
              confcEx: 956, DoN: 1, wid: 1, wcc: 55, rr1c: 0.00, temp=18.40
              rad1h: 780, sunaz: 206, sunalt: 25
              rrange: 0.00, crange: -, correff: 1.00/0.89
NextHour30 => starttime: 2024-10-19 15:00:00, hourofday: 16, today: 0
              pvapifc: 1763, pvaifc: -, pvfc: 1763, aihit: 0, confc: 691
              confcEx: 691, DoN: 1, wid: 1, wcc: 55, rr1c: 0.00, temp=18.80
              rad1h: 560, sunaz: 220, sunalt: 20
              rrange: 0.00, crange: -, correff: 1.00/0.87
NextHour31 => starttime: 2024-10-19 16:00:00, hourofday: 17, today: 0
              pvapifc: 932, pvaifc: -, pvfc: 932, aihit: 0, confc: 683
              confcEx: 683, DoN: 1, wid: 2, wcc: 59, rr1c: 0.00, temp=18.70
              rad1h: 330, sunaz: 234, sunalt: 14
              rrange: 0.00, crange: -, correff: 1.00/0.99
NextHour32 => starttime: 2024-10-19 17:00:00, hourofday: 18, today: 0
              pvapifc: 315, pvaifc: -, pvfc: 315, aihit: 0, confc: 685
              confcEx: 685, DoN: 1, wid: 2, wcc: 63, rr1c: 0.00, temp=18.30
              rad1h: 130, sunaz: 247, sunalt: 6
              rrange: 0.00, crange: -, correff: 1.00/0.51
NextHour33 => starttime: 2024-10-19 18:00:00, hourofday: 19, today: 0
              pvapifc: 0, pvaifc: -, pvfc: 0, aihit: 0, confc: 761
              confcEx: 761, DoN: 1, wid: 2, wcc: 64, rr1c: 0.00, temp=17.20
              rad1h: 0, sunaz: 258, sunalt: -4
              rrange: 0.00, crange: -, correff: 1.00/0.00
NextHour34 => starttime: 2024-10-19 19:00:00, hourofday: 20, today: 0
              pvapifc: 0, pvaifc: -, pvfc: 0, aihit: 0, confc: 767
              confcEx: 767, DoN: 0, wid: 102, wcc: 67, rr1c: 0.00, temp=15.70
              rad1h: 0, sunaz: 270, sunalt: -13
              rrange: 0.00, crange: -, correff: 1.00/-
NextHour35 => starttime: 2024-10-19 20:00:00, hourofday: 21, today: 0
              pvapifc: 0, pvaifc: -, pvfc: 0, aihit: 0, confc: 803
              confcEx: 803, DoN: 0, wid: 102, wcc: 69, rr1c: 0.00, temp=14.60
              rad1h: 0, sunaz: 282, sunalt: -22
              rrange: 0.00, crange: -, correff: 1.00/-
NextHour36 => starttime: 2024-10-19 21:00:00, hourofday: 22, today: 0
              pvapifc: 0, pvaifc: -, pvfc: 0, aihit: 0, confc: 613
              confcEx: 613, DoN: 0, wid: 102, wcc: 68, rr1c: 0.00, temp=13.80
              rad1h: 0, sunaz: 295, sunalt: -31
              rrange: 0.00, crange: -, correff: 1.00/-
NextHour37 => starttime: 2024-10-19 22:00:00, hourofday: 23, today: 0
              pvapifc: 0, pvaifc: -, pvfc: 0, aihit: 0, confc: 610
              confcEx: 610, DoN: 0, wid: 102, wcc: 68, rr1c: 0.00, temp=13.20
              rad1h: 0, sunaz: 311, sunalt: -39
              rrange: 0.00, crange: -, correff: 1.00/-
NextHour38 => starttime: 2024-10-19 23:00:00, hourofday: 24, today: 0
              pvapifc: 0, pvaifc: -, pvfc: 0, aihit: 0, confc: 617
              confcEx: 617, DoN: -, wid: -, wcc: -, rr1c: -, temp=-
              rad1h: 0, sunaz: 329, sunalt: -45
              rrange: -, crange: -, correff: 1.00/-

Rewe2000 · 18 Oktober 2024, 09:56:42

Hallo Heiko,

hier die gewünschte Ausgabe von get next hours:

Code Auswählen

NextHour00 => starttime: 2024-10-18 09:00:00, hourofday: 10, today: 1
              pvapifc: 882, pvaifc: -, pvfc: 882, aihit: 0, confc: 454
              confcEx: 497, DoN: 1, wid: 2, wcc: 69, rr1c: 0.00, temp=8.00
              rad1h: 370, sunaz: 126, sunalt: 15
              rrange: 0.00, crange: 70, correff: 1.00/-
NextHour01 => starttime: 2024-10-18 10:00:00, hourofday: 11, today: 1
              pvapifc: 1383, pvaifc: -, pvfc: 1383, aihit: 0, confc: 1304
              confcEx: 1304, DoN: 1, wid: 2, wcc: 69, rr1c: 0.00, temp=10.00
              rad1h: 580, sunaz: 139, sunalt: 22
              rrange: 0.00, crange: 70, correff: 1.00/-
NextHour02 => starttime: 2024-10-18 11:00:00, hourofday: 12, today: 1
              pvapifc: 1836, pvaifc: -, pvfc: 1836, aihit: 0, confc: 1037
              confcEx: 1037, DoN: 1, wid: 2, wcc: 78, rr1c: 0.00, temp=11.40
              rad1h: 770, sunaz: 154, sunalt: 28
              rrange: 0.00, crange: 80, correff: 1.00/-
NextHour03 => starttime: 2024-10-18 12:00:00, hourofday: 13, today: 1
              pvapifc: 3040, pvaifc: -, pvfc: 3040, aihit: 0, confc: 1632
              confcEx: 1632, DoN: 1, wid: 2, wcc: 75, rr1c: 0.00, temp=12.40
              rad1h: 850, sunaz: 171, sunalt: 31
              rrange: 0.00, crange: 75, correff: 1.50/0.49
NextHour04 => starttime: 2024-10-18 13:00:00, hourofday: 14, today: 1
              pvapifc: 1860, pvaifc: -, pvfc: 1860, aihit: 0, confc: 1999
              confcEx: 1999, DoN: 1, wid: 2, wcc: 81, rr1c: 0.00, temp=13.40
              rad1h: 780, sunaz: 188, sunalt: 31
              rrange: 0.00, crange: 80, correff: 1.00/-
NextHour05 => starttime: 2024-10-18 14:00:00, hourofday: 15, today: 1
              pvapifc: 1621, pvaifc: -, pvfc: 1621, aihit: 0, confc: 1811
              confcEx: 1811, DoN: 1, wid: 3, wcc: 87, rr1c: 0.00, temp=14.50
              rad1h: 680, sunaz: 205, sunalt: 28
              rrange: 0.00, crange: 85, correff: 1.00/-
NextHour06 => starttime: 2024-10-18 15:00:00, hourofday: 16, today: 1
              pvapifc: 1240, pvaifc: -, pvfc: 1240, aihit: 0, confc: 2148
              confcEx: 2148, DoN: 1, wid: 3, wcc: 90, rr1c: 0.00, temp=14.80
              rad1h: 520, sunaz: 220, sunalt: 22
              rrange: 0.00, crange: 90, correff: 1.00/-
NextHour07 => starttime: 2024-10-18 16:00:00, hourofday: 17, today: 1
              pvapifc: 1526, pvaifc: -, pvfc: 1526, aihit: 0, confc: 1905
              confcEx: 1905, DoN: 1, wid: 3, wcc: 90, rr1c: 0.00, temp=14.90
              rad1h: 320, sunaz: 234, sunalt: 15
              rrange: 0.00, crange: 90, correff: 2.00/0.44
NextHour08 => starttime: 2024-10-18 17:00:00, hourofday: 18, today: 1
              pvapifc: 310, pvaifc: -, pvfc: 310, aihit: 0, confc: 885
              confcEx: 885, DoN: 1, wid: 3, wcc: 86, rr1c: 0.00, temp=14.50
              rad1h: 130, sunaz: 246, sunalt: 7
              rrange: 0.00, crange: 85, correff: 1.00/-
NextHour09 => starttime: 2024-10-18 18:00:00, hourofday: 19, today: 1
              pvapifc: 28, pvaifc: -, pvfc: 28, aihit: 0, confc: 2101
              confcEx: 2101, DoN: 1, wid: 3, wcc: 81, rr1c: 0.00, temp=13.70
              rad1h: 20, sunaz: 258, sunalt: -2
              rrange: 0.00, crange: 80, correff: 0.60/0.00
NextHour10 => starttime: 2024-10-18 19:00:00, hourofday: 20, today: 1
              pvapifc: 0, pvaifc: -, pvfc: 0, aihit: 0, confc: 1071
              confcEx: 1071, DoN: 0, wid: 103, wcc: 79, rr1c: 0.00, temp=12.90
              rad1h: 0, sunaz: 269, sunalt: -12
              rrange: 0.00, crange: 80, correff: 1.00/-
NextHour11 => starttime: 2024-10-18 20:00:00, hourofday: 21, today: 1
              pvapifc: 0, pvaifc: -, pvfc: 0, aihit: 0, confc: 560
              confcEx: 560, DoN: 0, wid: 103, wcc: 73, rr1c: 0.00, temp=12.40
              rad1h: 0, sunaz: 280, sunalt: -22
              rrange: 0.00, crange: 75, correff: 1.00/-
NextHour12 => starttime: 2024-10-18 21:00:00, hourofday: 22, today: 1
              pvapifc: 0, pvaifc: -, pvfc: 0, aihit: 0, confc: 1629
              confcEx: 1629, DoN: 0, wid: 103, wcc: 73, rr1c: 0.00, temp=11.70
              rad1h: 0, sunaz: 293, sunalt: -31
              rrange: 0.00, crange: 75, correff: 1.00/-
NextHour13 => starttime: 2024-10-18 22:00:00, hourofday: 23, today: 1
              pvapifc: 0, pvaifc: -, pvfc: 0, aihit: 0, confc: 301
              confcEx: 301, DoN: 0, wid: 103, wcc: 62, rr1c: 0.00, temp=11.40
              rad1h: 0, sunaz: 308, sunalt: -40
              rrange: 0.00, crange: 60, correff: 1.00/-
NextHour14 => starttime: 2024-10-18 23:00:00, hourofday: 24, today: 1
              pvapifc: 0, pvaifc: -, pvfc: 0, aihit: 0, confc: 298
              confcEx: 298, DoN: 0, wid: 103, wcc: 59, rr1c: 0.00, temp=11.00
              rad1h: 0, sunaz: 326, sunalt: -46
              rrange: 0.00, crange: 60, correff: 1.00/-
NextHour15 => starttime: 2024-10-19 00:00:00, hourofday: 01, today: 0
              pvapifc: 0, pvaifc: -, pvfc: 0, aihit: 0, confc: 244
              confcEx: 244, DoN: 0, wid: 103, wcc: 59, rr1c: 0.00, temp=10.80
              rad1h: 0, sunaz: 348, sunalt: -50
              rrange: 0.00, crange: 60, correff: 1.00/-
NextHour16 => starttime: 2024-10-19 01:00:00, hourofday: 02, today: 0
              pvapifc: 0, pvaifc: -, pvfc: 0, aihit: 0, confc: 243
              confcEx: 243, DoN: 0, wid: 102, wcc: 56, rr1c: 0.00, temp=10.40
              rad1h: 0, sunaz: 11, sunalt: -50
              rrange: 0.00, crange: 55, correff: 1.00/-
NextHour17 => starttime: 2024-10-19 02:00:00, hourofday: 03, today: 0
              pvapifc: 0, pvaifc: -, pvfc: 0, aihit: 0, confc: 224
              confcEx: 224, DoN: 0, wid: 102, wcc: 63, rr1c: 0.00, temp=10.20
              rad1h: 0, sunaz: 33, sunalt: -47
              rrange: 0.00, crange: 65, correff: 1.00/-
NextHour18 => starttime: 2024-10-19 03:00:00, hourofday: 04, today: 0
              pvapifc: 0, pvaifc: -, pvfc: 0, aihit: 0, confc: 214
              confcEx: 214, DoN: 0, wid: 103, wcc: 64, rr1c: 0.00, temp=10.20
              rad1h: 0, sunaz: 51, sunalt: -40
              rrange: 0.00, crange: 65, correff: 1.00/-
NextHour19 => starttime: 2024-10-19 04:00:00, hourofday: 05, today: 0
              pvapifc: 0, pvaifc: -, pvfc: 0, aihit: 0, confc: 218
              confcEx: 218, DoN: 0, wid: 103, wcc: 70, rr1c: 0.00, temp=10.20
              rad1h: 0, sunaz: 66, sunalt: -32
              rrange: 0.00, crange: 70, correff: 1.00/-
NextHour20 => starttime: 2024-10-19 05:00:00, hourofday: 06, today: 0
              pvapifc: 0, pvaifc: -, pvfc: 0, aihit: 0, confc: 216
              confcEx: 216, DoN: 0, wid: 103, wcc: 73, rr1c: 0.00, temp=10.50
              rad1h: 0, sunaz: 79, sunalt: -22
              rrange: 0.00, crange: 75, correff: 1.00/-
NextHour21 => starttime: 2024-10-19 06:00:00, hourofday: 07, today: 0
              pvapifc: 0, pvaifc: -, pvfc: 0, aihit: 0, confc: 216
              confcEx: 216, DoN: 0, wid: 103, wcc: 77, rr1c: 0.00, temp=10.30
              rad1h: 0, sunaz: 91, sunalt: -13
              rrange: 0.00, crange: 75, correff: 1.00/-
NextHour22 => starttime: 2024-10-19 07:00:00, hourofday: 08, today: 0
              pvapifc: 0, pvaifc: -, pvfc: 0, aihit: 0, confc: 217
              confcEx: 217, DoN: 0, wid: 103, wcc: 84, rr1c: 0.00, temp=10.40
              rad1h: 0, sunaz: 102, sunalt: -3
              rrange: 0.00, crange: 85, correff: 1.00/-
NextHour23 => starttime: 2024-10-19 08:00:00, hourofday: 09, today: 0
              pvapifc: 223, pvaifc: -, pvfc: 223, aihit: 0, confc: 398
              confcEx: 398, DoN: 1, wid: 3, wcc: 85, rr1c: 0.00, temp=10.70
              rad1h: 80, sunaz: 114, sunalt: 7
              rrange: 0.00, crange: 85, correff: 1.17/-
NextHour24 => starttime: 2024-10-19 09:00:00, hourofday: 10, today: 0
              pvapifc: 691, pvaifc: 572, pvfc: 572, aihit: 1, confc: 454
              confcEx: 497, DoN: 1, wid: 3, wcc: 80, rr1c: 0.00, temp=11.20
              rad1h: 290, sunaz: 126, sunalt: 15
              rrange: 0.00, crange: 80, correff: 1.00/-
NextHour25 => starttime: 2024-10-19 10:00:00, hourofday: 11, today: 0
              pvapifc: 1240, pvaifc: -, pvfc: 1240, aihit: 0, confc: 1304
              confcEx: 1304, DoN: 1, wid: 3, wcc: 82, rr1c: 0.00, temp=12.40
              rad1h: 520, sunaz: 140, sunalt: 22
              rrange: 0.00, crange: 80, correff: 1.00/-
NextHour26 => starttime: 2024-10-19 11:00:00, hourofday: 12, today: 0
              pvapifc: 1860, pvaifc: -, pvfc: 1860, aihit: 0, confc: 1037
              confcEx: 1037, DoN: 1, wid: 3, wcc: 86, rr1c: 0.00, temp=13.60
              rad1h: 780, sunaz: 155, sunalt: 27
              rrange: 0.00, crange: 85, correff: 1.00/-
NextHour27 => starttime: 2024-10-19 12:00:00, hourofday: 13, today: 0
              pvapifc: 2265, pvaifc: -, pvfc: 2265, aihit: 0, confc: 1632
              confcEx: 1632, DoN: 1, wid: 3, wcc: 86, rr1c: 0.00, temp=14.50
              rad1h: 950, sunaz: 171, sunalt: 30
              rrange: 0.00, crange: 85, correff: 1.00/-
NextHour28 => starttime: 2024-10-19 13:00:00, hourofday: 14, today: 0
              pvapifc: 2943, pvaifc: -, pvfc: 2943, aihit: 0, confc: 1999
              confcEx: 1999, DoN: 1, wid: 3, wcc: 85, rr1c: 0.00, temp=15.70
              rad1h: 1020, sunaz: 188, sunalt: 30
              rrange: 0.00, crange: 85, correff: 1.21/0.71
NextHour29 => starttime: 2024-10-19 14:00:00, hourofday: 15, today: 0
              pvapifc: 2289, pvaifc: -, pvfc: 2289, aihit: 0, confc: 1811
              confcEx: 1811, DoN: 1, wid: 3, wcc: 84, rr1c: 0.00, temp=16.40
              rad1h: 960, sunaz: 205, sunalt: 27
              rrange: 0.00, crange: 85, correff: 1.00/-
NextHour30 => starttime: 2024-10-19 15:00:00, hourofday: 16, today: 0
              pvapifc: 1860, pvaifc: -, pvfc: 1860, aihit: 0, confc: 2148
              confcEx: 2148, DoN: 1, wid: 3, wcc: 81, rr1c: 0.00, temp=16.80
              rad1h: 780, sunaz: 220, sunalt: 22
              rrange: 0.00, crange: 80, correff: 1.00/-
NextHour31 => starttime: 2024-10-19 16:00:00, hourofday: 17, today: 0
              pvapifc: 1097, pvaifc: -, pvfc: 1097, aihit: 0, confc: 1905
              confcEx: 1905, DoN: 1, wid: 3, wcc: 81, rr1c: 0.00, temp=16.80
              rad1h: 460, sunaz: 234, sunalt: 15
              rrange: 0.00, crange: 80, correff: 1.00/-
NextHour32 => starttime: 2024-10-19 17:00:00, hourofday: 18, today: 0
              pvapifc: 405, pvaifc: -, pvfc: 405, aihit: 0, confc: 885
              confcEx: 885, DoN: 1, wid: 3, wcc: 80, rr1c: 0.00, temp=16.20
              rad1h: 170, sunaz: 246, sunalt: 7
              rrange: 0.00, crange: 80, correff: 1.00/-
NextHour33 => starttime: 2024-10-19 18:00:00, hourofday: 19, today: 0
              pvapifc: 28, pvaifc: -, pvfc: 28, aihit: 0, confc: 2101
              confcEx: 2101, DoN: 1, wid: 3, wcc: 79, rr1c: 0.00, temp=15.00
              rad1h: 20, sunaz: 257, sunalt: -3
              rrange: 0.00, crange: 80, correff: 0.60/0.00
NextHour34 => starttime: 2024-10-19 19:00:00, hourofday: 20, today: 0
              pvapifc: 0, pvaifc: -, pvfc: 0, aihit: 0, confc: 1071
              confcEx: 1071, DoN: 0, wid: 103, wcc: 83, rr1c: 0.00, temp=13.70
              rad1h: 0, sunaz: 269, sunalt: -12
              rrange: 0.00, crange: 85, correff: 1.00/-
NextHour35 => starttime: 2024-10-19 20:00:00, hourofday: 21, today: 0
              pvapifc: 0, pvaifc: -, pvfc: 0, aihit: 0, confc: 560
              confcEx: 560, DoN: 0, wid: 103, wcc: 82, rr1c: 0.00, temp=12.60
              rad1h: 0, sunaz: 280, sunalt: -22
              rrange: 0.00, crange: 80, correff: 1.00/-
NextHour36 => starttime: 2024-10-19 21:00:00, hourofday: 22, today: 0
              pvapifc: 0, pvaifc: -, pvfc: 0, aihit: 0, confc: 1629
              confcEx: 1629, DoN: 0, wid: 103, wcc: 81, rr1c: 0.00, temp=11.90
              rad1h: 0, sunaz: 293, sunalt: -32
              rrange: 0.00, crange: 80, correff: 1.00/-
NextHour37 => starttime: 2024-10-19 22:00:00, hourofday: 23, today: 0
              pvapifc: 0, pvaifc: -, pvfc: 0, aihit: 0, confc: 301
              confcEx: 301, DoN: 0, wid: 103, wcc: 81, rr1c: 0.00, temp=11.60
              rad1h: 0, sunaz: 308, sunalt: -40
              rrange: 0.00, crange: 80, correff: 1.00/-
NextHour38 => starttime: 2024-10-19 23:00:00, hourofday: 24, today: 0
              pvapifc: 0, pvaifc: -, pvfc: 0, aihit: 0, confc: 298
              confcEx: 298, DoN: -, wid: -, wcc: -, rr1c: -, temp=-
              rad1h: 0, sunaz: 326, sunalt: -47
              rrange: -, crange: 00, correff: 1.00/-

Gruß Reinhard

DS_Starter · 18 Oktober 2024, 10:00:52

Danke, sieht gut aus. Mir ging es um die Zeitstempel "starttime: 2024-10-XX".
Es sind sowohl die Zeiten 2024-10-18 als auch 2024-10-19 vorhanden. Damit müssen die Events auch wie vorgesehen erstellt werden.
Du loggst die Events mit DbLog oder Filelog?
Kannst du ein list des loggenden Devices noch posten? Vllt. fällt da noch etwas auf.

Rewe2000 · 18 Oktober 2024, 10:15:18

Ich hatte erst Filelog und habe dann auf DBLog umgestellt, da ich in SQL die Daten leichter "manipulieren" kann, wenn mal ein Chart nicht passt (z.B. ein Wert wegen event-on-change-reading fehlt).
Ein list von DBLog sende ich dir mit.

Gruß Reinhard

DS_Starter · 18 Oktober 2024, 16:11:06

Ich glaube ich weiß was das Thema ist. In meiner DB habe ich einen Primary Key gesetzt. Dadurch wird ein Loggen von mehreren Datensätzen mit identischen Datum, Device und Reading verhindert und es kommt zu keiner Dopplung am Folgetag.
Wenn du magst kannst du auch einen solchen Key setzen. Allerdings muß ich mal überlegen ob ich noch eine andere Lösung finde.

Grüße,
Heiko

DS_Starter · 18 Oktober 2024, 17:01:15

Eine sehr einfache Variante wäre ein DbRep zu benutzen und jeden Abend 23:00 einen Job laufen zu lassen der mit timestamp_begin=next_day_begin, timestamp_end=next_day_end alle Readings AllPVforecastsToEvent des Folgetages aus der DB löscht.
Damit gibt es keine doppelten Einträge mehr.
Das werde ich bei mir auch einbauen, da dadurch auch die Aktualität der initialen Forcast-Werte verbessert wird.

Rewe2000 · 20 Oktober 2024, 09:51:19

Hallo Heiko,

sorry, ich habe deine Antworten übersehen, die Mail über Antworten auf den Beitrag vom Fhem Forum hatte ich nicht erhalten.

Wenn die doppelten Daten vom SF Modul so in Ordnung sind, dann würde ich mir auch mit DBRep behelfen, um die doppelten Einträge wieder los zu werden. Das ist die einfachste Lösung um saubere Charts zu erhalten.
Ich gehe davon aus, dass du meine Mitschnitte vom EventMonitor und das Log vom DBLog nicht mehr benötigst?
Wenn doch, so gib mir kurz Bescheid, ich hatte die gestern Nacht noch erstellt.

Gruß Reinhard

DS_Starter · 20 Oktober 2024, 10:11:20

Moin Reinhard,

die Mitschnitte brauche ich nicht mehr zwingend, da mir der Zusammenhang klar geworden ist.
Das DbRep habe ich bei mir schon regelmäßig kurz vor Mitternacht eingeplant und tut was es soll.
Als Vorlage:

Code Auswählen

define Rep.Del.AllPVforecastsToEvent DbRep LogDBShort
attr Rep.Del.AllPVforecastsToEvent alias Löschen Readings AllPVforecastsToEvent des Folgetages
attr Rep.Del.AllPVforecastsToEvent comment ermöglicht dass die Readings AllPVforecastsToEvent am Folgetag wieder neu und aktuell geschrieben werden können
attr Rep.Del.AllPVforecastsToEvent devStateIcon initialized:control_3dot_hor_s connected:10px-kreis-gelb .*disconnect:10px-kreis-rot .*done:10px-kreis-gruen
attr Rep.Del.AllPVforecastsToEvent disable 0
attr Rep.Del.AllPVforecastsToEvent event-on-update-reading state
attr Rep.Del.AllPVforecastsToEvent icon edit_delete
attr Rep.Del.AllPVforecastsToEvent room Datenbank->Produktiv
attr Rep.Del.AllPVforecastsToEvent showproctime 1
attr Rep.Del.AllPVforecastsToEvent timestamp_begin next_day_begin
attr Rep.Del.AllPVforecastsToEvent timestamp_end next_day_end
attr Rep.Del.AllPVforecastsToEvent verbose 2

Da du dir die Arbeit aber schon gemacht hast, kannst du deine Mitschnitte gern noch posten einfach um nochmal die Bestätigung der Analyse zu bekommen.

Edit: ich ergänze noch das Wiki entsprechend.

Grüße,
Heiko

Rewe2000 · 20 Oktober 2024, 11:09:04

Hallo Heiko,

anbei wie gewünscht meine Mitschnitte von gestern Nacht, gekürzt auf Daten vom SolarForcast Device.

Fhem Log (DBLog verbose 4):

Code Auswählen

2024.10.20 00:06:00 4: DBLogging - ################################################################
2024.10.20 00:06:00 4: DBLogging - ###              start of new Logcycle                       ###
2024.10.20 00:06:00 4: DBLogging - ################################################################
2024.10.20 00:06:00 4: DBLogging - number of events received: 33 of device: SolarForecast
2024.10.20 00:06:00 4: DBLogging - check Device: SolarForecast , Event: nextCycletime: 00:07:10
2024.10.20 00:06:00 4: DBLogging - check Device: SolarForecast , Event: AllPVforecastsToEvent: 0 Wh
2024.10.20 00:06:00 4: DBLogging - added event - Timestamp: 2024-10-20 00:59:59, Device: SolarForecast, Type: SOLARFORECAST, Event: AllPVforecastsToEvent: 0 Wh, Reading: AllPVforecastsToEvent, Value: 0, Unit: Wh
2024.10.20 00:06:00 4: DBLogging - check Device: SolarForecast , Event: AllPVforecastsToEvent: 168 Wh
2024.10.20 00:06:00 4: DBLogging - added event - Timestamp: 2024-10-20 08:59:59, Device: SolarForecast, Type: SOLARFORECAST, Event: AllPVforecastsToEvent: 168 Wh, Reading: AllPVforecastsToEvent, Value: 168, Unit: Wh
2024.10.20 00:06:00 4: DBLogging - check Device: SolarForecast , Event: AllPVforecastsToEvent: 734 Wh
2024.10.20 00:06:00 4: DBLogging - added event - Timestamp: 2024-10-20 09:59:59, Device: SolarForecast, Type: SOLARFORECAST, Event: AllPVforecastsToEvent: 734 Wh, Reading: AllPVforecastsToEvent, Value: 734, Unit: Wh
2024.10.20 00:06:00 4: DBLogging - check Device: SolarForecast , Event: AllPVforecastsToEvent: 918 Wh
2024.10.20 00:06:00 4: DBLogging - added event - Timestamp: 2024-10-20 10:59:59, Device: SolarForecast, Type: SOLARFORECAST, Event: AllPVforecastsToEvent: 918 Wh, Reading: AllPVforecastsToEvent, Value: 918, Unit: Wh
2024.10.20 00:06:00 4: DBLogging - check Device: SolarForecast , Event: AllPVforecastsToEvent: 1085 Wh
2024.10.20 00:06:00 4: DBLogging - added event - Timestamp: 2024-10-20 11:59:59, Device: SolarForecast, Type: SOLARFORECAST, Event: AllPVforecastsToEvent: 1085 Wh, Reading: AllPVforecastsToEvent, Value: 1085, Unit: Wh
2024.10.20 00:06:00 4: DBLogging - check Device: SolarForecast , Event: AllPVforecastsToEvent: 1408 Wh
2024.10.20 00:06:00 4: DBLogging - added event - Timestamp: 2024-10-20 12:59:59, Device: SolarForecast, Type: SOLARFORECAST, Event: AllPVforecastsToEvent: 1408 Wh, Reading: AllPVforecastsToEvent, Value: 1408, Unit: Wh
2024.10.20 00:06:00 4: DBLogging - check Device: SolarForecast , Event: AllPVforecastsToEvent: 3450 Wh
2024.10.20 00:06:00 4: DBLogging - added event - Timestamp: 2024-10-20 13:59:59, Device: SolarForecast, Type: SOLARFORECAST, Event: AllPVforecastsToEvent: 3450 Wh, Reading: AllPVforecastsToEvent, Value: 3450, Unit: Wh
2024.10.20 00:06:00 4: DBLogging - check Device: SolarForecast , Event: AllPVforecastsToEvent: 2925 Wh
2024.10.20 00:06:00 4: DBLogging - added event - Timestamp: 2024-10-20 14:59:59, Device: SolarForecast, Type: SOLARFORECAST, Event: AllPVforecastsToEvent: 2925 Wh, Reading: AllPVforecastsToEvent, Value: 2925, Unit: Wh
2024.10.20 00:06:00 4: DBLogging - check Device: SolarForecast , Event: AllPVforecastsToEvent: 1252 Wh
2024.10.20 00:06:00 4: DBLogging - added event - Timestamp: 2024-10-20 15:59:59, Device: SolarForecast, Type: SOLARFORECAST, Event: AllPVforecastsToEvent: 1252 Wh, Reading: AllPVforecastsToEvent, Value: 1252, Unit: Wh
2024.10.20 00:06:00 4: DBLogging - check Device: SolarForecast , Event: AllPVforecastsToEvent: 912 Wh
2024.10.20 00:06:00 4: DBLogging - added event - Timestamp: 2024-10-20 16:59:59, Device: SolarForecast, Type: SOLARFORECAST, Event: AllPVforecastsToEvent: 912 Wh, Reading: AllPVforecastsToEvent, Value: 912, Unit: Wh
2024.10.20 00:06:00 4: DBLogging - check Device: SolarForecast , Event: AllPVforecastsToEvent: 444 Wh
2024.10.20 00:06:00 4: DBLogging - added event - Timestamp: 2024-10-20 17:59:59, Device: SolarForecast, Type: SOLARFORECAST, Event: AllPVforecastsToEvent: 444 Wh, Reading: AllPVforecastsToEvent, Value: 444, Unit: Wh
2024.10.20 00:06:00 4: DBLogging - check Device: SolarForecast , Event: AllPVforecastsToEvent: 10 Wh
2024.10.20 00:06:00 4: DBLogging - added event - Timestamp: 2024-10-20 18:59:59, Device: SolarForecast, Type: SOLARFORECAST, Event: AllPVforecastsToEvent: 10 Wh, Reading: AllPVforecastsToEvent, Value: 10, Unit: Wh
2024.10.20 00:06:00 4: DBLogging - check Device: SolarForecast , Event: AllPVforecastsToEvent: 0 Wh
2024.10.20 00:06:00 4: DBLogging - added event - Timestamp: 2024-10-20 19:59:59, Device: SolarForecast, Type: SOLARFORECAST, Event: AllPVforecastsToEvent: 0 Wh, Reading: AllPVforecastsToEvent, Value: 0, Unit: Wh
2024.10.20 00:06:00 4: DBLogging - check Device: SolarForecast , Event: AllPVforecastsToEvent: 144 Wh
2024.10.20 00:06:00 4: DBLogging - added event - Timestamp: 2024-10-21 08:59:59, Device: SolarForecast, Type: SOLARFORECAST, Event: AllPVforecastsToEvent: 144 Wh, Reading: AllPVforecastsToEvent, Value: 144, Unit: Wh
2024.10.20 00:06:00 4: DBLogging - check Device: SolarForecast , Event: AllPVforecastsToEvent: 652 Wh
2024.10.20 00:06:00 4: DBLogging - added event - Timestamp: 2024-10-21 09:59:59, Device: SolarForecast, Type: SOLARFORECAST, Event: AllPVforecastsToEvent: 652 Wh, Reading: AllPVforecastsToEvent, Value: 652, Unit: Wh
2024.10.20 00:06:00 4: DBLogging - check Device: SolarForecast , Event: AllPVforecastsToEvent: 789 Wh
2024.10.20 00:06:00 4: DBLogging - added event - Timestamp: 2024-10-21 10:59:59, Device: SolarForecast, Type: SOLARFORECAST, Event: AllPVforecastsToEvent: 789 Wh, Reading: AllPVforecastsToEvent, Value: 789, Unit: Wh
2024.10.20 00:06:00 4: DBLogging - check Device: SolarForecast , Event: AllPVforecastsToEvent: 1118 Wh
2024.10.20 00:06:00 4: DBLogging - added event - Timestamp: 2024-10-21 11:59:59, Device: SolarForecast, Type: SOLARFORECAST, Event: AllPVforecastsToEvent: 1118 Wh, Reading: AllPVforecastsToEvent, Value: 1118, Unit: Wh
2024.10.20 00:06:00 4: DBLogging - check Device: SolarForecast , Event: AllPVforecastsToEvent: 1156 Wh
2024.10.20 00:06:00 4: DBLogging - added event - Timestamp: 2024-10-21 12:59:59, Device: SolarForecast, Type: SOLARFORECAST, Event: AllPVforecastsToEvent: 1156 Wh, Reading: AllPVforecastsToEvent, Value: 1156, Unit: Wh
2024.10.20 00:06:00 4: DBLogging - check Device: SolarForecast , Event: AllPVforecastsToEvent: 2713 Wh
2024.10.20 00:06:00 4: DBLogging - added event - Timestamp: 2024-10-21 13:59:59, Device: SolarForecast, Type: SOLARFORECAST, Event: AllPVforecastsToEvent: 2713 Wh, Reading: AllPVforecastsToEvent, Value: 2713, Unit: Wh
2024.10.20 00:06:00 4: DBLogging - check Device: SolarForecast , Event: AllPVforecastsToEvent: 2992 Wh
2024.10.20 00:06:00 4: DBLogging - added event - Timestamp: 2024-10-21 14:59:59, Device: SolarForecast, Type: SOLARFORECAST, Event: AllPVforecastsToEvent: 2992 Wh, Reading: AllPVforecastsToEvent, Value: 2992, Unit: Wh
2024.10.20 00:06:00 4: DBLogging - check Device: SolarForecast , Event: AllPVforecastsToEvent: 1323 Wh
2024.10.20 00:06:00 4: DBLogging - added event - Timestamp: 2024-10-21 15:59:59, Device: SolarForecast, Type: SOLARFORECAST, Event: AllPVforecastsToEvent: 1323 Wh, Reading: AllPVforecastsToEvent, Value: 1323, Unit: Wh
2024.10.20 00:06:00 4: DBLogging - check Device: SolarForecast , Event: AllPVforecastsToEvent: 892 Wh
2024.10.20 00:06:00 4: DBLogging - added event - Timestamp: 2024-10-21 16:59:59, Device: SolarForecast, Type: SOLARFORECAST, Event: AllPVforecastsToEvent: 892 Wh, Reading: AllPVforecastsToEvent, Value: 892, Unit: Wh
2024.10.20 00:06:00 4: DBLogging - check Device: SolarForecast , Event: AllPVforecastsToEvent: 397 Wh
2024.10.20 00:06:00 4: DBLogging - added event - Timestamp: 2024-10-21 17:59:59, Device: SolarForecast, Type: SOLARFORECAST, Event: AllPVforecastsToEvent: 397 Wh, Reading: AllPVforecastsToEvent, Value: 397, Unit: Wh
2024.10.20 00:06:00 4: DBLogging - check Device: SolarForecast , Event: AllPVforecastsToEvent: 28 Wh
2024.10.20 00:06:00 4: DBLogging - added event - Timestamp: 2024-10-21 18:59:59, Device: SolarForecast, Type: SOLARFORECAST, Event: AllPVforecastsToEvent: 28 Wh, Reading: AllPVforecastsToEvent, Value: 28, Unit: Wh
2024.10.20 00:06:00 4: DBLogging - check Device: SolarForecast , Event: AllPVforecastsToEvent: 0 Wh
2024.10.20 00:06:00 4: DBLogging - added event - Timestamp: 2024-10-21 19:59:59, Device: SolarForecast, Type: SOLARFORECAST, Event: AllPVforecastsToEvent: 0 Wh, Reading: AllPVforecastsToEvent, Value: 0, Unit: Wh
2024.10.20 00:06:00 4: DBLogging - check Device: SolarForecast , Event: Current_GridFeedIn: 2 W
2024.10.20 00:06:00 4: DBLogging - check Device: SolarForecast , Event: Today_Hour01_BatOut: 36 Wh
2024.10.20 00:06:00 4: DBLogging - check Device: SolarForecast , Event: Current_PowerBatOut: -339 W
2024.10.20 00:06:00 4: DBLogging - check Device: SolarForecast , Event: Current_Consumption: -341 W
2024.10.20 00:06:00 4: DBLogging - check Device: SolarForecast , Event: Current_Surplus: 341 W
2024.10.20 00:06:00 4: DBLogging - check Device: SolarForecast , Event: NextHours_Sum04_ConsumptionForecast: 977 Wh
2024.10.20 00:06:00 4: DBLogging - check Device: SolarForecast , Event: RestOfDayConsumptionForecast: 22051 Wh

EventMonitor SolarForecast:

Code Auswählen

2024-10-20 00:04:51 SolarForecast SolarForecast updated
2024-10-20 00:06:00 SolarForecast SolarForecast nextCycletime: 00:07:10
2024-10-20 00:59:59 SolarForecast SolarForecast AllPVforecastsToEvent: 0 Wh
2024-10-20 08:59:59 SolarForecast SolarForecast AllPVforecastsToEvent: 168 Wh
2024-10-20 09:59:59 SolarForecast SolarForecast AllPVforecastsToEvent: 734 Wh
2024-10-20 10:59:59 SolarForecast SolarForecast AllPVforecastsToEvent: 918 Wh
2024-10-20 11:59:59 SolarForecast SolarForecast AllPVforecastsToEvent: 1085 Wh
2024-10-20 12:59:59 SolarForecast SolarForecast AllPVforecastsToEvent: 1408 Wh
2024-10-20 13:59:59 SolarForecast SolarForecast AllPVforecastsToEvent: 3450 Wh
2024-10-20 14:59:59 SolarForecast SolarForecast AllPVforecastsToEvent: 2925 Wh
2024-10-20 15:59:59 SolarForecast SolarForecast AllPVforecastsToEvent: 1252 Wh
2024-10-20 16:59:59 SolarForecast SolarForecast AllPVforecastsToEvent: 912 Wh
2024-10-20 17:59:59 SolarForecast SolarForecast AllPVforecastsToEvent: 444 Wh
2024-10-20 18:59:59 SolarForecast SolarForecast AllPVforecastsToEvent: 10 Wh
2024-10-20 19:59:59 SolarForecast SolarForecast AllPVforecastsToEvent: 0 Wh
2024-10-21 08:59:59 SolarForecast SolarForecast AllPVforecastsToEvent: 144 Wh
2024-10-21 09:59:59 SolarForecast SolarForecast AllPVforecastsToEvent: 652 Wh
2024-10-21 10:59:59 SolarForecast SolarForecast AllPVforecastsToEvent: 789 Wh
2024-10-21 11:59:59 SolarForecast SolarForecast AllPVforecastsToEvent: 1118 Wh
2024-10-21 12:59:59 SolarForecast SolarForecast AllPVforecastsToEvent: 1156 Wh
2024-10-21 13:59:59 SolarForecast SolarForecast AllPVforecastsToEvent: 2713 Wh
2024-10-21 14:59:59 SolarForecast SolarForecast AllPVforecastsToEvent: 2992 Wh
2024-10-21 15:59:59 SolarForecast SolarForecast AllPVforecastsToEvent: 1323 Wh
2024-10-21 16:59:59 SolarForecast SolarForecast AllPVforecastsToEvent: 892 Wh
2024-10-21 17:59:59 SolarForecast SolarForecast AllPVforecastsToEvent: 397 Wh
2024-10-21 18:59:59 SolarForecast SolarForecast AllPVforecastsToEvent: 28 Wh
2024-10-21 19:59:59 SolarForecast SolarForecast AllPVforecastsToEvent: 0 Wh
2024-10-20 00:06:00 SolarForecast SolarForecast Current_GridFeedIn: 2 W
2024-10-20 00:06:00 SolarForecast SolarForecast Today_Hour01_BatOut: 36 Wh
2024-10-20 00:06:00 SolarForecast SolarForecast Current_PowerBatOut: -339 W
2024-10-20 00:06:00 SolarForecast SolarForecast Current_Consumption: -341 W
2024-10-20 00:06:00 SolarForecast SolarForecast Current_Surplus: 341 W
2024-10-20 00:06:00 SolarForecast SolarForecast NextHours_Sum04_ConsumptionForecast: 977 Wh
2024-10-20 00:06:00 SolarForecast SolarForecast RestOfDayConsumptionForecast: 22051 Wh
2024-10-20 00:06:01 SolarForecast SolarForecast updated

List DBLog:

Code Auswählen

Internals:
   COLUMNS    field length used for Device: 64, Type: 64, Event: 512, Reading: 64, Value: 128, Unit: 32 
   CONFIGURATION /opt/fhem/contrib/dblog/db.conf
   DEF        /opt/fhem/contrib/dblog/db.conf .*:.*
   FD         5
   FUUID      5c47772d-f33f-7df9-7675-adaeb281cfff3526
   FVERSION   93_DbLog.pm:v5.10.2-s29036/2024-07-21
   MODE       asynchronous
   MODEL      MYSQL
   NAME       DBLogging
   NR         2
   NTFY_ORDER 50-DBLogging
   PID        518445
   REGEXP     .*:.*
   SBP_PID    518446
   SBP_STATE  running
   STATE      connected
   TYPE       DbLog
   UTF8       1
   dbconn     mysql:database=fhem;host=192.168.50.37;port=3306
   dbuser     Reinhard
   eventCount 609
   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.10.2
   OLDREADINGS:
   READINGS:
     2024-10-20 11:03:42   CacheOverflowLastNum 0
     2023-11-28 10:18:15   CacheOverflowLastState normal
     2024-10-20 11:03:45   CacheUsage      2
     2024-10-20 11:03:42   NextSync        2024-10-20 11:04:12 or when CacheUsage 500 is reached
     2024-10-20 11:03:42   background_processing_time 0.0154
     2024-10-20 11:03:42   sql_processing_time 0.0111
     2024-10-20 11:03:42   state           connected
     2021-01-04 16:13:47   userCommand     SELECT COUNT(*)
   hmccu:
Attributes:
   DbLogExclude .*
   DbLogSelectionMode Exclude/Include
   DbLogType  History
   asyncMode  1
   cacheEvents 2
   comment    Dieses ist das aktuelle Logdevice, welches die Daten in die SQL-Datenbank schreibt.
   devStateIcon connected:it_network .*disconnect:control_home .*done:general_ok running:refresh
   event-on-update-reading state.*
   excludeDevs TYPE=at
   group      Hardware
   icon       system_backup
   insertMode 1
   room       Logging
   showproctime 1
   verbose    2

Melde dich einfach wenn etwas fehlt, was du noch gebraucht hättest, ich würde dann die kompletten Daten in die Cloud legen, da diese doch sehr umfangreich sind.

Ich habe nun das Löschen der Daten mit einem DBRep und einem at angelegt, ab morgen sollten die Daten dann passen.

Vielen Dank für die Hilfe
Gruß Reinhard

DS_Starter · 20 Oktober 2024, 14:09:03

Ja, danke. Das bestätigt meine Erkenntnisse.
Den Abschnitt im Wiki habe ich ergänzt.

LG