Let us not forget about the issues about this that would follow along with DST,
as some areas do follow DST, others don’t, others stay permanently on DST, and
so on. It’s a very intricate list of alterations every 6 months.
Ben Amick
Telecom Analyst
From: cisco-voip [mailto:[email protected]] On Behalf Of
Tanner Ezell
Sent: Tuesday, January 24, 2017 9:12 AM
To: Anthony Holloway <[email protected]>
Cc: [email protected]
Subject: Re: [cisco-voip] UCCX Script to get Time Zone by Area Code
To add to that fun, some states have multiple timezones!
I completely agree with Anthony regarding his first point, I myself have a cell
phone with a phone number thats about 15 years old and I don't live anywhere
near it. If you go this route, consider this as a helper, rather than an
absolute and confirm with the user at some point.
On Mon, Jan 23, 2017 at 10:05 PM, Anthony Holloway
<[email protected]<mailto:[email protected]>> wrote:
I have never done this before.
Seems to me like there are two major hurdles here:
1) How do you know that the caller is actually in that timezone at the time of
the call? For instance, I could be visiting a relative in another
state/timezone, but using my cell to call in, OR I could be using their home
phone, but trying to schedule service in my home timezone. Furthermore,
business SIP Trunks are national DID serviced, and I could call "from anywhere
in the country" from my office SIP trunk.
2) How will you keep the data current? The best option is to let someone else
keep the data current and subscribe to their web api service. However, from a
quick glance, no one is mapping area code to timezone, rather it seems to be
lat/long to timezone. So, you need to pull twice: 1) area code to lat/long (if
that even exists), 2) lat/long to timezone. But then what will you do when
that service is discontinued?
I guess, if nothing else, you could roughly divide up the country's timezones
by state borders, and for those border areas, they get to suffer +/- 1 hour to
ease your administration.
E.g.,
Scrap the small south west corner of North Dakota that's in Mountain Time and
just make the entire ND state in Central Time.
The only states you'd "really" be messing with are:
OR, ID, ND, SD, NE, KY, TN, FL
All the rest are practically, or exactly, in one single timezone.
Just make a decision on a heat map of population density, or timezone coverage
to see which way you go in those borderline states.
And now you can create mapping for state to timezone approximations with just
four simple String variables, and four simple If steps like this:
String eastern_states = "NY,NJ,MD,etc.";
String central_states = "ND,SD,NE,etc..";
String mountain_states = "MT,AZ,ID,etc.";
String pacific_states = "WA,CA,NV,etc.";
if (eastern_states.contains(calling_state)) {
/* Eastern TimeZone State */
}
if (central_states.contains(calling_state)) {
/* Central TimeZone State */
}
if (mountain_states.contains(calling_state)) {
/* Mountain TimeZone State */
}
if (pacific_states.contains(calling_state)) {
/* Pacific TimeZone State */
}
But you'll still have to convert area code to state first , so, pull up the
list of area codes by state on wikipedia:
https://en.wikipedia.org/wiki/List_of_North_American_Numbering_Plan_area_codes#United_States<http://cp.mcafee.com/d/FZsSd6Qm7DQT1O8V4TsSyyO-OCe78CzASyyO-OCeuvpdEEILLfzDDT3qabxEVd7dXThKr8qHaNk54SRtxIrsKr9JGX3oSVsSPZT1PPP_nV4ttUsqejhOzRXBQSnTepKMZtxNPG8FHnjlKqenKl3PWApmU6CQjoUTvHEEzD61RTPhOrKr9PCJhbc-7695pbuxbu00UoAlBwlBioHlQl1BoP9yEwHYpmS0G36Ri7NB0yaxo_o2KN_hmRkfE1wjxavE2ENfp_gTqlblbCqOmbAaJMJZ0kIToHMd9_7wqrjKMO-r1vF6y0QJSBiRiVCIBziWq80C92g36y0oJ6iQPh1eFEw8_cQg0CiLCy02qMYQg42NEw48_FEw4GEurvudFIyIBaOc>
And get to creating your area code to state mapping. This one is a little
bigger data set, so maybe not a String variable setup like above, but rather a
nice little XML file? TIP: Notepad++ Regex Find/Replace, or if you're feeling
really progressive, periodic Python web scraping, which generates the XML for
you.
<?xml version="1.0" encoding="UTF-8"?>
<area_codes>
<area_code id="612">MN</area_code>
...etc...
</area_codes>
calling_state = Get XML Document Data ("//area_code[@id="' + area_code + '"]")
On Mon, Jan 23, 2017 at 3:12 PM Matthew Loraditch
<[email protected]<mailto:[email protected]>>
wrote:
Anyone ever written one of to get Time zone from Caller ID area code? I know
how it would work, but hoping maybe there is a template (especially for the
database side somewhere)
Matthew G. Loraditch – CCNP-Voice, CCNA-R&S, CCDA
Network Engineer
Direct Voice: 443.541.1518<tel:(443)%20541-1518>
Facebook<http://cp.mcafee.com/d/2DRPoO86Qm7DQT1O8V4TsSyyO-OCe78CzASyyO-OCeuvpdEEILLfzDDT3qabxEVd7dXThKr8qHaNk54SRtxIrsKr9JGX3oSVsSPZT1PPP_nV4ttUsqejhOzRXBQSnTepKMZtxNPG8FHnjlKqenKl3PWApmU6CQPoUTvHEEzD61RTPhOrKr9PCJhbcasXJL8lGlVv2vDOH2vS9AE-WsjfdSBiRiVCIByV2Hsbvg5bdSaY3ivNU6CQXIcLCMnWhEwdbtFkJkKpH9oQKCy09ygA0NEw6bhAJcQgjGq82fPd409AHVEw0CIfd410Iq812fWq81aG7CTTzpXxCnasI>
|
Twitter<http://cp.mcafee.com/d/1jWVIe3x0SyMY-CUeh78CXCQkmnSkNMV4QsCQkmnSkNPPX9J55BZVYsY-Urhhsd79EVLuWdPp3lpmawECSHIdzrBPpdJnor6TbCSvKUeuuvW_8zHL3zhOqekuLsKCO-VPdS7HIeeth5dqWqJPhOZOEuvkzaT0QSOr76XZt54sUMeK-qejtPpesRG9pAP4FP-fbU5_fBm09-NcTqlblbCqOmbAaJMJZ0kIToHMd9_7wqrjKMO-r1vF6y0QJSBiRiVCIBziWq80C92g36y0oJ6iQPh1eFEw8_cQg0CiLCy02qMYQg42NEw48_FEw4GEurvudWLT8EaVe>
|
LinkedIn<http://cp.mcafee.com/d/avndy0Orhouvjs78zAjtPqabbXaoUsyqejqabbXaoVVZASyyO-Y-euvsdEEK6zAQsTLt6VIxGIH5gkjrlS6NJOVICSHIdzrBPrfTs7fffZvAhRTxNEVd7afnKnjpvsVCX3RS77eEyCJtdmVEVuVkffGhBrwqrodzzt-Kyyeso7nvd79KVIDeqR4IMFNYE5vgB3BYnmS1r2vDOH0LfX4UlfGhBZ2kUBjFRm5oqp5itlvdSBiRiVCIByV2Hsbvg5bdSaY3ivNU6CQXIcLCMnWhEwdbtFkJkKpH9oQKCy09ygA0NEw6bhAJcQgjGq82fPd409AHVEw0CIfd410Iq812fWq81aG7CTTzsDx8N0OJ>
|
G+<http://cp.mcafee.com/d/FZsS92gOd21J5xVZdMsyehdTdEEILIFzxO9EVdEEILIFzDDSjqabbXPUVVZMSyyUqejhPuZQrCO6GOIl1hdJnor6TbCOrqKMSdKndI_tMsYY_R-h7nu76zAQsEZuVtdBZPCrIfnossWyaqRQRrCzBXBgY-F6lK1FJYSedTWWa8VNwttYQsCXCOsVHkiP5zSWshHkyv_bU04b-vaI9_oD2FZicLFyRqjErJaBGBPdpb5O5mUm-wamrIlU6A_zMddFTopvdwLQzh0qmXiFqFsPmiNFtd40j4x81zh0cmz9qpEwDkQg4vCq80j9nPh01douq821oQg24vQQg2lkfdLL6NjI5eiyBKfGg>
_______________________________________________
cisco-voip mailing list
[email protected]<mailto:[email protected]>
https://puck.nether.net/mailman/listinfo/cisco-voip<http://cp.mcafee.com/d/1jWVIg41ESyMY-CUeh78CXCQkmnSkNMV4QsCQkmnSkNPPX9J55BZVYsY-Urhhsd79EVLuWdPp3lpmawECSHIdzrBPpdJnor6TbCSvKUeuuvW_8zHL3zhOqekuLsKCO-VPdS7HIeeth5dqWqJPhOZOEuvkzaT0QSUr76XZt54sUMeK-qejtPpesRG9pyPtyL0QDYu1K2qKMM-l9OwXnbiFqFsPmiNKQGmGncRAIn8lrxrW0FpKNnwqj-f0QSDtxBYS2_id41FrJaBGBPdpb6BQQg1ci4w6d40NqcBFCy2tjh0h-pEw1cBvd404RxVEw85zh08h_jh09lgYS-Yrvce_>
_______________________________________________
cisco-voip mailing list
[email protected]<mailto:[email protected]>
https://puck.nether.net/mailman/listinfo/cisco-voip<http://cp.mcafee.com/d/5fHCNASyMY-CUeh78CXCQkmnSkNMV4QsCQkmnSkNPPX9J55BZVYsY-Urhhsd79EVLuWdPp3lpmawECSHIdzrBPpdJnor6TbCSvKUeuuvW_8zHL3zhOqekuLsKCO-VPdS7HIeeth5dqWqJPhOZOEuvkzaT0QSedzzt-Kyyeso7nvd79KVIDeqR4INpKNnwqj-f0T1dnoovaAVgtHBFkJkKpH9oTqlblbCqOmbAaJMJZ0kIToHMd9_7wqrjKMO-r1vF6y0QJSBiRiVCIBziWq80C92g36y0oJ6iQPh1eFEw8_cQg0CiLCy02qMYQg42NEw48_FEw4GEurvudW_VmBBP8>
Confidentiality Note: This message is intended for use only by the individual
or entity to which it is addressed and may contain information that is
privileged, confidential, and exempt from disclosure under applicable law. If
the reader of this message is not the intended recipient or the employee or
agent responsible for delivering the message to the intended recipient, you are
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited. If you have received this communication
in error, please contact the sender immediately and destroy the material in its
entirety, whether electronic or hard copy. Thank you_______________________________________________
cisco-voip mailing list
[email protected]
https://puck.nether.net/mailman/listinfo/cisco-voip
