Issue
The 'EndTimeZone' and 'StartTimeZone' fields did not contain a standard Lotus Notes time zone, nor did the document contain a '$CSTrack' field. The missing $CSTrack' field means the Lotus Notes was not the source client used to create the calendar item.
The 'EndTimeZone' and 'StartTimeZone' fields contained the following value: "Z=6$DO=1$DL=3 2 1 11 1 1$ZX=0$ZN=GMT-6"
A meeting that did migrate correctly, contained a '$CSTrack' field, and had the following value in the 'EndTimeZone' and 'StartTimeZone' fields: "Z=6$DO=1$DL=3 2 1 11 1 1$ZX=23$ZN=Central"
It looks like the corrupt calendar item was not created in Lotus Notes, and was created from a smart phone or a MAC OS.
Solution
For example a minimal set for the US would be:
GMT-5|Eastern Standard Time
GMT-6|Central Standard Time
GMT-7|Mountain Standard Time
GMT-8|Pacific Standard Time
For Europe GMT+1
GMT+1|Romance Standard Time
How do you format UTC without a time zone offset?
The TimeZoneTextFile does not dictate the actual offsets, it only cross references some text (as reported from Notes) to the Windows timezone name (which specifies the offset). Valid entries for UTC would be:
UTC|UTC or UTC+0|UTC or UTC|Greenwich Standard Time
The first two would result in "(UTC) Coordinated Universal Time" while the last would be "(UTC) Monrovia, Reykjavik"
How do you format a 30 minute fractional time zone offset? E.g. UTC-04:30 offset
The left of the | must match what is in the Notes document - this will vary based on the originating device/application. I suspect the leading 0 may be something to look at closely. Also the devices my use GMT and not UTC. If there is uncertainty or various devices, all 4 (or more) combinations could be created as in:
UTC-04:30|Venezuela Standard Time
UTC-4:30|Venezuela Standard Time
GMT-04:30|Venezuela Standard Time
GMT-4:30|Venezuela Standard Time
How do you format a 45 minute fractional time zone offset? E.g. UTC+05:45 offset
Same as above. UTC+05:45|Nepal Standard Time or UTC+5:45|Nepal Standard Time
Limitations/Suggestions
There is the possibility that Daylight Savings Time may not be correctly identified since an "unknown" zone like GMT-5 may use DST, but the zone name does not indicate that.
Since this issue is introduced by non-Notes clients (like smart phone apps/Mac), the customer should consider all timezones where their smartphone/ Mac users are located for inclusion into the mapping additions.
There is no limit to the number of timezone mappings that may be added.
The modified TimeZoneTextFile.txt should be placed on all workstations replacing the original file. Existing entries should not be removed from the file.
Timezone name case is not critical - all are converted to lower case for internal comparison
The Windows timezone portion ( following the | ) should be copied from an existing entry in the mapping file to ensure it is a valid Windows Timezone name
Development has created an enhancement task to design and implement a more automatic and complete handling of unexpected timezone names. A release version for this enhancement has not been determined.
Attachment
Attached is a file with the Continental US and other time zones added. This file also contains iOS time zones for North America. Use this list to add additional time zones to the file
Time Zones
The following table shows the time zones that are valid for Windows OS, the GMT offset for each time zone, and the resource that is displayed for each time zone.
| Time Zone | Display | |
|---|---|---|
|
Afghanistan Standard Time |
(GMT+04:30) Kabul | |
|
Alaskan Standard Time |
(GMT-09:00) Alaska | |
|
Arab Standard Time |
(GMT+03:00) Kuwait, Riyadh | |
|
Arabian Standard Time |
(GMT+04:00) Abu Dhabi, Muscat | |
|
Arabic Standard Time |
(GMT+03:00) Baghdad | |
|
Atlantic Standard Time |
(GMT-04:00) Atlantic Time (Canada) | |
|
AUS Central Standard Time |
(GMT+09:30) Darwin | |
|
AUS Eastern Standard Time |
(GMT+10:00) Canberra, Melbourne, Sydney | |
|
Azerbaijan Standard Time |
(GMT +04:00) Baku | |
|
Azores Standard Time |
(GMT-01:00) Azores | |
|
Canada Central Standard Time |
(GMT-06:00) Saskatchewan | |
|
Cape Verde Standard Time |
(GMT-01:00) Cape Verde Islands | |
|
Caucasus Standard Time |
(GMT+04:00) Yerevan | |
|
Cen. Australia Standard Time |
(GMT+09:30) Adelaide | |
|
Central America Standard Time |
(GMT-06:00) Central America | |
|
Central Asia Standard Time |
(GMT+06:00) Astana, Dhaka | |
|
Central Brazilian Standard Time |
(GMT -04:00) Manaus | |
|
Central Europe Standard Time |
(GMT+01:00) Belgrade, Bratislava, Budapest, Ljubljana, Prague | |
|
Central European Standard Time |
(GMT+01:00) Sarajevo, Skopje, Warsaw, Zagreb | |
|
Central Pacific Standard Time |
(GMT+11:00) Magadan, Solomon Islands, New Caledonia | |
|
Central Standard Time |
(GMT-06:00) Central Time (US and Canada) | |
|
Central Standard Time (Mexico) |
(GMT-06:00) Guadalajara, Mexico City, Monterrey | |
|
China Standard Time |
(GMT+08:00) Beijing, Chongqing, Hong Kong SAR, Urumqi | |
|
Dateline Standard Time |
(GMT-12:00) International Date Line West | |
|
E. Africa Standard Time |
(GMT+03:00) Nairobi | |
|
E. Australia Standard Time |
(GMT+10:00) Brisbane | |
|
E. Europe Standard Time |
(GMT+02:00) Minsk | |
|
E. South America Standard Time |
(GMT-03:00) Brasilia | |
|
Eastern Standard Time |
(GMT-05:00) Eastern Time (US and Canada) | |
|
Egypt Standard Time |
(GMT+02:00) Cairo | |
|
Ekaterinburg Standard Time |
(GMT+05:00) Ekaterinburg | |
|
Fiji Standard Time |
(GMT+12:00) Fiji Islands, Kamchatka, Marshall Islands | |
|
FLE Standard Time |
(GMT+02:00) Helsinki, Kiev, Riga, Sofia, Tallinn, Vilnius | |
|
Georgian Standard Time |
(GMT +04:00) Tblisi | |
|
GMT Standard Time |
(GMT) Greenwich Mean Time : Dublin, Edinburgh, Lisbon, London | |
|
Greenland Standard Time |
(GMT-03:00) Greenland | |
|
Greenwich Standard Time |
(GMT) Casablanca, Monrovia | |
|
GTB Standard Time |
(GMT+02:00) Athens, Bucharest, Istanbul | |
|
Hawaiian Standard Time |
(GMT-10:00) Hawaii | |
|
India Standard Time |
(GMT+05:30) Chennai, Kolkata, Mumbai, New Delhi | |
|
Iran Standard Time |
(GMT+03:30) Tehran | |
|
Israel Standard Time |
(GMT+02:00) Jerusalem | |
|
Korea Standard Time |
(GMT+09:00) Seoul | |
|
Mid-Atlantic Standard Time |
(GMT-02:00) Mid-Atlantic | |
|
Mountain Standard Time |
(GMT-07:00) Mountain Time (US and Canada) | |
|
Mountain Standard Time (Mexico) |
(GMT-07:00) Chihuahua, La Paz, Mazatlan | |
|
Myanmar Standard Time |
(GMT+06:30) Yangon (Rangoon) | |
|
N. Central Asia Standard Time |
(GMT+06:00) Almaty, Novosibirsk | |
|
Namibia Standard Time |
(GMT +02:00) Windhoek | |
|
Nepal Standard Time |
(GMT+05:45) Kathmandu | |
|
New Zealand Standard Time |
(GMT+12:00) Auckland, Wellington | |
|
Newfoundland Standard Time |
(GMT-03:30) Newfoundland and Labrador | |
|
North Asia East Standard Time |
(GMT+08:00) Irkutsk, Ulaanbaatar | |
|
North Asia Standard Time |
(GMT+07:00) Krasnoyarsk | |
|
Pacific SA Standard Time |
(GMT-04:00) Santiago | |
|
Pacific Standard Time |
(GMT-08:00) Pacific Time (US and Canada); Tijuana | |
|
Romance Standard Time |
(GMT+01:00) Brussels, Copenhagen, Madrid, Paris | |
|
Russian Standard Time |
(GMT+03:00) Moscow, St. Petersburg, Volgograd | |
|
SA Eastern Standard Time |
(GMT-03:00) Buenos Aires, Georgetown | |
|
SA Pacific Standard Time |
(GMT-05:00) Bogota, Lima, Quito | |
|
SA Western Standard Time |
(GMT-04:00) Caracas, La Paz | |
|
Samoa Standard Time |
(GMT-11:00) Midway Island, Samoa | |
|
SE Asia Standard Time |
(GMT+07:00) Bangkok, Hanoi, Jakarta | |
|
Singapore Standard Time |
(GMT+08:00) Kuala Lumpur, Singapore | |
|
South Africa Standard Time |
(GMT+02:00) Harare, Pretoria | |
|
Sri Lanka Standard Time |
(GMT+06:00) Sri Jayawardenepura | |
|
Taipei Standard Time |
(GMT+08:00) Taipei | |
|
Tasmania Standard Time |
(GMT+10:00) Hobart | |
|
Tokyo Standard Time |
(GMT+09:00) Osaka, Sapporo, Tokyo | |
|
Tonga Standard Time |
(GMT+13:00) Nuku'alofa | |
|
US Eastern Standard Time |
(GMT-05:00) Indiana (East) | |
|
US Mountain Standard Time |
(GMT-07:00) Arizona | |
|
Vladivostok Standard Time |
(GMT+10:00) Vladivostok | |
|
W. Australia Standard Time |
(GMT+08:00) Perth | |
|
W. Central Africa Standard Time |
(GMT+01:00) West Central Africa | |
|
W. Europe Standard Time |
(GMT+01:00) Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna | |
|
West Asia Standard Time |
(GMT+05:00) Islamabad, Karachi, Tashkent | |
|
West Pacific Standard Time |
(GMT+10:00) Guam, Port Moresby | |
|
Yakutsk Standard Time |
(GMT+09:00) Yakutsk |
