Autoloader for Vici: SQLServer -> MySQL

[UltimateCollector]

Hello all:

I'm running vicidialnow-ce-1.2_final on a Dell Poweredge 2650 which pushes call through my Trixbox 2.6.

I'd like to automate the "lead loading" portion of Vici so that I can push leads from my SQL Server 2005 database into the ViciDial system so I'm not stuck with doing it manually everyday.

What table(s) need to be populated with the lead data? Are there any caveots against pushing the leads in through the backend?

[heinz]

Hi,
the only table you have to worry about is vicidial_list.
You can directly upload into the database - the only thing you need is a corresponding entry in vicidial_lists for vicidial_list.list_id. Make sure you don't try to overwrite vicidial_list.lead_id - it's unique and will cause trouble with duplicate entries.

Thanks,
heinz

[UltimateCollector]

One thing that occured to me this morning is that MS-SQL will need to check for duplicates (among other things) within the file.

Thanks again!

UC