Lookup City based on Caller ID

[auto_exec]

Originally Posted by briggs

quick question:

Will this area code database work for canada as well? This would be a nice feature for my diamond.

Also, if I have a dialer skin installed, will they interfer with each other?

Thanks

<EDITED>: Didn't realize other area codes were included, see my post below. Canada will work.


This shouldn't interfere with dialer skins at all, as it's a standalone app that gets triggered based on incoming/outgoing communications.

[auto_exec]

Originally Posted by auto_exec

Hmm.. by default, this won't work for Canada.. it should pop up with "State: Area code not found." for anything not in the reg file I attached in the first post (since the reg file I've attached only has the US area codes/states cross-referenced). That said, if you were to add new String values in that same key (HKLM/Software/HTC/PHONE/AreaCode) with Name = 3-digit area code and String = area, it should read it with no problem.

If you could point me to a website or listing of area codes to areas, I could probably get that set up in a reg file ready for import... I'll do some looking around on my own as well, maybe I can build my own listing of area codes, etc, to cover more places if I have time.

This shouldn't interfere with dialer skins at all, as it's a standalone app that gets triggered based on incoming/outgoing communications.

I was wrong! Looking at the reg file, it DOES have Canadian area codes. Should be all good!

[edraven]

It shouldn't be too hard to modify the .reg file to make this a little more specific, instead of just showing the state.

ie. 415 isn't the entire state of California, it's mainly just San Francisco & Marin Counties. (see http://www.bennetyee.org/ucsd-pages/area.html or several other lists)

My question is, how will this app handle all the extra text? Would it be hard to modify the app to show both the state and area descriptions on separate lines?

[auto_exec]

Originally Posted by edraven

It shouldn't be too hard to modify the .reg file to make this a little more specific, instead of just showing the state.

ie. 415 isn't the entire state of California, it's mainly just San Francisco & Marin Counties. (see http://www.bennetyee.org/ucsd-pages/area.html or several other lists)

My question is, how will this app handle all the extra text? Would it be hard to modify the app to show both the state and area descriptions on separate lines?

I'd actually started researching this a bit after I first posted... looked at the NANPA database, etc... if we could find a good list with reasonable patterned descriptions (i.e. a description that would be easily parse-able), it wouldn't be hard to update the app... I was planning on removing the "Unknown number" line at the top of the form (since it's somewhat redundant as your incoming call screen shows it anyways) and maybe just making it a one-liner with the state/area info.

Eventually I'd like to just have an external database file that the program will read from... I've been looking around for a good source database (ideally one that has city/state info instead of just state), but the only free one with city/state info that I could find online was:

http://www.wcisd.hpc.mil/~phil/npanxx/npanxx99.txt

Problem with the above file is that it's from 1999 (and so it's out-of-date). If anyone has suggestions or finds a good database file to use, feel free to post here or PM me... I'd be more than happy to give it a shot.

[edraven]

Ah, yeah, using Area code + prefix is way better than what I was proposing. From your '99 list, going up one dir, and clicking one of the links on that page led me to this:

http://www.nanpa.com/reports/reports...es_assign.html

Which contains this:
http://www.nanpa.com/nanp1/allutlzd.zip

Which has all states, area code, prefix, *provider*, and city.

Doesn't look too hard to parse either, I may give it a shot if I get some free time today, but of course you'd still have to modify your app to accept it.

[auto_exec]

Originally Posted by edraven

Ah, yeah, using Area code + prefix is way better than what I was proposing. From your '99 list, going up one dir, and clicking one of the links on that page led me to this:

http://www.nanpa.com/reports/reports...es_assign.html

Which contains this:
http://www.nanpa.com/nanp1/allutlzd.zip

Which has all states, area code, prefix, *provider*, and city.

Doesn't look too hard to parse either, I may give it a shot if I get some free time today, but of course you'd still have to modify your app to accept it.

Great catch! I was on the NANPA site, but somehow I missed this page... I can probably try to incorporate this file/data when I get home from work today... shouldn't be too hard. Maybe I can even add settings options where you can choose what you want displayed (i.e. state only, city/state, city/state/provider).


Update: I also found a similar file for Canada on this page http://www.cnac.ca/co_codes/co_code_status_map.htm, direct link to file is http://www.cnac.ca/data/NPANXX.zip...

[edraven]

Originally Posted by edraven

Doesn't look too hard to parse either

awk gets you most of the way there, this is for a CSV output:

cat allutlzd.txt |awk -F"\t" '{print $1","$2","$4","$5}'

output is like this:

AK ,907-200,"ACS WIRELESS, INC." ,VALDEZ
AK ,907-209,"DOBSON CELLULAR SYSTEMS, INC." ,JUNEAU

but of course you'll want to modify it to output in .reg format...

something like this maybe?

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\HTC\PHONE\AreaCode\]

[HKEY_LOCAL_MACHINE\SOFTWARE\HTC\PHONE\AreaCode\\41 5]

[HKEY_LOCAL_MACHINE\SOFTWARE\HTC\PHONE\AreaCode\\41 5\343]
"Company"="MCI WORLDCOM COMMUNICATIONS, INC., CA"
"RateCenter"="SNFC CNTRL"
"State"="CA"

[HKEY_LOCAL_MACHINE\SOFTWARE\HTC\PHONE\AreaCode\\41 5\344]
"Company"="PACIFIC BELL"
"RateCenter"="SNFC CNTRL"
"State"="CA"

[auto_exec]

Originally Posted by edraven

awk gets you most of the way there, this is for a CSV output:

cat allutlzd.txt |awk -F"\t" '{print $1","$2","$4","$5}'

output is like this:

AK ,907-200,"ACS WIRELESS, INC." ,VALDEZ
AK ,907-209,"DOBSON CELLULAR SYSTEMS, INC." ,JUNEAU

but of course you'll want to modify it to output in .reg format...

something like this maybe?

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\HTC\PHONE\AreaCode\]

[HKEY_LOCAL_MACHINE\SOFTWARE\HTC\PHONE\AreaCode\\41 5]

[HKEY_LOCAL_MACHINE\SOFTWARE\HTC\PHONE\AreaCode\\41 5\343]
"Company"="MCI WORLDCOM COMMUNICATIONS, INC., CA"
"RateCenter"="SNFC CNTRL"
"State"="CA"

[HKEY_LOCAL_MACHINE\SOFTWARE\HTC\PHONE\AreaCode\\41 5\344]
"Company"="PACIFIC BELL"
"RateCenter"="SNFC CNTRL"
"State"="CA"

Actually I was just thinking of leaving it in a physical file that would install in the pgm directory... the program would then parse through the file to find required info... this way people dont have to mess with their registry, and they can update the file if they need to/want to...

[edraven]

That'd probably be better, but if you change your mind, I just finished the script. This uses TCL.

#!/usr/bin/tclsh

set f [open allutlzd.txt r]

puts "Windows Registry Editor Version 5.00"

while {[gets $f line] != -1} {
set field [split $line "\t" ]
set tmp [split [lindex $field 1] -]

set state [string trim [lindex $field 0]]
set areaCode [string trim [lindex $tmp 0]]
set prefix [string trim [lindex $tmp 1]]
set company [string trim [lindex $field 3]]
regsub -all {"} $company {} company
set rateCenter [string trim [lindex $field 4]]

#puts "$areaCode $prefix $company $rateCenter $state"
if {[regexp {[0-9]{3}} $areaCode]} {
puts "
\[HKEY_LOCAL_MACHINE\\SOFTWARE\\HTC\\PHONE\\AreaCode \\\\$areaCode\\$prefix\\]
\"Company\"=\"$company\"
\"RateCenter\"=\"$rateCenter\"
\"State\"=\"$state\"
"
}

}

close $f

[joeykrim]

Originally Posted by auto_exec

Actually I was just thinking of leaving it in a physical file that would install in the pgm directory... the program would then parse through the file to find required info... this way people dont have to mess with their registry, and they can update the file if they need to/want to...

i really like this program. i hope you can make the update to remove the unknown caller line since it is redundant. also one bug ive found is on the touch pro, when i have the keyboard slide out the screen is in landscape mode. when i receive a text or call from an unknown caller in landscape mode it doesnt appear correctly on the screen. it makes a small rectangular box. when i put the keyboard back in, whether during the call or 10 min later, and the screen changes to portrait mode the program then pops up with the information and i have to hit hide.

hopefully that makes sense, it just doesnt appear correctly in landscape mode. let me know if i can help!