Find Jobs
Hire Freelancers

Play custom messages to caller, based on ODBC Database connection

$250-1500 NZD

Completed
Posted almost 6 years ago

$250-1500 NZD

Paid on delivery
I have a requirement to play a custom message to a caller, that needs to be driven from a database, and is able to scale out. We will have IVRs in place, that the caller will press, which will then move to the context we are looking for your to develop for us. In side this context, you will need to look up a database, with a syntax like (callerregion is set by option the caller selects in the IVR) select areas,restoretime from tblADMSOutages where region='${callerregion}' If this returns no information, you will need to proceed to the failover destination. If this returns information, we need to play the information from the database to the user. You may have single or multiple rows of data, which is in the following format. areas Area One,City Four,Town Two restoretime 2018-05-03 13:00:00 areas Area Three,City Seven,City Eight restoretime 2018-05-08 23:00:00 So assuming the above, and assuming the call was incoming on the 2018-05-03 at 11am, we would expect the caller to hear: We are currently aware of outages in the following areas: Area One,City Four,Town Two with an expected restore time of today at 1pm Area Three,City Seven,City Eight with an expected restore time of 8th of May at 11pm If you require additional information, please press 1 However if the caller was calling in within 30 minutes of an outage resolution time (or past an expected restore time, we would expect the caller to hear: We are currently aware of outages in the following areas: Area One,City Four,Town Two that should be restored within the next 30 minutes. Area Three,City Seven,City Eight with an expected restore time of 8th of May at 11pm If you require additional information, please press 1 In order to achieve this, we have recorded the following: intro - We are currently aware of outages in the following areas: restore - with an expected restore time of restoresoon - that should be restored within the next 30 minutes footer - If you require additional information, please press 1 For each area we have the audio file recorded, which is saved all in lowercase, with no spaces etc (so Area One would be areaone, and City Four would be cityfour, etc) At anytime during the message the caller should be able to press 1. If the caller does not press anything within 5 seconds of the message been completed, the message should repeat once, if the caller doesnt press anything, the call should end. If the caller does press 1, the call should be transferred to failover number. This needs to scale, during peak times, this will be getting played to 200+ callers concurrently. I'm not sure if what we require can be managed within the dialplan, if AGI is required, we would like this to be PHP.
Project ID: 16997600

About the project

3 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
How are you? I have rich experience in developing asterisk. I have been studying about pbx for 5 years. I will satisfy your requirement. Hope to contact with you. Best regards.
$972 NZD in 10 days
4.9 (16 reviews)
6.2
6.2
3 freelancers are bidding on average $972 NZD for this job
User Avatar
hello how are you? I have just read your job description and so much interested in your project. I have already good experience with Asterisk PBX and VOIP call app so I feel confident in this field. do you have any detailed doc or design file for your project? I am waiting for your reply..
$972 NZD in 10 days
5.0 (1 review)
2.7
2.7

About the client

Flag of NEW ZEALAND
Hastings, New Zealand
0.0
0
Payment method verified
Member since May 18, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.