<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="">mit options=raw bekomm ich die Werte wie sie in der DB stehen:<div class=""><div class="">{</div><div class=""> "version": "0.3",</div><div class=""> "data": {</div><div class=""> "tuples": [</div><div class=""> [</div><div class=""> 1575158604000,</div><div class=""> -75650,</div><div class=""> 1</div><div class=""> ],</div><div class=""> [</div><div class=""> 1575158937000,</div><div class=""> -75650,</div><div class=""> 1</div><div class=""> ],</div><div class=""> [</div><div class=""> 1575159255000,</div><div class=""> -75650,</div><div class=""> 1</div><div class=""> ],</div><div class="">…</div><div class=""><br class=""></div><div class="">ohne options=raw erhalte ich (egal was ich als Startzeitpunkt der Anfrage nehme) zu Beginn diesen sehr hohen Wert:</div><div class=""><div class="">"version": "0.3",</div><div class=""> "data": {</div><div class=""> "tuples": [</div><div class=""> [</div><div class=""> 1575158604000,</div><div class=""> 820301.205,</div><div class=""> 1</div><div class=""> ],</div><div class=""> [</div><div class=""> 1575158937000,</div><div class=""> 0,</div><div class=""> 1</div><div class=""> ],</div><div class=""> [</div><div class=""> 1575159255000,</div><div class=""> 0,</div><div class=""> 1</div><div class=""> ],</div></div><div class="">...</div><div class="">Dieser hohe Wert erschliesst sich mir nicht, und ich frage mich, ob dies einfach davon herkommt, dass keine negativen Energiewerte (Zählerstände) geloggt werden können?</div><div class="">Bei positiven Zählerständen habe ich das Problem nicht.</div><div class="">Liebe Grüsse</div><div class="">Pascal</div><div><br class=""><blockquote type="cite" class=""><div class="">Am 02.12.2019 um 20:16 schrieb Andreas Goetz <<a href="mailto:cpuidle@gmail.com" class="">cpuidle@gmail.com</a>>:</div><br class="Apple-interchange-newline"><div class=""><meta http-equiv="Content-Type" content="text/html; charset=utf-8" class=""><div style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">…um das zu klären müsstest Du Dir mal die API Abfrage selbst im Browser aufmachen und schauen was da passiert- einmal “normal” aufrufen und einmal ein “&options=raw” anhängen. Dann siehst Du Row- und verarbeitete Daten.<div class=""><br class=""></div><div class="">Viele Grüße, Andreas</div><div class=""><br class=""><div class=""><br class=""><blockquote type="cite" class=""><div class="">On 2. Dec 2019, at 19:18, <a href="mailto:volkszaehler@wiuhelmtell.ch" class="">volkszaehler@wiuhelmtell.ch</a> wrote:</div><br class="Apple-interchange-newline"><div class=""><meta http-equiv="Content-Type" content="text/html; charset=utf-8" class=""><div style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><span style="caret-color: rgb(0, 0, 0);" class="">Hallo zusammen</span><div class="" style="caret-color: rgb(0, 0, 0);"><br class=""></div><div class="" style="caret-color: rgb(0, 0, 0);">Nach langer Inaktivität melde ich mich auch gerne wieder, und bereits mit einer Frage…;)</div><div class="" style="caret-color: rgb(0, 0, 0);">Gerne würde ich die Zählerstände eines Produktions-Zählers in die Datenbank schreiben. Allerdings werden diese Werte dann falsch dargestellt, siehe Screenshot (jeweils sehr hoher Wert zu Beginn, danach 0):</div><div class="" style="caret-color: rgb(0, 0, 0);"><span id="cid:C86C8049-5BA5-4955-A989-527B19DEFC31@clevergie.ch" class=""><PastedGraphic-1.png></span></div><div class="" style="caret-color: rgb(0, 0, 0);"><br class=""></div><div class="" style="caret-color: rgb(0, 0, 0);">Die Daten in der Datenbank sind nach mir korrekt (Auszug):</div><div class="" style="caret-color: rgb(0, 0, 0);"><x-row class="" style="display: block; height: var(--hterm-charsize-height); line-height: var(--hterm-charsize-height); visibility: visible; caret-color: rgba(0, 0, 0, 0); font-family: "courier new", monospace; font-size: 13px; white-space: pre;">| 48188830 | 300 | 1575299985000 | -75460 |</x-row><x-row class="" style="display: block; height: var(--hterm-charsize-height); line-height: var(--hterm-charsize-height); visibility: visible; caret-color: rgba(0, 0, 0, 0); font-family: "courier new", monospace; font-size: 13px; white-space: pre;">| 48189024 | 300 | 1575300310000 | -75450 |</x-row><x-row class="" style="display: block; height: var(--hterm-charsize-height); line-height: var(--hterm-charsize-height); visibility: visible; caret-color: rgba(0, 0, 0, 0); font-family: "courier new", monospace; font-size: 13px; white-space: pre;">| 48189215 | 300 | 1575300650000 | -75450 |</x-row><x-row class="" style="display: block; height: var(--hterm-charsize-height); line-height: var(--hterm-charsize-height); visibility: visible; caret-color: rgba(0, 0, 0, 0); font-family: "courier new", monospace; font-size: 13px; white-space: pre;">| 48189412 | 300 | 1575300974000 | -75450 |</x-row><x-row class="" style="display: block; height: var(--hterm-charsize-height); line-height: var(--hterm-charsize-height); visibility: visible; caret-color: rgba(0, 0, 0, 0); font-family: "courier new", monospace; font-size: 13px; white-space: pre;">| 48189606 | 300 | 1575301297000 | -75450 |</x-row><x-row class="" style="display: block; height: var(--hterm-charsize-height); line-height: var(--hterm-charsize-height); visibility: visible; caret-color: rgba(0, 0, 0, 0); font-family: "courier new", monospace; font-size: 13px; white-space: pre;">| 48189800 | 300 | 1575301638000 | -75450 |</x-row><x-row class="" style="display: block; height: var(--hterm-charsize-height); line-height: var(--hterm-charsize-height); visibility: visible; caret-color: rgba(0, 0, 0, 0); font-family: "courier new", monospace; font-size: 13px; white-space: pre;">| 48189994 | 300 | 1575301963000 | -75450 |</x-row><x-row class="" style="display: block; height: var(--hterm-charsize-height); line-height: var(--hterm-charsize-height); visibility: visible; caret-color: rgba(0, 0, 0, 0); font-family: "courier new", monospace; font-size: 13px; white-space: pre;">| 48190188 | 300 | 1575302302000 | -75450 |</x-row><x-row class="" style="display: block; height: var(--hterm-charsize-height); line-height: var(--hterm-charsize-height); visibility: visible; caret-color: rgba(0, 0, 0, 0); font-family: "courier new", monospace; font-size: 13px; white-space: pre;">| 48190382 | 300 | 1575302628000 | -75450 |</x-row><x-row class="" style="display: block; height: var(--hterm-charsize-height); line-height: var(--hterm-charsize-height); visibility: visible; caret-color: rgba(0, 0, 0, 0); font-family: "courier new", monospace; font-size: 13px; white-space: pre;">| 48190573 | 300 | 1575302955000 | -75450 |</x-row><x-row class="" style="display: block; height: var(--hterm-charsize-height); line-height: var(--hterm-charsize-height); visibility: visible; caret-color: rgba(0, 0, 0, 0); font-family: "courier new", monospace; font-size: 13px; white-space: pre;">| 48190767 | 300 | 1575303283000 | -75450 |</x-row><x-row class="" style="display: block; height: var(--hterm-charsize-height); line-height: var(--hterm-charsize-height); visibility: visible; caret-color: rgba(0, 0, 0, 0); font-family: "courier new", monospace; font-size: 13px; white-space: pre;">| 48190964 | 300 | 1575303622000 | -75450 |</x-row><x-row class="" style="display: block; height: var(--hterm-charsize-height); line-height: var(--hterm-charsize-height); visibility: visible; caret-color: rgba(0, 0, 0, 0); font-family: "courier new", monospace; font-size: 13px; white-space: pre;">| 48191158 | 300 | 1575303943000 | -75450 |</x-row><x-row class="" style="display: block; height: var(--hterm-charsize-height); line-height: var(--hterm-charsize-height); visibility: visible; caret-color: rgba(0, 0, 0, 0); font-family: "courier new", monospace; font-size: 13px; white-space: pre;">| 48191352 | 300 | 1575304283000 | -75450 |</x-row><x-row class="" style="display: block; height: var(--hterm-charsize-height); line-height: var(--hterm-charsize-height); visibility: visible; caret-color: rgba(0, 0, 0, 0); font-family: "courier new", monospace; font-size: 13px; white-space: pre;">| 48191546 | 300 | 1575304617000 | -75450 |</x-row><x-row class="" style="display: block; height: var(--hterm-charsize-height); line-height: var(--hterm-charsize-height); visibility: visible; caret-color: rgba(0, 0, 0, 0); font-family: "courier new", monospace; font-size: 13px; white-space: pre;">| 48191740 | 300 | 1575304941000 | -75450 |</x-row><x-row class="" style="display: block; height: var(--hterm-charsize-height); line-height: var(--hterm-charsize-height); visibility: visible; caret-color: rgba(0, 0, 0, 0); font-family: "courier new", monospace; font-size: 13px; white-space: pre;">| 48191934 | 300 | 1575305264000 | -75450 |</x-row><x-row class="" style="display: block; height: var(--hterm-charsize-height); line-height: var(--hterm-charsize-height); visibility: visible; caret-color: rgba(0, 0, 0, 0); font-family: "courier new", monospace; font-size: 13px; white-space: pre;">| 48192125 | 300 | 1575305603000 | -75440 |</x-row></div><div class="" style="caret-color: rgb(0, 0, 0);">Mir ist bewusst, dass zwischen den jeweils gleichen Zählerständen kein Verbrauch/Produktion dargestellt wird. Ich Frage mich aber, wieso die Darstellung (egal, welchen Bereich ich auswähle) zu Beginn derart hoch ist.</div><div class="" style="caret-color: rgb(0, 0, 0);">Frage: Ist das Loggen von negativen Werten, wie sie bei Bilanzzählern bzw. Produktionszählern auftreten, nicht möglich?</div><div class="" style="caret-color: rgb(0, 0, 0);"><br class=""></div><div class="" style="caret-color: rgb(0, 0, 0);">Liebe Grüsse</div><div class="" style="caret-color: rgb(0, 0, 0);"><br class=""></div><div class="" style="caret-color: rgb(0, 0, 0);">Pascal</div></div></div></blockquote></div><br class=""></div></div></div></blockquote></div><br class=""></div></body></html>