Re: Time Zone lookup?
Rebecca, Check out the site http://www.pawprint.net/wt/ Some data is available at http://www.timezoneconverter.com/ Perhaps you can contact them to see if the data is available in a spreadsheet, or you can find a way to extract it from the website. There is a feature to print a reference card and you can select all countries/regions and then export directly into Excel if you are using Windows XP. http://www.timezoneconverter.com/cgi-bin/tzref.tzc Other sites http://tycho.usno.navy.mil/tzones.html (select all countries at the bottom) http://www.timeanddate.com/worldclock/custom.html?continent=allsort=0low=0 http://www.worldtimezone.com/ Rgds, Chris Rom Schlumberger ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Time Zone lookup?
So, with the addition of TimeZones in ITSM 7, tied to the City/Person record/etc, I was wondering if anyone had a good place to pull the time zone information from, like a spreadsheet I could then use to import? The websites I found just show it displayed on a screen... ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Time Zone lookup?
Here's what we use: http://www.zipcodedownload.com/ It's Zip Code-based, which is close enough for us. Includes preferred and acceptable city names, whether or not the Zip Code observes DST, Longitude/Latitude (geographic center of Zip Code area), and a few other nuggets. I think the one-time was around $40. Mike White Office: 813-978-2192 E-mail: [EMAIL PROTECTED] Rebecca Hammond [EMAIL PROTECTED]To: arslist@ARSLIST.ORG CAT.COM cc: Sent by: Action Subject: Time Zone lookup? Request System discussion list(ARSList) [EMAIL PROTECTED] ORG 12/20/2006 10:32 Please respond to arslist So, with the addition of TimeZones in ITSM 7, tied to the City/Person record/etc, I was wondering if anyone had a good place to pull the time zone information from, like a spreadsheet I could then use to import? The websites I found just show it displayed on a screen... ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Time Zone lookup?
Interesting, but I guess I should have mentioned that our users are Global, therefore we need something with international data ;-) On Wed, 20 Dec 2006 10:38:02 -0500, Mike White [EMAIL PROTECTED] wrote: Here's what we use: http://www.zipcodedownload.com/ It's Zip Code-based, which is close enough for us. Includes preferred and acceptable city names, whether or not the Zip Code observes DST, Longitude/Latitude (geographic center of Zip Code area), and a few other nuggets. I think the one-time was around $40. Mike White Office: 813-978-2192 E-mail: [EMAIL PROTECTED] Rebecca Hammond [EMAIL PROTECTED]To: arslist@ARSLIST.ORG CAT.COM cc: Sent by: Action Subject: Time Zone lookup? Request System discussion list(ARSList) [EMAIL PROTECTED] ORG 12/20/2006 10:32 Please respond to arslist So, with the addition of TimeZones in ITSM 7, tied to the City/Person record/etc, I was wondering if anyone had a good place to pull the time zone information from, like a spreadsheet I could then use to import? The websites I found just show it displayed on a screen... ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are = ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
