Hi Nathan,

OK that makes some sense now. I was just needing to test out a playback and I did not catch the TTS aspect. I will just make a .WAV file and see how that works.

Thanks for you advice!!

Bryant.

Hi vinodkewate,

Wow.. Thanks for the input!

I do not have a DB created yet, but I have some colleagues here that are DBA's. I can get their expertise on creating a database of doctors and zipcodes.

I should just be able to use the W2K SQL on the CCX server correct?

I will follow the steps you outlined and give that a try.

I really appreciate your help.

Bryant.

Yes Correct, u can have it on ur server.

But i hope its not that much huge, and will not eat too much space on UCCX box.

Hi vinodkewate,

Thanks for your help. I only have about 20 doctors addresses that I need to query.

I created a database on the SQL server running on the CCX and created tables and data for one of the doctors.

I ran a SQL query in the DB Read > select * from DoctorInfo where ZipCode = 92673 and it worked.

I put the select * from DoctorInfo where ZipCode = value(Get Digit String) and the debug on the script just passed right over the successful to SQL error on the branch and terminated.

So I cannot figure out or find any documentation as to why the script is getting SQL errors.

Also on the SET statement, I wanted to setup a TTS to playback to the caller the values from each column that the variables match.

Do you know how to do that?

I just have SET DoctorAddress = DoctorAddress... but I know that is not right. I think I need something like

SET DoctorAddress = plSpeech + plSpeechAddress + DoctorAddress

Hi Bryan,

If you want get all the rows of the Select * from

About your question I think you will need to modify your query because you are querying the database and your  database doesn't know what is "= value("Get Digit String")".

Gabriel.

With the TTS you need a Create Generated Prompt with the variable that contains the address, then you have to use a create container prompt to concatenate a prerecorded .wav that says maybe "the doctor's address is" and after that add the generated prompt. and then you have to use a play prompt step to play the .wav + the generated prompt.

I meant that collect the ZIP code entered by user in one variable.

Say Input_ZIPCode=Get digit string()

Then fire SQL query to select doctors and address having ZIP_Code= Input_ZIPCode

Hi Vinodkewate,

I was able to get the TTS working and I created a database with SQL. I am able to query the database for a few columns and have the results returned to play back an address. My question is now, I have multiple hospital locations within the same zip code. How do I script it to where the select * from XXX returns those multiple locations and allows the caller to to press 1 , 2, or 3 to hear the addresses for each location?

Thanks,

Bryant,.

Hi Bryant,

After you query the database for all the posible hospitals, you can create a prompt array, so when he dials 1 you can take and play the prompt in position 0 of the array and so on. But I think the easier and better way is that for each row that the query throws you play the prompt for the triggering contact, and then you can ask him with a menu if he wants to hear again that prompt or continue with the next prompt, all this by using labels.

Hi Gabsaaqom,

Yes I see what you mean by doing a physician loop. I was able to get the script to play out a TTS prompt for each physician, but I am not sure how to create a "prompt array". Do you know of any script examples I can follow to customize my script?

Thanks for your help.

Bryant

Hi Gabriel,

So I took your advise and I was able to use the labels as you suggested. It works great!! Thanks..

So I attached my simple script. I plan to customize it more.

I just enabled the Nuance Recognizer 9 and tested my aa.aef canned cisco script to verify. It works as expected.

Drilling down through the aa.aef script, I realize that it is way too complicated for me to figure out.

I just was wondering what steps I need in my simple script "script11.aef" to integrate ASR functions that will allow the caller to "SAY" the zipcode in addition to DTMF.

If I just get directed in the right direction, I can try and figure it out.

I do not know if I need conditional prompts since I already have ASR enabled.

I seem to have the simple recognition "menu" working "ONLY" as DTMF right now in my simple script. I made a grammar *.digit but I am not sure why it does not respond to speech as the aa.aef does.

What my goal is, is to have the spoken zipcode get saved as a string to use as a variable in quering a SQL database, Just like the get digit string does now with DTMF.

Thanks gabssagom,

So for complete functionality on the TTS, I would need to setup a provider within IPCC correct?

The question I have is if the nuance dragon naturally speaking v10 would work as the MRCP server?

Thanks,

Bryant.