Zeitstempel-Formate/en: Unterschied zwischen den Versionen

Aus emoTouch
Zur Navigation springen Zur Suche springen
(Übernehme Bearbeitung einer neuen Version der Quellseite)
 
(Eine dazwischenliegende Version desselben Benutzers wird nicht angezeigt)
Zeile 1: Zeile 1:
 
<languages/>
 
<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.
 
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 ===
 
=== ISO 8601 ===
−
This is a readable format similar to DATE_TIME, supported by a few programs.
+
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 ''[[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.
 
−
* 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.
 

Aktuelle Version vom 20. Februar 2023, 09:39 Uhr

Sprachen:
Deutsch • ‎English

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.

Abgerufen von „https://wiki.emotouch.de/index.php?title=Zeitstempel-Formate/en&oldid=2485“