get_switch_codes.pl

[gmcust3]

I have downloaded a file from Mantis.

get_switch_codes.pl

Now, I want to run a query

update vicidial_list set status='INVAL' where left(phone_number,6) not in ( select npanxx from nanpa_codes where ocn!='');

After my lead has been loaded.

How to do that ?

[williamconley]

1 Mysql command line version

Code: Select all

mysql -pPASSWORD
use asterisk;
SQL STATEMENT(S) TO EXECUTE
exit

2 phpmyadmin

3 webmin

[gmcust3]

How to use it with new_listloader_superL.php ?

[williamconley]

don't. run it separately (after).

[gmcust3]

Any reason for DONT ?

[williamconley]

if you know how, do. if you don't, do it separately. it's not like there's a requirement of some sort.

[gmcust3]

Trying this :

CREATE TRIGGER List_Invalid_Check
AFTER insert ON vicidial_list
FOR EACH ROW
BEGIN
update vicidial_list set status='INVAL' where left(phone_number,6) not in ( select npanxx from nanpa_codes where ocn!='');
END