Page 1 of 1

one click adding of multiple DID

PostPosted: Tue Apr 19, 2011 8:26 pm
by boybawang
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

PostPosted: Wed Apr 20, 2011 9:00 am
by williamconley
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 ...

PostPosted: Wed Apr 20, 2011 8:05 pm
by boybawang
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

PostPosted: Wed Apr 20, 2011 8:13 pm
by williamconley
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