vicidial.org

Clustered:
-2 Asterisk
-1 DB/Wen Server
Asterisk 1.8.vici
Dahdi current
SVN trunk
Ubuntu 10.04 server LTS



Hi guys any idea where to upload bulk DNC list directly to my Database rather than adding them on the DNC -add/delete (This comes with like 500K-800K).Which tables should this be added.Thanks a lot

This topic has been up on the forum before a few times:
viewtopic.php?t=21592
viewtopic.php?t=6284
viewtopic.php?t=21307

I recommend you upload those phone numbers to a separate table in the database and just run a query to remove those who have matching number in the vicidial_list.

@DomeDan

any idea how to create run query system for duplicates, and i should put this on my cronjobs right..?

Use google to find out how to import the list of phone numbers to the database (mysql import text file)

then use some query to update vicidial_list, for example:
UPDATE vicidial_list SET status = 'RUBEN' where phone_number in (select phone_number from your_imported_list_of_phone_numbers)

remember, always make a backup before running any query