<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Am 18.08.2016 um 06:40 schrieb Daniel Lauckner:<br>
<blockquote cite="mid:1615091394.20160818064053@jahp.de" type="cite">
<pre wrap="">Hallo Saftwerk,
Das kommt daher das die MW zwar das "yesterday" erkennt aber
die Uhrzeit nicht. Deswegen wird der Tuple von gestern ~00Uhr
zurück gegeben.
Die Uhrzeit muss nach dem Tag stehen, dann wirds besser.
</pre>
</blockquote>
Hallo Daniel,<br>
Vielen Dank, mit dem "&to=yesterday 22:00" klappt es viel besser
:-)<br>
<br>
Aber nochmal zum Problem mit "&from=": Leider stimmt deine
Vermutung, trotzdem muss noch ein weiterer Bug drin sein.<br>
Unten um Beispiel mit from zeigt der Header die richtige Zeit aber
beim erstem Tupel die falsche Zeit.<br>
Auch ist merkwürdig dass in Header dreimal 21:58 und einmal 21:59
steht.<br>
<br>
<a class="moz-txt-link-freetext"
href="http://pi3.fritz.box/middleware.php/data.csv">http://pi3.fritz.box/middleware.php/data.csv</a>?<font
color="#cc0000"><b>from=yesterday%2022:00</b></font>&uuid[]=00000007-0001-0182-ffff-0123456789ab&uuid[]=00000008-0001-0181-ffff-0123456789ab&uuid[]=00000006-0001-0280-ffff-0123456789ab&uuid[]=00000010-0002-0180-ffff-0123456789ab&tuples=2&options=raw&tsfmt=sql<br>
<table x:str="" style="border-collapse: collapse;width:282pt"
border="0" cellpadding="0" cellspacing="0" width="377">
<colgroup><col
style="mso-width-source:userset;mso-width-alt:3913;width:80pt"
width="107"> <col
style="mso-width-source:userset;mso-width-alt:8594;width:176pt"
width="235"> <col
style="mso-width-source:userset;mso-width-alt:1280;width:26pt"
width="35"> </colgroup><tbody>
<tr style="height:12.75pt" height="17">
<td style="height:12.75pt;width:80pt" height="17" width="107">#
source:</td>
<td style="width:176pt" width="235">volkszaehler.org</td>
<td style="width:26pt" width="35"><br>
</td>
</tr>
<tr style="height:12.75pt" height="17">
<td style="height:12.75pt" height="17"># version:</td>
<td>0.3</td>
<td><br>
</td>
</tr>
<tr style="height:12.75pt" height="17">
<td style="height:12.75pt" height="17"><br>
</td>
<td><br>
</td>
<td><br>
</td>
</tr>
<tr style="height:12.75pt" height="17">
<td style="height:12.75pt" height="17"># uuid:</td>
<td>00000007-0001-0182-ffff-0123456789ab</td>
<td><br>
</td>
</tr>
<tr style="height:12.75pt" height="17">
<td style="height:12.75pt" height="17"># title:</td>
<td>Haus HT</td>
<td><br>
</td>
</tr>
<tr style="height:12.75pt" height="17">
<td style="height:12.75pt" height="17"># from:</td>
<td class="xl22" x:num="42600.916631944441" align="right">18.08.2016
<font color="#cc0000"><b>21:59</b></font></td>
<td><br>
</td>
</tr>
<tr style="height:12.75pt" height="17">
<td style="height:12.75pt" height="17"># to:</td>
<td class="xl22" x:num="42601.350486111114" align="right">19.08.2016
08:24</td>
<td><br>
</td>
</tr>
<tr style="height:12.75pt" height="17">
<td style="height:12.75pt" height="17"># average:</td>
<td x:num="" align="right">0</td>
<td><br>
</td>
</tr>
<tr style="height:12.75pt" height="17">
<td style="height:12.75pt" height="17"># consumption:</td>
<td x:num="" align="right">0</td>
<td><br>
</td>
</tr>
<tr style="height:12.75pt" height="17">
<td style="height:12.75pt" height="17"># rows:</td>
<td x:num="" align="right">2</td>
<td><br>
</td>
</tr>
<tr style="height:12.75pt" height="17">
<td class="xl22" style="height:12.75pt"
x:num="42601.259062500001" height="17" align="right">19.08.2016
<font color="#cc0000"><b>06:13</b></font></td>
<td>6984536.7</td>
<td x:num="" align="right">710</td>
</tr>
<tr style="height:12.75pt" height="17">
<td class="xl22" style="height:12.75pt"
x:num="42601.350486111114" height="17" align="right">19.08.2016
08:24</td>
<td x:num="" align="right">6984597</td>
<td x:num="" align="right">709</td>
</tr>
<tr style="height:12.75pt" height="17">
<td style="height:12.75pt" height="17"><br>
</td>
<td><br>
</td>
<td><br>
</td>
</tr>
<tr style="height:12.75pt" height="17">
<td style="height:12.75pt" height="17"># uuid:</td>
<td>00000008-0001-0181-ffff-0123456789ab</td>
<td><br>
</td>
</tr>
<tr style="height:12.75pt" height="17">
<td style="height:12.75pt" height="17"># title:</td>
<td>Haus NT</td>
<td><br>
</td>
</tr>
<tr style="height:12.75pt" height="17">
<td style="height:12.75pt" height="17"># from:</td>
<td class="xl22" x:num="42600.915520833332" align="right">18.08.2016
<font color="#cc0000"><b>21:58</b></font></td>
<td><br>
</td>
</tr>
<tr style="height:12.75pt" height="17">
<td style="height:12.75pt" height="17"># to:</td>
<td class="xl22" x:num="42601.350358796299" align="right">19.08.2016
08:24</td>
<td><br>
</td>
</tr>
<tr style="height:12.75pt" height="17">
<td style="height:12.75pt" height="17"># average:</td>
<td x:num="" align="right">0</td>
<td><br>
</td>
</tr>
<tr style="height:12.75pt" height="17">
<td style="height:12.75pt" height="17"># consumption:</td>
<td x:num="" align="right">0</td>
<td><br>
</td>
</tr>
<tr style="height:12.75pt" height="17">
<td style="height:12.75pt" height="17"># rows:</td>
<td x:num="" align="right">2</td>
<td><br>
</td>
</tr>
<tr style="height:12.75pt" height="17">
<td class="xl22" style="height:12.75pt"
x:num="42601.063807870371" height="17" align="right">19.08.2016
<font color="#cc0000"><b>01:31</b></font></td>
<td>16461004.3</td>
<td x:num="" align="right">5661</td>
</tr>
<tr style="height:12.75pt" height="17">
<td class="xl22" style="height:12.75pt"
x:num="42601.350358796299" height="17" align="right">19.08.2016
08:24</td>
<td>16461556.9</td>
<td x:num="" align="right">5660</td>
</tr>
<tr style="height:12.75pt" height="17">
<td style="height:12.75pt" height="17"><br>
</td>
<td><br>
</td>
<td><br>
</td>
</tr>
<tr style="height:12.75pt" height="17">
<td style="height:12.75pt" height="17"># uuid:</td>
<td>00000006-0001-0280-ffff-0123456789ab</td>
<td><br>
</td>
</tr>
<tr style="height:12.75pt" height="17">
<td style="height:12.75pt" height="17"># title:</td>
<td>Haus ET</td>
<td><br>
</td>
</tr>
<tr style="height:12.75pt" height="17">
<td style="height:12.75pt" height="17"># from:</td>
<td class="xl22" x:num="42600.915405092594" align="right">18.08.2016
<font color="#cc0000"><b>21:58</b></font></td>
<td><br>
</td>
</tr>
<tr style="height:12.75pt" height="17">
<td style="height:12.75pt" height="17"># to:</td>
<td class="xl22" x:num="42601.350844907407" align="right">19.08.2016
08:25</td>
<td><br>
</td>
</tr>
<tr style="height:12.75pt" height="17">
<td style="height:12.75pt" height="17"># average:</td>
<td x:num="" align="right">0</td>
<td><br>
</td>
</tr>
<tr style="height:12.75pt" height="17">
<td style="height:12.75pt" height="17"># consumption:</td>
<td x:num="" align="right">0</td>
<td><br>
</td>
</tr>
<tr style="height:12.75pt" height="17">
<td style="height:12.75pt" height="17"># rows:</td>
<td x:num="" align="right">2</td>
<td><br>
</td>
</tr>
<tr style="height:12.75pt" height="17">
<td class="xl22" style="height:12.75pt"
x:num="42601.315995370373" height="17" align="right">19.08.2016
<font color="#cc0000"><b>07:35</b></font></td>
<td>25114143.9</td>
<td x:num="" align="right">1940</td>
</tr>
<tr style="height:12.75pt" height="17">
<td class="xl22" style="height:12.75pt"
x:num="42601.350844907407" height="17" align="right">19.08.2016
08:25</td>
<td>25115137.5</td>
<td x:num="" align="right">1940</td>
</tr>
<tr style="height:12.75pt" height="17">
<td style="height:12.75pt" height="17"><br>
</td>
<td><br>
</td>
<td><br>
</td>
</tr>
<tr style="height:12.75pt" height="17">
<td style="height:12.75pt" height="17"># uuid:</td>
<td>00000010-0002-0180-ffff-0123456789ab</td>
<td><br>
</td>
</tr>
<tr style="height:12.75pt" height="17">
<td style="height:12.75pt" height="17"># title:</td>
<td>PV</td>
<td><br>
</td>
</tr>
<tr style="height:12.75pt" height="17">
<td style="height:12.75pt" height="17"># from:</td>
<td class="xl22" x:num="42600.915706018517" align="right">18.08.2016
<font color="#cc0000"><b>21:58</b></font></td>
<td><br>
</td>
</tr>
<tr style="height:12.75pt" height="17">
<td style="height:12.75pt" height="17"># to:</td>
<td class="xl22" x:num="42601.350844907407" align="right">19.08.2016
08:25</td>
<td><br>
</td>
</tr>
<tr style="height:12.75pt" height="17">
<td style="height:12.75pt" height="17"># average:</td>
<td x:num="" align="right">0</td>
<td><br>
</td>
</tr>
<tr style="height:12.75pt" height="17">
<td style="height:12.75pt" height="17"># consumption:</td>
<td x:num="" align="right">0</td>
<td><br>
</td>
</tr>
<tr style="height:12.75pt" height="17">
<td style="height:12.75pt" height="17"># rows:</td>
<td x:num="" align="right">2</td>
<td><br>
</td>
</tr>
<tr style="height:12.75pt" height="17">
<td class="xl22" style="height:12.75pt"
x:num="42601.311932870369" height="17" align="right">19.08.2016
<font color="#cc0000"><b>07:29</b></font></td>
<td>30915781.9</td>
<td x:num="" align="right">2265</td>
</tr>
<tr style="height:12.75pt" height="17">
<td class="xl22" style="height:12.75pt"
x:num="42601.350844907407" height="17" align="right">19.08.2016
08:25</td>
<td>30916953.7</td>
<td x:num="" align="right">2264</td>
</tr>
</tbody>
</table>
<br>
<br>
<br>
</body>
</html>