<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Ausgegeben wird bis “now” wenn- wie bei der ersten Anfrage- ohne to abgefragt wird. Trotzdem kommen die 2036er Timestamps<br class=""><div><br class=""></div><div>Auf welcher Zeit läuft denn Deine Middleware? </div><div><br class=""></div><div>Viele Grüße, Andreas</div><div><br class=""><blockquote type="cite" class=""><div class="">On 24. Feb 2019, at 20:26, Frank Richter <<a href="mailto:frank.richter83@gmail.com" class="">frank.richter83@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="auto" class="">Hallo Thomas,<div dir="auto" class=""><br class=""></div><div dir="auto" class="">kannst du die gleiche Abfrage nochmal mit JSON machen?</div><div dir="auto" class=""><br class=""></div><div dir="auto" class="">Gibt's bei der Darstellung im Frontend irgendwelche Auffälligkeiten?</div><div dir="auto" class=""><br class=""></div><div dir="auto" class="">Grüße</div><div dir="auto" class="">Frank</div></div><br class=""><div class="gmail_quote"><div dir="ltr" class="">Am So., 24. Feb. 2019, 14:23 hat Thomas Höpfner <<a href="mailto:thomas@thhoe.de" class="">thomas@thhoe.de</a>> geschrieben:<br class=""></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><u class=""></u>
<div class=""><p style="padding:0;margin:0" class=""><span style="font-size:11pt;font-family:tahoma,arial,helvetica,sans-serif" class=""></span></p><div style="font-family: "Times New Roman"; font-size: inherit; padding: 0px; margin: 0px;" class=""><span style="font-size:11pt" class="">Hallo zusammen,</span></div><div style="font-family: "Times New Roman"; font-size: inherit; padding: 0px; margin: 0px;" class=""><span style="font-size:11pt" class=""><br class=""></span></div><div style="font-family: "Times New Roman"; font-size: inherit; padding: 0px; margin: 0px;" class=""><span style="font-size:11pt" class="">ich bin gerade dabei mir ein Script zu basteln, mit dem ich einen S0-Kanal überwachen kann. </span></div><div style="font-family: "Times New Roman"; font-size: inherit; padding: 0px; margin: 0px;" class=""><span style="font-size:11pt" class="">Es soll die Anzahl der im Impulse in den letzten X Minuten ausgewertet werden.</span></div><div style="font-family: "Times New Roman"; font-size: inherit; padding: 0px; margin: 0px;" class=""><span style="font-size:11pt" class="">Für das ganze habe ich eine Vorlage gefunden (wo weiß ich nicht mehr), die aber nicht funktioniert.</span></div><div style="font-family: "Times New Roman"; font-size: inherit; padding: 0px; margin: 0px;" class=""><span style="font-size:11pt" class="">Problem ist das die Antwort der Middleware für mich nicht Nachvollziehbar ist.</span></div><div style="font-family: "Times New Roman"; font-size: inherit; padding: 0px; margin: 0px;" class=""><span style="font-size:11pt" class="">Die URL zur Abfrage lautet: <a href="http://localhost/middleware.php/data/e2b64f10-92eb-11e2-94e4-ed0995b4eb89.csv?from=1551009686000" title="http://localhost/middleware.php/data/e2b64f10-92eb-11e2-94e4-ed0995b4eb89.csv?from=1551009686000
Klicken Sie auf den Link, um die URL in einem neuen Fenster zu öffnen." rel="noopener noreferrer" target="_blank" class="">http://localhost/middleware.php/data/e2b64f10-92eb-11e2-94e4-ed0995b4eb89.csv?from=1551009686000</a></span></div><div style="font-family: "Times New Roman"; font-size: inherit; padding: 0px; margin: 0px;" class=""><span style="font-size:11pt" class="">Das sollte richtig sein nach:</span><span style="font-size:11pt" class=""><a href="https://wiki.volkszaehler.org/development/api/reference" title="https://wiki.volkszaehler.org/development/api/reference
Klicken Sie auf den Link, um die URL in einem neuen Fenster zu öffnen." rel="noopener noreferrer" target="_blank" class=""> https://wiki.volkszaehler.org/development/api/reference</a><br class=""></span></div><div style="font-family: "Times New Roman"; font-size: inherit; padding: 0px; margin: 0px;" class=""><span style="font-size:11pt" class="">Antwort der Middleware:</span></div>
<div style="font-family: "Times New Roman"; font-size: inherit;" class=""> # source:;<a href="http://volkszaehler.org/" target="_blank" rel="noreferrer" class="">volkszaehler.org</a> </div>
<div style="font-family: "Times New Roman"; font-size: inherit;" class=""> # version:;0.3 </div>
<div style="font-family: "Times New Roman"; font-size: inherit;" class=""> # uuid:;e2b64f10-92eb-11e2-94e4-ed0995b4eb89 </div>
<div style="font-family: "Times New Roman"; font-size: inherit;" class=""> # title:;Strom_L2 </div>
<div style="font-family: "Times New Roman"; font-size: inherit;" class=""> # from:;2019-02-24 06:48:50 </div>
<div style="font-family: "Times New Roman"; font-size: inherit;" class=""> # to:;2036-02-07 07:37:55 </div>
<div style="font-family: "Times New Roman"; font-size: inherit;" class=""> # min:;2036-02-07 07:28:17; => ;0 </div>
<div style="font-family: "Times New Roman"; font-size: inherit;" class=""> # max:;2036-02-07 07:29:41; => ;1800 </div>
<div style="font-family: "Times New Roman"; font-size: inherit;" class=""> # average:;0 </div>
<div style="font-family: "Times New Roman"; font-size: inherit;" class=""> # consumption:;43.5 </div>
<div style="font-family: "Times New Roman"; font-size: inherit;" class=""> # rows:;88 </div>
<div style="font-family: "Times New Roman"; font-size: inherit;" class=""> 2019-02-24 06:50:00;25.714;1 </div>
<div style="font-family: "Times New Roman"; font-size: inherit;" class=""> 2036-02-07 07:28:17;0;1 </div>
<div style="font-family: "Times New Roman"; font-size: inherit;" class=""> 2036-02-07 07:28:24;257.143;1 </div>
<div style="font-family: "Times New Roman"; font-size: inherit;" class=""> 2036-02-07 07:28:29;360;1 </div>
<div style="font-family: "Times New Roman"; font-size: inherit;" class=""> 2036-02-07 07:28:5.....</div><div style="font-family: "Times New Roman"; font-size: inherit; padding: 0px; margin: 0px;" class=""><span style="font-size:11pt" class=""><br class=""></span></div><div style="font-family: "Times New Roman"; font-size: inherit; padding: 0px; margin: 0px;" class=""><span style="font-size:11pt" class="">Zum testen habe ich den Zeitbereich mit to= Eingegrenzt, URL: <a href="http://localhost/middleware.php/data/e2b64f10-92eb-11e2-94e4-ed0995b4eb89.csv?from=1551009097000&to=1551009157000" title="http://localhost/middleware.php/data/e2b64f10-92eb-11e2-94e4-ed0995b4eb89.csv?from=1551009097000&to=1551009157000
Klicken Sie auf den Link, um die URL in einem neuen Fenster zu öffnen." rel="noopener noreferrer" target="_blank" class="">http://localhost/middleware.php/data/e2b64f10-92eb-11e2-94e4-ed0995b4eb89.csv?from=1551009097000&to=1551009157000</a></span></div><div style="font-family: "Times New Roman"; font-size: inherit; padding: 0px; margin: 0px;" class=""><span style="font-size:11pt" class=""><span style="font-size:14.6667px" class="">Antwort der Middleware:</span></span></div>
<div style="font-family: "Times New Roman"; font-size: inherit;" class=""> # source:;<a href="http://volkszaehler.org/" target="_blank" rel="noreferrer" class="">volkszaehler.org</a> </div>
<div style="font-family: "Times New Roman"; font-size: inherit;" class=""> # version:;0.3 </div>
<div style="font-family: "Times New Roman"; font-size: inherit;" class=""> # uuid:;e2b64f10-92eb-11e2-94e4-ed0995b4eb89 </div>
<div style="font-family: "Times New Roman"; font-size: inherit;" class=""> # title:;Strom_L2 </div>
<div style="font-family: "Times New Roman"; font-size: inherit;" class=""> # from:;2019-02-24 06:48:50 </div>
<div style="font-family: "Times New Roman"; font-size: inherit;" class=""> # to:;2036-02-07 07:28:17 </div>
<div style="font-family: "Times New Roman"; font-size: inherit;" class=""> # min:;2036-02-07 07:28:17; => ;0 </div>
<div style="font-family: "Times New Roman"; font-size: inherit;" class=""> # max:;2019-02-24 06:50:00; => ;25.714 </div>
<div style="font-family: "Times New Roman"; font-size: inherit;" class=""> # average:;0 </div>
<div style="font-family: "Times New Roman"; font-size: inherit;" class=""> # consumption:;1 </div>
<div style="font-family: "Times New Roman"; font-size: inherit;" class=""> # rows:;3 </div>
<div style="font-family: "Times New Roman"; font-size: inherit;" class=""> 2019-02-24 06:50:00;25.714;1 </div>
<div style="font-family: "Times New Roman"; font-size: inherit;" class=""> 2036-02-07 07:28:17;0;1</div><p style="font-family: "Times New Roman"; font-size: inherit;" class="">Hier sieht mann womit ich nicht klar komme. Obwohl die Abfragen mit Abstand ausgeführt wurden, bekomme ich in beiden fällen die selbe (falsche) Antwort für "# from:" und "# to:". Sogar die 1 Daten sind identisch. </p><div style="font-family: "Times New Roman"; font-size: inherit; padding: 0px; margin: 0px;" class=""><span style="font-size:11pt" class="">Wie kommen diese Werte zustande?<br class=""></span></div><div style="font-family: "Times New Roman"; font-size: inherit; padding: 0px; margin: 0px;" class=""><span style="font-size:11pt" class="">Wo kann ich noch einen Schalter für "Debug" setzen?</span></div><div style="font-family: "Times New Roman"; font-size: inherit; padding: 0px; margin: 0px;" class=""><span style="font-size:11pt" class="">Oder gibt es einen besseren Weg für mein Script?</span></div><div style="font-family: "Times New Roman"; font-size: inherit; padding: 0px; margin: 0px;" class=""><span style="font-size:11pt" class=""><br class=""></span></div><div style="font-family: "Times New Roman"; font-size: inherit; padding: 0px; margin: 0px;" class=""><span style="font-size:11pt" class="">Ich hoffe mir kann jemand helfen.</span></div>
<pre style="white-space:pre-wrap;margin-top:0px;margin-bottom:0px" class=""><span style="font-family:tahoma,arial,helvetica,sans-serif" class=""><span style="font-size:11pt" class="">Mit freundlichen Grüßen,<br class=""><br class="">Thomas<br class=""></span></span><span style="font-family:tahoma,arial,helvetica,sans-serif" class=""><span style="font-size:11pt" class="">
Mail: </span></span><a href="mailto:thomas@thhoe.de" title="mailto:thomas@thhoe.de
Klicken Sie auf den Link, um die URL in einem neuen Fenster zu öffnen." rel="noopener noreferrer" target="_blank" class="">thomas@thhoe.de</a></pre>
</div>
</blockquote></div>
</div></blockquote></div><br class=""></body></html>