CLI leads loader and custom fields

All installation and configuration problems and questions

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

CLI leads loader and custom fields

Postby Vince-0 » Mon Feb 11, 2013 8:32 am

Hi,

Is it possible to use the CLI leads loader script to import a leads file that contains custom fields?
I've specified the exact list custom field names as in the leads file before the import. I'm trying to use the stdrankowner format so as to include multiple phone numbers.

Command:
VICIDIAL_IN_new_leads_file.pl --format=stdrankowner --debug

The field headers in a tab-delimited text file:

Code: Select all
vendor_lead_code source_id list_id phone_code phone_number title first_name middle last_name company_name address1 address2 address3 city   state   province postal_code country gender date_of_birth alt_phone email fax security_phrase comment   called_count status entry_date rank owner multi-alt-entries right_contact spoken_to money_value


The field data, once imported, look as though it has shifted one to the right and left the first data row out.

Is this at all possible to import with custom fields or should I start writing a custom script?

Thanks!
--
Vin

--
Version: 2.6-393a BUILD: 130124-172
Load: 0.03 0.06 0.02
Servers: DB: CentOS 6.2, Web+Dialers OpenSuse Vicibox 3.1.15
HW: DB: Dual Xeon Hex E5630@ .53GHz 32GB RAM, Dialerx4: Xeon Quad X5355@2.66GHz 8GB RAM, Web: Dual Xeon Quad E5420@2.50GHz 16GB RAM
Codecs: ulaw on soft-phones / g729 to carrier.
VoIP, no direct PSTN
Vince-0
 
Posts: 272
Joined: Fri Mar 02, 2012 4:27 pm
Location: South Africa

Re: CLI leads loader and custom fields

Postby williamconley » Mon Feb 11, 2013 3:22 pm

You should consider that there is a problem with your lead format. Try CSV, also try a single lead to see if you can get the format correct.

Also have a look at the other perl scripts already in /usr/share/astguiclient

Execute with --help to get documentation (and/or nano the file to see if there is deeper information available).

Also have a look at the non-agent.api to see if the "one at a time" importer will suit your needs (slower, but if it's automated speed is not that much of a big deal, right?)
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20258
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)


Return to Support

Who is online

Users browsing this forum: Bing [Bot], Google [Bot] and 147 guests