Page 1 of 1

Importing DNC list?

PostPosted: Fri Aug 01, 2008 8:25 am
by bryceowen
We have a rather lengthy internal DNC list and was wondering if there's any way to import the list as a whole to the Vicidial internal DNC without having to enter each number manually. If not, would it be possible to enter it as a separate list and add a filter that compares numbers being dialed against it?

PostPosted: Fri Aug 01, 2008 8:28 am
by ermali
For this kind off work i use EMS Sql manager 2007. You can import a list as a csv file without any problem.

PostPosted: Fri Aug 01, 2008 8:31 am
by bryceowen
So there's no way to do it through the Vicidial interface?

PostPosted: Fri Aug 01, 2008 8:41 am
by mflorell
How large is your DNC list?

In the SVN trunk version you can add hundreds of DNC phone numbers at once throught he web interface, but if you need to add thousands you really should use something else like PHPMyAdmin or another utility.

PostPosted: Fri Aug 01, 2008 9:24 am
by bryceowen
I'll be up front here, I was kinda thrust into the position of "make this happen" because I've done work on my company's intranet site using ASP (which I know isn't like PHP). I was hoping to find some kind of tutorial or maybe a better guide than the ones provided with the Vicidial software.

The DNC list I have is roughly 500 numbers long. If you can point me towards a possible solution, I'd be happy to investigate it myself, but I am limited to the Vicidial web interface.

PostPosted: Fri Aug 01, 2008 11:35 am
by mflorell
500 numbers isn't many at all, and with the SVN trunk version you could paste all of those into the DNC add screen in admin.php. But if you are using the 2.0.4 release you can only add one DNC number at a time.

Other than this, you should be able to use a tool like PHPMyAdmin, or setup some kind of ODBC connection to interact directly with the database.