DNC buld List

Any and all non-support discussions

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

DNC buld List

Postby ruben23 » Sun Sep 07, 2014 10:51 pm

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
SkypeID: rlacumba
IBM x3200 Dual Core 2.4 Ghz.
4GB Ram
VERSION: 2.4-311a
BUILD: 110514-1351
© 2011 ViciDial Group
Asterisk 1.4.27-vici
Another VICI_day, same trunK, same Channel-->Transcode...
ruben23
 
Posts: 1161
Joined: Thu Jul 31, 2008 10:35 am
Location: Davao City, Philippines

Re: DNC buld List

Postby DomeDan » Mon Sep 08, 2014 3:00 am

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.
Vicidial Partner. Region: Sweden/Norway.
Does Vicidial installation, configuration, customization, add-ons, CRM implementation, support, upgrading, network-related, pentesting etc. Remote and onsite assistance.
Email: domedan (at) gmail.com
DomeDan
 
Posts: 1226
Joined: Tue Jan 04, 2011 9:17 am
Location: Sweden

Re: DNC buld List

Postby ruben23 » Mon Sep 08, 2014 6:02 pm

@DomeDan

any idea how to create run query system for duplicates, and i should put this on my cronjobs right..?
SkypeID: rlacumba
IBM x3200 Dual Core 2.4 Ghz.
4GB Ram
VERSION: 2.4-311a
BUILD: 110514-1351
© 2011 ViciDial Group
Asterisk 1.4.27-vici
Another VICI_day, same trunK, same Channel-->Transcode...
ruben23
 
Posts: 1161
Joined: Thu Jul 31, 2008 10:35 am
Location: Davao City, Philippines

Re: DNC buld List

Postby DomeDan » Tue Sep 09, 2014 3:56 am

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
Vicidial Partner. Region: Sweden/Norway.
Does Vicidial installation, configuration, customization, add-ons, CRM implementation, support, upgrading, network-related, pentesting etc. Remote and onsite assistance.
Email: domedan (at) gmail.com
DomeDan
 
Posts: 1226
Joined: Tue Jan 04, 2011 9:17 am
Location: Sweden


Return to General Discussion

Who is online

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