vicidial.org

by **abhasbajpai** » Wed Aug 30, 2006 10:45 pm

i am having a problem in loading lists
i followed the scratch install
with super list loader and all things actually this is second setup first is working fine
when i try to load the same leads as in previous setup in tab delimited text files i made it through exel
it says
The file does not have the required number of fields to process it.
but the same file loads i previous setup
with super list loader
cvs which load in previous setup dosnt load here
saya
The file does not have the required number of fields to process it.
how do i cheak where i made blunder
please help

by **mflorell** » Thu Aug 31, 2006 12:01 am

have you tried using a custom format(Custom radio button) in the super lead loader?

by **abhasbajpai** » Thu Aug 31, 2006 10:44 pm

yes but that also not worked
it shows
VENDOR LEAD CODE
SOURCE ID:
LIST ID:
etc and default is none
when you scroll the the filed it should display VENDOR LEAD CODE for VENDOR LEAD CODE and so on
but it displays " " and so on
the page says Processing pipe-delimited file...
from scratch installation
i have done
perl -MCPAN -e shell

install OLE::Storage_Lite (needed for super list loader Excel)
install Spreadsheet::ParseExcel (needed for super list loader Excel)
and it says it is up to date
what to do

by **mflorell** » Thu Aug 31, 2006 11:05 pm

can you look in your error log for apache to see if you are getting any errors when the excel parsing perl scripts are running properly?

Do you have your ".pl" scripts in the vicidial web directory set to be executable?

Is your webserver on the same amchine as Asterisk?

by **abhasbajpai** » Fri Sep 01, 2006 4:24 am

Do you have your ".pl" scripts in the vicidial web directory set to be executable?
where to find these ".pl" scripts
all the php files are executable
this is the out put of /home/cron/ADMIN_adjust_GMTnow_on_leads.pl --debug
-----DEBUGGING -----

STARTING TIME ZONE DAYLIGHT SAVING TIME CALCULATION SCRIPT

SEED TIME 1157102418 : 2006-09-01 14:50:18 LOCAL GMT OFFSET NOW: -5
- Unique Country dial codes found: 0
- GMT phone codes records: 1010

RUNNING LOOP FOR COUNTRY CODE:
DONE
apatche is same machine as asterisk
and apache is showing no erorr
and is there is any way convert excel file to list loader format
that excel file is in same format as required by list loader
when convert it to tab delimited text or cvs
it says not enough fields to processos

by **mflorell** » Fri Sep 01, 2006 7:00 am

Does vicidial/ listloader_super.pl have execute permissions?

Is your web server on the same machine as Asterisk/VICIDIAL?

by **abhasbajpai** » Fri Sep 01, 2006 11:51 pm

YES of both
listloader.pl has executable permission
and webserver is on same machine

by **mflorell** » Sat Sep 02, 2006 7:52 am

Do you have fileuploads enabled in php.ini?

Does a file appear in the vicidial web directory after you upload it?

How large is the file that you are trying to upload?

What Excel version is the file saved as?

Is there any special formatting in the Excel file?

by **abhasbajpai** » Sun Sep 03, 2006 9:28 pm

Do you have fileuploads enabled in php.ini?
YES
Does a file appear in the vicidial web directory after you upload it?
it is not uploaded so its is not appearing

How large is the file that you are trying to upload?
it just have one thousand fields in it

What Excel version is the file saved as?
it excel XP (office 2002)

Is there any special formatting in the Excel file?
NO

how can i convert an excel file in proper format understandable by listlodaer

by **mflorell** » Sun Sep 03, 2006 11:23 pm

If the file is not uploading to the vicidial web directory then you have another problem somewhere.

to save in another format, just save as tab-delimited text or CSV in Excel and see if either of those work.

by **abhasbajpai** » Mon Sep 04, 2006 5:36 am

i have trye in both text delimited, CVS,excel text every format
but it is not doing
help please

by **mflorell** » Mon Sep 04, 2006 7:56 am

please explain what "it is not doing" means exactly.

Does the file appear in the vicidial web directory after you attempt to load it?

are there any errors that appear when you try to load the file?

by **espencer** » Mon Sep 04, 2006 9:57 am

mine loaded when i replaced the commas with pipes | (pipe is shift-backslash)

by **abhasbajpai** » Mon Sep 04, 2006 9:58 pm

mine loaded when i replaced the commas with pipes | (pipe is shift-backslash)

please explain what "it is not doing" means exactly.

it is syaing not enough fileds to process
secondly i got om eroor on apatche error log can you help me with this
file dose not appear in vicidial directory

[client 127.0.0.1] PHP Warning: fopen(./project_auth_entries.txt) [<a href='function.fopen'>function.fopen</a>]: failed to open stream: Permission denied in /var/www/html/vicidial/new_listloader_superL.php on line 117, referer: http://sevenseas/vicidial/new_listloader_superL.php
[client 127.0.0.1] PHP Notice: Undefined variable: LOGfullname in /var/www/html/vicidial/new_listloader_superL.php on line 146, referer: http://sevenseas/vicidial/new_listloader_superL.php
[client 127.0.0.1] PHP Warning: fwrite(): supplied argument is not a valid stream resource in /var/www/html/vicidial/new_listloader_superL.php on line 146, referer: http://sevenseas/vicidial/new_listloader_superL.php
[client 127.0.0.1] PHP Warning: fclose(): supplied argument is not a valid stream resource in /var/www/html/vicidial/new_listloader_superL.php on line 147, referer: http://sevenseas/vicidial/new_listloader_superL.php
[client 127.0.0.1] PHP Notice: Undefined variable: server_ip in /var/www/html/vicidial/new_listloader_superL.php on line 187, referer: http://sevenseas/vicidial/new_listloader_superL.php
[client 127.0.0.1] PHP Notice: Undefined variable: OK_to_process in /var/www/html/vicidial/new_listloader_superL.php on line 299, referer: http://sevenseas/vicidial/new_listloader_superL.php
[client 127.0.0.1] PHP Warning: copy(/usr/local/apache2/htdocs/vicidial/vicidial_temp_file.txt) [<a href='function.copy'>function.copy</a>]: failed to open stream: Permission denied in /var/www/html/vicidial/new_listloader_superL.php on line 531, referer: http://sevenseas/vicidial/new_listloader_superL.php
[client 127.0.0.1] PHP Warning: fopen(/usr/local/apache2/htdocs/vicidial/vicidial_temp_file.txt) [<a href='function.fopen'>function.fopen</a>]: failed to open stream: No such file or directory in /var/www/html/vicidial/new_listloader_superL.php on line 532, referer: http://sevenseas/vicidial/new_listloader_superL.php
[client 127.0.0.1] PHP Warning: fopen(/usr/local/apache2/htdocs/vicidial/listloader_stmts.txt) [<a href='function.fopen'>function.fopen</a>]: failed to open stream: Permission denied in /var/www/html/vicidial/new_listloader_superL.php on line 534, referer: http://sevenseas/vicidial/new_listloader_superL.php
[client 127.0.0.1] PHP Warning: fgets(): supplied argument is not a valid stream resource in /var/www/html/vicidial/new_listloader_superL.php on line 536, referer:

by **mflorell** » Mon Sep 04, 2006 11:23 pm

looks like your vicidial directory is not set to allow writing.

chmod 0666 /var/www/html/vicidial/

by **abhasbajpai** » Tue Sep 05, 2006 12:46 am

iit is allowed to write
i have done that
but than also in no awail
the same problem is comming
when i try to load the list it says
there are not enough filed to process
even though the same file uploads in the other setup
now apatche is also not giving any error
how to debug this

vicidial.org

list not loading ???

list not loading ???

Who is online