Re: Lookup City based on Caller ID
 

<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.

Re: Lookup City based on Caller ID
 

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

Re: Lookup City based on Caller ID
 

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?

Re: Lookup City based on Caller ID
 

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.

Re: Lookup City based on Caller ID
 

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.

Re: Lookup City based on Caller ID
 

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...

Re: Lookup City based on Caller ID
 

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"

Re: Lookup City based on Caller ID
 

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... ;)

Re: Lookup City based on Caller ID
 

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

Re: Lookup City based on Caller ID
 

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! :)