From what I can gather (my boss couldn't tell me) it is a Nortel model 61C PBX. What I am to be responsible for is creating screen "pop ups" that either bring up data from the database on a current customer, or a blank form (with the phone number and caller id coming from the phone system in a text format for us to deciede upon) to add a new customer. Either way, I will need to (I think) create a stored proceedure (or something like it) to do a quick search of the database and send that information to a specific workstation. What I was looking for was information on the way that system interfaces with SQL 2000, either an online reference or a text book. We are not yet close to implementing the system and I want to get more familiar with it. I hope this helps more, any information would be wonderful.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Interface a predictive Dialling system with SQL 2000
- Thread starter ascheper
- Start date
stoolpigeon
Programmer
I'll hop in on this post since it is more recent than the last.
The PBX is not your dialer it is part of your phone system. You are going to need to get some specifics about your dialer to bridge it and your database. I'll give you a quick example of how I do that and it may help you - I don't know, but like I said, at some point you are going to need to find out what kind of dialer you are going to be working w/, what it can do, etc.
To dial your dialer will need a minimum of 2 items about each number it will call - a valid phone number and some kind of unique identifier - like an account number.
In my case the dialer runs on unix. (w/a sybase db by the way). It has it's own interface for the agent. When an agent wants to switch over to our system the agent hits a button on their telnet app that grabs the account number and writes it to a text file on their hard drive. Then they flip over to a VB app that reads that text file and uses ADO to connect to my SQL Server database and look up the account and then do all their reads and writes.
If you have questions about what a dialer does or if you find out more about what you will be running - feel free to let me know.
Thanks,
Ron
The PBX is not your dialer it is part of your phone system. You are going to need to get some specifics about your dialer to bridge it and your database. I'll give you a quick example of how I do that and it may help you - I don't know, but like I said, at some point you are going to need to find out what kind of dialer you are going to be working w/, what it can do, etc.
To dial your dialer will need a minimum of 2 items about each number it will call - a valid phone number and some kind of unique identifier - like an account number.
In my case the dialer runs on unix. (w/a sybase db by the way). It has it's own interface for the agent. When an agent wants to switch over to our system the agent hits a button on their telnet app that grabs the account number and writes it to a text file on their hard drive. Then they flip over to a VB app that reads that text file and uses ADO to connect to my SQL Server database and look up the account and then do all their reads and writes.
If you have questions about what a dialer does or if you find out more about what you will be running - feel free to let me know.
Thanks,
Ron
- Status
Similar threads
- Locked
- Question
- Locked
- Question
