Suggested Development: Remove DNC lead from hopper.

[mrgunston]

I discovered an issue that whenever a lead is added to the DNC list, it remains on the hopper. We found that this was causing leads to be called where they shouldn't. We have a process now to reset the hopper whenever a lead is manually added to DNC however, I thought id share my suggestion for a Vici improvement to stop this from happening again:

Improvement:

- Add code to the function which inserts into the vicidial_dnc to also do the following: “DELETE FROM vicidial_hopper WHERE phone_number = @dnc_phone_number”



Vicibox 2.12-565a from vicibox_v7x68_65.iso | Vicidial 2.12-565a Build 160827-0917 | Asterisk 11.23.1-vici | Single Server | No Digium/Sangoma Hardware | No Extra Software After Installation | DELL R710 | Intel Xeon CPU X5690 @ 3.47Ghz 6 Cores

[williamconley]

So ... write yourself a nice "trigger"

https://stackoverflow.com/questions/162 ... e-in-mysql

And then (after it's tested) post it to the Vicidial Issue Tracker (link at the top of this page) and then post a link to that issue here plus perhaps a copy of the code here (since it will be fairly simple mysql code). That's your best bet to get it included in a future version of Vicidial.

[mflorell]

This is usually only a problem for companies that have their hopper level set way too high. Your hopper level should be no more than the number of calls your campaign will place in 5 minutes. There are all kinds of problems that can happen if you set it too high, like calling recently added DNC numbers, or numbers of people who are calling inbound, etc...