vicidial.org

Hello,

we have a client who is currently using OSDial but wants to use VICIdial instead. He wants to migrate the leads and disposition status from OSdial to VICIdial. Is there any way where I can insert the leads into VICIdial with user supplied disposition status i.e disp status set to something else other than "NEW".

I could think of inserting all the leads as "NEW" and then writing a script to update the disposition status for each number in vicidial_list table. But I am hoping for something much simpler than this.

Thanks

Why don't you export them from OSdial database as SQL statements and import them into Vicidial database, correcting the statements if necessary.

How many leads are there?

What does the osdial_list schema look like?
(describe osdial_list;)

If you can connect to the OSDial system with MySQL then you can also do

SELECT * from osdial_list INTO OUTFILE 'list_export.txt';
(you may need to change the '*' to an ordered list of fields to match vicidial)

Which will just give you a dump that you can use to import into vicidial_list:

LOAD DATA INFILE 'list_export.txt' INTO TABLE vicidial_list;


It might take some tweaking of those statements, but we have done these kind of data moves successfully before using the above method.