If you work, you use the phone. And if you use the phone, chances are you've called directory assistance a time or two. Now think about all your coworkers: sales and marketing people, accounting people, human resources, and the list goes on. All these departments are likely to call directory assistance a lot.
I decided to see how much we call directory assistance where I work. I asked our MIS chief, David Geiger, how much we spend in directory assistance each month.
"A lot," he said.
"A thousand a month?" I countered.
"Nah, maybe three, four hundred."
We spend between $3600 and $4800 a year on directory assistance. I knew I was on to something big. Initially I thought I could find a database with most US phone numbers, stuff them in my database, and then access them from an intranet. Quickly I found that government agencies and telephone companies offer different databases, but nothing comprehensive--not to mention affordable.
CD-ROM Phone Books
A little research on the Net led me to Phone-Disc, from Digital Directory
Assistance (DDA), and two promising products: PhoneDisc PowerFinder and
PhoneDisc PowerFinder US. It has six CD-ROMS, each covering a region of the US.
If the number you want is in California, you look in the West region disk, for
example. The next product, PowerFinder USA One, is what I was looking for. It
comes on six CD-ROMS, like PowerFinder, but DDA designed these CDs for
simultaneous access by the PowerFinder client, which has native NT clients for
Intel, Alpha, and PowerPC (sorry, MIPS). You can load these clients on your
workstations and access the entire USA One database, about 112 million records
simultaneously.
I shared the six CD-ROMs from various networked machines. I connected to each machine and made the networked CD ROM drives local to my machine. Voilà! The client saw them. Unfortunately, I had to do some setup on the client side, and I still hadn't achieved my goal of providing the database over the intranet so I could use my Web browser.
On the Intranet
A quick call to Jeremy Cook at DDA gave me the answer I was looking for. I
visited DDA's Web page at www.phonedisc.com/tech/ soft.htm and downloaded
pdhttp.exe and pdhttp.wri, which is a write document that explains how to set up
and run the pdhttp.exe program, an intranet server for the PhoneDisc PowerFinder
USA One database. DDA recommends that you purchase a hard drive capable of
handling the database, about 3.8GB, all at once. However, you can share the
database's six CDs from networked CD-ROMS and provide the completely qualified
path to the software for each CD.
I purchased a 4GB SCSI hard drive. These drives are generally available for under $1000, or less if you go IDE.
I copied each CD-ROM to the hard disk. Six CDs and about 3.8GB later, I was ready to try the server. After I installed the pdhttp.exe server and told it what port I wanted it to listen on and where the database resided, I was ready to access the database with my browser.
The Search
Screen 1 shows how the default search screen looks when you access the
server. I selected a familiar name, Duke Communications, and did a search.
Screen 2 is the result screen, complete with company name, address, phone
number, and SIC code. I didn't specify an exact match, so I also got some close
matches.
If this program only did searches, it would be worthwhile, but it does even more. Knowing that no two people search alike, DDA gives you the mechanism to create search pages. Screen 3 is a form I created by following the instructions in the pdhttp.wri document (with a little beautification from our Web master, T.J. Harty).
Listing 1 is the source code for the new search form. The call to the PhoneDisc intranet server is in the line <FORM METHOD="POST" ACTION="/cgi-bin/pdlookup">. PhoneDisc collects the information and passes it to the lookup program through these special PhoneDisc variables:
sstr The string used for the search
looktype The type of search to do:
Name, Address, Phone, SIC
numreturn The number of matches from the search
matchtype 1=Exact, 0=Closest
hn.lim House Number
sr.lim Street
ci.lim City
st.lim State
zi.lim Zip
ac.lim Area Code
busres databases to search BUS, RES, BOTH
Win-Win Situation
Setting up a directory assistance alternative on your intranet is a win-win
situation in many ways. You can save your company money, and the search
capabilities PhoneDisc offers are far superior to those of ordinary directory
assistance--try asking directory assistance for that printer on Cleveland
Street. So with a small investment ($800 for a 4GB IDE drive and $259 for
PhoneDisc with one user at a time), you can set up this system quickly.
On One Disk
PowerFinder USA One is available on Digital Voice Data (DVD)-ROM. This
format makes the entire USA One database available on one disk. Tune in to DDA's
Web site for more information.
PowerFinder |
Digital Directory Assistance * 301-657-8548 or 800-284-8353 Web: www.dda-inc.com Price: PowerFinder: $129 (average retail price); PowerFinder USA One; One concurrent user: $259; Two concurrent users: $449; Five concurrent users: $799 |