Zeitstempel-Formate/en - Versionsgeschichte

FuzzyBot: Übernehme Bearbeitung einer neuen Version der Quellseite

2023-02-20T09:39:08Z

Übernehme Bearbeitung einer neuen Version der Quellseite

FuzzyBot: FuzzyBot verschob die Seite Datenexport und Import: Anwendungsbeispiel/en nach Zeitstempel-Formate/en, ohne dabei eine Weiterleitung anzulegen: Teil der übersetzbaren Seite „Datenexport und Import: Anwendungsbeispiel“

2022-11-13T22:08:21Z

FuzzyBot verschob die Seite Datenexport und Import: Anwendungsbeispiel/en nach Zeitstempel-Formate/en, ohne dabei eine Weiterleitung anzulegen: Teil der übersetzbaren Seite „Datenexport und Import: Anwendungsbeispiel“

Fgehrs am 1. Juli 2022 um 11:57 Uhr

2022-07-01T11:57:20Z

FuzzyBot: Übernehme Bearbeitung einer neuen Version der Quellseite

2022-07-01T11:56:29Z

Übernehme Bearbeitung einer neuen Version der Quellseite

Aliebelt: Die Seite wurde neu angelegt: „== SPSS == SPSS can easily import the UNIX timestamp format as a numeric value that can be used, for example, to calculate time differences. However, SPSS unfo…“

2022-05-02T10:29:47Z

Die Seite wurde neu angelegt: „== SPSS == SPSS can easily import the UNIX timestamp format as a numeric value that can be used, for example, to calculate time differences. However, SPSS unfo…“

Neue Seite

<languages />

The timeline data of emoTouch contains millisecond information. There are several ways to export this millisecond information to other programs and no program is able to import this information in every format. emoTouch supports the export of timeline information in three formats: UNIX timestamp, DATE_TIME and ISO 8601.

== Timestamp formats ==

=== UNIX timestamp ===
This is simply a very large number representing the number of milliseconds after 1970-1-1 00:00:00. Since it is an ordinary number, the UNIX timestamp is easy to import into other programs, but it is difficult for humans to read. Therefore, you will usually want to convert it to a more readable date format.

=== DATE_TIME ===
This is a formatted date and time that looks something like "2022-03-12 08:24:30.324". This format is readable, but more complicated to import, since the importing operating system and the program must use exactly the same format (e.g. for the decimal point) to read the time information correctly.

=== ISO 8601 ===
This is a readable format similar to DATE_TIME, supported by a few programs.

== Microsoft Excel ==
=== UNIX Timestamp ===
* Export your data in emoTouch with the option ''UNIX Timestamp''.
* Load and open the Excel template ''emoTouch Import''.
* Import the emoTouch export file using the ''Import/Text File'' option (not the CSV option).
* You do not need to change the default settings of the import dialog. Import the data to a new sheet in the same workbook.
* 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 "UNIX Timestamp" cell template that comes with the template.
* To convert the UNIX Timestamp to a readable Date_Time format, copy the formula in the "Date_Time" column of the "Templates" 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.
* To change the format of the date_time column, you can select another option in the ''cell styles'' dialog or create your own format.

=== DATE_TIME ===
* Export your data to emoTouch with the ''DATE_TIME'' option.
* '''CAUTION: The decimal point (comma or period) in the export file ''MUST'' match your operating system and program settings.'''
* Download and open the Excel template ''emoTouch Import''.
* Import the emoTouch export file using the ''Import/Text File'' option (not the CSV option).
* You do not need to change the default settings of the import dialog. Import the data into a new sheet in the same workbook.
* You should see the timestamp in date_time format with the milliseconds after the decimal point (comma or period), which depends on your operating system and program. If the last three digits (milliseconds) in the imported data are truncated or all set to 0, try using the other decimal point option in the emoTouch export options.
* To change the format of the date_time column, you can select another option in the ''cell styles'' dialog or create your own format.

== Open Office, Libre Office, Apple Numbers ==
To import the emoTouch timeline into these programs, you can also download the template file for Microsoft Excel, open it and follow the basic procedure in the Excel section.

== SPSS ==
SPSS can easily import the UNIX timestamp format as a numeric value that can be used, for example, to calculate time differences. However, SPSS unfortunately does not support readable date/time formats containing milliseconds. If you try to convert the UNIX timestamp to a readable format in SPSS or import the DATE_TIME or ISO 8601 format into SPSS, this will probably fail or produce unreliable data.

@@ Zeile 1: / Zeile 1: @@
 <languages/>
 The timeline data of emoTouch contains millisecond information. There are several ways to export this millisecond information to other programs and no program is able to import this information in every format. emoTouch supports the export of timeline information in three formats: UNIX timestamp, DATE_TIME and ISO 8601.
@@ Zeile 12: / Zeile 11: @@
 === ISO 8601 ===
 This is a readable format similar to DATE_TIME, supported by a few programs.

← Nächstältere Version	Version vom 13. November 2022, 22:08 Uhr
(kein Unterschied)

@@ Zeile 14: / Zeile 14: @@
 This is a readable format similar to DATE_TIME, supported by a few programs.
 == Microsoft Excel ==
 === UNIX Timestamp ===
 * Export your data  in emoTouch with the option ''UNIX Timestamp''.
-* Load and open the Excel template ''emoTouch Import''.
+* Load and open the Excel template ''[[Media:EmoTouch_Import.xlsx|emoTouch Import]]''.
 * Import the emoTouch export file using the ''Import/Text File'' option (not the CSV option).
 * You do not need to change the default settings of the import dialog. Import the data to a new sheet in the same workbook.
@@ Zeile 24: / Zeile 23: @@
 * To convert the UNIX Timestamp to a readable Date_Time format, copy the formula in the "Date_Time" column of the "Templates" 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.
 * To change the format of the date_time column, you can select another option in the ''cell styles'' dialog or create your own format.
 === DATE_TIME ===