[RELEASED] Export/Import tool for OpenCart 1.5.5.x

mettty wrote:

mettty wrote:

mettty wrote:Hi,
I have the same problem as qaso. There are restrictions on my webhost, so I can't export the file. But I want to try, if I can import the file. And for that I need at least one sample.
Someone who can share with me?

Thanks.

Maybe I found the problem with restrictions. My webhost don't allow me use functions sys_get_temp_dir() and tempnam(), which needs server root temp folder. So tool can't make the export file. I tried to modify PHPExcel files to set tmp folder manually (like 'data/folder/tmp') without result.
Problem is in opencartfolder/system/PHPExcel/classes/PHPExcel/Shared/file.php line 106 function sys_get_temp_dir()
and in opencartfolder/system/PHPExcel/classes/PHPExcel/Writer/Excel2007.php line 205.

Please help, if someone have any idea how to edit this code. Could not imagine how to use opencart without this tool.

I'm like a spammer, but I solved it. Problem is in Excel2007, which (I don't know why) has another method for temp directories on server then Excel5. So back to Excel5.

So if you have the same problem as qaso:

qaso wrote:I have installed your newest version. It still doesnt work. Here is log:

Code: Select all

2013-02-21 14:16:50 - PHP Warning:  realpath() [<a href='function.realpath'>function.realpath</a>]: open_basedir restriction in effect. File(/tmp) is not within the allowed path(s): (/data/web/filatelista.eu/:/data/f/i/filatelista.eu/:/usr/php53/lib/php/:/apachetmp/) in /data/f/i/filatelista.eu/web/system/PHPExcel/Classes/PHPExcel/Shared/File.php on line 136
2013-02-21 14:16:50 - PHP Warning:  tempnam() [<a href='function.tempnam'>function.tempnam</a>]: open_basedir restriction in effect. File() is not within the allowed path(s): (/data/web/filatelista.eu/:/data/f/i/filatelista.eu/:/usr/php53/lib/php/:/apachetmp/) in /data/f/i/filatelista.eu/web/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php on line 205
2013-02-21 14:16:50 - PHP Exception:  Could not close zip file php://output. in /data/f/i/filatelista.eu/web/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php on line 378

and your older version of Import/Export tool was ok, just do this:
in /admin/model/tool/export.php
edit line 2613 from

Code: Select all

header('Content-Disposition: attachment;filename="backup_categories_products.xlsx"');

to

Code: Select all

header('Content-Disposition: attachment;filename="backup_categories_products.xls"');

edit line 2615 from

Code: Select all

$objWriter = PHPExcel_IOFactory::createWriter($workbook, 'Excel2007');

to

Code: Select all

$objWriter = PHPExcel_IOFactory::createWriter($workbook, 'Excel5');

Back to server I imported the .xls file and it's ok.

Sorry JNeuhoff for those edits. Hope, you won't be angry. Hope that this will help to somebody.

CloudCyberSystems wrote:getting this error...

Code: Select all

Parse error: syntax error, unexpected $end in /home/cloudcyb/public_html/system/PHPExcel/Classes/PHPExcel/Calculation.php on line 2926

Fatal error: Class 'PHPExcel_Calculation' not found in /home/cloudcyb/public_html/system/PHPExcel/Classes/PHPExcel.php on line 151

schiggi wrote:Moving my site from one hoster to another. Get the same error at the new hoster's site while exporting data:

Code: Select all

Server error!

The server encountered an internal error and was unable to complete your request.

Error message: 
Premature end of script headers: index.php

If you think this is a server error, please contact the webmaster.

Error 500

My memory allowances should be high enough (~5000 SKUs) with a 512MB memory limit. PHP version 5.3/MySQL 5.5. I suspect that maybe some php extensions are needed/have to be allowed.

Can someone assist me with this problem?

Thank you!

schiggi wrote:I am bit lost with my issue. Could somebody point me to a direction, where I could start to look for the problem? Using the latest OC version and the latest update of the export/import tool.

schiggi wrote:Moving my site from one hoster to another. Get the same error at the new hoster's site while exporting data:

Code: Select all

Server error!

The server encountered an internal error and was unable to complete your request.

Error message: 
Premature end of script headers: index.php

If you think this is a server error, please contact the webmaster.

Error 500

My memory allowances should be high enough (~5000 SKUs) with a 512MB memory limit. PHP version 5.3/MySQL 5.5. I suspect that maybe some php extensions are needed/have to be allowed.

Can someone assist me with this problem?

Thank you!

schiggi wrote:Thanks for the reply. I think, JNeuhoff meant another user with his reply. In any case, during the export I getting this error.

baronen wrote:Hi, I'm probably dumb, but followed the instructions and can't get the addon to work. It does not show up anywhere.
I have OC 1.5.5.1 and downloaded opencart-1-5-5-x-export-import-17.
I use VQmod but I cant find the addon.
Reinstalled VQmod and verified that it works by trying another addon.
Also selected the tool in top admin user group.

Is it just that the addon is hidden or something?

baronen wrote:

baronen wrote:Hi, I'm probably dumb, but followed the instructions and can't get the addon to work. It does not show up anywhere.
I have OC 1.5.5.1 and downloaded opencart-1-5-5-x-export-import-17.
I use VQmod but I cant find the addon.
Reinstalled VQmod and verified that it works by trying another addon.
Also selected the tool in top admin user group.

Is it just that the addon is hidden or something?

Bump?
Any ideas of whats wrong?

JNeuhoff wrote:

schiggi wrote:Thanks for the reply. I think, JNeuhoff meant another user with his reply. In any case, during the export I getting this error.

Your need to ask your webhost for the error_log log entries for exactly the time when your Internal Server Error 500 occured. My guess is it could be a timeout issue.

[Wed Aug 20 22:57:31 2014] [warn] [client 91.64.44.88] Timeout waiting for output from CGI script /var/www/cgi-bin/cgi_wrapper/cgi_wrapper, referer: http://xxx.xx/admin/index.php?route=tool/export&token=7e595c3ba28533adbe8c5f77f7c44879
[Wed Aug 20 22:57:31 2014] [error] [client 91.64.44.88] Script timed out before returning headers: cgi_wrapper, referer: http://xxx.xx/admin/index.php?route=tool/export&token=7e595c3ba28533adbe8c5f77f7c44879
[Wed Aug 20 22:58:31 2014] [warn] [client 91.64.44.88] Timeout waiting for output from CGI script /var/www/cgi-bin/cgi_wrapper/cgi_wrapper, referer: http://xxx.xx/admin/index.php?route=tool/export&token=7e595c3ba28533adbe8c5f77f7c44879