List "0"

Any and all non-support discussions

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

List "0"

Postby KDell » Thu Apr 21, 2011 12:31 pm

When we get an inbound call, it gets assigned to list "0" For some reason I cannot download this list. How can I get it to download?
Multi Server Set Up (3 Asterisk/1 SQL) | VERSION: 2.4-290 | BUILD: 101127-2232 | Asterisk - 1.4.21.2-vici | Ubuntu 8.04 LTS | No Digium/Sangoma Hardware | No Extra Software After Installation
G729 via Digium | 80 seats
KDell
 
Posts: 129
Joined: Tue Sep 21, 2010 6:16 pm

Postby williamconley » Thu Apr 21, 2011 3:55 pm

execute this mysql command:

Code: Select all
update vicidial_list set list_id='66666666' where list_id='0';


This will reassign all leads in list_id "0" to list_id '66666666'.
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: 20258
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Postby KDell » Thu Apr 21, 2011 3:57 pm

williamconley wrote:execute this mysql command:

Code: Select all
update vicidial_list set list_id='66666666' where list_id='0';


This will reassign all leads in list_id "0" to list_id '66666666'.
oh awesome, this is perfect, I wanted to call back inbound drops! so I can just have this run every night and create a new list id! right?
Multi Server Set Up (3 Asterisk/1 SQL) | VERSION: 2.4-290 | BUILD: 101127-2232 | Asterisk - 1.4.21.2-vici | Ubuntu 8.04 LTS | No Digium/Sangoma Hardware | No Extra Software After Installation
G729 via Digium | 80 seats
KDell
 
Posts: 129
Joined: Tue Sep 21, 2010 6:16 pm

Postby williamconley » Thu Apr 21, 2011 4:22 pm

why don't you change the list_id for your ingroup/DID to a real number? 8) (is it a word or a 0 or blank right now?)
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: 20258
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Postby KDell » Thu Apr 21, 2011 5:23 pm

williamconley wrote:why don't you change the list_id for your ingroup/DID to a real number? 8) (is it a word or a 0 or blank right now?)

List ID is 0
No list name or description - I think this is a default setting, I dont know enough to change it without the worry that it might affect how the inbound calls are stored.
Multi Server Set Up (3 Asterisk/1 SQL) | VERSION: 2.4-290 | BUILD: 101127-2232 | Asterisk - 1.4.21.2-vici | Ubuntu 8.04 LTS | No Digium/Sangoma Hardware | No Extra Software After Installation
G729 via Digium | 80 seats
KDell
 
Posts: 129
Joined: Tue Sep 21, 2010 6:16 pm

Postby williamconley » Thu Apr 21, 2011 5:49 pm

the only thing it will change is the list_id that they are stored in. LOL change it to the list_id of the list you want them in. that's what the field is for. the "default" is actually 999 if i recall.

it should never be set to "0" as that is not a legal list_id in the first place. and i've had situations when list_id "0" actually became activated! (and began dialing in several campaigns 8)). I have weird clients that do all sorts of things (sorta like having list_id Zero for a default DID list id)
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: 20258
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Postby KDell » Fri Apr 22, 2011 11:50 am

oh now it gets weirder - I have list 999 and a list 0

List 0 has these statuses:
A 2718 0
AA Answering Machine Auto 198 0
AFTHRS Inbound After Hours Drop 42344 0
AL Answering Machine Msg Played 207 0
AM Answering Machine Sent to Mesg 13 0
B Busy 104 0
CALLBK Call Back 223 694
CBHOLD Call Back Hold 117 0
CS Customer Service 227 0
DC 160 0
DNC DO NOT CALL 8723 0
DROP Agent Not Available 40518 0
ERI Agent Error 6850 0
INBND 2116 0
INCALL Lead Being Called 21 0
IS 2121 0
N 8124 0
NA No Answer AutoDial 108 0
NEW New Lead 0 19
NI 16915 0
NS 449421 0
PU Call Picked Up 72 0
RD 22591 0
Refuse 1 0
SALE Sale 63622 0
SaleIS 6536 0
TIMEOT Inbound Queue Timeout Drop 225 0
WN 7485 0
XFER 189 0



List 999 has these:
A 62 0
AA Answering Machine Auto 1 0
AFTHRS Inbound After Hours Drop 3168 0
AL Answering Machine Msg Played 2 0
B Busy 9 0
CALLBK Call Back 0 27
CBHOLD Call Back Hold 7 0
DC 4 0
DNC DO NOT CALL 162 0
DROP Agent Not Available 472 0
ERI Agent Error 79 0
INBND 950 0
N 166 0
NA No Answer AutoDial 1 0
NEW New Lead 0 60000
NI 69 0
NS 4276 0
RD 386 0
SALE Sale 480 0
SaleIS 53 0
TIMEOT Inbound Queue Timeout Drop 5 0
WN 171 0
Xfer 3 0


I'm going to have to talk to some people and figure this out - it's not caused a problem yet, but I dont want us to start diling all these inbound back out - our clients might get a little touchy about that one!
Multi Server Set Up (3 Asterisk/1 SQL) | VERSION: 2.4-290 | BUILD: 101127-2232 | Asterisk - 1.4.21.2-vici | Ubuntu 8.04 LTS | No Digium/Sangoma Hardware | No Extra Software After Installation
G729 via Digium | 80 seats
KDell
 
Posts: 129
Joined: Tue Sep 21, 2010 6:16 pm

Postby williamconley » Fri Apr 22, 2011 12:47 pm

you'll need to locate the logs and match them up to find out where these numbers originated.

then be sure that list Zero does not exist on any DID/Ingroup or anywhere so you can stop generating list zero entries that will need cleaning up in the future
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: 20258
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Postby KDell » Fri Apr 22, 2011 12:49 pm

williamconley wrote:you'll need to locate the logs and match them up to find out where these numbers originated.

then be sure that list Zero does not exist on any DID/Ingroup or anywhere so you can stop generating list zero entries that will need cleaning up in the future
could it be generated because we left something blank?
Multi Server Set Up (3 Asterisk/1 SQL) | VERSION: 2.4-290 | BUILD: 101127-2232 | Asterisk - 1.4.21.2-vici | Ubuntu 8.04 LTS | No Digium/Sangoma Hardware | No Extra Software After Installation
G729 via Digium | 80 seats
KDell
 
Posts: 129
Joined: Tue Sep 21, 2010 6:16 pm

Postby williamconley » Fri Apr 22, 2011 12:54 pm

blank and zero are the same thing in the world of numeric variables.

(means yes 8))
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: 20258
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Postby KDell » Fri Apr 22, 2011 12:58 pm

williamconley wrote:blank and zero are the same thing in the world of numeric variables.

(means yes 8))
Looks like it's in our DID's I'm going to go in and change all 500 of them over - will this work retroactively? or will I need to still change that list ID?
Multi Server Set Up (3 Asterisk/1 SQL) | VERSION: 2.4-290 | BUILD: 101127-2232 | Asterisk - 1.4.21.2-vici | Ubuntu 8.04 LTS | No Digium/Sangoma Hardware | No Extra Software After Installation
G729 via Digium | 80 seats
KDell
 
Posts: 129
Joined: Tue Sep 21, 2010 6:16 pm

Postby williamconley » Fri Apr 22, 2011 1:06 pm

does not "work retroactively" unless you have a time machine (isn't there an open source one?)
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: 20258
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Postby KDell » Fri Apr 22, 2011 1:09 pm

williamconley wrote:does not "work retroactively" unless you have a time machine (isn't there an open source one?)
Well I ordered a Tardis, we'll see if it works! :D
Multi Server Set Up (3 Asterisk/1 SQL) | VERSION: 2.4-290 | BUILD: 101127-2232 | Asterisk - 1.4.21.2-vici | Ubuntu 8.04 LTS | No Digium/Sangoma Hardware | No Extra Software After Installation
G729 via Digium | 80 seats
KDell
 
Posts: 129
Joined: Tue Sep 21, 2010 6:16 pm

Postby williamconley » Fri Apr 22, 2011 1:16 pm

Problem is that they canceled the project and the open source one was Blue and SMALLER on the inside than the outside anyway but it Was Gonna be better ... LOL
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: 20258
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)


Return to General Discussion

Who is online

Users browsing this forum: No registered users and 60 guests