Export/Import tool for OpenCart 1.5.0.x

@JNeuhoff: I'm running OC 1.5.2.1 with Export/Import Tool on a VPS with full Parallels Plesk control.
Everything was working fine or a while until recently I added approx 1000 more products & now I'm receiving the same memory timeout error:
As you can see, I've tried increasing the memory limit to 528M but still getting the error. Should I be specifying any of these other variables?

max_execution_time
max_input_time
post_max_size
upload_max_filesize

Thanks in advance for any advise.

deeve wrote:@JNeuhoff: I'm running OC 1.5.2.1 with Export/Import Tool on a VPS with full Parallels Plesk control.
Everything was working fine or a while until recently I added approx 1000 more products & now I'm receiving the same memory timeout error:

Code: Select all

Fatal Error: Allowed memory size of 551550976 bytes exhausted (tried to allocate 71 bytes) in /var/www/vhosts/mywebsite/httpdocs/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/CacheBase.php on line 130

As you can see, I've tried increasing the memory limit to 528M but still getting the error. Should I be specifying any of these other variables?

max_execution_time
max_input_time
post_max_size
upload_max_filesize

Thanks in advance for any advise.

Can you do a phpinfo file so you know that you have set everything right.

Hi Xciso, I have the following in my php.ini file if that's what you mean:

Hi. No i mean if you can make a phpinfo file.
Google it.

Sorry, misunderstood. I already had one of those & thought I'd set the limits correctly within Parallels - values below are Local & Master. I thought they looked fine so long as Local overrides Master - my site in question is on my VPS & obviously shares resources:

max_execution_time: 300/60
max_file_uploads: 20/20
max_input_nesting_level: 64/64
max_input_time: 300/60
memory_limit: 512M/128M
post_max_size: 32M/8M

If you are running fastcgi i think you set everything from same php.ini.
And thats why i want you to test with a phpinfo file, so you can see that you have changed in right places.
And also that you have to restart apache2.

I just downloaded the php.ini file from the Loaded Configuration File path & changed the Master settings to be the same & restarted Apache2 Service but still I get the same error.

Any other ideas?

this is an excellent mod - works really well on a reseller build of 5.4.1 (up to 1500sku) - but, I have recently had another build to worry about - jumped at your mod, and installed.

I can export products/categories as per normal, but the upload (import) is erroring:

Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 94 bytes) in XXX /public_html/system/PHPExcel/Classes/PHPExcel/Worksheet.php on line 961

I have upped the memory on the PHP.ini and on the server allocation... is there anywhere else I should be looking..

(phpinfo here)

many thanks,



P

Phil_L wrote: I have upped the memory on the PHP.ini and on the server allocation... is there anywhere else I should be looking..

(phpinfo here)

many thanks,

P

Your memory_limit is only 128 MB, which is probably too small.

JNeuhoff wrote:

Phil_L wrote: I have upped the memory on the PHP.ini and on the server allocation... is there anywhere else I should be looking..

(phpinfo here)

many thanks,

P

Your memory_limit is only 128 MB, which is probably too small.

changed and, upped to 1024m and it's still error'ing.

please can you suggest further fixes?

Hello Mates,

I am running on Oc 1.5.5.1 with updated Import/Export Tool
But when ever i am trying to Import/Export the excelsheet,iam getting the following error.
I am uploading around 2500 products.

PHP Fatal Error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 76 bytes) in /home/run/public_html/mydomain.com/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/Memory.php on line 46

2013-03-13 20:57:08 - PHP Warning: Cannot modify header information - headers already sent by (output started at /home/rx/public_html/mydomain.com/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/Memory.php:46) in /home/run/public_html/mydomain.com/admin/model/tool/export.php on line 49

2013-03-13 20:57:08 - PHP Warning: Cannot modify header information - headers already sent by (output started at /home/rx/public_html/mydomain.com/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/Memory.php:46) in /home/rx/public_html/mydomain.com/admin/model/tool/export.php on line 50

Please if anyone solved this error,please share me the solution...Thanks in Advance.

Phil_L wrote:

JNeuhoff wrote:

Phil_L wrote: I have upped the memory on the PHP.ini and on the server allocation... is there anywhere else I should be looking..

(phpinfo here)

many thanks,

P

Your memory_limit is only 128 MB, which is probably too small.

changed and, upped to 1024m and it's still error'ing.

please can you suggest further fixes?

Please can I get some support for this.

many thanks,

Hi, i'm hoping I can get some help here. Opencart 1.5.4. Import/Export manager used to function perfectly. Suddenly, the module has disappeared from the bottom of the system drop down in admin. The module still appears and is enabled under VQMod Manager. I have tried replacing files from back up but to no avail. Any ideas? I would really appreciate any advice.

Hi,

Using opencart Version 1.5.5.1

Options boost (latest Version March 2013)

with export/import tool but on running i get thw following error:

Parse error: syntax error, unexpected ',' in /vqmod/vqcache/vq2-admin_model_tool_export.php on line 2272

Line 2272 in that file is :

$this->setCell( $worksheet, $i, $j++, html_entity_decode($row['ob_info'],ENT_QUOTES,'UTF-8') ), $textFormat );

any ideas what this could be?

Anybody know of an import/export tool that works with less errors? I dont mind paying.

vik007 wrote:Hi,

Using opencart Version 1.5.5.1

Options boost (latest Version March 2013)

with export/import tool but on running i get thw following error:

Parse error: syntax error, unexpected ',' in /vqmod/vqcache/vq2-admin_model_tool_export.php on line 2272

Line 2272 in that file is :

$this->setCell( $worksheet, $i, $j++, html_entity_decode($row['ob_info'],ENT_QUOTES,'UTF-8') ), $textFormat );

any ideas what this could be?

This is an issue with the Options Boost VQMod XML script which tries to modify the admin/model/tool/export.php, adding its own fields.

Would there be a quick resolution i could do or do you think Q will have to make the changes and a new release?

Export is blank. So I cannot seem to get the format right.

When I am importing it is now telling me this message:

Fatal error: Call to undefined method PHPExcel_Reader_CSV::setReadDataOnly() in /home/faecaver/public_html/ocart/admin/model/tool/export.php on line 1644

That should it read so I can get it to import?

FaeCaverns wrote:Export is blank. So I cannot seem to get the format right.

When I am importing it is now telling me this message:

Fatal error: Call to undefined method PHPExcel_Reader_CSV::setReadDataOnly() in /home/faecaver/public_html/ocart/admin/model/tool/export.php on line 1644

That should it read so I can get it to import?

I keep saying that to almost every problem reported here: Please check your Opencart's system/logs/error.txt, and your servers error_log (ask your webhost for access to the latter!).

When the data is imported it clears the previous data and writes new data to the database. Is it at all possible to perhaps and a button to the panel which gives you the option of importing data without clearing the existing data?