Page 1 of 1

CLI leads loader and custom fields

PostPosted: Mon Feb 11, 2013 8:32 am
by Vince-0
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

Re: CLI leads loader and custom fields

PostPosted: Mon Feb 11, 2013 3:22 pm
by williamconley
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?)