Importing DNC list?

All installation and configuration problems and questions

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

Importing DNC list?

Postby bryceowen » Fri Aug 01, 2008 8:25 am

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?
bryceowen
 
Posts: 39
Joined: Fri Aug 01, 2008 8:12 am
Location: Jacksonville, FL

Postby ermali » Fri Aug 01, 2008 8:28 am

For this kind off work i use EMS Sql manager 2007. You can import a list as a csv file without any problem.
ermali
 
Posts: 16
Joined: Fri Aug 01, 2008 7:18 am

Postby bryceowen » Fri Aug 01, 2008 8:31 am

So there's no way to do it through the Vicidial interface?
bryceowen
 
Posts: 39
Joined: Fri Aug 01, 2008 8:12 am
Location: Jacksonville, FL

Postby mflorell » Fri Aug 01, 2008 8:41 am

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.
mflorell
Site Admin
 
Posts: 18387
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby bryceowen » Fri Aug 01, 2008 9:24 am

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.
Last edited by bryceowen on Fri Aug 01, 2008 11:44 am, edited 1 time in total.
bryceowen
 
Posts: 39
Joined: Fri Aug 01, 2008 8:12 am
Location: Jacksonville, FL

Postby mflorell » Fri Aug 01, 2008 11:35 am

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.
mflorell
Site Admin
 
Posts: 18387
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida


Return to Support

Who is online

Users browsing this forum: No registered users and 120 guests