Page 1 of 1

Leads not uploaded into the database

PostPosted: Mon May 17, 2010 9:44 am
by siazyl
Hello everyone,

I am new in using VicidialNOW. First of all, let me thank the developer of Vicidial in creating a great software.

I am having a couple of issues though when uploading the leads to the list. My version of Vicidial is:

VERSION: 2.0.5-174
BUILD: 90522-0506

I have tried using the Super Lead Loader/web interface in loading the leads. I can see that it reports the number of leads as GOOD. All 31k rows. But, I am unable to see it under the LISTS or the CAMPAIGN section I have assigned it to.

I have also tried using the command line.

===================

[root@vici extras]# /usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl --forcelistid=110 –forcephonecode=1

----- FORCE LISTID OVERRIDE: 110 -----


-- VICIDIAL_IN_new_leads_file.pl --

This program is designed to take a tab delimited file and import it into the VICIDIAL system.

testMULTI_VICIDIAL_lead_file.txt 2018
testMULTI_VICIDIAL_lead_file.txt 2018

DBD::mysql::db do failed: Column count doesn't match value count at row 1 at /usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl line 937, <infile> line 10.
DBD::mysql::db do failed: Column count doesn't match value count at row 1 at /usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl line 983, <infile> line 14.


TOTALS FOR testMULTI_VICIDIAL_lead_file.txt:
Lines in lead file: 14
INSERTED: 14
INSERT STATEMENTS: 2
ERROR: 0
MULTI-ALT-PHONE: 0
script execution time in seconds: 2 minutes: 0.0333333333333333

====================

Still, no leads are inserted in the database.

If you need additional information regarding the server setup, please let me know. I would really love to get this resolved soon.

Thank you in advance for any help. =)

PostPosted: Tue May 18, 2010 2:41 am
by gardo
It would help if you can post a screenshot of how you load your leads via the web based super leads loader. Most of the time, people forget to add an entry in the list id override box for the leads to go into.

PostPosted: Tue May 25, 2010 12:48 am
by siazyl
hi gardo. I think the upgrade of the vicidial software caused the issue. I have reinstalled the server, and everything is working okay now.