Modul 93_DbRep - Reporting und Management von Datenbankinhalten (DbLog)

DS_Starter · 06 Februar 2018, 19:14:57

Also es hat tatsächlich etwas mit den Millisekunden zu tun. Wenn ich 23:59:59.999 ergänze wird der Datensatz auch bei exportToFile mit selektiert. Mir ist aber absolut nicht klar womit das zusammenhängen könnte da das Statement von fetchrows gleich ist und dort auch so funktioniert.
Ich muss mal schauen wie ich das eingebaut bekomme damit es auch bei Postgre/Sqlite keine Probleme gibt.

knxler · 06 Februar 2018, 19:22:44

Hallo Heiko,

fetchrows funktioniert auch bei mir.
Das ist dann aber wirklich komisch.
Wenn ich dir irgendwie helfen kann lass es mich wissen.

Grüße

DS_Starter · 06 Februar 2018, 22:07:39

Hallo Martin,

das hat jetzt eine Weile gedauert bis ich das Problem identifizieren konnte. Das hatte etwas damit zu tun wie ich mit Platzhaltern in SQL-Staements umgehe.
Habe auch schon viel getestet und sieht gut aus.
Die Version 7.8.1 im ersten Beitrag habe ich erneut nochgeladen.

Probier es mal bitte bei dir aus.

LG,
Heiko

knxler · 07 Februar 2018, 19:28:49

Hallo Heiko,

leider habe ich erst jetzt Zeit gefunden deine neue Version zu testen.
Leider ist der Fehler aber immer noch da. Der letzte Datensatz fehlt.

Gruß Martin

DS_Starter · 07 Februar 2018, 20:11:04

Hi Martin,

habe es gerade bei nochmal ausgeführt. Funktioniert prima...

Code Auswählen


"2018-02-05 00:04:18","MyWetter","WEATHER","temperature: -3","temperature","-3","C"
"2018-02-05 00:14:19","MyWetter","WEATHER","temperature: -3","temperature","-3","C"
"2018-02-05 00:24:20","MyWetter","WEATHER","temperature: -3","temperature","-3","C"
"2018-02-05 00:34:21","MyWetter","WEATHER","temperature: -3","temperature","-3","C"
"2018-02-05 00:44:21","MyWetter","WEATHER","temperature: -3","temperature","-3","C"
"2018-02-05 00:54:22","MyWetter","WEATHER","temperature: -3","temperature","-3","C"
"2018-02-05 01:04:23","MyWetter","WEATHER","temperature: -3","temperature","-3","C"
"2018-02-05 01:14:24","MyWetter","WEATHER","temperature: -3","temperature","-3","C"
"2018-02-05 01:24:25","MyWetter","WEATHER","temperature: -3","temperature","-3","C"
"2018-02-05 01:34:25","MyWetter","WEATHER","temperature: -3","temperature","-3","C"
"2018-02-05 01:44:26","MyWetter","WEATHER","temperature: -3","temperature","-3","C"
"2018-02-05 01:54:27","MyWetter","WEATHER","temperature: -3","temperature","-3","C"
"2018-02-05 02:04:28","MyWetter","WEATHER","temperature: -3","temperature","-3","C"
"2018-02-05 02:14:29","MyWetter","WEATHER","temperature: -3","temperature","-3","C"
"2018-02-05 02:24:29","MyWetter","WEATHER","temperature: -3","temperature","-3","C"
"2018-02-05 02:34:30","MyWetter","WEATHER","temperature: -3","temperature","-3","C"
"2018-02-05 02:44:31","MyWetter","WEATHER","temperature: -3","temperature","-3","C"
"2018-02-05 02:54:32","MyWetter","WEATHER","temperature: -3","temperature","-3","C"
"2018-02-05 03:04:33","MyWetter","WEATHER","temperature: -3","temperature","-3","C"
"2018-02-05 03:14:33","MyWetter","WEATHER","temperature: -3","temperature","-3","C"
"2018-02-05 03:24:34","MyWetter","WEATHER","temperature: -3","temperature","-3","C"
"2018-02-05 03:34:35","MyWetter","WEATHER","temperature: -3","temperature","-3","C"
"2018-02-05 03:44:36","MyWetter","WEATHER","temperature: -2","temperature","-2","C"
"2018-02-05 03:54:37","MyWetter","WEATHER","temperature: -2","temperature","-2","C"
"2018-02-05 04:04:37","MyWetter","WEATHER","temperature: -2","temperature","-2","C"
"2018-02-05 04:14:38","MyWetter","WEATHER","temperature: -2","temperature","-2","C"
"2018-02-05 04:24:39","MyWetter","WEATHER","temperature: -2","temperature","-2","C"
"2018-02-05 04:34:40","MyWetter","WEATHER","temperature: -2","temperature","-2","C"
"2018-02-05 04:44:40","MyWetter","WEATHER","temperature: -2","temperature","-2","C"
"2018-02-05 04:54:41","MyWetter","WEATHER","temperature: -2","temperature","-2","C"
"2018-02-05 05:04:42","MyWetter","WEATHER","temperature: -2","temperature","-2","C"
"2018-02-05 05:14:43","MyWetter","WEATHER","temperature: -2","temperature","-2","C"
"2018-02-05 05:24:44","MyWetter","WEATHER","temperature: -2","temperature","-2","C"
"2018-02-05 05:34:44","MyWetter","WEATHER","temperature: -2","temperature","-2","C"
"2018-02-05 05:44:45","MyWetter","WEATHER","temperature: -2","temperature","-2","C"
"2018-02-05 05:54:46","MyWetter","WEATHER","temperature: -2","temperature","-2","C"
"2018-02-05 06:04:47","MyWetter","WEATHER","temperature: -2","temperature","-2","C"
"2018-02-05 06:14:48","MyWetter","WEATHER","temperature: -2","temperature","-2","C"
"2018-02-05 06:24:48","MyWetter","WEATHER","temperature: -2","temperature","-2","C"
"2018-02-05 06:34:49","MyWetter","WEATHER","temperature: -2","temperature","-2","C"
"2018-02-05 06:44:50","MyWetter","WEATHER","temperature: -1","temperature","-1","C"
"2018-02-05 06:54:51","MyWetter","WEATHER","temperature: -1","temperature","-1","C"
"2018-02-05 07:04:52","MyWetter","WEATHER","temperature: -1","temperature","-1","C"
"2018-02-05 07:14:52","MyWetter","WEATHER","temperature: -1","temperature","-1","C"
"2018-02-05 07:24:53","MyWetter","WEATHER","temperature: -1","temperature","-1","C"
"2018-02-05 07:34:54","MyWetter","WEATHER","temperature: -1","temperature","-1","C"
"2018-02-05 07:44:55","MyWetter","WEATHER","temperature: 0","temperature","0","C"
"2018-02-05 07:54:56","MyWetter","WEATHER","temperature: 0","temperature","0","C"
"2018-02-05 08:04:56","MyWetter","WEATHER","temperature: 0","temperature","0","C"
"2018-02-05 08:14:57","MyWetter","WEATHER","temperature: 0","temperature","0","C"
"2018-02-05 08:24:58","MyWetter","WEATHER","temperature: 0","temperature","0","C"
"2018-02-05 08:34:59","MyWetter","WEATHER","temperature: 0","temperature","0","C"
"2018-02-05 08:45:00","MyWetter","WEATHER","temperature: -1","temperature","-1","C"
"2018-02-05 08:55:00","MyWetter","WEATHER","temperature: -1","temperature","-1","C"
"2018-02-05 09:05:02","MyWetter","WEATHER","temperature: -1","temperature","-1","C"
"2018-02-05 09:15:03","MyWetter","WEATHER","temperature: -1","temperature","-1","C"
"2018-02-05 09:25:04","MyWetter","WEATHER","temperature: -1","temperature","-1","C"
"2018-02-05 09:35:04","MyWetter","WEATHER","temperature: -1","temperature","-1","C"
"2018-02-05 09:45:05","MyWetter","WEATHER","temperature: 0","temperature","0","C"
"2018-02-05 09:55:06","MyWetter","WEATHER","temperature: 0","temperature","0","C"
"2018-02-05 10:05:07","MyWetter","WEATHER","temperature: 0","temperature","0","C"
"2018-02-05 10:15:07","MyWetter","WEATHER","temperature: 0","temperature","0","C"
"2018-02-05 10:25:08","MyWetter","WEATHER","temperature: 0","temperature","0","C"
"2018-02-05 10:35:09","MyWetter","WEATHER","temperature: 0","temperature","0","C"
"2018-02-05 10:45:10","MyWetter","WEATHER","temperature: -2","temperature","-2","C"
"2018-02-05 10:55:10","MyWetter","WEATHER","temperature: -2","temperature","-2","C"
"2018-02-05 11:05:11","MyWetter","WEATHER","temperature: -2","temperature","-2","C"
"2018-02-05 11:15:12","MyWetter","WEATHER","temperature: -2","temperature","-2","C"
"2018-02-05 11:25:12","MyWetter","WEATHER","temperature: -2","temperature","-2","C"
"2018-02-05 11:35:13","MyWetter","WEATHER","temperature: -2","temperature","-2","C"
"2018-02-05 11:45:14","MyWetter","WEATHER","temperature: -2","temperature","-2","C"
"2018-02-05 11:55:15","MyWetter","WEATHER","temperature: -2","temperature","-2","C"
"2018-02-05 12:05:15","MyWetter","WEATHER","temperature: -2","temperature","-2","C"
"2018-02-05 12:15:16","MyWetter","WEATHER","temperature: -2","temperature","-2","C"
"2018-02-05 12:25:17","MyWetter","WEATHER","temperature: -2","temperature","-2","C"
"2018-02-05 12:35:17","MyWetter","WEATHER","temperature: -2","temperature","-2","C"
"2018-02-05 12:45:18","MyWetter","WEATHER","temperature: -1","temperature","-1","C"
"2018-02-05 12:55:19","MyWetter","WEATHER","temperature: -1","temperature","-1","C"
"2018-02-05 13:05:20","MyWetter","WEATHER","temperature: -1","temperature","-1","C"
"2018-02-05 13:15:20","MyWetter","WEATHER","temperature: -1","temperature","-1","C"
"2018-02-05 13:25:21","MyWetter","WEATHER","temperature: -1","temperature","-1","C"
"2018-02-05 13:35:22","MyWetter","WEATHER","temperature: -1","temperature","-1","C"
"2018-02-05 13:45:23","MyWetter","WEATHER","temperature: -1","temperature","-1","C"
"2018-02-05 13:55:23","MyWetter","WEATHER","temperature: -1","temperature","-1","C"
"2018-02-05 14:05:24","MyWetter","WEATHER","temperature: -1","temperature","-1","C"
"2018-02-05 14:15:25","MyWetter","WEATHER","temperature: -1","temperature","-1","C"
"2018-02-05 14:25:25","MyWetter","WEATHER","temperature: -1","temperature","-1","C"
"2018-02-05 14:35:26","MyWetter","WEATHER","temperature: 0","temperature","0","C"
"2018-02-05 14:45:27","MyWetter","WEATHER","temperature: 0","temperature","0","C"
"2018-02-05 14:55:28","MyWetter","WEATHER","temperature: 0","temperature","0","C"
"2018-02-05 15:05:28","MyWetter","WEATHER","temperature: 0","temperature","0","C"
"2018-02-05 15:15:29","MyWetter","WEATHER","temperature: 0","temperature","0","C"
"2018-02-05 15:25:30","MyWetter","WEATHER","temperature: 0","temperature","0","C"
"2018-02-05 15:35:30","MyWetter","WEATHER","temperature: 0","temperature","0","C"
"2018-02-05 15:45:31","MyWetter","WEATHER","temperature: 0","temperature","0","C"
"2018-02-05 15:55:32","MyWetter","WEATHER","temperature: 0","temperature","0","C"
"2018-02-05 16:05:33","MyWetter","WEATHER","temperature: 0","temperature","0","C"
"2018-02-05 16:15:33","MyWetter","WEATHER","temperature: 0","temperature","0","C"
"2018-02-05 16:25:34","MyWetter","WEATHER","temperature: 0","temperature","0","C"
"2018-02-05 16:35:35","MyWetter","WEATHER","temperature: 0","temperature","0","C"
"2018-02-05 16:45:36","MyWetter","WEATHER","temperature: 0","temperature","0","C"
"2018-02-05 16:55:36","MyWetter","WEATHER","temperature: 0","temperature","0","C"
"2018-02-05 17:05:37","MyWetter","WEATHER","temperature: 0","temperature","0","C"
"2018-02-05 17:15:38","MyWetter","WEATHER","temperature: 0","temperature","0","C"
"2018-02-05 17:25:39","MyWetter","WEATHER","temperature: 0","temperature","0","C"
"2018-02-05 17:35:39","MyWetter","WEATHER","temperature: 0","temperature","0","C"
"2018-02-05 17:45:40","MyWetter","WEATHER","temperature: 0","temperature","0","C"
"2018-02-05 17:55:41","MyWetter","WEATHER","temperature: 0","temperature","0","C"
"2018-02-05 18:05:41","MyWetter","WEATHER","temperature: 0","temperature","0","C"
"2018-02-05 18:15:42","MyWetter","WEATHER","temperature: 0","temperature","0","C"
"2018-02-05 18:25:43","MyWetter","WEATHER","temperature: 0","temperature","0","C"
"2018-02-05 18:35:44","MyWetter","WEATHER","temperature: 0","temperature","0","C"
"2018-02-05 18:45:44","MyWetter","WEATHER","temperature: -1","temperature","-1","C"
"2018-02-05 18:55:45","MyWetter","WEATHER","temperature: -1","temperature","-1","C"
"2018-02-05 19:05:46","MyWetter","WEATHER","temperature: -1","temperature","-1","C"
"2018-02-05 19:15:47","MyWetter","WEATHER","temperature: -1","temperature","-1","C"
"2018-02-05 19:25:47","MyWetter","WEATHER","temperature: -1","temperature","-1","C"
"2018-02-05 19:35:48","MyWetter","WEATHER","temperature: -2","temperature","-2","C"
"2018-02-05 19:45:49","MyWetter","WEATHER","temperature: -2","temperature","-2","C"
"2018-02-05 19:55:49","MyWetter","WEATHER","temperature: -2","temperature","-2","C"
"2018-02-05 20:05:50","MyWetter","WEATHER","temperature: -2","temperature","-2","C"
"2018-02-05 20:15:51","MyWetter","WEATHER","temperature: -2","temperature","-2","C"
"2018-02-05 20:25:52","MyWetter","WEATHER","temperature: -2","temperature","-2","C"
"2018-02-05 20:35:52","MyWetter","WEATHER","temperature: -2","temperature","-2","C"
"2018-02-05 20:45:53","MyWetter","WEATHER","temperature: -3","temperature","-3","C"
"2018-02-05 20:55:54","MyWetter","WEATHER","temperature: -3","temperature","-3","C"
"2018-02-05 21:05:55","MyWetter","WEATHER","temperature: -3","temperature","-3","C"
"2018-02-05 21:15:55","MyWetter","WEATHER","temperature: -3","temperature","-3","C"
"2018-02-05 21:25:56","MyWetter","WEATHER","temperature: -3","temperature","-3","C"
"2018-02-05 21:35:57","MyWetter","WEATHER","temperature: -3","temperature","-3","C"
"2018-02-05 21:45:58","MyWetter","WEATHER","temperature: -2","temperature","-2","C"
"2018-02-05 21:55:58","MyWetter","WEATHER","temperature: -2","temperature","-2","C"
"2018-02-05 22:05:59","MyWetter","WEATHER","temperature: -2","temperature","-2","C"
"2018-02-05 22:16:00","MyWetter","WEATHER","temperature: -2","temperature","-2","C"
"2018-02-05 22:26:01","MyWetter","WEATHER","temperature: -2","temperature","-2","C"
"2018-02-05 22:36:01","MyWetter","WEATHER","temperature: -2","temperature","-2","C"
"2018-02-05 22:46:02","MyWetter","WEATHER","temperature: -3","temperature","-3","C"
"2018-02-05 22:56:03","MyWetter","WEATHER","temperature: -3","temperature","-3","C"
"2018-02-05 23:06:04","MyWetter","WEATHER","temperature: -3","temperature","-3","C"
"2018-02-05 23:16:04","MyWetter","WEATHER","temperature: -3","temperature","-3","C"
"2018-02-05 23:26:05","MyWetter","WEATHER","temperature: -3","temperature","-3","C"
"2018-02-05 23:36:06","MyWetter","WEATHER","temperature: -3","temperature","-3","C"
"2018-02-05 23:46:07","MyWetter","WEATHER","temperature: -5","temperature","-5","C"
"2018-02-05 23:56:07","MyWetter","WEATHER","temperature: -5","temperature","-5","C"
"2018-02-05 23:59:59","MyWetter","WEATHER","temperature: -6","temperature","-6","C"

Mach mir mal bitte ein List von deinem DbRep-Device.
Jetzt fällt mir wirklich langsam nichts mehr ein.

Grüße
Heiko

knxler · 07 Februar 2018, 20:35:15

Hallo Heiko,

hier mein list.

Gruß

DS_Starter · 07 Februar 2018, 20:56:08

List ist ok. Ich habe dir ein verbose 5 Log von mir angehängt zum Vergleich.
Schau mal ob du irgendetwas siehst was dir auffält im Unterschied zu deinem Log.

Code Auswählen


2018.02.07 20:53:12.888 4: DbRep Rep.LogDB1 - -------- New selection --------- 
2018.02.07 20:53:12.890 4: DbRep Rep.LogDB1 - Command: exportToFile 
2018.02.07 20:53:12.892 5: DbRep Rep.LogDB1 - Timestamp begin epocheseconds: 1517785200
2018.02.07 20:53:12.893 4: DbRep Rep.LogDB1 - Timestamp begin human readable: 2018-02-05 00:00:00
2018.02.07 20:53:12.894 5: DbRep Rep.LogDB1 - Timestamp end epocheseconds: 1517871599
2018.02.07 20:53:12.895 4: DbRep Rep.LogDB1 - Timestamp end human readable: 2018-02-05 23:59:59
2018.02.07 20:53:12.896 5: DbRep Rep.LogDB1 - weekday of start for selection: Mo  ->  wdadd: 604800
2018.02.07 20:53:12.897 4: DbRep Rep.LogDB1 - Aggregation: no
2018.02.07 20:53:12.909 4: DbRep Rep.LogDB1 -> Start BlockingCall expfile_DoParse
2018.02.07 20:53:12.916 5: DbRep Rep.LogDB1 - IsTimeSet: 1, IsAggrSet: 0
2018.02.07 20:53:12.917 5: DbRep Rep.LogDB1 - Timestamp-Array: 
no_aggregation#2018-02-05 00:00:00#2018-02-05 23:59:59
2018.02.07 20:53:12.918 5: DbRep Rep.LogDB1 - Device specifications use for select: MyWetter
2018.02.07 20:53:12.920 5: DbRep Rep.LogDB1 - Reading specification use for select: temperature
2018.02.07 20:53:12.921 5: DbRep Rep.LogDB1 - Device specifications use for select: MyWetter
2018.02.07 20:53:12.922 5: DbRep Rep.LogDB1 - Reading specification use for select: temperature
2018.02.07 20:53:12.923 4: DbRep Rep.LogDB1 - SQL execute: SELECT TIMESTAMP,DEVICE,TYPE,EVENT,READING,VALUE,UNIT FROM history where DEVICE = 'MyWetter' AND READING = 'temperature' AND TIMESTAMP >= '2018-02-05 00:00:00' AND TIMESTAMP <= '2018-02-05 23:59:59' ORDER BY TIMESTAMP;
2018.02.07 20:53:12.931 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 00:04:18 MyWetter WEATHER temperature: -3 temperature -3 �C
2018.02.07 20:53:12.932 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 00:14:19 MyWetter WEATHER temperature: -3 temperature -3 �C
2018.02.07 20:53:12.933 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 00:24:20 MyWetter WEATHER temperature: -3 temperature -3 �C
2018.02.07 20:53:12.934 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 00:34:21 MyWetter WEATHER temperature: -3 temperature -3 �C
2018.02.07 20:53:12.935 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 00:44:21 MyWetter WEATHER temperature: -3 temperature -3 �C
2018.02.07 20:53:12.935 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 00:54:22 MyWetter WEATHER temperature: -3 temperature -3 �C
2018.02.07 20:53:12.936 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 01:04:23 MyWetter WEATHER temperature: -3 temperature -3 �C
2018.02.07 20:53:12.937 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 01:14:24 MyWetter WEATHER temperature: -3 temperature -3 �C
2018.02.07 20:53:12.937 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 01:24:25 MyWetter WEATHER temperature: -3 temperature -3 �C
2018.02.07 20:53:12.938 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 01:34:25 MyWetter WEATHER temperature: -3 temperature -3 �C
2018.02.07 20:53:12.939 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 01:44:26 MyWetter WEATHER temperature: -3 temperature -3 �C
2018.02.07 20:53:12.939 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 01:54:27 MyWetter WEATHER temperature: -3 temperature -3 �C
2018.02.07 20:53:12.940 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 02:04:28 MyWetter WEATHER temperature: -3 temperature -3 �C
2018.02.07 20:53:12.941 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 02:14:29 MyWetter WEATHER temperature: -3 temperature -3 �C
2018.02.07 20:53:12.941 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 02:24:29 MyWetter WEATHER temperature: -3 temperature -3 �C
2018.02.07 20:53:12.942 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 02:34:30 MyWetter WEATHER temperature: -3 temperature -3 �C
2018.02.07 20:53:12.943 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 02:44:31 MyWetter WEATHER temperature: -3 temperature -3 �C
2018.02.07 20:53:12.943 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 02:54:32 MyWetter WEATHER temperature: -3 temperature -3 �C
2018.02.07 20:53:12.944 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 03:04:33 MyWetter WEATHER temperature: -3 temperature -3 �C
2018.02.07 20:53:12.945 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 03:14:33 MyWetter WEATHER temperature: -3 temperature -3 �C
2018.02.07 20:53:12.946 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 03:24:34 MyWetter WEATHER temperature: -3 temperature -3 �C
2018.02.07 20:53:12.947 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 03:34:35 MyWetter WEATHER temperature: -3 temperature -3 �C
2018.02.07 20:53:12.948 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 03:44:36 MyWetter WEATHER temperature: -2 temperature -2 �C
2018.02.07 20:53:12.949 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 03:54:37 MyWetter WEATHER temperature: -2 temperature -2 �C
2018.02.07 20:53:12.950 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 04:04:37 MyWetter WEATHER temperature: -2 temperature -2 �C
2018.02.07 20:53:12.950 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 04:14:38 MyWetter WEATHER temperature: -2 temperature -2 �C
2018.02.07 20:53:12.951 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 04:24:39 MyWetter WEATHER temperature: -2 temperature -2 �C
2018.02.07 20:53:12.952 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 04:34:40 MyWetter WEATHER temperature: -2 temperature -2 �C
2018.02.07 20:53:12.953 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 04:44:40 MyWetter WEATHER temperature: -2 temperature -2 �C
2018.02.07 20:53:12.954 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 04:54:41 MyWetter WEATHER temperature: -2 temperature -2 �C
2018.02.07 20:53:12.955 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 05:04:42 MyWetter WEATHER temperature: -2 temperature -2 �C
2018.02.07 20:53:12.956 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 05:14:43 MyWetter WEATHER temperature: -2 temperature -2 �C
2018.02.07 20:53:12.957 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 05:24:44 MyWetter WEATHER temperature: -2 temperature -2 �C
2018.02.07 20:53:12.958 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 05:34:44 MyWetter WEATHER temperature: -2 temperature -2 �C
2018.02.07 20:53:12.959 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 05:44:45 MyWetter WEATHER temperature: -2 temperature -2 �C
2018.02.07 20:53:12.968 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 05:54:46 MyWetter WEATHER temperature: -2 temperature -2 �C
2018.02.07 20:53:12.972 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 06:04:47 MyWetter WEATHER temperature: -2 temperature -2 �C
2018.02.07 20:53:12.973 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 06:14:48 MyWetter WEATHER temperature: -2 temperature -2 �C
2018.02.07 20:53:12.973 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 06:24:48 MyWetter WEATHER temperature: -2 temperature -2 �C
2018.02.07 20:53:12.974 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 06:34:49 MyWetter WEATHER temperature: -2 temperature -2 �C
2018.02.07 20:53:12.975 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 06:44:50 MyWetter WEATHER temperature: -1 temperature -1 �C
2018.02.07 20:53:12.975 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 06:54:51 MyWetter WEATHER temperature: -1 temperature -1 �C
2018.02.07 20:53:12.976 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 07:04:52 MyWetter WEATHER temperature: -1 temperature -1 �C
2018.02.07 20:53:12.976 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 07:14:52 MyWetter WEATHER temperature: -1 temperature -1 �C
2018.02.07 20:53:12.977 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 07:24:53 MyWetter WEATHER temperature: -1 temperature -1 �C
2018.02.07 20:53:12.978 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 07:34:54 MyWetter WEATHER temperature: -1 temperature -1 �C
2018.02.07 20:53:12.978 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 07:44:55 MyWetter WEATHER temperature: 0 temperature 0 �C
2018.02.07 20:53:12.979 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 07:54:56 MyWetter WEATHER temperature: 0 temperature 0 �C
2018.02.07 20:53:12.980 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 08:04:56 MyWetter WEATHER temperature: 0 temperature 0 �C
2018.02.07 20:53:12.980 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 08:14:57 MyWetter WEATHER temperature: 0 temperature 0 �C
2018.02.07 20:53:12.981 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 08:24:58 MyWetter WEATHER temperature: 0 temperature 0 �C
2018.02.07 20:53:12.982 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 08:34:59 MyWetter WEATHER temperature: 0 temperature 0 �C
2018.02.07 20:53:12.982 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 08:45:00 MyWetter WEATHER temperature: -1 temperature -1 �C
2018.02.07 20:53:12.983 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 08:55:00 MyWetter WEATHER temperature: -1 temperature -1 �C
2018.02.07 20:53:12.983 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 09:05:02 MyWetter WEATHER temperature: -1 temperature -1 �C
2018.02.07 20:53:12.984 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 09:15:03 MyWetter WEATHER temperature: -1 temperature -1 �C
2018.02.07 20:53:12.985 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 09:25:04 MyWetter WEATHER temperature: -1 temperature -1 �C
2018.02.07 20:53:12.985 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 09:35:04 MyWetter WEATHER temperature: -1 temperature -1 �C
2018.02.07 20:53:12.986 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 09:45:05 MyWetter WEATHER temperature: 0 temperature 0 �C
2018.02.07 20:53:12.986 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 09:55:06 MyWetter WEATHER temperature: 0 temperature 0 �C
2018.02.07 20:53:12.987 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 10:05:07 MyWetter WEATHER temperature: 0 temperature 0 �C
2018.02.07 20:53:12.988 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 10:15:07 MyWetter WEATHER temperature: 0 temperature 0 �C
2018.02.07 20:53:12.988 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 10:25:08 MyWetter WEATHER temperature: 0 temperature 0 �C
2018.02.07 20:53:12.989 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 10:35:09 MyWetter WEATHER temperature: 0 temperature 0 �C
2018.02.07 20:53:12.989 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 10:45:10 MyWetter WEATHER temperature: -2 temperature -2 �C
2018.02.07 20:53:12.990 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 10:55:10 MyWetter WEATHER temperature: -2 temperature -2 �C
2018.02.07 20:53:12.991 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 11:05:11 MyWetter WEATHER temperature: -2 temperature -2 �C
2018.02.07 20:53:12.991 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 11:15:12 MyWetter WEATHER temperature: -2 temperature -2 �C
2018.02.07 20:53:12.992 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 11:25:12 MyWetter WEATHER temperature: -2 temperature -2 �C
2018.02.07 20:53:12.993 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 11:35:13 MyWetter WEATHER temperature: -2 temperature -2 �C
2018.02.07 20:53:12.993 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 11:45:14 MyWetter WEATHER temperature: -2 temperature -2 �C
2018.02.07 20:53:12.994 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 11:55:15 MyWetter WEATHER temperature: -2 temperature -2 �C
2018.02.07 20:53:12.994 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 12:05:15 MyWetter WEATHER temperature: -2 temperature -2 �C
2018.02.07 20:53:12.995 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 12:15:16 MyWetter WEATHER temperature: -2 temperature -2 �C
2018.02.07 20:53:12.996 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 12:25:17 MyWetter WEATHER temperature: -2 temperature -2 �C
2018.02.07 20:53:12.996 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 12:35:17 MyWetter WEATHER temperature: -2 temperature -2 �C
2018.02.07 20:53:12.997 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 12:45:18 MyWetter WEATHER temperature: -1 temperature -1 �C
2018.02.07 20:53:12.998 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 12:55:19 MyWetter WEATHER temperature: -1 temperature -1 �C
2018.02.07 20:53:12.998 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 13:05:20 MyWetter WEATHER temperature: -1 temperature -1 �C
2018.02.07 20:53:12.999 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 13:15:20 MyWetter WEATHER temperature: -1 temperature -1 �C
2018.02.07 20:53:12.999 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 13:25:21 MyWetter WEATHER temperature: -1 temperature -1 �C
2018.02.07 20:53:13.001 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 13:35:22 MyWetter WEATHER temperature: -1 temperature -1 �C
2018.02.07 20:53:13.002 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 13:45:23 MyWetter WEATHER temperature: -1 temperature -1 �C
2018.02.07 20:53:13.003 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 13:55:23 MyWetter WEATHER temperature: -1 temperature -1 �C
2018.02.07 20:53:13.003 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 14:05:24 MyWetter WEATHER temperature: -1 temperature -1 �C
2018.02.07 20:53:13.004 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 14:15:25 MyWetter WEATHER temperature: -1 temperature -1 �C
2018.02.07 20:53:13.005 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 14:25:25 MyWetter WEATHER temperature: -1 temperature -1 �C
2018.02.07 20:53:13.005 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 14:35:26 MyWetter WEATHER temperature: 0 temperature 0 �C
2018.02.07 20:53:13.006 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 14:45:27 MyWetter WEATHER temperature: 0 temperature 0 �C
2018.02.07 20:53:13.006 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 14:55:28 MyWetter WEATHER temperature: 0 temperature 0 �C
2018.02.07 20:53:13.007 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 15:05:28 MyWetter WEATHER temperature: 0 temperature 0 �C
2018.02.07 20:53:13.008 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 15:15:29 MyWetter WEATHER temperature: 0 temperature 0 �C
2018.02.07 20:53:13.008 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 15:25:30 MyWetter WEATHER temperature: 0 temperature 0 �C
2018.02.07 20:53:13.009 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 15:35:30 MyWetter WEATHER temperature: 0 temperature 0 �C
2018.02.07 20:53:13.010 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 15:45:31 MyWetter WEATHER temperature: 0 temperature 0 �C
2018.02.07 20:53:13.010 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 15:55:32 MyWetter WEATHER temperature: 0 temperature 0 �C
2018.02.07 20:53:13.011 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 16:05:33 MyWetter WEATHER temperature: 0 temperature 0 �C
2018.02.07 20:53:13.011 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 16:15:33 MyWetter WEATHER temperature: 0 temperature 0 �C
2018.02.07 20:53:13.012 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 16:25:34 MyWetter WEATHER temperature: 0 temperature 0 �C
2018.02.07 20:53:13.013 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 16:35:35 MyWetter WEATHER temperature: 0 temperature 0 �C
2018.02.07 20:53:13.013 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 16:45:36 MyWetter WEATHER temperature: 0 temperature 0 �C
2018.02.07 20:53:13.014 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 16:55:36 MyWetter WEATHER temperature: 0 temperature 0 �C
2018.02.07 20:53:13.015 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 17:05:37 MyWetter WEATHER temperature: 0 temperature 0 �C
2018.02.07 20:53:13.015 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 17:15:38 MyWetter WEATHER temperature: 0 temperature 0 �C
2018.02.07 20:53:13.016 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 17:25:39 MyWetter WEATHER temperature: 0 temperature 0 �C
2018.02.07 20:53:13.016 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 17:35:39 MyWetter WEATHER temperature: 0 temperature 0 �C
2018.02.07 20:53:13.017 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 17:45:40 MyWetter WEATHER temperature: 0 temperature 0 �C
2018.02.07 20:53:13.018 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 17:55:41 MyWetter WEATHER temperature: 0 temperature 0 �C
2018.02.07 20:53:13.018 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 18:05:41 MyWetter WEATHER temperature: 0 temperature 0 �C
2018.02.07 20:53:13.019 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 18:15:42 MyWetter WEATHER temperature: 0 temperature 0 �C
2018.02.07 20:53:13.020 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 18:25:43 MyWetter WEATHER temperature: 0 temperature 0 �C
2018.02.07 20:53:13.020 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 18:35:44 MyWetter WEATHER temperature: 0 temperature 0 �C
2018.02.07 20:53:13.021 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 18:45:44 MyWetter WEATHER temperature: -1 temperature -1 �C
2018.02.07 20:53:13.022 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 18:55:45 MyWetter WEATHER temperature: -1 temperature -1 �C
2018.02.07 20:53:13.022 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 19:05:46 MyWetter WEATHER temperature: -1 temperature -1 �C
2018.02.07 20:53:13.023 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 19:15:47 MyWetter WEATHER temperature: -1 temperature -1 �C
2018.02.07 20:53:13.024 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 19:25:47 MyWetter WEATHER temperature: -1 temperature -1 �C
2018.02.07 20:53:13.024 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 19:35:48 MyWetter WEATHER temperature: -2 temperature -2 �C
2018.02.07 20:53:13.025 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 19:45:49 MyWetter WEATHER temperature: -2 temperature -2 �C
2018.02.07 20:53:13.025 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 19:55:49 MyWetter WEATHER temperature: -2 temperature -2 �C
2018.02.07 20:53:13.026 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 20:05:50 MyWetter WEATHER temperature: -2 temperature -2 �C
2018.02.07 20:53:13.027 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 20:15:51 MyWetter WEATHER temperature: -2 temperature -2 �C
2018.02.07 20:53:13.027 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 20:25:52 MyWetter WEATHER temperature: -2 temperature -2 �C
2018.02.07 20:53:13.028 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 20:35:52 MyWetter WEATHER temperature: -2 temperature -2 �C
2018.02.07 20:53:13.029 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 20:45:53 MyWetter WEATHER temperature: -3 temperature -3 �C
2018.02.07 20:53:13.030 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 20:55:54 MyWetter WEATHER temperature: -3 temperature -3 �C
2018.02.07 20:53:13.030 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 21:05:55 MyWetter WEATHER temperature: -3 temperature -3 �C
2018.02.07 20:53:13.031 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 21:15:55 MyWetter WEATHER temperature: -3 temperature -3 �C
2018.02.07 20:53:13.032 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 21:25:56 MyWetter WEATHER temperature: -3 temperature -3 �C
2018.02.07 20:53:13.032 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 21:35:57 MyWetter WEATHER temperature: -3 temperature -3 �C
2018.02.07 20:53:13.033 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 21:45:58 MyWetter WEATHER temperature: -2 temperature -2 �C
2018.02.07 20:53:13.033 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 21:55:58 MyWetter WEATHER temperature: -2 temperature -2 �C
2018.02.07 20:53:13.034 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 22:05:59 MyWetter WEATHER temperature: -2 temperature -2 �C
2018.02.07 20:53:13.035 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 22:16:00 MyWetter WEATHER temperature: -2 temperature -2 �C
2018.02.07 20:53:13.035 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 22:26:01 MyWetter WEATHER temperature: -2 temperature -2 �C
2018.02.07 20:53:13.036 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 22:36:01 MyWetter WEATHER temperature: -2 temperature -2 �C
2018.02.07 20:53:13.037 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 22:46:02 MyWetter WEATHER temperature: -3 temperature -3 �C
2018.02.07 20:53:13.037 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 22:56:03 MyWetter WEATHER temperature: -3 temperature -3 �C
2018.02.07 20:53:13.038 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 23:06:04 MyWetter WEATHER temperature: -3 temperature -3 �C
2018.02.07 20:53:13.039 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 23:16:04 MyWetter WEATHER temperature: -3 temperature -3 �C
2018.02.07 20:53:13.039 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 23:26:05 MyWetter WEATHER temperature: -3 temperature -3 �C
2018.02.07 20:53:13.040 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 23:36:06 MyWetter WEATHER temperature: -3 temperature -3 �C
2018.02.07 20:53:13.041 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 23:46:07 MyWetter WEATHER temperature: -5 temperature -5 �C
2018.02.07 20:53:13.041 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 23:56:07 MyWetter WEATHER temperature: -5 temperature -5 �C
2018.02.07 20:53:13.042 5: DbRep Rep.LogDB1 -> write row:  2018-02-05 23:59:59 MyWetter WEATHER temperature: -6 temperature -6 C
2018.02.07 20:53:13.044 4: DbRep Rep.LogDB1 -> BlockingCall expfile_DoParse finished
2018.02.07 20:53:13.046 4: DbRep Rep.LogDB1 -> Start BlockingCall expfile_ParseDone
2018.02.07 20:53:13.052 3: DbRep Rep.LogDB1 - Number of exported datasets from fhemtest1 to file /sds1/backup/export.txt: MyWetter -- temperature -- 145.
2018.02.07 20:53:13.056 4: DbRep Rep.LogDB1 -> BlockingCall expfile_ParseDone finished

knxler · 07 Februar 2018, 22:11:09

Hallo Heiko,

ich kann nichts finden.
Kann es sein das du den alten Source eventuell hochgeladen hast? Die Version ist ja identisch zur vorherigen?

Martin

DS_Starter · 07 Februar 2018, 22:20:36

Kann natürlich sein. Habe die V7.9.0 hochgeladen.
Hier ist auch schon die zeitgewichtet Durchschnittsberechnung integriert. Ich hatte inzwischen weiterentwickelt.
Jetzt kannst du gleich beides austesten

LG,
Heiko

knxler · 07 Februar 2018, 22:40:17

Hallo noch einmal,

ich habe die 7.9.0 geladen. Der letzte Datensatz fehlt aber weiterhin.
Mit welchen set kann ich denn den neuen Mittelwert berechnen?

knxler · 07 Februar 2018, 22:48:01

Hallo,

ich habe mal andere Tage genommen.
Bei exportToFile fehlt immer der letzte Datensatz und bei fetchrows wird der letzte ausgegeben.

DS_Starter · 07 Februar 2018, 22:52:21

Zitatich habe die 7.9.0 geladen. Der letzte Datensatz fehlt aber weiterhin.

wirklich eigenartig. grenze mal time begin bis ende auf zwei Tage ein und aggregation auf day. Dann bitte wieder ein verbose 5. mal schauen wie es dann bei dir aussieht.
Ich kann mir wirklich nicht erklären wieso der letzte Wert bei mir kommt und bei dir nicht.

ZitatMit welchen set kann ich denn den neuen Mittelwert berechnen?

Du stellst Attribut averageCalcForm = avgTimeWeightMean. Die Berechnung ist wie üblich mit set averageValue zu starten.
Zeitabgrenzung und aggregation wie üblich.

DS_Starter · 07 Februar 2018, 23:06:56

Wir schauen morgen nochmal. Vielleicht fällt mir bis dahin noch etwas ein.

GN,
Heiko

knxler · 08 Februar 2018, 19:35:59

Hallo Heiko,

leider habe ich momentan nicht viel Zeit.
Hier nun der neue Select über 2 Tage.

Gruß Martin

DS_Starter · 08 Februar 2018, 19:51:31

Hallo Martin,

habe die V7.9.0 im ersten Beitrag neu hochgeladen. Die export Funktion ist umgebaut und verwendet nun die Architektur wie fetchrows.
Funktioniert bei mir nach wie vor einwandfrei und nun hoffe ich natürllich dass du auch positives Feddback geben kannst.

Grüße
Heiko