https://wiki.emotouch.de/index.php?action=history&feed=atom&title=Translations%3AZeitstempel-Formate%2F6%2Fen 2026-05-13T13:07:14Z Versionsgeschichte dieser Seite in emoTouch MediaWiki 1.35.1 https://wiki.emotouch.de/index.php?title=Translations:Zeitstempel-Formate/6/en&diff=2054&oldid=prev 2022-11-13T22:08:22Z

<p>FuzzyBot verschob die Seite <a href="/index.php?title=Translations:Datenexport_und_Import:_Anwendungsbeispiel/6/en&amp;action=edit&amp;redlink=1" class="new" title="Translations:Datenexport und Import: Anwendungsbeispiel/6/en (Seite nicht vorhanden)">Translations:Datenexport und Import: Anwendungsbeispiel/6/en</a> nach <a href="/index.php/Translations:Zeitstempel-Formate/6/en" title="Translations:Zeitstempel-Formate/6/en">Translations:Zeitstempel-Formate/6/en</a>, ohne dabei eine Weiterleitung anzulegen: Teil der übersetzbaren Seite „Datenexport und Import: Anwendungsbeispiel“</p> <table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface"> <tr class="diff-title" lang="de"> <td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">← Nächstältere Version</td> <td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">Version vom 13. November 2022, 22:08 Uhr</td> </tr><tr><td colspan="2" class="diff-notice" lang="de"><div class="mw-diff-empty">(kein Unterschied)</div> </td></tr></table>

FuzzyBot https://wiki.emotouch.de/index.php?title=Translations:Zeitstempel-Formate/6/en&diff=1757&oldid=prev 2022-07-01T11:57:20Z

<p></p> <table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="de"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Nächstältere Version</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Version vom 1. Juli 2022, 11:57 Uhr</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l2" >Zeile 2:</td> <td colspan="2" class="diff-lineno">Zeile 2:</td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=== UNIX Timestamp ===  </div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=== UNIX Timestamp ===  </div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* Export your data  in emoTouch with the option ''UNIX Timestamp''.</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* Export your data  in emoTouch with the option ''UNIX Timestamp''.</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>* Load and open the Excel template ''emoTouch Import''.</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>* Load and open the Excel template ''<ins class="diffchange diffchange-inline">[[Media:EmoTouch_Import.xlsx|</ins>emoTouch Import<ins class="diffchange diffchange-inline">]]</ins>''.</div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* Import the emoTouch export file using the ''Import/Text File'' option (not the CSV option).  </div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* Import the emoTouch export file using the ''Import/Text File'' option (not the CSV option).  </div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* You do not need to change the default settings of the import dialog. Import the data to a new sheet in the same workbook.</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* You do not need to change the default settings of the import dialog. Import the data to a new sheet in the same workbook.</div></td></tr> <!-- diff cache key mediawiki:diff::1.12:old-1404:rev-1757 --> </table>

Fgehrs https://wiki.emotouch.de/index.php?title=Translations:Zeitstempel-Formate/6/en&diff=1404&oldid=prev 2022-05-02T10:17:13Z

<p>Die Seite wurde neu angelegt: „== Microsoft Excel == === UNIX Timestamp === * Export your data in emoTouch with the option &#039;&#039;UNIX Timestamp&#039;&#039;. * Load and open the Excel template &#039;&#039;emoTouch…“</p> <p><b>Neue Seite</b></p><div>== Microsoft Excel ==<br /> === UNIX Timestamp === <br /> * Export your data in emoTouch with the option ''UNIX Timestamp''.<br /> * Load and open the Excel template ''emoTouch Import''.<br /> * Import the emoTouch export file using the ''Import/Text File'' option (not the CSV option). <br /> * You do not need to change the default settings of the import dialog. Import the data to a new sheet in the same workbook.<br /> * EXCEL displays the long numbers of the Unix timestamp in scientific notation by default (1.6xxxxE+12). This prevents you from seeing the relevant end of the timestamp with the last three numbers representing milliseconds. To change this, select the column containing the timestamp and apply the &quot;UNIX Timestamp&quot; cell template that comes with the template. <br /> * To convert the UNIX Timestamp to a readable Date_Time format, copy the formula in the &quot;Date_Time&quot; column of the &quot;Templates&quot; sheet and copy it to an empty column of the sheet containing your imported emoTouch data. You may need to adjust the reference to the Unix timestamp column in the formula (E by default). If you see only one row of hashtags (######), the column is simply not wide enough to display the contents. <br /> * To change the format of the date_time column, you can select another option in the ''cell styles'' dialog or create your own format.</div>

Aliebelt