one click adding of multiple DID

Any and all non-support discussions

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

one click adding of multiple DID

Postby boybawang » Tue Apr 19, 2011 8:26 pm

hi guys, is it advisable to do a direct sql injection script to add a couple of DID's to the vicidial_inbound_dids table with specific settings? anyone tried this?

love you all
Vicidial Installation + Configuration + Support + Custom Development
Download my ebook on installing vicidial for free http://download.vicidial.com/ubuntu/VIC ... 100331.pdf
skype: deodax.cordova@gmail.com
m: +639172063730
boybawang
 
Posts: 989
Joined: Sat Nov 14, 2009 1:18 pm
Location: Dumaguete City, Negros Oriental, Philippines

Postby williamconley » Wed Apr 20, 2011 9:00 am

As long as you duplicate an existing entry completely and don't miss any fields it should work fine. we've done it on several occasions. be sure to follow all the rules ...
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20258
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Postby boybawang » Wed Apr 20, 2011 8:05 pm

So far I have tried a basic CSV dump of just the DID number and DID description to the table and it worked fine, when you click on the added DID from the web interface its assigned default settings which goes to an EXTEN that has no service message on it
Vicidial Installation + Configuration + Support + Custom Development
Download my ebook on installing vicidial for free http://download.vicidial.com/ubuntu/VIC ... 100331.pdf
skype: deodax.cordova@gmail.com
m: +639172063730
boybawang
 
Posts: 989
Joined: Sat Nov 14, 2009 1:18 pm
Location: Dumaguete City, Negros Oriental, Philippines

Postby williamconley » Wed Apr 20, 2011 8:13 pm

create one the exact way you'd like it to be, and then open it in phpmyadmin and "dump it" to your browser (or just use mysqldump). then it will provide you with the code to re-create each record.

then you can re-create a record with slight changes quite easily. and use that mysql code in php or perl
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20258
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)


Return to General Discussion

Who is online

Users browsing this forum: No registered users and 57 guests