View Single Post
  #24 (permalink)  
Old 01-15-2009, 01:23 AM
auto_exec's Avatar
auto_exec
PPCGeeks Regular
Offline
Threadstarter
Location: Chicago
 
Join Date: Jul 2007
Posts: 97
Reputation: 90
auto_exec is becoming a great contributor
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Re: Lookup City based on Caller ID

Quote:
Originally Posted by edraven View Post
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.

Last edited by auto_exec; 01-15-2009 at 01:26 AM.
Reply With Quote