Super lead loader problem

[aster1]

I made some lead list in excel as well as csv format .. tried super lead loader on both files .. It detects file type and even show good leads

--- FORCE LISTID OVERRIDE: 101 -----
Processing Excel file...

Done GOOD: 39 BAD: 0 TOTAL: 39

but leads arent there in database ( vicidial_list table ) . I get no errors at all but still it doesnt upload to database . php upload is on , file limit is huge , vicidial directory chmoded to 777

Btw what format does basic lead loader required . I saw a tygraleadloader or something in wiki but link is broken .. can anyone upload that program somewhere . Thx .

[aster1]

same file saved as tab delimited format and tried basic loader error is

Processing tab-delimited file... (22|0)

LIST ID OVERRIDE FOR THIS FILE: 101


record 1 BAD- PHONE: ROW: || DUP:
record 3 BAD- PHONE: ROW: || DUP:
record 5 BAD- PHONE: ROW: || DUP:
record 7 BAD- PHONE: ROW: || DUP:
record 9 BAD- PHONE: ROW: || DUP:
record 11 BAD- PHONE: ROW: || DUP:
record 13 BAD- PHONE: ROW: || DUP:
record 15 BAD- PHONE: ROW: || DUP:
record 17 BAD- PHONE: ROW: || DUP:
record 19 BAD- PHONE: ROW: || DUP:

Done GOOD: 39 BAD: 39 TOTAL: 78
DUPLICATE: 0 POSTAL MATCH: 0


good and bad both 39 .. i have saved them as per manager manual fields but most of unrequired fields are empty .. this certainly can be my list format issue instead of vici ... any example excel file or so ? and do all field really need to be filled ??

[gerski]

you need at least phone number and first name.. and you are ready to go =)

also you can try super list loader and also try to use tab delimited format.

[mflorell]

Try loading the testMULTI_VICIDIAL_lead_file.txt file in the extras directory and see if you load uploading is even working proberly.

[aster1]

sory for delay in reply i was out for few days . i tried performance_test_leads.txt and it showed number of good leads properly even created vicidial temp file in vicidial directoy of 7 mb ( same as uploaded file ) but in mysql table vicidial_list the new leads arent entered ... whee could the problem be ?

[mflorell]

So there are no leads in your vicidial_list table at all?

have you looked at the apache error log?

[mr_mehul_shah]

Pls. post the output of this command. : tail -30 /var/log/httpd/error_log which version of vicidial u r using...

[aster1]

astguiclient version 2.0.2 .. there are 14 leads in vicidial_list table ( scratch install direct insert from mysql) but cant import properly . using centos ..

using basic lead loader and performance_test_leads.txt in extas directory .
httpd log

Code: Select all

[root@localhost vicidial]# tail -30 /var/log/httpd/error_log which version of
==> /var/log/httpd/error_log <==
[Sun Jan 07 23:21:04 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined variable: DBX in /var/www/html/vicidial/listloader.php on line 452, referer: http://192.168.56.129/vicidial/listloader.php
[Sun Jan 07 23:21:04 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined variable: dup_lead in /var/www/html/vicidial/listloader.php on line 251, referer: http://192.168.56.129/vicidial/listloader.php
[Sun Jan 07 23:21:04 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined variable: DBX in /var/www/html/vicidial/listloader.php on line 363, referer: http://192.168.56.129/vicidial/listloader.php
[Sun Jan 07 23:21:04 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined variable: DBX in /var/www/html/vicidial/listloader.php on line 452, referer: http://192.168.56.129/vicidial/listloader.php
[Sun Jan 07 23:21:04 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined variable: dup_lead in /var/www/html/vicidial/listloader.php on line 251, referer: http://192.168.56.129/vicidial/listloader.php
[Sun Jan 07 23:21:04 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined variable: DBX in /var/www/html/vicidial/listloader.php on line 363, referer: http://192.168.56.129/vicidial/listloader.php
[Sun Jan 07 23:21:04 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined variable: DBX in /var/www/html/vicidial/listloader.php on line 452, referer: http://192.168.56.129/vicidial/listloader.php
[Sun Jan 07 23:21:04 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined variable: dup_lead in /var/www/html/vicidial/listloader.php on line 251, referer: http://192.168.56.129/vicidial/listloader.php
[Sun Jan 07 23:21:04 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined variable: DBX in /var/www/html/vicidial/listloader.php on line 363, referer: http://192.168.56.129/vicidial/listloader.php
[Sun Jan 07 23:21:04 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined variable: DBX in /var/www/html/vicidial/listloader.php on line 452, referer: http://192.168.56.129/vicidial/listloader.php
[Sun Jan 07 23:21:04 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined variable: dup_lead in /var/www/html/vicidial/listloader.php on line 251, referer: http://192.168.56.129/vicidial/listloader.php
[Sun Jan 07 23:21:04 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined variable: DBX in /var/www/html/vicidial/listloader.php on line 363, referer: http://192.168.56.129/vicidial/listloader.php
[Sun Jan 07 23:21:04 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined variable: DBX in /var/www/html/vicidial/listloader.php on line 452, referer: http://192.168.56.129/vicidial/listloader.php
[Sun Jan 07 23:21:04 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined variable: dup_lead in /var/www/html/vicidial/listloader.php on line 251, referer: http://192.168.56.129/vicidial/listloader.php
[Sun Jan 07 23:21:04 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined variable: DBX in /var/www/html/vicidial/listloader.php on line 363, referer: http://192.168.56.129/vicidial/listloader.php
[Sun Jan 07 23:21:04 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined variable: DBX in /var/www/html/vicidial/listloader.php on line 452, referer: http://192.168.56.129/vicidial/listloader.php
[Sun Jan 07 23:21:04 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined variable: dup_lead in /var/www/html/vicidial/listloader.php on line 251, referer: http://192.168.56.129/vicidial/listloader.php
[Sun Jan 07 23:21:04 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined variable: DBX in /var/www/html/vicidial/listloader.php on line 363, referer: http://192.168.56.129/vicidial/listloader.php
[Sun Jan 07 23:21:04 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined variable: DBX in /var/www/html/vicidial/listloader.php on line 452, referer: http://192.168.56.129/vicidial/listloader.php
[Sun Jan 07 23:21:04 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined variable: dup_lead in /var/www/html/vicidial/listloader.php on line 251, referer: http://192.168.56.129/vicidial/listloader.php
[Sun Jan 07 23:21:04 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined variable: DBX in /var/www/html/vicidial/listloader.php on line 363, referer: http://192.168.56.129/vicidial/listloader.php
[Sun Jan 07 23:21:04 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined variable: DBX in /var/www/html/vicidial/listloader.php on line 452, referer: http://192.168.56.129/vicidial/listloader.php
[Sun Jan 07 23:21:04 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined variable: dup_lead in /var/www/html/vicidial/listloader.php on line 251, referer: http://192.168.56.129/vicidial/listloader.php
[Sun Jan 07 23:21:04 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined variable: DBX in /var/www/html/vicidial/listloader.php on line 363, referer: http://192.168.56.129/vicidial/listloader.php
[Sun Jan 07 23:21:04 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined variable: DBX in /var/www/html/vicidial/listloader.php on line 452, referer: http://192.168.56.129/vicidial/listloader.php
[Sun Jan 07 23:21:04 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined variable: dup_lead in /var/www/html/vicidial/listloader.php on line 251, referer: http://192.168.56.129/vicidial/listloader.php
[Sun Jan 07 23:21:04 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined variable: DBX in /var/www/html/vicidial/listloader.php on line 363, referer: http://192.168.56.129/vicidial/listloader.php
[Sun Jan 07 23:21:04 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined variable: DBX in /var/www/html/vicidial/listloader.php on line 452, referer: http://192.168.56.129/vicidial/listloader.php
[Sun Jan 07 23:21:04 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined variable: dup_lead in /var/www/html/vicidial/listloader.php on line 251, referer: http://192.168.56.129/vicidial/listloader.php
[Sun Jan 07 23:21:04 2007] [error] [client 192.168.56.1] PHP Fatal error:  Maximum execution time of 30 seconds exceeded in /var/www/html/vicidial/listloader.php on line 335, referer: http://192.168.56.129/vicidial/listloader.php
tail: cannot open `which' for reading: No such file or directory
tail: cannot open `version' for reading: No such file or directory
tail: cannot open `of' for reading: No such file or directory
[root@localhost vicidial]#


[aster1]

here another one gicing good mysql error ( previous huge list has execution time error

DBD::mysql::db do failed: Column count doesn't match value count at row 1 at /var/www/html/vicidial/listloader.pl line 440.
DBD::mysql::db do failed: Column count doesn't match value count at row 1 at /var/www/html/vicidial/listloader.pl line 466.

Code: Select all

[root@localhost vicidial]# tail -30 /var/log/httpd/error_log which version of
==> /var/log/httpd/error_log <==
[Sun Jan 07 23:26:13 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined index:  submit_file in /var/www/html/vicidial/listloader.php on line 35, referer: http://192.168.56.129/vicidial/listloader.php
[Sun Jan 07 23:26:13 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined index:  list_id_override in /var/www/html/vicidial/listloader.php on line 36, referer: http://192.168.56.129/vicidial/listloader.php
[Sun Jan 07 23:26:13 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined index:  submit in /var/www/html/vicidial/listloader.php on line 38, referer: http://192.168.56.129/vicidial/listloader.php
[Sun Jan 07 23:26:13 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined index:  submit in /var/www/html/vicidial/listloader.php on line 38, referer: http://192.168.56.129/vicidial/listloader.php
[Sun Jan 07 23:26:13 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined index:  SUBMIT in /var/www/html/vicidial/listloader.php on line 39, referer: http://192.168.56.129/vicidial/listloader.php
[Sun Jan 07 23:26:13 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined index:  SUBMIT in /var/www/html/vicidial/listloader.php on line 39, referer: http://192.168.56.129/vicidial/listloader.php
[Sun Jan 07 23:26:13 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined variable: server_ip in /var/www/html/vicidial/listloader.php on line 85, referer: http://192.168.56.129/vicidial/listloader.php
[Sun Jan 07 23:26:15 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined index:  submit_file in /var/www/html/vicidial/listloader.php on line 35, referer: http://192.168.56.129/vicidial/listloader.php
[Sun Jan 07 23:26:15 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined index:  list_id_override in /var/www/html/vicidial/listloader.php on line 36, referer: http://192.168.56.129/vicidial/listloader.php
[Sun Jan 07 23:26:15 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined index:  submit in /var/www/html/vicidial/listloader.php on line 38, referer: http://192.168.56.129/vicidial/listloader.php
[Sun Jan 07 23:26:15 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined index:  submit in /var/www/html/vicidial/listloader.php on line 38, referer: http://192.168.56.129/vicidial/listloader.php
[Sun Jan 07 23:26:15 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined index:  SUBMIT in /var/www/html/vicidial/listloader.php on line 39, referer: http://192.168.56.129/vicidial/listloader.php
[Sun Jan 07 23:26:15 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined index:  SUBMIT in /var/www/html/vicidial/listloader.php on line 39, referer: http://192.168.56.129/vicidial/listloader.php
[Sun Jan 07 23:26:15 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined variable: server_ip in /var/www/html/vicidial/listloader.php on line 85, referer: http://192.168.56.129/vicidial/listloader.php
[Sun Jan 07 23:26:17 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined index:  leadfile in /var/www/html/vicidial/new_listloader_superL.php on line 37, referer: http://192.168.56.129/vicidial/listloader.php
[Sun Jan 07 23:26:17 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined index:  leadfile in /var/www/html/vicidial/new_listloader_superL.php on line 38, referer: http://192.168.56.129/vicidial/listloader.php
[Sun Jan 07 23:26:17 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined index:  leadfile in /var/www/html/vicidial/new_listloader_superL.php on line 39, referer: http://192.168.56.129/vicidial/listloader.php
[Sun Jan 07 23:26:17 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined variable: list_id_override in /var/www/html/vicidial/new_listloader_superL.php on line 100, referer: http://192.168.56.129/vicidial/listloader.php
[Sun Jan 07 23:26:17 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined variable: DB in /var/www/html/vicidial/new_listloader_superL.php on line 122, referer: http://192.168.56.129/vicidial/listloader.php
[Sun Jan 07 23:26:17 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined variable: LOGfullname in /var/www/html/vicidial/new_listloader_superL.php on line 158, referer: http://192.168.56.129/vicidial/listloader.php
[Sun Jan 07 23:26:17 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined variable: server_ip in /var/www/html/vicidial/new_listloader_superL.php on line 203, referer: http://192.168.56.129/vicidial/listloader.php
[Sun Jan 07 23:26:17 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined variable: leadfile_name in /var/www/html/vicidial/new_listloader_superL.php on line 290, referer: http://192.168.56.129/vicidial/listloader.php
[Sun Jan 07 23:26:17 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined variable: file_layout in /var/www/html/vicidial/new_listloader_superL.php on line 291, referer: http://192.168.56.129/vicidial/listloader.php
[Sun Jan 07 23:26:17 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined variable: OK_to_process in /var/www/html/vicidial/new_listloader_superL.php on line 323, referer: http://192.168.56.129/vicidial/listloader.php
[Sun Jan 07 23:26:19 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined variable: DB in /var/www/html/vicidial/new_listloader_superL.php on line 122, referer: http://192.168.56.129/vicidial/new_listloader_superL.php
[Sun Jan 07 23:26:19 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined variable: LOGfullname in /var/www/html/vicidial/new_listloader_superL.php on line 158, referer: http://192.168.56.129/vicidial/new_listloader_superL.php
[Sun Jan 07 23:26:19 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined variable: server_ip in /var/www/html/vicidial/new_listloader_superL.php on line 203, referer: http://192.168.56.129/vicidial/new_listloader_superL.php
[Sun Jan 07 23:26:19 2007] [error] [client 192.168.56.1] PHP Notice:  Undefined variable: OK_to_process in /var/www/html/vicidial/new_listloader_superL.php on line 323, referer: http://192.168.56.129/vicidial/new_listloader_superL.php
DBD::mysql::db do failed: Column count doesn't match value count at row 1 at /var/www/html/vicidial/listloader.pl line 440.
DBD::mysql::db do failed: Column count doesn't match value count at row 1 at /var/www/html/vicidial/listloader.pl line 466.
tail: cannot open `which' for reading: No such file or directory
tail: cannot open `version' for reading: No such file or directory
tail: cannot open `of' for reading: No such file or directory
[root@localhost vicidial]#


[aster1]

Ooops it was due to my mistake i was checking if the campaign scripts will show some extra information from some other coloumn of table with that --A--field--B-- method so i added a coloumn named extra to vicidial_list table .. it never worked nonetheless broke list loader too . I deleted the coloumn i added and now its working fine .. leads are loading properly . Thx for tips guys