Page 1 of 1

Uploading leads in txt format

PostPosted: Sat Feb 07, 2009 5:41 pm
by tsvision
I have tried numerous times and cannot load list that has 65K records. It seems to load only 42K+ records. Is there a limitation on how many records vicidialnow can handle?

PostPosted: Sun Feb 08, 2009 1:04 am
by williamconley
I had issues a couple times with timeout in php (max execution time) and/or max upload file size.

Re: Uploading leads in txt format

PostPosted: Sun Feb 08, 2009 3:23 am
by tsvision
So how did you solve the problem? Were you able to upload more thank 65K records?

PostPosted: Sun Feb 08, 2009 4:05 am
by okli
From docs/REQUIRED_APPS_INSTALL.txt
vi /usr/local/lib/php.ini


Make sure short tags are enabled:
"short_open_tag = On"

some other fields to change if using web-based lead loader:
max_execution_time = 330
max_input_time = 360
post_max_size = 48M
upload_max_filesize = 42M
default_socket_timeout = 360

SCRATC_INSTALL.txt:
- cp php.ini-dist /usr/local/lib/php.ini
NOTE: you will want to make sure NOTICE logging is turned off:
error_reporting = E_ALL & ~E_NOTICE ; (this is default)
!!! REQUIRED !!! be sure the memory limit for scripts in php.ini is AT LEAST 48M:
memory_limit = 48M
Make sure short tags are enabled:
short_open_tag = On
some other fields to change if using web-based lead loader:
max_execution_time = 330
max_input_time = 360
post_max_size = 48M
upload_max_filesize = 42M
default_socket_timeout = 360


Mine are as follows:
max_execution_time = 3000 ; Maximum execution time of each script, in seconds
max_input_time = 3000 ; Maximum amount of time each script may spend parsing request data
memory_limit = 120M ; Maximum amount of memory a script may consume (16MB)
post_max_size = 50M
Last time uloaded ~100 000 leads.

In docs directory, there are plenty of examples and configuration files for perhaps anything ralated to vicidial you may need.

Re: Uploading leads in txt format

PostPosted: Sun Feb 08, 2009 12:58 pm
by tsvision
Hi Okli....I followed your instruction. But still the leads load upto 42K+. This is what I did:

vi /usr/local/lib/php.ini

The file was empty...so I inserted the following lines:

"short_open_tag = On"

max_execution_time = 3000
max_input_time = 3000
post_max_size = 50M
upload_max_filesize = 42M
default_socket_timeout = 360

I saved and exit and tried to upload a list with 65K record but still only loads 42K+ records. My actual txt file is only 5MB. Thanks for your help.

PostPosted: Sun Feb 08, 2009 3:48 pm
by okli
You need to restart Apache to apply the changes, did you?
Did you edit the proper php.ini, I doubt it's empty. Not idea where php.ini is in CentOS, in Debian for example it's /etc/php5/apache2/php.ini, in SCRATCH_INSTALL Slackware is used.

PostPosted: Sun Feb 08, 2009 4:06 pm
by tsvision
I installed the latest release of VICIDIALNOW 1.2rc1 so I am assuming it is in /usr/local/lib/php.ini . I googled to see where this file might be located and all Centos install confirms the same location. Plus I did restart my server so I think Apache was restarted also.

PostPosted: Sun Feb 08, 2009 4:17 pm
by okli
Do you get any error message in the web browser? Anything in apache's error.log?

Double check:
Code: Select all
locate php.ini
Is there any other file, in /etc for example?
Doesn't vicidialNow install eaccelerator? It should have had it's values at least in php.ini. Sorry, can't help much further, I've used mostly Debian with vicidial versions from SVN trunk.

PostPosted: Sun Feb 08, 2009 10:51 pm
by williamconley
of course, there could also be a problem with a record at that spot. bad format, illegal character.

what type of file are you uploading? have you tried "tab delimited" plain upload, or changed away from that if that was the one you were already using?

PostPosted: Wed Mar 04, 2009 6:50 am
by gardo
Under CentOS and other RedHat derivative distribution, the php.ini is located in /etc. You'll need to edit /etc/php.ini. Can you post the errors you're getting in your apache logs while loading the leads. The apache error logs are located under /var/log/httpd/.