Large lead import via VICIDIAL_IN_new_leads_file.pl

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Large lead import via VICIDIAL_IN_new_leads_file.pl

Postby Cyberwolf2 » Wed May 12, 2021 3:28 am

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"
Install by vicifast script by callcentertech.net, maintained by me
AlmaLinux8
Asterisk 16.17.0-vici
astGUIclient: VERSION: 2.14-878a, BUILD: 230312-2212
IONOS Dedicated AR6-32, 6 core 32GBram AMD
VOIP Provider: Skyetel
NGINX
Cyberwolf2
 
Posts: 16
Joined: Mon May 10, 2021 7:59 pm

Re: Large lead import via VICIDIAL_IN_new_leads_file.pl

Postby mflorell » Wed May 12, 2021 6:27 am

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.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Large lead import via VICIDIAL_IN_new_leads_file.pl

Postby GenXOutsourcing » Thu May 13, 2021 4:15 pm

Why not just put into Excel and load it?

In the lead loader you can use Custom Layout to map the fields
Built too many to count, Centos7 Scratch install, Opensuse Scratch install, Centos8 Scratch install, etc.
Dual 8 core/32gb RAM/500gb SSDs
SVN Version:3440
VERSION: 2.14-812a
genxoutsourcing.com
GenXOutsourcing
 
Posts: 120
Joined: Sun Sep 22, 2019 12:53 am


Return to Support

Who is online

Users browsing this forum: Google [Bot], Majestic-12 [Bot] and 103 guests

cron