[UPDATED] Export/Import module for OpenCart 1.3.4

Every time somebody visits your web site, our server takes a log of it in either your access.log file or your error.log file (for times when people get errors like 404, etc... These logs are available for you to download at any time via FTP in the directory logs/yourdomain.com/http/ on our server. We rotate the logs every night so that access.log and error.log only contain today's logs, while error.log.0 and access.log.0 contain yesterdays (the last FULL day of logging available). After two days, we delete the log files.

JNeuhoff wrote:This module is now available for the OpenCart 1.3.4 version.

	function upload( $filename ) {
		set_error_handler('error_handler_for_export',E_ALL);
		$database = Registry::get('db');
		require_once 'Spreadsheet/Excel/Reader.php';
		ini_set("memory_limit","512M");
		ini_set("max_execution_time",180);

Andi wrote:180 seconds is probably the amount of time it takes from the upload completing and seeing the Error 500 in my case too...
Perhaps it works on your test server as it has more CPU cycles?
Dreamhost shared hosting is a little 'busy'....

Andi wrote:My Import partially works though - I get categories and products, but it times out before completing options.
Not sure how that links to .htaccess files?
The only one I have is the one in the root, named htaccess.txt which I renamed correctly so it could be used...

Will try removing it though.
And might increase the timeout - just to see.
... in the morning though!

Andi wrote:I've just changed

Code: Select all

ini_set("max_execution_time",180);

to 1800 instead of 180.

Ran fine, and all products imported.
Sorted.

(I didn't touch the .htaccess file, alter the XLS file - nothing! Just altered that one line and tried again).
Hope that helps.

JNeuhoff wrote:I think trying to upload 60 000 products won't work the Import because the reader.php, which the Import uses. is very memory hungry, about 64MB to 128MB per 1000 products.

I have been thinking about replacing the XLS format with the Open Document Spreadsheet format if I can find suitable reader and writer classes for it, and if it uses significant less memory.

I didn't really have any problem with this until I added 2k more to my import. Is there any way to adjust the limitations on the export size. I know that excel 2003 could handle upto 65k lines items.

I think in this instance, the ability to specify if its an update (thus replace) or an addition (thus add) would be appropriate (I've taken to manually editing the export.php file now lol)