<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">müsste per einzelnem mysql update statement gehen ala:<div class=""><pre class="programlisting" style="box-sizing: inherit; margin-top: 20px; margin-bottom: 20px; margin-left: 6px; padding: 3px 8px; border: 1px solid rgb(217, 217, 217); outline: 0px; font-size: 13px; vertical-align: baseline; background-color: rgb(238, 238, 238); font-family: 'Courier New', Courier, fixed, monospace; overflow: auto; line-height: 1.5;">UPDATE t1 SET col1 = col1 / 1600 * 2000;</pre><div class="">(wenn jetzt noch jemand die korrekten Tabellennamen und Spaltennamen nennen könnte… ;-)</div><div class=""><br class=""></div><div><blockquote type="cite" class=""><div class="">Am 26.06.2016 um 21:56 schrieb Klaus Reichenecker <<a href="mailto:kr@kr123.de" class="">kr@kr123.de</a>>:</div><br class="Apple-interchange-newline"><div class=""><div style="font-family: Helvetica; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255);" class=""><font size="2" face="Arial" class="">Nicht schön,</font></div><div style="font-family: Helvetica; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255);" class=""><font size="2" face="Arial" class=""></font> </div><div style="font-family: Helvetica; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255);" class=""><font size="2" face="Arial" class="">aber ich würde jetzt einen neuen Kanal anlegen,</font></div><div style="font-family: Helvetica; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255);" class=""><font size="2" face="Arial" class="">beim alten die UUID ändern, und wenn ich Vergleiche übers Jahr sehen will beide anschalten</font></div><div style="font-family: Helvetica; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255);" class=""><font size="2" face="Arial" class=""></font> </div><div style="font-family: Helvetica; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255);" class=""><font size="2" face="Arial" class="">Grüße</font></div><div style="font-family: Helvetica; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255);" class=""><font size="2" face="Arial" class=""></font> </div><div style="font-family: Helvetica; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255);" class=""><font size="2" face="Arial" class="">Klaus</font></div><blockquote dir="ltr" style="font-family: Helvetica; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); padding-left: 5px; margin-left: 5px; border-left-color: rgb(0, 0, 0); border-left-width: 2px; border-left-style: solid; padding-right: 0px; margin-right: 0px;" class="" type="cite"><div style="font-style: normal; font-variant-caps: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-family: arial;" class="">----- Original Message -----<span class="Apple-converted-space"> </span></div><div style="background-color: rgb(228, 228, 228); font-style: normal; font-variant-caps: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-family: arial; background-position: initial initial; background-repeat: initial initial;" class=""><b class="">From:</b><span class="Apple-converted-space"> </span><a title="thomas@thhoe.de" href="mailto:thomas@thhoe.de" style="text-decoration: underline; color: rgb(149, 79, 114);" class="">Thomas Höpfner</a></div><div style="font-style: normal; font-variant-caps: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-family: arial;" class=""><b class="">To:</b><span class="Apple-converted-space"> </span><a title="volkszaehler-users@lists.volkszaehler.org" href="mailto:volkszaehler-users@lists.volkszaehler.org" style="text-decoration: underline; color: rgb(149, 79, 114);" class="">volkszaehler-users@lists.volkszaehler.org</a></div><div style="font-style: normal; font-variant-caps: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-family: arial;" class=""><b class="">Sent:</b><span class="Apple-converted-space"> </span>Sunday, June 26, 2016 8:26 PM</div><div style="font-style: normal; font-variant-caps: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-family: arial;" class=""><b class="">Subject:</b><span class="Apple-converted-space"> </span>[vz-users] Zählertausch</div><div class=""><br class=""></div><div class="WordSection1" style="page: WordSection1;"><div style="font-size: 11pt; font-family: Calibri, sans-serif; margin: 0cm 0cm 0pt;" class="">Hallo zusammen,<o:p class=""></o:p></div><div style="font-size: 11pt; font-family: Calibri, sans-serif; margin: 0cm 0cm 0pt;" class=""><o:p class=""> </o:p></div><div style="font-size: 11pt; font-family: Calibri, sans-serif; margin: 0cm 0cm 0pt;" class="">heute musste ich meinen Zähler tauschen.<span class="Apple-converted-space"> </span><o:p class=""></o:p></div><div style="font-size: 11pt; font-family: Calibri, sans-serif; margin: 0cm 0cm 0pt;" class="">Das Problem, der alte hatte 1600 Imp/kWh, der neue 2000.<o:p class=""></o:p></div><div style="font-size: 11pt; font-family: Calibri, sans-serif; margin: 0cm 0cm 0pt;" class="">Nachdem ich die Einstellung für den Zähler im Frontend stimmen die alten Daten nicht mehr.<o:p class=""></o:p></div><div style="font-size: 11pt; font-family: Calibri, sans-serif; margin: 0cm 0cm 0pt;" class="">Ich suche jetzt nach einer Möglichkeit das die alten und neuen Daten als ein Kanal im Frontend angezeigt werden.<o:p class=""></o:p></div><div style="font-size: 11pt; font-family: Calibri, sans-serif; margin: 0cm 0cm 0pt;" class="">Kann man die Daten in der Datenbank irgendwie "migrieren"?<o:p class=""></o:p></div><div style="font-size: 11pt; font-family: Calibri, sans-serif; margin: 0cm 0cm 0pt;" class="">Es muss auch in der Datenbank sein, die Impulse werden von einen Net-IO mit Ethersex an die Middleware übertragen. Auf den habe ich im Moment keinen Zugriff.<o:p class=""></o:p></div><div style="font-size: 11pt; font-family: Calibri, sans-serif; margin: 0cm 0cm 0pt;" class=""><o:p class=""> </o:p></div><div style="font-size: 11pt; font-family: Calibri, sans-serif; margin: 0cm 0cm 0pt;" class="">Ich hoffe jemand kann mir helfen.<o:p class=""></o:p></div><div style="font-size: 11pt; font-family: Calibri, sans-serif; margin: 0cm 0cm 0pt;" class=""><o:p class=""> </o:p></div><div style="font-size: 11pt; font-family: Calibri, sans-serif; margin: 0cm 0cm 0pt;" class="">Gruß,<o:p class=""></o:p></div><div style="font-size: 11pt; font-family: Calibri, sans-serif; margin: 0cm 0cm 0pt;" class=""><o:p class=""> </o:p></div><div style="font-size: 11pt; font-family: Calibri, sans-serif; margin: 0cm 0cm 0pt;" class="">Thomas<o:p class=""></o:p></div><div style="font-size: 11pt; font-family: Calibri, sans-serif; margin: 0cm 0cm 0pt;" class=""><o:p class=""> </o:p></div><div style="font-size: 11pt; font-family: Calibri, sans-serif; margin: 0cm 0cm 0pt;" class=""><o:p class=""> </o:p></div></div></blockquote></div></blockquote></div><br class=""><div class="">
<span class="Apple-style-span" style="border-collapse: separate; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: normal; border-spacing: 0px;"><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div class="">Gruß</div><div class=""><br class=""></div><div class="">Matthias</div></div></span>
</div>
<br class=""></div></body></html>