Jason Pruim wrote:
On Mar 31, 2008, at 8:21 PM, Jim Lucas wrote:
I work for a telephone & internet company. Currently we have a tool
that allows us to track the allocation of IP's to customers. What I
am looking for is a tool that will allow me to track the allocation of
phone numbers to our customers.
Building the tool for IP allocation management was pretty easy since
the IP world works off a set of rules that govern the allocation of
IP's. Unfortunately the phone number world does not have the same rule
set. Actually, it has no rules.
Has anybody built, heard of, or used a tool like this?
Any suggestions would be great.
Thanks much!
Hi Jim,
Are you looking for away to see where each phone number is set such a
using GPS coordinates to pinpoint the building the phone is registered to?
Or, are you looking for away to be able to pull up ABC Company and see
all the phone numbers listed to them?
If it's the latter, I'd recommend setting up a database with a few
tables, depending on the size of your company, possibly a table for
customer names and an ID, then a table with phone numbers and a Matching
ID field. Then you can either search, or browse through the customer
directory, and choose the company you are looking for and then pull up
the current phone numbers.
But my guess is that may not be exactly what you are looking for since
you can program circles around me I figure I must have missed something :)
Think the opposite from what you just described. What I want to be able
to do is have a pool of numbers from which I can assign a range or
individual numbers to a given customer. But this tool is not to track
the customers, but rather allow me to keep track of which numbers are
still available from the predefined number range. While also taking
into account tracking vanity numbers, and numbers that have previously
been assigned and need to be held for at least 90 days.
For now, this is the minimum of what I need. I will need to be able to
modify the source code to tie into our current billing system and be
able to reference a customers account.
--
Jason Pruim
Raoset Inc.
Technology Manager
MQC Specialist
3251 132nd ave
Holland, MI, 49424-9337
www.raoset.com
japruim@xxxxxxxxxx
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
