losing 200-300 leads when loading new leads

[WP702]

I’ve noticed this allot lately. When I add new leads the leads that say are being added and the actual leads added are 200-300 less.
EX:
I’m uploading 10k leads. I weed out all dupes for the new leads against the campaign and end up with approx 9700 leads I then go to the "All lists view" click on my list ID (400) and it says I have 9505 leads.

Where are my leads going? Is this from the DNC list? If the missing leads are DNC leads wouldn't they be weeded out when I de-dupe them from the other leads in the campaign?

Any help is appreciated THANKS!

[williamconley]

did you verify that all 10k leads had id 400 on them? or use the override so they would all go to id 400 upon import?

you could import them into a mysql table and compare them to the leads that were imported successfully to find the "missing" leads (would be both the dupes and the "missing") and this may help you at least identify which ones are missing and import them again and see what happens to them this time.

also, please read the stickies and post your configuration and versions. i am unaware of lead loading bugs in specific versions, but others (like those actually working for eflo/vicidial!) may be aware that all you need to do is upgrade. make it part of your "signature".

[saif.rahman]

you can use an alternative way for uploading leads that is by using the command line script .

VICIDIAL_IN_new_leads_file.pl

that will use a tab-deli mated text file. Put that file containing the leads in /usr/share/astguiclient/LEADS_IN/ and then run the above script with --debug option.

[mflorell]

There's also a minicsv option for loading files with that script.

Run it with the --help flag for more info.

[tgalan]

I think I have the same problem,

ex, I'm uploading a list on the admin.php of vicidial, the results on the webpage are
Done: Good 1584 bad 243 total 1827

but when I go to show list only says leads count 240.

I'm using the 1.2 version of vicidialnow astguiclient is the 2.0.5 on a single server, Intel Core 2 Duo 1.8, 2gbs Ram, 250gb HD...

[williamconley]

did you override the lead_id during import to be sure they all went into the same list?

also: it's best if you give us the version NUMBER of Vicidial (and a sep number for vicidialNOW's version, they are not the same) as opposed to "last" which will quickly lose it's meaning. Remember that these comments will still be here years from now.


Thanks.

[tgalan]

Yes i've done this a couple of times and the same results....

[williamconley]

have you checked in mysql to see where the leads went (or if they were imported at all)?

[tgalan]

how can I check that?

[williamconley]

check the number of records in the leads table with phpmyadmin or from the console by using the mysql command line.

do you have phpmyadmin or webmin or any other interesting tools?

if not, you can use the console (or PuTTY console) to check the number of leads:


Step one: how many leads REALLY imported?

mysql -p

mysql> use asterisk;
mysql> select count(*) from vicidial_list;

do this before and after the import (yes you can just do the "select" line before and after, it does not have to be exited)

[tgalan]

jajajaj

Thanks, I see the results... the problem was I mistake on the CSV file, I change the format of the file and it solve the problems....

Exactly this text definition part...

EX:

"Alan's Burguers","Alan Smith","1234567890"
to
'Alans Burguers' 'Alan Smith' '1234567890'

[williamconley]

and that is why i use tab delimited only. lol

[tgalan]

jajajaj

Thanks, I see the results... the problem was I mistake on the CSV file, I change the format of the file and it solve the problems....

Exactly this text definition part...

EX:

"Alan's Burguers","Alan Smith","1234567890"
to
'Alans Burguers' 'Alan Smith' '1234567890'

But that was with that file only, then I try another csv file and work perfetcly,

Thanks a lot.....

[darkwu33]

i had the same problem with a live campaign I didn't realize that i was losing 100-150 leads, i change from CSV to tab delimiter and the problem gone!!

[williamconley]

a stray Robert's (note the apostrophe) or other funky character in a delimited file other than "tab" can wreak havoc. Especially since it doesn't happen very often, and it seems almost random when it does. Then you find the exact record it stopped on and find that the address contains "Next to McDonald's" LOL

of course, you CAN build a routine to properly strip out invalid characters. But i've never (knock on wood) bumped into a tab in a random location. lol