asterisk users - Apr 2009 - AstDB & MixMonitor queries

Hi

My setup : Trixbox 2.6.1 & TE410P running well ..I've 2 design issues to
consider :

1. I need to store the CallerId of the PSTN caller with his language preference
so that next time he is played the prompt in his language that he chose the
first time.What would be better - storing his number in the Asterisk DB and
using Dbput and DBget ? or storing it in MySQL from the dial plan and quering it
everytime to see the callers record ? how many records can AstDB handle safely ?
In my case the total records wont exceed 20,000 since there are many repeat
callers ?
2. I need all your help in writing an IVR program in Asterisk - i prefer AGI and
PHP. The caller calls into the system - he is asked to record his Name (IVR
plays it back and confirms) next he is aked to record his age (IVR plays back
and confirms) and next he is asked to record his address(IVR plays back and asks
his confimration) ..I wud typically want all this to be stored in a single file
which my agent would listen and record a response to it. My queries : i) Is it
advisable to record the caller responses as a single prompt in append modes or 3
separate files and combine them using php since everytine the IVR wud confimr
the input it shd play only that particular promt for ex: while asking for age
confirmation it shd only play "you entered age as:" <caller
response on age>, how will asterisk know where to play from in that single
file if i choose to go wiht just 1 file? how can i use mixmonitor effectively

Thanks
Sriram 
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20090420/a8429c13/attachment.htm

On Mon, 20 Apr 2009, Sriram wrote:
> 2. I need all your help in writing an IVR program in Asterisk - i prefer 
> AGI and PHP. The caller calls into the system - he is asked to record 
> his Name (IVR plays it back and confirms) next he is aked to record his 
> age (IVR plays back and confirms) and next he is asked to record his 
> address(IVR plays back and asks his confimration) ..I wud typically want 
> all this to be stored in a single file which my agent would listen and 
> record a response to it. My queries : i) Is it advisable to record the 
> caller responses as a single prompt in append modes or 3 separate files 
> and combine them using php since everytine the IVR wud confimr the input 
> it shd play only that particular promt for ex: while asking for age 
> confirmation it shd only play "you entered age as:" <caller
response on
> age>, how will asterisk know where to play from in that single file if i
> choose to go wiht just 1 file? how can i use mixmonitor effectively
I prefer writing AGIs in C. I can execute tens (maybe hundreds) of AGIs 
written in C before you can load your interpreter and parse.

I'd vote for recording in separate files and concatenating them at the end 
of the call. Since you want to play single responses, you don't have 
any choice.

I'm just finishing a system where for each "step" in my
"recipe," there is
a long prompt and a short prompt. The caller gets the long prompt the 
first time. After hearing their response (voice or DTMF) they get a chance 
to confirm. If they want to do over, they hear the short prompt.

For this application, I have to record the prompt and their response. At 
the end of the call, all of the prompts and responses for all the steps 
are concatenated into a single WAV, encoded to WMA and uploaded to a web 
site for the client to review.

All of the recipes and steps are stored in a MySQL database so I can add, 
subtract, and rearrange steps easily.

Thanks in advance,
------------------------------------------------------------------------
Steve Edwards      sedwards at sedwards.com      Voice: +1-760-468-3867 PST
Newline                                             Fax: +1-760-731-3000