Vicidial loosing leads

[albokos]

Hi everyone!!

So i'm back with an other question (sorry). i've had some problems loading leads in vicidial. To be clear when i try to load a 1000 leads list i find that only 500 are effectivly load in rthe campaign.

Sometimes the loader exports the entire list, but when associating with the campaign some leqds are lost. What is the auestion and what can i do to fix this issue

Thanks!!!

[mflorell]

How exactly are you loading leads?

Have you tried tab or pipe delimited text files?

[albokos]

I'm using the procedure given in the management manual. i'm using the load new leads button on the web GUI and import an xls list from the disk. then i add a new list and associate it with a campaign. all theses are done usin the WEB GUI

[okli]

Have you tries regular csv file, not excel one?

I've been using comma separated files since vici 2.0.3 and never had a single issue with imports.

[albokos]

i've never tried with a csv i will and post the feedback. thanks!!

[albokos]

I'v tried using csv today, but i ran into an other issue, no list can be add no more. when i upload the csv file everything seems going well and i get the Done message.
but when i add a the corresponding list into vicidial i display 0 leads in the list and the list is not add to the campaign.

I've tried using xls file thinking it was due to the format but no way, same thing happens

[albokos]

This is my AST_VDhopper.pl --debugX output

Code: Select all

 NO SHUFFLE-NEW-LEADS INTO HOPPER DEFINED FOR LEAD ORDER
CAMPAIGN STATS: 1|UPDATE vicidial_campaign_stats SET dialable_leads='70' where campaign_id='CAMPAC68';|
     Getting Leads to add to hopper
     |SELECT lead_id FROM vicidial_hopper where campaign_id='CAMPAC68';|
     NO RECYCLE-LEADS INTO HOPPER DEFINED
     lead call order:      order by lead_id asc
     |SELECT lead_id,list_id,gmt_offset_now,phone_number,state,status,modify_date,user FROM vicidial_list where called_since_last_reset='N' and status IN('A','NA','ABS','DROP') and list_id IN('683','682','681') and lead_id NOT IN('444691','444639','444682','444777','444783','444784','444642','444637','444779','444773','444774','444791','444805','444798','444794','444790','444789','444738','444736','444712','444714','444718','444676','444631','444770','444769','444764','444763','444761','444748','444733','444722','444720','444710','444709','444693','444696','444652','444640','444683','444685','444680','444679','444654','444659','444660','444662','444663','444664','444666','444667','444672','444643','444647','444674','444808','444801','444795','444793','444759','444758','444754','444705','444699','444697','444622','444623','444627','444629','444636','0') and ((gmt_offset_now IN('13.00','12.75','12.50','12.25','12.00','11.75','11.50','11.25','11.00','10.75','10.50','10.25','10.00','9.75','9.50','9.25','9.00','8.75','8.50','8.25','8.00','7.75','7.50','7.25','7.00','6.75','6.50','6.25','6.00','5.75','5.50','5.25','5.00','4.75','4.50','4.25','4.00','3.75','3.50','3.25','3.00','2.75','2.50','2.25','2.00','1.75','1.50','1.25','1.00','0.75','0.50','0.25','0.00','-0.25','-0.50','-0.75','-1.00','-1.25','-1.50','-1.75','-2.00','-2.25','-2.50','-2.75','-3.00','-3.25','-3.50','-3.75','-4.00','-4.25','-4.50','-4.75','-5.00','-5.25','-5.50','-5.75','-6.00','-6.25','-6.50','-6.75','-7.00','-7.25','-7.50','-7.75','-8.00','-8.25','-8.50','-8.75','-9.00','-9.25','-9.50','-9.75','-10.00','-10.25','-10.50','-10.75','-11.00','-11.25','-11.50','-11.75','-12.00','-12.25','-12.50','-12.75','99') ) )   order by lead_id asc limit 100;|
     Adding to hopper:     0
     DONE with this campaign
DONE. Script execution time in seconds: 0


[williamconley]

switch to tab delimited. the fields and the exact order are displayed if you push the "?" help button while loading leads.

the required fields are phone_code, phone_number and country. the rest can just be "tab" which makes them blank.

do it with a test list with 5 or 10 of the same number in them, then convert your excel list to this field order and format and it will work.

any time you have a problem uploading a list, always switch to tab delimited. after that you can go back to the other methods at will, but tab delimited always works for problems lists.

[albokos]

Thanks william. Your advices are always usefull.

See you!!!

[williamconley]

i also have a cute little utility program (windows executable, installs in about 4 seconds) that will take a "purely #s" list and convert it (instantly) to a "vici-ready" list. For those who purchase lists of phone numbers with NO other information (or export from other software and really don't need to bring the other information along for the ride ...). It will convert 120k list in about 30 seconds to a "vici-ready" tab-delimited list ready for the "upload leads".