<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="">Hi Thomas,<div class=""><br class=""></div><div class=""><blockquote type="cite" class=""><div class=""><div class="" style="font-family: tahoma, arial, helvetica, sans-serif; font-size: 11pt; padding: 0px; margin: 0px;"><span class="" style="font-size: 11pt;">option=raw bewirkt auch nichts</span></div></div></blockquote><div class=""><br class=""></div>der Parameter heißt auch <b class="">options</b>, sorry.<br class=""><div><br class=""><blockquote type="cite" class=""><div class="">On 29. Mar 2019, at 12:22, Thomas Höpfner <<a href="mailto:thomas@thhoe.de" class="">thomas@thhoe.de</a>> wrote:</div><br class="Apple-interchange-newline"><div class="">
<meta name="Generator" content="Kopano WebApp v3.5.2.2146+87.1" class="">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" class="">
<title class="">AW: [vz-users] VZ2.0</title>
<div class=""><div style="font-family: tahoma, arial, helvetica, sans-serif; font-size: 11pt; padding: 0px; margin: 0px;" class="">Ja, habe ich. Die Ergebnisse sind für mich aber nicht plausible</div></div></div></blockquote><div><br class=""></div>Schau Dir bitte erstmal die Rohwerte an, sonst bringt das nichts.</div><div><br class=""></div><div>Viele Grüße, </div><div>Andreas</div><div><br class=""><blockquote type="cite" class=""><div class=""><div class=""><div style="font-family: tahoma, arial, helvetica, sans-serif; font-size: 11pt; padding: 0px; margin: 0px;" class=""><span style="font-size: 11pt; font-family: tahoma, arial, helvetica, sans-serif;" class="">Mit der Abfrage: /api/data/9f406840-efe1-11e8-b377-734492b60243.json?from=1553771216330&to=1553857616330&value<1.7<br class=""></span></div><div style="font-family: tahoma, arial, helvetica, sans-serif; font-size: 11pt; padding: 0px; margin: 0px;" class=""><span style="font-size: 11pt; font-family: tahoma, arial, helvetica, sans-serif;" class=""><br class=""></span></div><div style="font-family: tahoma, arial, helvetica, sans-serif; font-size: 11pt; padding: 0px; margin: 0px;" class=""><span style="font-size: 11pt; font-family: tahoma, arial, helvetica, sans-serif;" class="">Bekomme ich folgendes Ergebniss:</span></div>
<table class="treeTable" border="1" cellspacing="0" cellpadding="0" aria-label="" aria-activedescendant="/data/tuples">
<tbody class="">
<tr class="treeRow stringRow opened" aria-level="0" aria-selected="false" aria-expanded="true">
<td style="padding-inline-start: 0px;" class="treeLabelCell"><span class="treeIcon open"></span><span class="treeLabel stringLabel" aria-labelledby="default" data-level="0">version</span></td>
<td class="treeValueCell stringCell"><span aria-labelledby="value" class="">"0.3"</span></td>
</tr>
<tr class="treeRow objectRow opened hasChildren" aria-level="0" aria-selected="false" aria-expanded="true">
<td style="padding-inline-start: 0px;" class="treeLabelCell"><span class="treeIcon theme-twisty open"></span><span class="objectLabel treeLabel" aria-labelledby="default" data-level="0">data</span></td>
<td class="treeValueCell objectCell"><span aria-labelledby="value" class=""></span></td>
</tr>
<tr class="treeRow objectRow selected hasChildren" aria-level="1" aria-selected="true" aria-expanded="false">
<td style="padding-inline-start: 16px;" class="treeLabelCell"><span class="treeIcon theme-twisty"></span><span class="objectLabel treeLabel" aria-labelledby="default" data-level="1">tuples</span></td>
<td class="treeValueCell objectCell"><span aria-labelledby="value" class=""><span class="arrayLeftBracket">[</span><span class="more-ellipsis">…</span><span class="arrayRightBracket">]</span><span class="arrayProperties"></span></span></td>
</tr>
<tr class="treeRow stringRow opened" aria-level="1" aria-selected="false" aria-expanded="true">
<td style="padding-inline-start: 16px;" class="treeLabelCell"><span class="treeIcon open"></span><span class="treeLabel stringLabel" aria-labelledby="default" data-level="1">uuid</span></td>
<td class="treeValueCell stringCell"><span aria-labelledby="value" class="">"9f406840-efe1-11e8-b377-734492b60243"</span></td>
</tr>
<tr class="treeRow numberRow opened" aria-level="1" aria-selected="false" aria-expanded="true">
<td style="padding-inline-start: 16px;" class="treeLabelCell"><span class="treeIcon open"></span><span class="treeLabel numberLabel" aria-labelledby="default" data-level="1">from</span></td>
<td class="numberCell treeValueCell"><span aria-labelledby="value" class="">1553589362085</span></td>
</tr>
<tr class="treeRow numberRow opened" aria-level="1" aria-selected="false" aria-expanded="true">
<td style="padding-inline-start: 16px;" class="treeLabelCell"><span class="treeIcon open"></span><span class="treeLabel numberLabel" aria-labelledby="default" data-level="1">to</span></td>
<td class="numberCell treeValueCell"><span aria-labelledby="value" class="">1553857562069</span></td>
</tr>
<tr class="treeRow objectRow opened hasChildren" aria-level="1" aria-selected="false" aria-expanded="true">
<td style="padding-inline-start: 16px;" class="treeLabelCell"><span class="treeIcon theme-twisty open"></span><span class="objectLabel treeLabel" aria-labelledby="default" data-level="1">min</span></td>
<td class="treeValueCell objectCell"><span aria-labelledby="value" class=""></span></td>
</tr>
<tr class="treeRow numberRow opened" aria-level="2" aria-selected="false" aria-expanded="true">
<td style="padding-inline-start: 32px;" class="treeLabelCell"><span class="treeIcon open"></span><span class="treeLabel numberLabel" aria-labelledby="default" data-level="2">0</span></td>
<td class="numberCell treeValueCell"><span aria-labelledby="value" class="">1553857562069</span></td>
</tr>
<tr class="treeRow numberRow opened" aria-level="2" aria-selected="false" aria-expanded="true">
<td style="padding-inline-start: 32px;" class="treeLabelCell"><span class="treeIcon open"></span><span class="treeLabel numberLabel" aria-labelledby="default" data-level="2">1</span></td>
<td class="numberCell treeValueCell"><span aria-labelledby="value" class="">1.8391721066400666</span></td>
</tr>
<tr class="treeRow objectRow opened hasChildren" aria-level="1" aria-selected="false" aria-expanded="true">
<td style="padding-inline-start: 16px;" class="treeLabelCell"><span class="treeIcon theme-twisty open"></span><span class="objectLabel treeLabel" aria-labelledby="default" data-level="1">max</span></td>
<td class="treeValueCell objectCell"><span aria-labelledby="value" class=""></span></td>
</tr>
<tr class="treeRow numberRow opened" aria-level="2" aria-selected="false" aria-expanded="true">
<td style="padding-inline-start: 32px;" class="treeLabelCell"><span class="treeIcon open"></span><span class="treeLabel numberLabel" aria-labelledby="default" data-level="2">0</span></td>
<td class="numberCell treeValueCell"><span aria-labelledby="value" class="">1553854502254</span></td>
</tr>
<tr class="treeRow numberRow opened" aria-level="2" aria-selected="false" aria-expanded="true">
<td style="padding-inline-start: 32px;" class="treeLabelCell"><span class="treeIcon open"></span><span class="treeLabel numberLabel" aria-labelledby="default" data-level="2">1</span></td>
<td class="numberCell treeValueCell"><span aria-labelledby="value" class="">2.681328908710176</span></td>
</tr>
<tr class="treeRow numberRow opened" aria-level="1" aria-selected="false" aria-expanded="true">
<td style="padding-inline-start: 16px;" class="treeLabelCell"><span class="treeIcon open"></span><span class="treeLabel numberLabel" aria-labelledby="default" data-level="1">average</span></td>
<td class="numberCell treeValueCell"><span aria-labelledby="value" class="">2.672</span></td>
</tr>
<tr class="treeRow numberRow opened" aria-level="1" aria-selected="false" aria-expanded="true">
<td style="padding-inline-start: 16px;" class="treeLabelCell"><span class="treeIcon open"></span><span class="treeLabel numberLabel" aria-labelledby="default" data-level="1">consumption</span></td>
<td class="numberCell treeValueCell"><span aria-labelledby="value" class="">199.079</span></td>
</tr>
<tr class="treeRow numberRow opened" aria-level="1" aria-selected="false" aria-expanded="true">
<td style="padding-inline-start: 16px;" class="treeLabelCell"><span class="treeIcon open"></span><span class="treeLabel numberLabel" aria-labelledby="default" data-level="1">rows</span></td>
<td class="numberCell treeValueCell"><span aria-labelledby="value" class="">19</span></td>
</tr>
</tbody>
</table><div style="font-family: tahoma, arial, helvetica, sans-serif; font-size: 11pt; padding: 0px; margin: 0px;" class=""><span style="font-size: 11pt; font-family: tahoma, arial, helvetica, sans-serif;" class=""><br class=""></span></div><div style="font-family: tahoma, arial, helvetica, sans-serif; font-size: 11pt; padding: 0px; margin: 0px;" class=""><span style="font-size: 11pt; font-family: tahoma, arial, helvetica, sans-serif;" class="">option=raw bewirkt auch nichts</span></div><div style="font-family: tahoma, arial, helvetica, sans-serif; font-size: 11pt; padding: 0px; margin: 0px;" class=""><span style="font-size: 11pt; font-family: tahoma, arial, helvetica, sans-serif;" class=""><br class=""></span></div><div style="font-family: tahoma, arial, helvetica, sans-serif; font-size: 11pt; padding: 0px; margin: 0px;" class=""><span style="font-size: 11pt; font-family: tahoma, arial, helvetica, sans-serif;" class="">operation=delete funktioniert (wenn vz@localhost das darf)</span></div><div style="font-family: tahoma, arial, helvetica, sans-serif; font-size: 11pt; padding: 0px; margin: 0px;" class=""><span style="font-size: 11pt; font-family: tahoma, arial, helvetica, sans-serif;" class=""><br class=""></span></div><div style="font-family: tahoma, arial, helvetica, sans-serif; font-size: 11pt; padding: 0px; margin: 0px;" class=""><span style="font-size: 11pt; font-family: tahoma, arial, helvetica, sans-serif;" class=""><br class=""></span></div>
<pre style="white-space: pre-wrap;" class=""><span style="font-family: tahoma, arial, helvetica, sans-serif; font-size: 11pt;" class="">Gruß,<br class=""><br class="">Thomas</span><br class=""></pre><div style="padding: 0px; margin: 0px; min-height: 11pt; font-family: tahoma, arial, helvetica, sans-serif; font-size: 11pt;" class=""><br class=""></div><div style="padding: 0px; margin: 0px; min-height: 11pt; font-family: tahoma, arial, helvetica, sans-serif; font-size: 11pt;" class=""><br class=""></div>
<blockquote style="border-left: 2px solid #325FBA; padding-left: 5px; margin: 0px 5px;" class=""><span style="font-family: tahoma,arial,helvetica,sans-serif; font-size: 10pt;" class="">-----Ursprüngliche Nachricht-----<br class=""><span class=""><strong class="">Von:</strong> Andreas Goetz <<a href="mailto:cpuidle@gmail.com" class="">cpuidle@gmail.com</a>></span><br class=""><span class=""><strong class="">Gesendet:</strong> Freitag 29 März 2019 11:29</span><br class=""><span class=""><strong class="">An:</strong> <a href="http://volkszaehler.org" class="">volkszaehler.org</a> - users <<a href="mailto:volkszaehler-users@demo.volkszaehler.org" class="">volkszaehler-users@demo.volkszaehler.org</a>></span><br class=""><span class=""><strong class="">Betreff:</strong> Re: [vz-users] VZ2.0</span><br class=""><br class=""></span><!-- begin sanitized html -->
<div class="bodyclass">Hast Du das mal ausprobiert? Erfahrungsbericht wäre Klasse und auch fürs Wiki wär das sicher relevant.
<div class=""><br class=""></div>
<div class="">Viele Grüße, Andreas</div>
<div class=""><br class="">
<div class=""><br class="">
<blockquote class="">
<div class="">On 27. Mar 2019, at 12:29, Andreas Goetz <<a href="mailto:cpuidle@gmail.com" target="_blank" title="mailto:cpuidle@gmail.com Klicken Sie auf den Link, um die URL in einem neuen Fenster zu öffnen." rel="noopener" class="">cpuidle@gmail.com</a>> wrote:</div>
<br class="Apple-interchange-newline">
<div class="">
<div class="" dir="ltr">
<div class="">Hallo Thomas,</div>
<div class=""><br class=""></div>
<div class="">mir ist noch eingefallen dass Du den ausreißer vmtl. per Browser (!) ohne SQL reparieren kannst:</div>
<div class=""><br class=""></div>
<div class="">- Klick auf das (i) in der Kanalliste, dann "Daten"</div>
<div class="">- im neuen Fenster erscheint die Abfrage der Middleware für den im GUI gewählten Zeitraum- daran ein "&value<0" für die negativen Werte anhängen</div>
<div class="">- wenn das Ergebnis plausibel aussieht nochmal ein "&operation=delete" anhängen</div>
<div class=""><br class=""></div>
<div class="">Zu beachten ist, dass die value-Einschränkung auf die Rohdaten geht- bei einem "Sensor" entsprechen die aber, bis auf "Resolution" als Skalierungsfaktor dem was Du siehst.</div>
<div class="">Natürlich muss Dein VZ Datenbankuser die Rechte zum löschen haben...</div>
<div class=""><br class=""></div>
<div class="">vg</div>
<div class="">Andreas</div>
<div class=""><br class=""></div>
</div>
<br class="">
<div class="gmail_quote">
<div class="gmail_attr" dir="ltr">On Wed, Mar 27, 2019 at 10:40 AM Thomas Höpfner <<a href="mailto:thomas@thhoe.de" target="_blank" title="mailto:thomas@thhoe.de Klicken Sie auf den Link, um die URL in einem neuen Fenster zu öffnen." rel="noopener" class="">thomas@thhoe.de</a>> wrote:<br class=""></div>
<blockquote class="gmail_quote" style="margin: 0px 0px 0px 0.8ex; padding-left: 1ex; border-left-color: #cccccc; border-left-width: 1px; border-left-style: solid;"><u class=""></u>
<div class="">
<div class="" style="margin: 0px; padding: 0px; font-family: tahoma, arial, helvetica, sans-serif; font-size: 11pt;">Hallo Andreas,</div>
<div class="" style="margin: 0px; padding: 0px; font-family: tahoma, arial, helvetica, sans-serif; font-size: 11pt;"><span class="" style="font-family: tahoma,arial,helvetica,sans-serif; font-size: 11pt;"><br class=""></span></div>
<div class="" style="margin: 0px; padding: 0px; font-family: tahoma, arial, helvetica, sans-serif; font-size: 11pt;"><span class="" style="font-family: tahoma,arial,helvetica,sans-serif; font-size: 11pt;">Danke für die superschnelle Antwort.</span></div>
<div class="" style="margin: 0px; padding: 0px; font-family: tahoma, arial, helvetica, sans-serif; font-size: 11pt;">Der negative Wert resultiert aus einen Bug in meiner Erfassung. Dieser wird auch im Verlauf so angezeigt.</div>
<div class="" style="margin: 0px; padding: 0px; font-family: tahoma, arial, helvetica, sans-serif; font-size: 11pt;"><span class="" style="font-family: tahoma,arial,helvetica,sans-serif; font-size: 11pt;"><span class=""><noname.png></span><br class=""></span></div>
<div class="" style="margin: 0px; padding: 0px; font-family: tahoma, arial, helvetica, sans-serif; font-size: 11pt;"><span class="" style="font-family: tahoma,arial,helvetica,sans-serif; font-size: 11pt;"><br class=""></span></div>
<div class="" style="margin: 0px; padding: 0px; font-family: tahoma, arial, helvetica, sans-serif; font-size: 11pt;"><span class="" style="font-family: tahoma,arial,helvetica,sans-serif; font-size: 11pt;">Was für mich nicht passt ist die zeitliche Zuordnung des Balkens im 1. Screenshot.<br class=""></span></div>
<pre class="" style="white-space: pre-wrap;"><span class="" style="font-family: tahoma,arial,helvetica,sans-serif; font-size: 11pt;"><br class="">Mit freundlichen Grüßen,<br class=""><br class="">Thomas </span></pre>
<div class="" style="margin: 0px; padding: 0px; font-family: tahoma, arial, helvetica, sans-serif; font-size: 11pt; min-height: 11pt;"><br class=""></div>
<blockquote class="" style="margin: 0px 5px; padding-left: 5px; border-left-color: #325fba; border-left-width: 2px; border-left-style: solid;">
<div class="gmail_quote">
<blockquote class="gmail_quote" style="margin: 0px 0px 0px 0.8ex; padding-left: 1ex; border-left-color: #cccccc; border-left-width: 1px; border-left-style: solid;">
<div class="">
<pre class="" style="white-space: pre-wrap;"> </pre>
</div>
</blockquote>
</div>
</blockquote>
</div>
</blockquote>
</div>
</div>
</blockquote>
</div>
<br class=""></div>
</div>
<!-- end sanitized html --></blockquote>
</div>
</div></blockquote></div><br class=""></div></body></html>