Loading new leads with existing call status

[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

[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.

[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

[Fares MEHENI]

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