vicidial.org

VICIDIAL astGUIclient discussion forum
http://forum.eflo.net/VICIDIALforum/

Super lead loader problem

http://forum.eflo.net/VICIDIALforum/viewtopic.php?f=4&t=2074

Page 1 of 1

Super lead loader problem

PostPosted: Mon Dec 25, 2006 5:51 am
by 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 .

PostPosted: Mon Dec 25, 2006 6:19 am
by 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 ??

PostPosted: Tue Dec 26, 2006 4:45 am
by 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.

PostPosted: Tue Dec 26, 2006 8:09 am
by mflorell
Try loading the testMULTI_VICIDIAL_lead_file.txt file in the extras directory and see if you load uploading is even working proberly.

PostPosted: Sat Jan 06, 2007 6:35 am
by 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 ?

PostPosted: Sat Jan 06, 2007 9:44 am
by mflorell
So there are no leads in your vicidial_list table at all?

have you looked at the apache error log?

HI

PostPosted: Sat Jan 06, 2007 12:08 pm
by mr_mehul_shah
Pls. post the output of this command. : tail -30 /var/log/httpd/error_log which version of vicidial u r using...

PostPosted: Sun Jan 07, 2007 12:56 pm
by 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]#

PostPosted: Sun Jan 07, 2007 1:00 pm
by 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]#

PostPosted: Sun Jan 07, 2007 1:07 pm
by aster1
Ooops it was due to my mistake :D 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 :)
All times are UTC - 5 hours
Page 1 of 1
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/