Due to state of emergency in Florida MySQL script

All installation and configuration problems and questions

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

Due to state of emergency in Florida MySQL script

Postby davesdatasystems » Fri Aug 30, 2019 9:49 am

Ok, i figured i would ask here, since i cant seem to get this script right. Or if there is a direct setting in vicidial to do this, that would be even better.

So i do not want to call Florida while it is in the state of emergency, and i got the script working fine for not calling Florida, i used state NOT IN('FL'), but i also wanted to filter out the area codes as well, so to do the state and area codes, i used state NOT IN('FL') & left(phone_number,3) NOT IN ('239','305','321','352','386','407','561','689','727','754','772','786','813','850','863','904','941','954') but when i did the test, it said it would dial 0 leads. So i am wondering what i might of did wrong on the script, or is there somewhere else in vicidial that will filter out the states without using filters.
VICIBOX V10 installed via USB
VERSION: 2.14b0.5
BUILD: 220831-0850
Asterisk 13.38.2-vici
SVN: 3641 (at time of this signature edit)
Custom PC
No Extra Software After Installation
davesdatasystems
 
Posts: 132
Joined: Thu Aug 25, 2011 11:39 am

Re: Due to state of emergency in Florida MySQL script

Postby ambiorixg12 » Fri Aug 30, 2019 11:09 am

I would suggest you run the query directly against the vicidial_list table and verify it return leads to dial out
ambiorixg12
 
Posts: 448
Joined: Tue Sep 17, 2013 10:35 pm

Re: Due to state of emergency in Florida MySQL script

Postby TwistedFister » Fri Sep 06, 2019 12:10 pm

post just as is in filters

left(phone_number,3) <> '239' AND
left(phone_number,3) <> '305' AND
left(phone_number,3) <> '321' AND
left(phone_number,3) <> '352' AND
left(phone_number,3) <> '386' AND
left(phone_number,3) <> '407' AND
left(phone_number,3) <> '561' AND
left(phone_number,3) <> '727' AND
left(phone_number,3) <> '754' AND
left(phone_number,3) <> '772' AND
left(phone_number,3) <> '786' AND
left(phone_number,3) <> '813' AND
left(phone_number,3) <> '850' AND
left(phone_number,3) <> '863' AND
left(phone_number,3) <> '904' AND
left(phone_number,3) <> '941' AND
left(phone_number,3) <> '954'

name it florida or whatever ... save then under campaign setting go to filter and select whatever you named it.
TwistedFister
 
Posts: 78
Joined: Tue Jul 26, 2016 11:50 am

Re: Due to state of emergency in Florida MySQL script

Postby williamconley » Fri Sep 06, 2019 1:10 pm

ambiorixg12 wrote:I would suggest you run the query directly against the vicidial_list table and verify it return leads to dial out


Agreed 8-)

plus: use "and" not "&"
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!)


Return to Support

Who is online

Users browsing this forum: Google [Bot] and 107 guests