I have Created Asterisk Server
Dahdi Linux Complete
What I have done here is :
- Developed Asterisk server. I have two server. One for Asterisk and another for MYSQL
- created 10 Agents. Agents are login using **1 that i have created dialplan to login the agents
- I have Two Campaigns.
I want to assign 5 agents in each CAMPAIGNS.
I have uploaded my customer details in my MYSQL server.
In my MYSQL server database i have assigned CAMPAIGN ID to know the each CAMPAIGNS.
campaign Name Campaign ID
CAMPAIGN A 1
CAMPAIGN B 2
I have 10 Agents
I want to add 5 agents for each
Campaign A Campaign B
Once the agents logged in,
Agents will hear some music.
I have created a web application. There is one button to get that information from MYSQL. Once i click that ‘get numbers’ BUTTON on that application, it’ll automatically take that number from MYSQL database. dialing through asterisk. i have created a user in ‘manager.conf’ to connect that asterisk with application. Without campaign itz working. everything is Ok.
With out Campaign ID i have assigned context on my application. one i try to dial itz going through that Context. Itz working fine. everything is perfect.
If i want to dial using CAMPAIGN ID then.
what i have to do is instead of that context on my manager application code, i have given campaign ID.
So, Some one told me that i have to write a dial plan to fetch the campaign ID from MYSQL database and to create a two QUEUES for two campaign as well as assign 5 agents in each Queues.
So any one any IDEA about to write dialplan using MYSQL?
campaign ID table name is: cust_campaign_details
Thanks & regards