Suggested Development: Remove DNC lead from hopper.

Discussions about development of VICIDIAL and astGUIclient

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Suggested Development: Remove DNC lead from hopper.

Postby mrgunston » Sun Nov 18, 2018 7:39 pm

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
mrgunston
 
Posts: 33
Joined: Tue Oct 11, 2016 9:51 pm

Re: Suggested Development: Remove DNC lead from hopper.

Postby williamconley » Sun Nov 18, 2018 11:44 pm

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.
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: Suggested Development: Remove DNC lead from hopper.

Postby mflorell » Mon Nov 19, 2018 3:14 am

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...
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida


Return to Development

Who is online

Users browsing this forum: No registered users and 33 guests