Migrating leads and disposition status from OSDIAL

[shree249]

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

[okli]

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

[mflorell]

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.