Vicidial mysql repair command / goautodial mysql repair command below are the possible issue faced while db/mysql corrupted 1. your session has been disabled 2. Autodial calls not landing to Agents. 3. realtime report not updating properly 4. agent error Run the below command as ssh shell ie: from putty mysqlcheck -u root -p –auto-repair ..
Category : VICIDIAL
Here’s the source for a php/agi file and dialplan sample I made, which can help you implement what you need : #extensions.conf exten => 12345,1,Goto(dtmf-recording,${EXTEN},1) [dtmf-recording] exten => _X.,1,Answer exten => _X.,2,Set(TIMEOUT(digits)=5) exten => _X.,3,Set(TIMEOUT(response)=10) exten => _X.,4,Set(TIMESTAMP=${STRFTIME(${EPOCH},,%Y%m%d-%H%M%S)}) exten => _X.,n,Read(DTMF|/var/lib/asterisk/agi-bin/sounds/whatever) exten => _X.,n,Hangup exten => h,1,Deadagi(agi-bin/report_dtmf.php|${TIMESTAMP}|${DTMF}) ————————————————— report_dtmf.php : <?php set_time_limit(30); require_once “phpagi.php”; declare(ticks ..
This campaign has zero leads in the dial hopper This campaign has 0 leads in the dial hopper ! This campaign has zero leads in the dial hopper No Leads in the Hopper to dial Follow the below step to get rid of the above error /problem ..
vicidial_log Field Name Description Location uniqueid unique id for record lead_id Lead Identifier /vicidial/admin_search_lead.php list_id List Name vicidial/admin.php?ADD=100 campaign_id Campaign Name vicidial/admin.php?ADD=10 call_date Call Date and Time /vicidial/user_stats.php?user= start_epoch Start of Call end_epoch End of Call length_in_sec Length of Call in seconds /vicidial/user_stats.php?user= status Dispositioned Status given at end of call Note this may no ..
recording_log Field Name Description Location recording_id Primary Key for this table channel asterisk channel when call was live vicidial/admin_modify_lead.php?lead_id=#### server_ip IP address of server user is connected to extension could be callerid of the client or extension call was ultimately sent to start_time start time of call start_epoch start time of call in unix epoch ..
vicidial_agent_log Field Name Description Location agent_log_id Primary Key for this table user User Name ID field vicidial/AST_agent_time_detail.php server_ip IP address of server user is connected to vicidial/AST_usergroup_login_report.php event_time Time logged for start of event or call lead_id link to vicidial_list.lead_id campaign_id Campaign user is logged into /vicidial/AST_agent_time_detail.php pause_epoch start of agent pause time pause_sec length ..
vicidial_closer_log Field Name Description Location closecallid closed call table Primary key lead_id ID of Lead vicidial/admin_modify_lead.php?lead_id= list_id ID of List vicidial/admin_modify_lead.php?lead_id= campaign_id Alpha Numeric Campaign ID from Vicidial Campaigns call_date Date and Time call was made start_epoch Start of Call Time end_epoch End of Call Time length_in_sec Total Length of call in seconds vicidial/AST_agent_performance_detail.php status ..
vicidial_log Field Name Description Location uniqueid unique id for record lead_id Lead Identifier /vicidial/admin_search_lead.php list_id List Name vicidial/admin.php?ADD=100 campaign_id Campaign Name vicidial/admin.php?ADD=10 call_date Call Date and Time /vicidial/user_stats.php?user= start_epoch Start of Call end_epoch End of Call length_in_sec Length of Call in seconds /vicidial/user_stats.php?user= status Dispositioned Status given at end of call Note this may no ..
Most of these fields are visible in /vicidial/admin_modify_lead.php?lead_id={LEAD_ID} and/or on the agent screen. If so, they are marked “admin_modify_lead” or “agent screen” (or “both”). Field Name Description Location lead_id Unique ID for leads, incrementing admin_modify_lead entry_date Date/time lead imported modify_date Date/time of last modification Enforced by mysql code status Disposition/Status (NEW, DROP) admin_modify_lead user vicidial ..
NEW – New Lead – Lead has not been called, or cannot be called QUEUE – Lead To Be Called – Lead is about to be sent to an agent INCALL – Lead Being Called – Agent is talking to the lead DROP – Agent Not Available – Call was dropped while customer was waiting ..
Recent Comments