Any person who has an account in a bank would like to know his/her account balance status at any time. The customers have got only three options - walk down to the bank to get these details or contact the bank staff through telephone or go for the Internet banking. The first option is not feasible in the present scenario. The second option is not possible all the time as it may increase the workload of the staff and for the third option using Internet Banking facility will require a system with Internet facility which may not be possessed by many of the customers. To simplify, Xtend IVR brings out a faster approach in dealing with the accounts in banks.
The automated attendant will work as given below:
$db = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Bank.xls;Extended Properties=Excel 8.0" $retrycount = 2 MAIN: display "Waiting for call . . ." answer 1 * Welcome user play "Welcome.wav" play "silence.wav" ACCEPT_ACCNO: display "Accept account number" play "silence.wav" $retry = $retrycount while $retry > 0 play "PunchAccount.wav" $Acno = Input(4,5) if $Acno = "" if $retry = $retrycount play "advice.wav" endif else break endif $retry -= 1 endwhile if $Acno = "" then goto GOODBYE ACCEPT_PIN: display "Accept PIN number" play "silence.wav" $retry = $retrycount while $retry > 0 play "GetPin.wav" $Pin = Input(4,5) if $Pin <> "" break endif $retry -= 1 endwhile if $Pin == "" then goto GOODBYE display "Validating User" $sql = format("SELECT * FROM [Sheet1$] WHERE AccNo = '%s'",$Acno) $dbalias = db.RunSQL($db, $sql) if $dbalias.eof play "InvalidAcno.wav" goto GOODBYE endif if compare($dbalias.PIN,$Pin) <> 0 play "InvalidPin.wav" goto GOODBYE endif play "silence.wav" play "AccBal.wav" $wave = Money2Wav($dbalias.Balance) play $wave GOODBYE: display "Terminating Call" play "silence.wav" play "goodbye.wav" hangup goto MAIN ONHANGUP: hangup goto MAIN ONSYSTEMERROR: log $error display $error hangup goto MAIN