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
DNC buld List
Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N
4 posts
• Page 1 of 1
DNC buld List
by ruben23 » Sun Sep 07, 2014 10:51 pm
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...
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
by 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.
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
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
by 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..?
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...
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
by 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
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
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
4 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 134 guests