The Time Zone field used in facility and equipment records displays as a drop-down list. It must be imported as an integer. The following table shows each time zone and its associated integer:
(GMT-12:00) International Date Line West |
0 |
(GMT-11:00) Midway Island, Samoa |
1 |
(GMT-10:00) Hawaii |
2 |
(GMT-09:00) Alaska |
3 |
(GMT-08:00) Pacific Time (US and Canada, Tijuana) |
4 |
(GMT-07:00) Mountain Time (US and Canada) |
10 |
(GMT-07:00) Chihuahua, La Paz, Mazatlan |
13 |
(GMT-07:00) Arizona |
15 |
(GMT-06:00) Central Time (US and Canada) |
20 |
(GMT-06:00) Saskatchewan |
25 |
(GMT-06:00) Guadalajara, Mexico City, Monterrey |
30 |
(GMT-06:00) Central America |
33 |
(GMT-05:00) Eastern Time (US and Canada) |
35 |
(GMT-05:00) Indiana (East) |
40 |
(GMT-05:00) Bogota, Lima, Quito |
45 |
(GMT-04:00) Atlantic Time (Canada) |
50 |
(GMT-04:00) Caracas, La Paz |
55 |
(GMT-04:00) Santiago |
56 |
(GMT-03:30) Newfoundland |
60 |
(GMT-03:00) Brasilia |
65 |
(GMT-03:00) Buenos Aires, Georgetown |
70 |
(GMT-03:00) Greenland |
73 |
(GMT-02:00) Mid-Atlantic |
75 |
(GMT-01:00) Azores |
80 |
(GMT-01:00) Cape Verde Is. |
83 |
(GMT) Greenwich Mean Time, Dublin, Edinburgh, Lisbon, London |
85 |
(GMT) Casablanca, Monrovia |
90 |
(GMT+01:00) Belgrade, Bratislava, Budapest, Ljubljana, Prague |
95 |
(GMT+01:00) Sarajevo, Skopje, Warsaw, Zagreb |
100 |
(GMT+01:00) Brussels, Copenhagen, Madrid, Paris |
105 |
(GMT+01:00) Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna |
110 |
(GMT+01:00) West Central Africa |
113 |
(GMT+02:00) Bucharest |
115 |
(GMT+02:00) Cairo |
120 |
(GMT+02:00) Helsinki, Kyiv, Riga, Sofia, Tallinn, Vilnius |
125 |
(GMT+02:00) Athens, Istanbul, Minsk |
130 |
(GMT+02:00) Jerusalem |
135 |
(GMT+02:00) Harare, Pretoria |
140 |
(GMT+03:00) Moscow, St. Petersburg, Volgograd |
145 |
(GMT+03:00) Kuwait, Riyadh |
150 |
(GMT+03:00) Nairobi |
155 |
(GMT+03:00) Baghdad |
158 |
(GMT+03:30) Tehran |
160 |
(GMT+04:00) Abu Dhabi, Muscat |
165 |
(GMT+04:00) Baku, Tbilisi, Yerevan |
170 |
(GMT+04:30) Kabul |
175 |
(GMT+05:00) Ekaterinburg |
180 |
(GMT+05:00) Islamabad, Karachi, Tashkent |
185 |
(GMT+05:30) Chennai, Kolkata, Mumbai, New Delhi |
190 |
(GMT+05:45) Kathmandu |
193 |
(GMT+06:00) Astana, Dhaka |
195 |
(GMT+06:00) Sri Jayawardenepura |
200 |
(GMT+06:00) Almaty, Novosibirsk |
201 |
(GMT+06:30) Yangon (Rangoon) |
203 |
(GMT+07:00) Bangkok, Hanoi, Jakarta |
205 |
(GMT+07:00) Krasnoyarsk |
207 |
(GMT+08:00) Beijing, Chongqing, Hong Kong SAR, Urumqi |
210 |
(GMT+08:00) Kuala Lumpur, Singapore |
215 |
(GMT+08:00) Taipei |
220 |
(GMT+08:00) Perth |
225 |
(GMT+08:00) Irkutsk, Ulaan Bataar |
227 |
(GMT+09:00) Seoul |
230 |
(GMT+09:00) Osaka, Sapporo, Tokyo |
235 |
(GMT+09:00) Yakutsk |
240 |
(GMT+09:30) Darwin |
245 |
(GMT+09:30) Adelaide |
250 |
(GMT+10:00) Canberra, Melbourne, Sydney |
255 |
(GMT+10:00) Brisbane |
260 |
(GMT+10:00) Hobart |
265 |
(GMT+10:00) Vladivostok |
270 |
(GMT+10:00) Guam, Port Moresby |
275 |
(GMT+11:00) Magadan, Solomon Is., New Caledonia |
280 |
(GMT+12:00) Fiji Islands, Kamchatka, Marshall Is. |
285 |
(GMT+12:00) Auckland, Wellington |
290 |
(GMT+13:00) Nuku'alofa |
300 |
Required Preparation in Source Files
You cannot use a transformation to do this mapping. Edit your source data to make sure the value in the column you are mapping to the Time Zone field contains valid integers.