[gelöst] CCU Historian Werte mittels HM Skript abfragen
Moderator: Co-Administratoren
[gelöst] CCU Historian Werte mittels HM Skript abfragen
Hallo zusammen
CCU-Historian ist toll. Endlich alle Werte aufzeichnen ohne sich darüber Gedanken zu machen!!
Eine Frage habe ich dennoch:
Wie kann ich in einem HM Skript bestimmte Werte des CCU-Historian abfragen?
Beispiel: Ich logge fleißig den Zählerstand meines Stromzählers. Um nun eine Tages-, Wochen-, Jahresverbrauchsübersicht zu erstellen, könnte ich mich Systemvariablen bedienen oder (was aus meiner Sicht viel besser wäre) einfach die im CCU-Historian gespeicherten Werte vor einem Tag, einer Woche, einem Jahr abfragen und mit dem aktuellen Wert vergleichen.
Die Daten liegen ja vor! Warum also nicht einfach auch nutzen?
Ich möchte kein Diagramm oder sonstiges, sondern eine Möglichkeit alte Zählerstände aus dem CCU-Historian mittels HM-Skript einfach abfragen.
Matthias meinte auf dem Usertreffen zu mir, dass dies mittels wget gehen sollte. Grundsätzlich verstehe ich, was damit gemeint ist.
Kann mir dennoch jemand mal den http Befehl nennen, mit dem ich den Wert vor genau 7 Tagen erhalte?
Bestünde eventuell sogar die Möglichkeit etwas komplexere Abfragen mittels http zu bewerkstelligen?
Vielen Dank!!
RamSauer
CCU-Historian ist toll. Endlich alle Werte aufzeichnen ohne sich darüber Gedanken zu machen!!
Eine Frage habe ich dennoch:
Wie kann ich in einem HM Skript bestimmte Werte des CCU-Historian abfragen?
Beispiel: Ich logge fleißig den Zählerstand meines Stromzählers. Um nun eine Tages-, Wochen-, Jahresverbrauchsübersicht zu erstellen, könnte ich mich Systemvariablen bedienen oder (was aus meiner Sicht viel besser wäre) einfach die im CCU-Historian gespeicherten Werte vor einem Tag, einer Woche, einem Jahr abfragen und mit dem aktuellen Wert vergleichen.
Die Daten liegen ja vor! Warum also nicht einfach auch nutzen?
Ich möchte kein Diagramm oder sonstiges, sondern eine Möglichkeit alte Zählerstände aus dem CCU-Historian mittels HM-Skript einfach abfragen.
Matthias meinte auf dem Usertreffen zu mir, dass dies mittels wget gehen sollte. Grundsätzlich verstehe ich, was damit gemeint ist.
Kann mir dennoch jemand mal den http Befehl nennen, mit dem ich den Wert vor genau 7 Tagen erhalte?
Bestünde eventuell sogar die Möglichkeit etwas komplexere Abfragen mittels http zu bewerkstelligen?
Vielen Dank!!
RamSauer
Zuletzt geändert von RamSauer am 26.04.2018, 15:16, insgesamt 1-mal geändert.
Re: CCU Historian Werte mittels HM Skript abfragen
OK!
Wir nähern uns der Sache!!
mit
bekomme ich ein json Objekt zurück für
den Parameter mit der ID = 969 (das ist die CCU Historian ID)
vom Startpunkt 23.03.2018 - 11:41:54 (Unix Time = 1521801714000)
bis zum Endpunkt 23.04.2018 - 11:41:54 (Unix Time = 1524476514000)
Nun muss man dieses json im Skript noch aufdröseln.
Das wird ja vielleicht doch noch was!
Wir nähern uns der Sache!!
mit
Code: Alles auswählen
http://[IP von CCU Historian]]:8080/query/jsonrpc.gy?j={"id": 123,"method": "getTimeSeries","params": [969,1521801714000,1524476514000]}
den Parameter mit der ID = 969 (das ist die CCU Historian ID)
vom Startpunkt 23.03.2018 - 11:41:54 (Unix Time = 1521801714000)
bis zum Endpunkt 23.04.2018 - 11:41:54 (Unix Time = 1524476514000)
Nun muss man dieses json im Skript noch aufdröseln.
Das wird ja vielleicht doch noch was!
-
- Beiträge: 1796
- Registriert: 03.11.2010, 10:25
- System: CCU
- Wohnort: Aachen
- Hat sich bedankt: 58 Mal
- Danksagung erhalten: 262 Mal
- Kontaktdaten:
Re: CCU Historian Werte mittels HM Skript abfragen
Mit /query/csv.gy?... kannst Du eine Zeitreihe im CSV-Format abholen. Das ist vielleicht etwas einfacher zu zerlegen.
Gruß
Mathias
Gruß
Mathias
Re: CCU Historian Werte mittels HM Skript abfragen
Geschafft und läuft!!
Das Skript holt für den angegebenen ccu-historian Datenpunkt alle gespeicherten Werte von jetzt bis vor X Tagen. Der erste Wert wird vom letzten Wert abgezogen und schon hat man das Delta für den betrachteten Zeitraum. Das Ergebnis wird in die angegebene Systemvariable geschrieben.
Damit ist es möglich, beliebig weit zurückzuschauen und sich das Delta zum jetzigen Zeitpunkt ausgeben zu lassen.
Getestet mit ccu-historian 1.2.0.
Viel Spaß damit
RamSauer
Das Skript holt für den angegebenen ccu-historian Datenpunkt alle gespeicherten Werte von jetzt bis vor X Tagen. Der erste Wert wird vom letzten Wert abgezogen und schon hat man das Delta für den betrachteten Zeitraum. Das Ergebnis wird in die angegebene Systemvariable geschrieben.
Damit ist es möglich, beliebig weit zurückzuschauen und sich das Delta zum jetzigen Zeitpunkt ausgeben zu lassen.
Getestet mit ccu-historian 1.2.0.
Viel Spaß damit
RamSauer
Code: Alles auswählen
!#######################################
!Script zur Deltawert Berechnung aus ccu-historian
!26.04.2018 RamSauer
!Version 0.1
!#######################################
!#######################################
!Einstellungen
!#######################################
string SysVar = "Regenmenge_Woche"; !Systemvariable in die geschrieben werden soll
integer tage = 7; !Zeitraum in Tagen
string hist_ip = "192.168.XXX.XX"; !IP Adresse ccu-Historien
string port = "8080"; ! Port ccu-Historien
string para_id = "969"; !ccu-historian Datenpunkt ID
string cuxd = "CUxD.CUX2801001:1"; !CUxD Exec Device
!#######################################
!Ab hier keine Änderungen mehr vornehmen
!#######################################
integer t = system.Date("%F %X").ToTime().ToInteger();
string endtime = t.ToString() + "000";
t = t - ( tage * 86400 );
string starttime = t.ToString() + "000";
string query = "http://" + hist_ip + ":" + port + "/query/jsonrpc.gy?j={%22id%22: 123, %22method%22: %22getTimeSeries%22,%22params%22: [" + para_id +
"," + starttime + "," + endtime + "]}";
dom.GetObject(cuxd + ".CMD_SETS").State("wget -q -O - '"#query#"'");
dom.GetObject(cuxd + ".CMD_QUERY_RET").State(1);
string hist_string = dom.GetObject(cuxd + ".CMD_RETS").State();
boolean error = hist_string.Contains("error");
if (error)
{
dom.GetObject(SysVar).State(-99);
quit;
}
hist_string = hist_string.StrValueByIndex(":", 4).Replace('],"dataPoint"', '').Replace('[', '');
real StartValue = hist_string.StrValueByIndex(",", 0).ToFloat();
real EndValue = StartValue;
foreach(x, hist_string.Split(","))
{
EndValue = x.ToFloat();
}
real delta = EndValue - StartValue;
dom.GetObject(SysVar).State(delta);
-
- Beiträge: 1796
- Registriert: 03.11.2010, 10:25
- System: CCU
- Wohnort: Aachen
- Hat sich bedankt: 58 Mal
- Danksagung erhalten: 262 Mal
- Kontaktdaten:
-
- Beiträge: 184
- Registriert: 14.03.2017, 10:29
- Hat sich bedankt: 29 Mal
- Danksagung erhalten: 1 Mal
Re: [gelöst] CCU Historian Werte mittels HM Skript abfragen
Hallo zusammen,
super diese Lösung
Ich würde gerne ein Skript erstellen, das mir die Gasverbräuche der letzten 24 Monate aus CCU-Homematic holt.
Wie kann ich denn bspw. einen summierten Verbrauch für Jan. 2018 aus CCU-Historian abrufen?
Gruß
duffy6
super diese Lösung
Ich würde gerne ein Skript erstellen, das mir die Gasverbräuche der letzten 24 Monate aus CCU-Homematic holt.
Wie kann ich denn bspw. einen summierten Verbrauch für Jan. 2018 aus CCU-Historian abrufen?
Gruß
duffy6
——-
Raspberrymatic auf einem Raspi 3B, Funkmodul HM-MOD-RPI-PCB
Raspberrymatic auf einem Raspi 3B, Funkmodul HM-MOD-RPI-PCB
-
- Beiträge: 184
- Registriert: 14.03.2017, 10:29
- Hat sich bedankt: 29 Mal
- Danksagung erhalten: 1 Mal
Re: [gelöst] CCU Historian Werte mittels HM Skript abfragen
Funktioniert das SKript bei Euch noch mit dem aktuellen CCU-historian v2.3?
Bei mir haben die Datapoints alle einen konstanten Wert:
Das Diagramm in CCU-homematic sieht jedoch prima aus:
Hat jmd ein ähnliches Problem? Ich komm nicht drauf, weshalb das nicht läuft....
Gruß
duffy6
Bei mir haben die Datapoints alle einen konstanten Wert:
Code: Alles auswählen
http://192.168.133.102:8091/query/jsonrpc.gy?j={%22id%22: 123, %22method%22: %22getTimeSeries%22,%22params%22: [81,1577969263000,1580561263000]}
Länge der CCU-Historian Antwort: 50038
Einheit: __
Anfangswert: 0.034000
0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0.034,0
Endwert: 0.000000
Differenz in 30 Tag(en): -0.034000
Gruß
duffy6
——-
Raspberrymatic auf einem Raspi 3B, Funkmodul HM-MOD-RPI-PCB
Raspberrymatic auf einem Raspi 3B, Funkmodul HM-MOD-RPI-PCB
-
- Beiträge: 184
- Registriert: 14.03.2017, 10:29
- Hat sich bedankt: 29 Mal
- Danksagung erhalten: 1 Mal
Re: [gelöst] CCU Historian Werte mittels HM Skript abfragen
Wenn ich das Delta von 30 Tage auf 1 Tag setze, dann klappt es!
Irgendwie scheint wohl der Antwortstring zu lang zu sein. Ich rufe nun einfach die Tageswerte ab
Ich würde aber doch gerne die letzten 30 Tage abfragen.
Ich dachte jetzt, dass ich einfach die letzten 30 Tageswerte addiere, allerdings fehlt es mir dazu an Programmier-Know-How.
Wie kann ich denn obiges Skript anpassen, dass ich die letzten 30 Werte eines abgefragten Wertes addieren kann?
Danke für Eure Hilfe!
duffy6
Irgendwie scheint wohl der Antwortstring zu lang zu sein. Ich rufe nun einfach die Tageswerte ab
Ich würde aber doch gerne die letzten 30 Tage abfragen.
Ich dachte jetzt, dass ich einfach die letzten 30 Tageswerte addiere, allerdings fehlt es mir dazu an Programmier-Know-How.
Wie kann ich denn obiges Skript anpassen, dass ich die letzten 30 Werte eines abgefragten Wertes addieren kann?
Danke für Eure Hilfe!
duffy6
——-
Raspberrymatic auf einem Raspi 3B, Funkmodul HM-MOD-RPI-PCB
Raspberrymatic auf einem Raspi 3B, Funkmodul HM-MOD-RPI-PCB
-
- Beiträge: 220
- Registriert: 03.09.2012, 15:34
- Hat sich bedankt: 3 Mal
- Danksagung erhalten: 9 Mal
Re: [gelöst] CCU Historian Werte mittels HM Skript abfragen
Hi,
mir ist schon klar das der Beitrag etwas älter ist aber hat jemand eine Lösung. Ich habe die aktuelle Version 2.4 installiert und da bekomme ich keine Rückmeldung.
Danke
mir ist schon klar das der Beitrag etwas älter ist aber hat jemand eine Lösung. Ich habe die aktuelle Version 2.4 installiert und da bekomme ich keine Rückmeldung.
Danke
-
- Beiträge: 1796
- Registriert: 03.11.2010, 10:25
- System: CCU
- Wohnort: Aachen
- Hat sich bedankt: 58 Mal
- Danksagung erhalten: 262 Mal
- Kontaktdaten:
Re: [gelöst] CCU Historian Werte mittels HM Skript abfragen
Ich habe selber kein CUxD installiert und nicht so viel Zeit HM-Skript zu debuggen. Folgendes ist mir aber aufgefallen: Die Variable x wird nicht deklariert. Ich denke, dass folgende Zeile vor der foreach-Schleife noch eingefügt werden muss.
Code: Alles auswählen
string x;