Loading new leads with existing call status
Posted:
Mon Jul 25, 2016 8:51 pmby MrMaddox
Hi team,
(Running Vicibox 7.0.3-160505, Asterix 11.22.0-vici)
Little new to uploading leads to a fresh setup, so just need some advice!
Loading new leads into vicidial, using custom layout (as it seems to work for the most part). Only issue is I am not sure how to specify vicidial to import the call statuses of the leads (NI, NP, VDAD etc).
Any thoughts? Is there an easy way to specify vicidial to check for this? Otherwise they are all uploaded and imported as NEW leads. Thanks in advance!
Elliot
Re: Loading new leads with existing call status
Posted:
Mon Jul 25, 2016 11:59 pmby lasthuman
hello,
you have 2 options.
1. you can export the table from your old server and get on new one.
2. if you only want move some lists. you can make a csv file with the lists and then import on new database, using a query. if you have some of experience with mysql then will be enough.
Re: Loading new leads with existing call status
Posted:
Tue Jul 26, 2016 8:07 amby mflorell
You can use the CLI lead loader to load leads with a pre-defined status, just use the "standard" format:
/usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl --help
standard:
vendor_lead_code|source_id|list_id|phone_code|phone_number|title|first_name|middle|last_name|address1|address2|address3|city|state|province|postal_code|country|gender|date_of_birth|alt_phone|email|security_phrase|COMMENTS|called_count|status|entry_date|multi-alt-entries
3857822|31022|105|01144|1625551212|MRS|B||BURTON|249 MUNDON ROAD|MALDON|ESSEX||||CM9 6PW|UK||||||COMMENTS|2|B|2007-08-09 00:00:00|7275551212_1_work!7275551213_61_sister house!7275551214_44_neighbor
Re: Loading new leads with existing call status
Posted:
Fri Oct 02, 2020 8:10 amby Fares MEHENI
mflorell wrote:You can use the CLI lead loader to load leads with a pre-defined status, just use the "standard" format:
/usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl --help
standard:
vendor_lead_code|source_id|list_id|phone_code|phone_number|title|first_name|middle|last_name|address1|address2|address3|city|state|province|postal_code|country|gender|date_of_birth|alt_phone|email|security_phrase|COMMENTS|called_count|status|entry_date|multi-alt-entries
3857822|31022|105|01144|1625551212|MRS|B||BURTON|249 MUNDON ROAD|MALDON|ESSEX||||CM9 6PW|UK||||||COMMENTS|2|B|2007-08-09 00:00:00|7275551212_1_work!7275551213_61_sister house!7275551214_44_neighbor
Hi,
I tried this in the correct format but the leads still show as new when loaded