DNC list bulk upload

[raloheni]

hi

is there any way to upload a bulk DNC list numbers in vicidial

like i have 30crores of numbers.

i hope via command line in linux it can be uploaded , can any one point me in which table i have to upload

in vicidial gui how much number can i paste to upload in the DNC list.

[mflorell]

How many is "30crores"?

[raloheni]

sorry its around 3crores
i am running the vicidial as domestic call using pri connection.

receltly indian GOVT made strict on DNC , and they provided around 3crores
list nuumber and it keep on increase everyday , so we need to update in the dnc list

[mflorell]

Keep in mind that I am not Indian, have never been to India and, like most of those on this forum, am not familiar with regional Indian terms.

I googled it and came up with this:
http://en.wikipedia.org/wiki/Crore

If this is accurate, you want to load 30,000,000+ numbers into the DNC table correct?

I would not recommend doing that since it will greatly increase the load on your system and could even cripple it if you do not have adequate hardware.

In these cases I usually recommend pre-filtering your leads on a different server before loading them into Vicidial.

[boybawang]

you can create a table within the database server and you can store those dnc numbers then after you upload a list which goes in vicidial_list table you will do a sql statement that compares and deletes the numbers on the vicidial_list table if it matches the ones on the dnc table you created


another option would be to have another server, upload the dncs, upload your new leads and and have it checked for dnc numbers then download it from that server and re upload it to your vicidial server