Large lead import via VICIDIAL_IN_new_leads_file.pl

[Cyberwolf2]

I have a large 10K+ records .csv file of leads to import. They look like this:

Code: Select all

Phone,First Name,Last Name,Sex,City,State
19791231234,Jane,Doe,female,Bay City, Texas


Since the format is not standard I created a template from the web interface to map the data.

Can I use the custom template with the VICIDIAL_IN_new_leads_file.pl ?

Or do I have to write a custom program to rearrange the data file and have it match say "minicsv" format ??

Code: Select all

minicsv:
address1,city,name,phone_number,state,postal_code
"105 Fifth St","Steinhatchee","Frank Smith","3525556601","FL","32359"


[mflorell]

The web lead-loader templates won't work with the 'VICIDIAL_IN_new_leads_file.pl' script. you would have to either modify the data to fit one of the existing formats, or modify one of the existing formats in that script to fit your data.

[GenXOutsourcing]

Why not just put into Excel and load it?

In the lead loader you can use Custom Layout to map the fields