Max import size or SQL database limited

[casibbald]

Hi Gang,

I have been importing my data into sugar and have imported about 2500 accounts.

I am trying to import the next batch of accounts and i get the following error.


Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 64 bytes) in /home/httpd/vhosts/mysite/httpdocs/sugar/modules/Import/parse_utils.php on line 49

now the next file im trying to import has about another 2000 accounts, and the csv file size is about 400kb.

I have a few more csv files totaling 40,000 accounts, will i not be able to get these in?

[Scotweb]

Depending on your ISP the php.ini file will have a file upload limit on it, perhaps this is the issue. Most ISP's seem to set this at 2.5MB though so your 400KB should be fine.

d

[Markku]

1. You can increase the memory allowed per process by editing this line in your php.ini file and restarting Apache:

memory_limit = 16M (add the line if it is missing)

2. If you do not have access to php.ini but your webspace is able to handle ".htaccess" files then you should be able to set it by adding the following line to .htaccess file

php_value memory_limit 16M

3. One alternative is to contact your service provider and ask them to change that setting. Maybe they are kind enough to help.

4. Another alternative could be to use phpMyAdmin and import your accounts directly to SugarCRM tables (but only 500-1000 accounts at a time).

[casibbald]

hi gang.

I increased memory_limit = 16

increased upload file max to 12mb.

still get same error.

where to now?

[Markku]

Just checking but did you restart Apache after changes in php.ini?
And do you think you could use phpMyAdmin to import your accounts to Sugar? Or just try to import 500 accounts at a time?