<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    Hallo Michael,<br>
    <br>
    der Timestamp ist ein Unixtimestamp * 1000.<br>
    Ein Unix-Timestamp sind die Sekunden seit dem 01.01.1970 00:00:00.<br>
    <br>
    Daraus ergibt sich für deinen Timestamp 948239830000 der Zeitpunkt
    2000-01-18T23:57:10+00:00 (UTC).<br>
    <br>
    Liefiert evtl. der Zähler einen falschen Zeitstempel?<br>
    <br>
    Gruß<br>
    Maik<br>
    <br>
    <br>
    <div class="moz-cite-prefix">Am 03.10.20 um 18:48 schrieb Michael
      Hartmann:<br>
    </div>
    <blockquote type="cite"
      cite="mid:000301d699a5$0345fbe0$09d1f3a0$@web.de">
      <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
      <meta name="Generator" content="Microsoft Word 14 (filtered
        medium)">
      <style><!--
/* Font Definitions */
@font-face
        {font-family:Calibri;
        panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
        {font-family:Tahoma;
        panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
        {font-family:Consolas;
        panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0cm;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
        {mso-style-priority:99;
        color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {mso-style-priority:99;
        color:purple;
        text-decoration:underline;}
p
        {mso-style-priority:99;
        mso-margin-top-alt:auto;
        margin-right:0cm;
        mso-margin-bottom-alt:auto;
        margin-left:0cm;
        font-size:12.0pt;
        font-family:"Times New Roman","serif";}
pre
        {mso-style-priority:99;
        mso-style-link:"HTML Vorformatiert Zchn";
        margin:0cm;
        margin-bottom:.0001pt;
        font-size:10.0pt;
        font-family:"Courier New";}
span.HTMLVorformatiertZchn
        {mso-style-name:"HTML Vorformatiert Zchn";
        mso-style-priority:99;
        mso-style-link:"HTML Vorformatiert";
        font-family:Consolas;
        mso-fareast-language:DE;}
span.E-MailFormatvorlage21
        {mso-style-type:personal-reply;
        font-family:"Calibri","sans-serif";
        color:#1F497D;}
.MsoChpDefault
        {mso-style-type:export-only;
        font-family:"Calibri","sans-serif";
        mso-fareast-language:EN-US;}
@page WordSection1
        {size:612.0pt 792.0pt;
        margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
        {page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
      <div class="WordSection1">
        <p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Ich
            habe nun die Daten mit dem Zeitstempel < 1588291200000
            (übrigens : Wie berechnet der sich?) abgefragt.<o:p></o:p></span></p>
        <p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
        <p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"
            lang="EN-US">Hier das Ergebis:<o:p></o:p></span></p>
        <p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"
            lang="EN-US"><o:p> </o:p></span></p>
        <p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"
            lang="EN-US">MariaDB [volkszaehler]> select * from data
            where timestamp < 1588291200000;<o:p></o:p></span></p>
        <p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"
            lang="EN-US">+---------+------------+--------------+-----------------+<o:p></o:p></span></p>
        <p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"
            lang="EN-US">| id      | channel_id | timestamp    |
            value           |<o:p></o:p></span></p>
        <p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">+---------+------------+--------------+-----------------+<o:p></o:p></span></p>
        <p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">|
            3521890 |          3 | 948239830000 |            1910 |<o:p></o:p></span></p>
        <p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">|
            3521891 |          2 | 948239830000 |       1185382.4 |<o:p></o:p></span></p>
        <p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">|
            3521892 |          6 | 948239830000 |             226 |<o:p></o:p></span></p>
        <p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">|
            3521893 |          7 | 948239830000 |             226 |<o:p></o:p></span></p>
        <p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">|
            3521894 |          8 | 948239830000 |           227.9 |<o:p></o:p></span></p>
        <p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">|
            3521895 |          9 | 948239830000 |              50 |<o:p></o:p></span></p>
        <p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">|
            3521896 |          2 | 948239835000 |         1185385 |<o:p></o:p></span></p>
        <p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">|
            3521897 |          3 | 948239835000 |  1915.338745687 |<o:p></o:p></span></p>
        <p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">|
            3521898 |          6 | 948239835000 |           225.9 |<o:p></o:p></span></p>
        <p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">|
            3521899 |          7 | 948239835000 | 226.06681550639 |<o:p></o:p></span></p>
        <p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">|
            3521900 |          8 | 948239835000 | 227.86647046885 |<o:p></o:p></span></p>
        <p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">|
            3521901 |          9 | 948239835000 |              50 |<o:p></o:p></span></p>
        <p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">|
            3521902 |          6 | 948239840000 |  225.9016823553 |<o:p></o:p></span></p>
        <p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">|
            3521903 |          2 | 948239840000 |       1185387.7 |<o:p></o:p></span></p>
        <p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">|
            3521904 |          3 | 948239840000 | 1919.1273783297 |<o:p></o:p></span></p>
        <p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">|
            3521905 |          7 | 948239840000 | 225.96569196876 |<o:p></o:p></span></p>
        <p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">|
            3521906 |          8 | 948239840000 | 227.83262567595 |<o:p></o:p></span></p>
        <p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">|
            3521907 |          9 | 948239840000 | 49.965691968756 |<o:p></o:p></span></p>
        <p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">|
            3521908 |          1 | 948239844958 |               0 |<o:p></o:p></span></p>
        <p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">+---------+------------+--------------+-----------------+<o:p></o:p></span></p>
        <p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">19
            rows in set (41.838 sec)<o:p></o:p></span></p>
        <p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
        <p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Fällt
            euch da irgendetwas auf? Wie ordne ich die hier gelistete
            channel id der UUID zu?<o:p></o:p></span></p>
        <p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
        <p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Grüße<o:p></o:p></span></p>
        <p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
        <p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Micha<o:p></o:p></span></p>
        <p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
        <p class="MsoNormal"><b><span
style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">Von:</span></b><span
style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">
            volkszaehler-users
            [<a class="moz-txt-link-freetext" href="mailto:volkszaehler-users-bounces@demo.volkszaehler.org">mailto:volkszaehler-users-bounces@demo.volkszaehler.org</a>] <b>Im
              Auftrag von </b>Frank Richter<br>
            <b>Gesendet:</b> Samstag, 3. Oktober 2020 17:49<br>
            <b>An:</b> volkszaehler.org - users<br>
            <b>Betreff:</b> Re: [vz-users] Fehlerhafte Daten in der DB
            löschen/korrigieren<o:p></o:p></span></p>
        <p class="MsoNormal"><o:p> </o:p></p>
        <div>
          <p class="MsoNormal">Nach jeder Zeile SQL, so wie von mir
            geschrieben. "use volkszaehler" klappt anscheinend auch
            ohne.<o:p></o:p></p>
          <div>
            <p class="MsoNormal"><o:p> </o:p></p>
          </div>
          <div>
            <p class="MsoNormal">Steht übrigens auch im Hinweistext von
              MariaDB in deinem Screenshot ;-)<o:p></o:p></p>
          </div>
          <div>
            <p class="MsoNormal"><o:p> </o:p></p>
          </div>
          <div>
            <p class="MsoNormal">Grüße<o:p></o:p></p>
          </div>
          <div>
            <p class="MsoNormal">Frank<o:p></o:p></p>
          </div>
        </div>
        <p class="MsoNormal"><o:p> </o:p></p>
        <div>
          <div>
            <p class="MsoNormal">Michael Hartmann <<a
                href="mailto:hartmann-micha@web.de"
                moz-do-not-send="true">hartmann-micha@web.de</a>>
              schrieb am Sa., 3. Okt. 2020, 17:43:<o:p></o:p></p>
          </div>
          <blockquote style="border:none;border-left:solid #CCCCCC
            1.0pt;padding:0cm 0cm 0cm
            6.0pt;margin-left:4.8pt;margin-right:0cm">
            <div>
              <p class="MsoNormal" style="margin-bottom:12.0pt">Frank,
                das Semikolon nach der gesamten Syntax?<o:p></o:p></p>
              <div>
                <p class="MsoNormal">Am 3. Oktober 2020 16:40:54 MESZ
                  schrieb Frank Richter <<a
                    href="mailto:frank.richter83@gmail.com"
                    target="_blank" moz-do-not-send="true">frank.richter83@gmail.com</a>>:<o:p></o:p></p>
                <div>
                  <p class="MsoNormal"> Hallo Micha,<o:p></o:p></p>
                  <div>
                    <p class="MsoNormal"><o:p> </o:p></p>
                  </div>
                  <div>
                    <p class="MsoNormal">SQL-Queries immer mit einem
                      Semikolon ";" abschließen. Und nicht "select"
                      sondern "select *".<o:p></o:p></p>
                  </div>
                  <div>
                    <p class="MsoNormal"><o:p> </o:p></p>
                  </div>
                  <div>
                    <p class="MsoNormal">Grüße<o:p></o:p></p>
                  </div>
                  <div>
                    <p class="MsoNormal">Frank<o:p></o:p></p>
                  </div>
                </div>
                <p class="MsoNormal"><o:p> </o:p></p>
                <div>
                  <div>
                    <p class="MsoNormal">Michael Hartmann <<a
                        href="mailto:hartmann-micha@web.de"
                        target="_blank" moz-do-not-send="true">hartmann-micha@web.de</a>>
                      schrieb am Sa., 3. Okt. 2020, 16:33:<o:p></o:p></p>
                  </div>
                  <blockquote style="border:none;border-left:solid
                    #CCCCCC 1.0pt;padding:0cm 0cm 0cm
                    6.0pt;margin-left:4.8pt;margin-right:0cm">
                    <div>
                      <div>
                        <p class="MsoNormal"
                          style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Hallo
                            Frank,</span><o:p></o:p></p>
                        <p class="MsoNormal"
                          style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </span><o:p></o:p></p>
                        <p class="MsoNormal"
                          style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">ich
                            habe das gemäß deiner Anleitung
                            abgearbeitet, ende aber an einer
                            „Eingabeaufforderung“ (->). Unabhängig ob
                            ich den Befehl select oder delete
                            voranstelle. Die Daten sind unverändert.</span><o:p></o:p></p>
                        <p class="MsoNormal"
                          style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </span><o:p></o:p></p>
                        <p class="MsoNormal"
                          style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Grüße</span><o:p></o:p></p>
                        <p class="MsoNormal"
                          style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </span><o:p></o:p></p>
                        <p class="MsoNormal"
                          style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Micha</span><o:p></o:p></p>
                        <p class="MsoNormal"
                          style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </span><o:p></o:p></p>
                        <p class="MsoNormal"
                          style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span
style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">Von:</span></b><span
style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">
                            volkszaehler-users [mailto:<a
                              href="mailto:volkszaehler-users-bounces@demo.volkszaehler.org"
                              target="_blank" moz-do-not-send="true">volkszaehler-users-bounces@demo.volkszaehler.org</a>]
                            <b>Im Auftrag von </b>Frank Richter<br>
                            <b>Gesendet:</b> Donnerstag, 1. Oktober 2020
                            19:01<br>
                            <b>An:</b> <a
                              href="http://volkszaehler.org"
                              target="_blank" moz-do-not-send="true">volkszaehler.org</a>
                            - users<br>
                            <b>Betreff:</b> Re: [vz-users] Fehlerhafte
                            Daten in der DB löschen/korrigieren</span><o:p></o:p></p>
                        <p class="MsoNormal"
                          style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
                        <div>
                          <p class="MsoNormal"
                            style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Hallo
                            Micha,<o:p></o:p></p>
                          <div>
                            <p class="MsoNormal"
                              style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
                          </div>
                          <div>
                            <p class="MsoNormal"
                              style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">finden
                              musst du ihn gar nicht zwingend, nur
                              löschen. Wenn du dir sicher bist, dass du
                              vor Mai nix sinnvolles in der DB hast,
                              kannst du folgendes machen:<o:p></o:p></p>
                          </div>
                          <div>
                            <p class="MsoNormal"
                              style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
                          </div>
                          <div>
                            <p class="MsoNormal"
                              style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">sudo
                              mysql<o:p></o:p></p>
                          </div>
                          <div>
                            <p class="MsoNormal"
                              style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">use
                              volkszaehler;<o:p></o:p></p>
                          </div>
                          <div>
                            <p class="MsoNormal"
                              style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">delete
                              from data where timestamp <
                              1588291200000;<o:p></o:p></p>
                          </div>
                          <div>
                            <p class="MsoNormal"
                              style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">exit<o:p></o:p></p>
                          </div>
                          <div>
                            <p class="MsoNormal"
                              style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
                          </div>
                          <div>
                            <p class="MsoNormal"
                              style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Der
                              Timestamp ist der 01. Mai 20 00:00 UTC.<o:p></o:p></p>
                          </div>
                          <div>
                            <p class="MsoNormal"
                              style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
                          </div>
                          <div>
                            <p class="MsoNormal"
                              style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Wenn
                              du vorher sehen willst, welche Datensätze
                              betroffen sind, ersetze delete durch
                              select *<o:p></o:p></p>
                          </div>
                          <div>
                            <p class="MsoNormal"
                              style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
                          </div>
                          <div>
                            <p class="MsoNormal"
                              style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Viele
                              Grüße<o:p></o:p></p>
                          </div>
                          <div>
                            <p class="MsoNormal"
                              style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Frank<o:p></o:p></p>
                          </div>
                        </div>
                        <p class="MsoNormal"
                          style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
                        <div>
                          <div>
                            <p class="MsoNormal"
                              style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Michael
                              Hartmann <<a
                                href="mailto:hartmann-micha@web.de"
                                target="_blank" moz-do-not-send="true">hartmann-micha@web.de</a>>
                              schrieb am Do., 1. Okt. 2020, 18:54:<o:p></o:p></p>
                          </div>
                          <blockquote
                            style="border:none;border-left:solid #CCCCCC
                            1.0pt;padding:0cm 0cm 0cm
6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt">
                            <div>
                              <p class="MsoNormal"
                                style="mso-margin-top-alt:auto;margin-bottom:12.0pt">Hallo
                                Frank,<br>
                                <br>
                                wie finde ich den? Ich bitte die
                                Anfängerfragen zu entschuldigen.<br>
                                <br>
                                Grüße<br>
                                <br>
                                Micha<o:p></o:p></p>
                              <div>
                                <p class="MsoNormal"
                                  style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Am
                                  1. Oktober 2020 17:56:34 MESZ schrieb
                                  Frank Richter <<a
                                    href="mailto:frank.richter83@gmail.com"
                                    target="_blank"
                                    moz-do-not-send="true">frank.richter83@gmail.com</a>>:<o:p></o:p></p>
                                <div>
                                  <div>
                                    <p class="MsoNormal"
                                      style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Hallo
                                      Micha,<o:p></o:p></p>
                                    <div>
                                      <p class="MsoNormal"
                                        style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
                                    </div>
                                    <div>
                                      <p class="MsoNormal"
                                        style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">wahrscheinlich
                                        hast du einen Wert mit Timestamp
                                        0 oder nahe 0 in der DB, also
                                        ca. 1970. Der muss raus.<o:p></o:p></p>
                                    </div>
                                    <div>
                                      <p class="MsoNormal"
                                        style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
                                    </div>
                                    <div>
                                      <p class="MsoNormal"
                                        style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Grüße<o:p></o:p></p>
                                    </div>
                                    <div>
                                      <p class="MsoNormal"
                                        style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Frank<o:p></o:p></p>
                                    </div>
                                    <p class="MsoNormal"
                                      style="mso-margin-top-alt:auto;margin-bottom:12.0pt"> <o:p></o:p></p>
                                    <div>
                                      <div>
                                        <p class="MsoNormal"
                                          style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Michael
                                          Hartmann <<a
                                            href="mailto:hartmann-micha@web.de"
                                            target="_blank"
                                            moz-do-not-send="true">hartmann-micha@web.de</a>>
                                          schrieb am Do., 1. Okt. 2020,
                                          14:36:<o:p></o:p></p>
                                      </div>
                                      <blockquote
                                        style="border:none;border-left:solid
                                        #CCCCCC 1.0pt;padding:0cm 0cm
                                        0cm
6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt">
                                        <div>
                                          <p class="MsoNormal"
                                            style="mso-margin-top-alt:auto;margin-bottom:12.0pt">Ich
                                            habe nur die Situation, dass
                                            für alle Zeiträume vor der
                                            Inbetriebnahme -2,1W im
                                            Frontend angezeigt werden.
                                            Egal, wie weit ich
                                            zurückgehe.<o:p></o:p></p>
                                          <div>
                                            <p class="MsoNormal"
                                              style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Am
                                              1. Oktober 2020 10:43:21
                                              MESZ schrieb "Thomas
                                              Höpfner" <<a
                                                href="mailto:thomas@thhoe.de"
                                                target="_blank"
                                                moz-do-not-send="true">thomas@thhoe.de</a>>:<o:p></o:p></p>
                                            <p
                                              style="margin:0cm;margin-bottom:.0001pt"><span
style="font-family:"Tahoma","sans-serif"">Hallo,</span><o:p></o:p></p>
                                            <p
                                              style="margin:0cm;margin-bottom:.0001pt"><span
style="font-family:"Tahoma","sans-serif""> </span><o:p></o:p></p>
                                            <p
                                              style="margin:0cm;margin-bottom:.0001pt"><span
style="font-family:"Tahoma","sans-serif"">man kann
                                                die Daten auch über das
                                                Frondent löschen. </span><o:p></o:p></p>
                                            <p
                                              style="margin:0cm;margin-bottom:.0001pt"><span
style="font-family:"Tahoma","sans-serif"">-
                                                Zeitbereich eingrenzen
                                                auf die zu löschten
                                                Daten </span><o:p></o:p></p>
                                            <p
                                              style="margin:0cm;margin-bottom:.0001pt"><span
style="font-family:"Tahoma","sans-serif"">- in der
                                                Auswertung auf deas
                                                blaue "I" klicken</span><o:p></o:p></p>
                                            <p
                                              style="margin:0cm;margin-bottom:.0001pt"><span
style="font-family:"Tahoma","sans-serif"">- in den
                                                sich öffnenten Fenster
                                                auf "Daten" klicken</span><o:p></o:p></p>
                                            <p
                                              style="margin:0cm;margin-bottom:.0001pt"><span
style="font-family:"Tahoma","sans-serif""> </span><o:p></o:p></p>
                                            <p
                                              style="margin:0cm;margin-bottom:.0001pt"><span
style="font-family:"Tahoma","sans-serif"">jetz
                                                öffnet sich eine Seite
                                                mit den in der Graphik
                                                angezeigten Daten .json
                                                formatiert </span><o:p></o:p></p>
                                            <p
                                              style="margin:0cm;margin-bottom:.0001pt"><span
style="font-family:"Tahoma","sans-serif"">- an die
                                                URL dieser Seite hängst
                                                du folgendes
                                                an: &operation=delete</span><o:p></o:p></p>
                                            <p
                                              style="margin:0cm;margin-bottom:.0001pt"><span
style="font-family:"Tahoma","sans-serif""> </span><o:p></o:p></p>
                                            <p
                                              style="margin:0cm;margin-bottom:.0001pt"><span
style="font-family:"Tahoma","sans-serif"">Bei den
                                                Syntax bin ich mir nicht
                                                sicher, habe es schon
                                                länger nicht mehr
                                                gemacht.</span><o:p></o:p></p>
                                            <p
                                              style="margin:0cm;margin-bottom:.0001pt"><span
style="font-family:"Tahoma","sans-serif"">Deshalb
                                                das Ganze ohne Gewähr.</span><o:p></o:p></p>
                                            <pre style="white-space:pre-wrap"><span style="font-size:12.0pt;font-family:"Tahoma","sans-serif"">Mit freundlichen Grüßen,</span><span style="font-size:11.0pt;font-family:"Tahoma","sans-serif"">

</span><span style="font-size:12.0pt;font-family:"Tahoma","sans-serif"">Thomas</span><span style="font-size:11.0pt;font-family:"Tahoma","sans-serif""> </span><o:p></o:p></pre>
                                            <p
                                              style="margin:0cm;margin-bottom:.0001pt;min-height:12pt"><span
style="font-family:"Tahoma","sans-serif""> </span><o:p></o:p></p>
                                            <blockquote
                                              style="border:none;border-left:solid
                                              #325FBA 1.5pt;padding:0cm
                                              0cm 0cm
4.0pt;margin-left:3.75pt;margin-top:5.0pt;margin-right:3.75pt;margin-bottom:5.0pt">
                                              <p class="MsoNormal"
                                                style="mso-margin-top-alt:auto;margin-bottom:12.0pt"><span
style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">-----Ursprüngliche
                                                  Nachricht-----<br>
                                                  <strong><span
                                                      style="font-family:"Tahoma","sans-serif"">Von:</span></strong>
                                                  Ralf Wismann <<a
                                                    href="mailto:ralf.wismann@gmx.de"
                                                    target="_blank"
                                                    moz-do-not-send="true">ralf.wismann@gmx.de</a>><br>
                                                  <strong><span
                                                      style="font-family:"Tahoma","sans-serif"">Gesendet:</span></strong>
                                                  Donnerstag 1 Oktober
                                                  2020 10:09<br>
                                                  <strong><span
                                                      style="font-family:"Tahoma","sans-serif"">An:</span></strong>
                                                  '<a
                                                    href="http://volkszaehler.org"
                                                    target="_blank"
                                                    moz-do-not-send="true">volkszaehler.org</a>
                                                  - users' <<a
                                                    href="mailto:volkszaehler-users@demo.volkszaehler.org"
                                                    target="_blank"
                                                    moz-do-not-send="true">volkszaehler-users@demo.volkszaehler.org</a>><br>
                                                  <strong><span
                                                      style="font-family:"Tahoma","sans-serif"">Betreff:</span></strong>
                                                  Re: [vz-users]
                                                  Fehlerhafte Daten in
                                                  der DB
                                                  löschen/korrigieren</span><o:p></o:p></p>
                                              <div>
                                                <div>
                                                  <p class="MsoNormal"
                                                    style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><strong> </strong><o:p></o:p></p>
                                                  <p class="MsoNormal"
                                                    style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Hallo<o:p></o:p></p>
                                                  <p class="MsoNormal"
                                                    style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">>Wie
                                                    kann ich die Daten
                                                    des Kanals vom Monat
                                                    Mai aus der DB
                                                    >löschen/korrigieren?<o:p></o:p></p>
                                                  <p class="MsoNormal"
                                                    style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
                                                  <p class="MsoNormal"
                                                    style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Lösche
                                                    bei mir fehlerhafte
                                                    Daten über ein
                                                    Skript raus. Dazu
                                                    nutze ich den
                                                    „harten“ delete
                                                    Befehle wie er hier
                                                    beschrieben ist:<o:p></o:p></p>
                                                  <p class="MsoNormal"
                                                    style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
                                                  <p class="MsoNormal"
                                                    style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><a
href="https://wiki.volkszaehler.org/howto/datenmengen" target="_blank"
                                                      title="https://wiki.volkszaehler.org/howto/datenmengen
                                                      Klicken Sie auf
                                                      den Link, um die
                                                      URL in einem neuen
                                                      Fenster zu
                                                      öffnen."
                                                      moz-do-not-send="true">https://wiki.volkszaehler.org/howto/datenmengen</a><o:p></o:p></p>
                                                  <p class="MsoNormal"
                                                    style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
                                                  <p class="MsoNormal"
                                                    style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Ich
                                                    würde die Befehle
                                                    aber dringend raten
                                                    im phpmyAdmin zu
                                                    simulieren und zu
                                                    testen bevor nachher
                                                    was falsches
                                                    gelöscht wird.<o:p></o:p></p>
                                                  <p class="MsoNormal"
                                                    style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
                                                  <p class="MsoNormal"
                                                    style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">VG<o:p></o:p></p>
                                                  <p class="MsoNormal"
                                                    style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Ralf<o:p></o:p></p>
                                                </div>
                                              </div>
                                            </blockquote>
                                          </div>
                                          <p class="MsoNormal"
                                            style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><br>
                                            -- <br>
                                            Diese Nachricht wurde von
                                            meinem Android-Gerät mit K-9
                                            Mail gesendet.<o:p></o:p></p>
                                        </div>
                                      </blockquote>
                                    </div>
                                  </div>
                                </div>
                              </div>
                              <p class="MsoNormal"
                                style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><br>
                                -- <br>
                                Diese Nachricht wurde von meinem
                                Android-Gerät mit K-9 Mail gesendet.<o:p></o:p></p>
                            </div>
                          </blockquote>
                        </div>
                      </div>
                    </div>
                  </blockquote>
                </div>
              </div>
              <p class="MsoNormal"><br>
                -- <br>
                Diese Nachricht wurde von meinem Android-Gerät mit K-9
                Mail gesendet.<o:p></o:p></p>
            </div>
          </blockquote>
        </div>
      </div>
    </blockquote>
    <br>
  </body>
</html>