[Asterisk-Users] Integrate asterisk with Database

[Vidura Senadeera]

 Hi All,

I am plainging to give a solutions for a sports club. Follwing is the
process that i need to achieve.
If any body achieve this kind of setup pls give me a feedback, so that i can
go through.


........Call flow ............ start


[for database operations please use an access database with suitably
configured fields]

Thank you for calling Sports World

Press 1 for English, 2 for French

Please key in your 12 digit membership number

Your membership number is [repeat the digits that have been keyed in]

Press 1 to confirm or 2 to key again [loop until confirmed]

[exit after three invalid attempts and say] Invalid membership number.
Please call customer services.

[Access database and lookup the membership number and check validity field
in database]

[If missing or invalid bin] The membership number is invalid. Transaction
terminated. [exit at this point]

Please enter your mobile number

Your mobile number is [repeat the digits that have been keyed in]

Press 1 to confirm or 2 to key again [loop until confirmed]

Please enter your activity code [4 digits]

Your activity code is [repeat the digits that have been keyed in]

Press 1 to confirm or 2 to key again [loop until confirmed]

Please enter your activity duration [upto 5 digits]

Your activity duration is [repeat the digits that have been keyed in]

Press 1 to confirm or 2 to key again [loop until confirmed]

[store mobile number, activity code and activity duration in the database]

Your transaction is complete.
Thank you for using sports world.

..........Call flow end ......



Thanks & Regards,
Vidura Senadeera.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20060630/b6c71711/attachment.htm