Sending data as voice mail to phone

Question

Hello I have an application. It deals with only couple of columns. customer Name varchar(100) customer Phone varchar(20) Department varchar(50) How it works: The customer service takes input from the customer and enters the Name  Customer's Phone# and the department they would like to talk to. Note: The Sales Person EMail ID Cell# Phone# Pager# are stored with the department. The moment the customer service takes input an email pager will be sent to the Sales Person and it's working fine. The Sales Persons wanted that they notified in their regular phone BlackBerry by voice mail as soon as their department has been selected. The application has been designed using C# SQL Server 2005. My questions: (1) How do I convert the SQL data in a wave format? (2) Do I need an interface to dial the phones and convey the voice msg? (3) Are there any freewares available so that I can use it? Appreciate your help. Thanks again Oppili Venkat

Oppili Venkat · Answer

Ya I agree. I have Mahesh's article and it's excellent. Let me scrounge for ITAPI3 and get on gear. I will keep you informed. Thanks OppiliVenkat

Sam Hobbs · Answer

Ignore julmar.com ; you don't need it. Also it appears that you should use ITAPI3 instead. Unfortunately there is no documentation so you need to download the source code and look at that. Probably you need to learn more about the C# language especially the part about use of events. There are articles in this web site that will help and there is a free book by Mahesh about C#. If you have specific questions about C# then you can create a new thread but try to get answers from articles and books. You should create a new thread for questions about C#.

Oppili Venkat · Answer

Hello Sam This jumlar.com site did confuse me a little. Could you kindly please send me the link where I have to read about the event for incoming calls? Really appreciate it. Thanks a lot for your help. Oppili Venkat

Oppili Venkat · Answer

Thanks Sam. I am just reading this TAPI concept(ofcourse new to me). I will keep you all let know once I my reading is complete. thanks again. Oppili Venkat

Sam Hobbs · Answer

Usually there is a better alternative to polling. Polling would not be a big problem but usually there is an event that can be used instead. Look in TAPI to see if there is an event for incoming calls; it is nearly certain that there is. You might need to queue them up if it is possible for them to come in faster than they can be processed.

Oppili Venkat · Answer

Hi Mahesh/Sam thanks for looking into this. I think that I should write a service to keep polling the table where I keep the calls received and invoke the TAPI so that the receiver can get the message dialed in who called. Just I am thinking this way. But you or Sam can throw can give guide me in this. Appreciate your time. Best Regards Oppili Venkat

Oppili Venkat · Answer

Hi Sam thanks for your response. I will see the articles for using TAPI and let you know. Thx again Best Regards Oppili Venkat

Mahesh Chand · Answer

Yes Sam is correct. You need to use TAPI.

Sam Hobbs · Answer

I think you are looking for text to speech software. I think Windows can do it. Look for articles in this web site about doing that. For dialing the number Windows has a Telephony API (TAPI) but Microsoft has not made a version for managed code. Perhaps you can use ATAPI - Managed TAPI wrapper for TAPI 2.0 . I don't know how to put all that together.