filter by area code

[Op3r]

We were trying to do this one. i admit im kind of a cluebie on Mysql but does anyone knows if this will work?

char_length(phone_number,3) Not IN ('239')

basically we want to dial any area code which is not 239.

any idea how to go about this? any guidelines on creating a filter that can be understand by a cluebie like me?

[okli]

phone_number NOT LIKE '239%'

% stands for any number(s)/character(s).

If you need different filter, this also may help- underscore (_) stands for one number/character.

So if you need to select X239XXXXX... you would use _239%.

http://dev.mysql.com/doc/refman/5.0/en/ ... tions.html

[lmora]

Create a filter with the following:

( left(phone_number,3) <> '239')

Rgds

[lmora]

Other way to do it would be using regular expressions.

add this to your filter:

phone_number not regexp '^[0-9]{2}239[0-9]{7}$'

You might need to change the number of digits that go before and after your area code . To give you an idea let me explain it applied to my case.
My phone number is a string of 12 characters made up as follows:
1 to 2. 01 fixed string (2)
3 to 5. area code (3)
6 to 12. remaining digits (7)

I hope it would help.

[gmcust3]

I tried using

(phone_number NOT LIKE "817%")

But /AST_timeonVDAD.php still shows that 817 is getting dialed !!

Filter comes into effect after RESETTING leads ?

[mflorell]

Please post results of this command after clearing your hopper:

/usr/share/astguiclient/AST_VDhopper.pl --debugX

[gmcust3]

Sorry but how to "clearing your hopper" ??

And after running

/usr/share/astguiclient/AST_VDhopper.pl -debugX

Where will I get the output results ??

[lmora]

It is not needed to reset the list since filter takes effect immediately.

I would recommend you to test your filter before applying it in production.
You can test the filter in the screen for filter creation.

[gmcust3]

Show Dialable Leads Count -

CAMPAIGN: Test
LISTS: '900017'
STATUSES: NEW AA A CS PNA NH N B XFER DROP -
FILTER: 817
CALL TIME: 24hours

|| This campaign has 469 leads to be dialed in those lists

[okli]

Sorry but how to "clearing your hopper" ??

There is a button on the campaign settings screen- Force Reset of Hopper:-->set to Y-->SUBMIT

[gmcust3]

And after running

/usr/share/astguiclient/AST_VDhopper.pl -debugX

Where will I get the output results ??

[lmora]

And after running

/usr/share/astguiclient/AST_VDhopper.pl -debugX

Where will I get the output results ??

Open a SSH session to your ViciDial server as root user then enter the command and the result will be displayed on the screen.

[gmcust3]

Tried and it runs me Nothing.

I thought it displays the output somewhere else.

[lmora]

mm, then it goes beyond my knowledge since I've used ViciDial for the last 5 months.

[billybobxm]

I would recommend using this:

left(phone_number,3) <> '239'

This is what I use for my filters here is an example of a filter I used for Labor Day.

left(phone_number,3) <> '205' AND
left(phone_number,3) <> '251' AND
left(phone_number,3) <> '256' AND
left(phone_number,3) <> '334' AND
left(phone_number,3) <> '225' AND
left(phone_number,3) <> '318' AND
left(phone_number,3) <> '337' AND
left(phone_number,3) <> '504' AND
left(phone_number,3) <> '985' AND
left(phone_number,3) <> '228' AND
left(phone_number,3) <> '601' AND
left(phone_number,3) <> '662' AND
left(phone_number,3) <> '769' AND
left(phone_number,3) <> '385' AND
left(phone_number,3) <> '435' AND
left(phone_number,3) <> '801' AND
left(phone_number,3) <> '401'