Leads not uploaded into the database
Posted: Mon May 17, 2010 9:44 am
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. =)
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. =)