Select the time zone that was used when creating the recipient data in order to keep your data consistent. Please note that the time zones are specified using standard (winter) time.
Example
You are working in Germany and regularly receive customer data in CSV format from your head office in Great Britain. The time difference between Germany and Great Britain is one hour.
If the data to be imported was created in British time and this is not specified when the data is imported, the data will be displayed inconsistently.
1. Time zone selection: Europe/Berlin
|
Import file (Generated in Great Britain) |
Display on the client (Client in Germany) |
|---|---|
|
Date and time |
Date and time |
|
31.12.2017 23:30 |
31.12.2017 23:30 |
The client displays the same time as in the import file. This is not correct because of the time difference between Great Britain and Germany. The data is inconsistent.
2. Time zone selection: Europe/London
|
Import file (Generated in Great Britain) |
Display on the client (Client in Germany) |
|---|---|
|
Date and time |
Date and time |
|
31.12.2017 23:30 |
01.01.2017 00:30 |
The correct time is displayed on the client. 23:30 pm British time corresponds to 00:30 am German time. The data is consistent.
Data types
The system handles date and time-related data types as follows:
|
Data type |
Description |
|||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
date only |
Data with the data type date only is imported one-to-one. The system does not convert the data at all. |
|||||||||||||||||
|
time only |
Data with the data type time only is converted in accordance with the selected time zone. Summer or winter time When only a time is specified, the system uses the date on which the import was started to decide whether the time is in summer or winter time. For example, if you import an import file on 01 December using an Inxmail Professional Client that is operated in Germany, the times will be interpreted as winter times. |
|||||||||||||||||
|
Date and time
|
Data with the data type Date and time is converted in accordance with the selected time zone. Summer or winter time The system uses the date specified in the import file to decide whether the time is in summer or winter time. For example, if ‘31.12.2017 23:30’ is specified in the import file and Europe/London has been selected as the time zone, the system interprets 23:30 as winter time because it was winter time in Great Britain/London on 31 December 2017 (31.12.2017). Further examples
|
|||||||||||||||||
