vicidial.org

mflorell wrote:It all depends on your carrier and whether you can trust the hangup cause codes coming back. Most carriers in the USA are not reliable on their disconnect codes by over 20%.

The only good solution we have found is using the paid-add-on Sangoma CPA call progress analysis proxy.

williamconley wrote:if you're dialing in the US, last time i checked the vicidial system categorized all as NA without regard for the coding (or lack thereof) regarding DC vs no answer.

i have a script that will check for zero second na (which indicates the provider didn't even attempt to call, translates to DC), but i have recent clients who have re-called those and found a fairly large percentage are real numbers ... if called through the same provider even.

so you may need to experiment with this. a useful tool is the carrier log.

mflorell wrote:We have been over this several times. Asterisk is not capable of detecting pre-answer signals, and carrier disconnect signaling is extremely inconsistent resulting in setting disconnect signals for valid phone numbers.

The only solution that works is a paid one, the Sangoma CPA that we have set up for several clients using ViciDial is very good at this, but you have to pay for it on a per channel basis.

dspaan wrote:We are located in South America but only make calls to the Netherlands, Europe. How could we use those cause codes to our benefit then?

DarknessBBB wrote:

dspaan wrote:We are located in South America but only make calls to the Netherlands, Europe. How could we use those cause codes to our benefit then?

I think you have to talk with your telco, if you use ISDN, and tell him to send the properly codes.
Then you can see them in the vicidial logs

http://networking.ringofsaturn.com/Rout ... ecodes.php

Usually the codes 16, 1 and 17 cover the 99% of the calls.

And, months ago we had a issues with a brand new E1 line, our telco configured it to send, for DC numbers, a vocal message in call progress mode. This way the call was archived as NA. I've just asked them to send instead the code "1".

Code: Select all


delimiter //
create trigger vicidial_carrier_log_ai
AFTER INSERT
ON vicidial_carrier_log
FOR EACH ROW

BEGIN

IF NEW.hangup_cause = '34'
THEN
UPDATE vicidial_list
SET status = 'PRI34'
WHERE vicidial_list.lead_id = NEW.lead_id;
END IF;

END;//
delimiter ;


Code: Select all

delimiter //

create trigger vicidial_list_bu BEFORE UPDATE ON vicidial_list
FOR EACH ROW

BEGIN
DECLARE huccount INTEGER;
DECLARE huc INTEGER;

IF NEW.status = "NA" THEN
SELECT count(DISTINCT hangup_cause) INTO huccount FROM vicidial_carrier_log WHERE lead_id = OLD.lead_id;
IF huccount = 1 THEN
SELECT hangup_cause INTO huc FROM vicidial_carrier_log WHERE lead_id = OLD.lead_id GROUP BY lead_id;
IF huc = "34" THEN
SET NEW.status = "PRI34";
END IF;
END IF;
END IF;
END;//
delimiter ;


Code: Select all

delimiter //
create trigger vicidial_list_bu BEFORE UPDATE ON vicidial_list
FOR EACH ROW
BEGIN
DECLARE callcount INTEGER;
DECLARE huccount INTEGER;
DECLARE huc INTEGER;
IF NEW.status = "NA" THEN
SELECT count(DISTINCT hangup_cause), count(hangup_cause)  INTO huccount, callcount FROM vicidial_carrier_log WHERE lead_id = OLD.lead_id;
IF callcount >= 4 AND huccount = 1 THEN     /* Leads are hung up min. 4-times and all times hangup_cause was the same */
SELECT hangup_cause INTO huc FROM vicidial_carrier_log WHERE lead_id = OLD.lead_id GROUP BY lead_id;
IF huc = "34" THEN
SET NEW.status = "PRI34";
END IF;
END IF;
END IF;
END;//
delimiter ;


Code: Select all


delimiter //

create trigger vicidial_list_bu BEFORE UPDATE ON vicidial_list

FOR EACH ROW

BEGIN

DECLARE callcount INTEGER;
DECLARE huccount INTEGER;
DECLARE huc INTEGER;

IF NEW.status = "NA" OR NEW.status = "N" THEN

SELECT count(DISTINCT hangup_cause), count(hangup_cause), hangup_cause INTO huccount, callcount, huc FROM vicidial_carrier_log WHERE lead_id = NEW.lead_id;

IF callcount >= 1 AND huccount = 1 AND huc = 1 THEN   
/* Number unassigned - put it away asap */

SET NEW.status = "PRI1";

ELSEIF callcount >= 3 AND huccount = 1 AND huc = 34 THEN   
/* Dialed 3times and all times hangup_cause was no circuit or channel */

SET NEW.status = "PRI34";

END IF;
END IF;

END;//
 
delimiter ;



dspaan wrote:Thanks for posting your updates, i will discuss this with my partner and test your script

dspaan wrote:Don't understand why VICIidial doesn't do this out of the box...

mflorell Posted: 2011-10-10 14:12:44 http://www.vicidial.org/VICIDIALforum/v ... 7288#77288 wrote:Using CONGESTION is very unreliable here in the USA. With telco deregulation many carriers oversell their lines and use very restrictive LCR so that you can get a CONGESTION frequently on valid numbers.

Code: Select all

UPDATE vicidial_list set called_since_last_reset='N' where list_id='$list_id';

Code: Select all

DROP trigger vicidial_list_bu;
UPDATE vicidial_list set called_since_last_reset='N' where list_id='$list_id';
CREATe trigger....


Code: Select all

[mysqld]
user      = mysql
socket      = /var/run/mysqld/mysqld.sock
port      = 3306
basedir      = /usr
datadir      = /var/lib/mysql
tmpdir      = /tmp
skip-external-locking
bind-address      = 0.0.0.0
key_buffer      = 384M
max_allowed_packet   = 16M
# thread_stack      = 128K
thread_cache_size   = 8
max_connections         = 400
#table_cache             = 512
table_cache             = 1M
thread_concurrency      = 4
sort_buffer_size        = 2M
read_buffer_size        = 2M
read_rnd_buffer_size    = 8M
myisam_sort_buffer_size = 64M
tmp_table_size          = 32M
myisam-recover         = BACKUP
query_cache_limit   = 8M
query_cache_size        = 32M
log_error                = /var/log/mysql/error.log
log_warnings = 0
log_slow_queries   = /var/log/mysql/mysql-slow.log
long_query_time = 2
log_bin         = /mnt/datastore/dbbackup/mysql-bin.log
expire_logs_days   = 10
max_binlog_size         = 100M


Code: Select all

ALTER TABLE `vicidial_carrier_log` ADD INDEX ( `lead_id` )


Code: Select all

/* Add an index on the lead_id column of  vicidial_carrier_log table!*/
ALTER TABLE `vicidial_carrier_log` ADD INDEX ( `lead_id` ) ;

delimiter //

create trigger vicidial_list_bu BEFORE UPDATE ON vicidial_list

FOR EACH ROW

BEGIN

DECLARE callcount INTEGER;
DECLARE huccount INTEGER;
DECLARE huc INTEGER;

IF (NEW.called_since_last_reset != "N") AND (NEW.status = "NA" OR NEW.status = "N") THEN

SELECT count(DISTINCT hangup_cause), count(hangup_cause), hangup_cause INTO huccount, callcount, huc FROM vicidial_carrier_log WHERE lead_id = NEW.lead_id;

IF callcount >= 1 AND huccount = 1 AND huc = 1 THEN   
/* Number unassigned - put it away asap */

SET NEW.status = "PRI1";

ELSEIF callcount >= 3 AND huccount = 1 AND huc = 34 THEN   
/* Dialed 3times and all times hangup_cause was no circuit or channel */

SET NEW.status = "PRI34";

ELSEIF callcount >= 3 AND huccount = 1 AND huc = 38 THEN   
/* Dialed 3times and all times hangup_cause was network out of order */

SET NEW.status = "PRI38";

END IF;
END IF;

END;//
 
delimiter ;


DomeDan wrote:
for example, I would like to try to call leads registered with this hangup cause:
19 no answer from the user 480 Temporarily unavailable
more then this onces:
1 unallocated number 404 Not Found

Anyway, as I mention earlier in this thread, I've been using this patch since July 2011 and still no problems

DomeDan wrote:

dspaan wrote:Don't understand why VICIidial doesn't do this out of the box...

mflorell Posted: 2011-10-10 14:12:44 viewtopic.php?p=77288#77288 wrote:Using CONGESTION is very unreliable here in the USA. With telco deregulation many carriers oversell their lines and use very restrictive LCR so that you can get a CONGESTION frequently on valid numbers.

Code: Select all

stmtA = "UPDATE vicidial_list set status='$VDL_status' where lead_id = '$CIDlead_id';";

Code: Select all

if ($CLstatus =~ /DISCONNECT/) {$CLnew_status = 'ADC';}

Code: Select all

if ($CLstatus =~ /DISCONNECT/) {$CLnew_status = 'DC';}

mflorell wrote:Post a diff -u file patch against current svn/trunk to the Issue tracker please.

DomeDan wrote:Thank you for those words omarrodriguezt! glad my efforts are appreciated!

It was added in r1891 but anyway.
yeah the status in vicidial_list will be DC in any of the hangup causes.
but in vicidial_log it will be ADC if its hangup cause 1
and ADCT if its any of these hangup causes: 19, 21, 34, 38
you can see those statuses under "CALL STATUS STATS" in the Outbound Calling Report /AST_VDADstats.php?group%5B%5D=--ALL--&SUBMIT=SUBMIT

Code: Select all

$stmtA = "UPDATE vicidial_list set comments='$hangup_cause|$dialstatus|$dial_time|$ring_time|$channel|$extension|$type|$callerid|$calleridname' where lead_id = '$CIDlead_id';";
$VDADaffected_rows = $dbhA->do($stmtA);

Code: Select all

                  ##############################################################
                  ### BEGIN - CPD Look for result for B/DC calls
                  ##############################################################

DomeDan wrote:I would suggest you to try an other carrier for comparison, its most likely the cause
and query vicidial_carrier_log to compare the results