Page 1 of 1

Large lead import via VICIDIAL_IN_new_leads_file.pl

PostPosted: Wed May 12, 2021 3:28 am
by 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"

Re: Large lead import via VICIDIAL_IN_new_leads_file.pl

PostPosted: Wed May 12, 2021 6:27 am
by 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.

Re: Large lead import via VICIDIAL_IN_new_leads_file.pl

PostPosted: Thu May 13, 2021 4:15 pm
by GenXOutsourcing
Why not just put into Excel and load it?

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