This latest version contains an improved error handler. And it now uses the XLSX as the default spreadsheet file format.
Still on our to-do list:
- Make it more override-friendly for customisations
- Incremental Import
- Multilingual support
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
It generates xlsx file but inside it is following text and nothing else:
Code: Select all
PHP Fatal error: '<strong>Could not close zip file php://output.</strong>' <br />
in /data/f/i/*****/web/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php:378<br />
Stack trace:<br />
#0 admin/model/tool/export.php(2599): PHPExcel_Writer_Excel2007->save('php://output')<br />
#1 admin/controller/tool/export.php(114): ModelToolExport->download()<br />
#2 [internal function]: ControllerToolExport->download()<br />
#3 vqmod/vqcache/vq2-system_engine_front.php(56): call_user_func_array(Array, Array)<br />
#4 vqmod/vqcache/vq2-system_engine_front.php(42): Front->execute(Object(Action))<br />
#5 admin/index.php(163): Front->dispatch(Object(Action), Object(Action))<br />
#6 {main}
The worksheets are still the same. We mainly focused on an improved error handler, and the usage of XLSX instead of the old XLS. Also, it now only needs PHPExcel, no PEAR libraries. Will improve foreign language character support in the next release, UTF-8 should work with XLSX by default.Xciso wrote:Thanks JNeuhoff! You are just amazing
Is it any big updates with this version for 1.5.5.1?
I know you talked about UTF-8, and multilanguage..
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
In order to start to work on it, I exported first to see the fields I need to use.
I downloaded the xlsx file but excel failed to open it saying it was in a wrong format or it was corrupted.
Any idea?
Thx
Use OpenOffice or LibreOffice. Other than that, you don' t provide enough details,soIam unable to help you.siffrock wrote:I have just installed the extention.
In order to start to work on it, I exported first to see the fields I need to use.
I downloaded the xlsx file but excel failed to open it saying it was in a wrong format or it was corrupted.
Any idea?
Thx
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
thanks for your reply.... yes, you are right I didn't give enough details ;-)
Ok, I have OC 1.5.5.1, I have installed your mod with vqmod and exported the first xlsx file.
I opened the file with excel 2010 and it failed.
I followed your suggestion to use OpenOffice and still doesn't show anything similar to a worksheet.
you can find the file I have downloaded here www.csvsick.com/backup_categories_products.xlsx
If you need more details, please let me know which one.
Thanks again...
P.S. I used a long time ago your old mod on oc 1.4 and it was really good ;-)
You got this error message in your XLSX file:siffrock wrote:Hi JNeuhouff,
thanks for your reply.... yes, you are right I didn't give enough details ;-)
Ok, I have OC 1.5.5.1, I have installed your mod with vqmod and exported the first xlsx file.
I opened the file with excel 2010 and it failed.
I followed your suggestion to use OpenOffice and still doesn't show anything similar to a worksheet.
you can find the file I have downloaded here http://www.csvsick.com/backup_categories_products.xlsx
If you need more details, please let me know which one.
Thanks again...
P.S. I used a long time ago your old mod on oc 1.4 and it was really good ;-)
Warning: set_time_limit() has been disabled for security reasons in /home/linweb18/m/monteverde.org.uk-1064622979/user/htdocs/oc2/admin/controller/tool/export.php on line 110
Please comment out line 110 in your admin/controller/tool/export.php and try again. Your webhost is overly restrictive with the security settings!
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Code: Select all
PHP Fatal error: '<strong>Could not close zip file php://output.</strong>' <br />
in /data/f/i/*****/web/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php:378<br />
Stack trace:<br />
#0 admin/model/tool/export.php(2599): PHPExcel_Writer_Excel2007->save('php://output')<br />
#1 admin/controller/tool/export.php(114): ModelToolExport->download()<br />
#2 [internal function]: ControllerToolExport->download()<br />
#3 vqmod/vqcache/vq2-system_engine_front.php(56): call_user_func_array(Array, Array)<br />
#4 vqmod/vqcache/vq2-system_engine_front.php(42): Front->execute(Object(Action))<br />
#5 admin/index.php(163): Front->dispatch(Object(Action), Object(Action))<br />
#6 {main}
Thank you.
qaso wrote:JNeuhoff plase could you provide me some info about my problem? Anyway I would like to thank you for your extension. I am using Opencart 1.5.5.1 and vqmod. I did everything by readme.txt but my import/export addon is generating xlsx file with following text inside it (when I open it with notepad):
I read somewhere that it could be a problem with permissions. What should I do to fix that?Code: Select all
PHP Fatal error: '<strong>Could not close zip file php://output.</strong>' <br /> in /data/f/i/*****/web/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php:378<br /> Stack trace:<br /> #0 admin/model/tool/export.php(2599): PHPExcel_Writer_Excel2007->save('php://output')<br /> #1 admin/controller/tool/export.php(114): ModelToolExport->download()<br /> #2 [internal function]: ControllerToolExport->download()<br /> #3 vqmod/vqcache/vq2-system_engine_front.php(56): call_user_func_array(Array, Array)<br /> #4 vqmod/vqcache/vq2-system_engine_front.php(42): Front->execute(Object(Action))<br /> #5 admin/index.php(163): Front->dispatch(Object(Action), Object(Action))<br /> #6 {main}
Thank you.
Yes, it looks like your PHP runs in safe_mode, which restricts access to zipped files in the php://output stream. I am afraid the only option is to switch web host, or to ask your web host to remove this restriction.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
It provides improved error and exception handlers.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Thanks for your anwer. Php_safe is turned off. I can edit all my php settings in web admin. So where could be a problem?JNeuhoff wrote:qaso wrote:JNeuhoff plase could you provide me some info about my problem? Anyway I would like to thank you for your extension. I am using Opencart 1.5.5.1 and vqmod. I did everything by readme.txt but my import/export addon is generating xlsx file with following text inside it (when I open it with notepad):
I read somewhere that it could be a problem with permissions. What should I do to fix that?Code: Select all
PHP Fatal error: '<strong>Could not close zip file php://output.</strong>' <br /> in /data/f/i/*****/web/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php:378<br /> Stack trace:<br /> #0 admin/model/tool/export.php(2599): PHPExcel_Writer_Excel2007->save('php://output')<br /> #1 admin/controller/tool/export.php(114): ModelToolExport->download()<br /> #2 [internal function]: ControllerToolExport->download()<br /> #3 vqmod/vqcache/vq2-system_engine_front.php(56): call_user_func_array(Array, Array)<br /> #4 vqmod/vqcache/vq2-system_engine_front.php(42): Front->execute(Object(Action))<br /> #5 admin/index.php(163): Front->dispatch(Object(Action), Object(Action))<br /> #6 {main}
Thank you.
Yes, it looks like your PHP runs in safe_mode, which restricts access to zipped files in the php://output stream. I am afraid the only option is to switch web host, or to ask your web host to remove this restriction.
As the error message suggests, it ismost likely an access right issue. or it could also be that you haven't the ZIP library installed on your server for PHP. Try using the latest Export/Import tool, which I uploaded a few hours ago. If the problem persists, check your system/logs/error.txt for any more details.qaso wrote: Thanks for your anwer. Php_safe is turned off. I can edit all my php settings in web admin. So where could be a problem?
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
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
I don't think it will ever work with your webhost.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
The PHP warnings can be overcome by using your upload_tmp_dir php setting in your 'admin/php.ini'. But the PHP Exception about not being able to close the zip file in the php://output stream is most likely because of an overly restrictive security setting, or because of a missing ZIP library for your PHP.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Thank you. I contacted my webhosting provider and we will see.JNeuhoff wrote:I don't think it will ever work with your webhost.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
The PHP warnings can be overcome by using your upload_tmp_dir php setting in your 'admin/php.ini'. But the PHP Exception about not being able to close the zip file in the php://output stream is most likely because of an overly restrictive security setting, or because of a missing ZIP library for your PHP.
that is based on your extension and have the ability of multilanguage and incremental imports you wont!! That way everybody would win...at least the ones that want multilanguage and incremetal import supported to the latest OC version! :-) How about that!! How agrees with me! Thanx JN
2013-02-25 4:30:58 - PHP Warning: realpath(): open_basedir restriction in effect. File(/tmp) is not within the allowed path(s): (/var/www/admin/data:.) in /var/www/admin/data/www/(***)/system/PHPExcel/Classes/PHPExcel/Shared/File.php on line 136
2013-02-25 4:30:58 - PHP Warning: tempnam(): open_basedir restriction in effect. File() is not within the allowed path(s): (/var/www/admin/data:.) in /var/www/admin/data/www/(***)/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php on line 205
2013-02-25 4:30:58 - PHP Exception: Could not close zip file php://output. in /var/www/admin/data/www/(***)/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php on line 378
On my VPS with full root acsec access
What can i do? I have never had this problems with your older versions. I use OpenCart 1.5.5.1.
I tryed at a other computer with older version of OpenOffice and there it looks good. But with that old version i cant save the file with xlsx.
Link to image so you can see what i mean:
http://79.99.6.193/oc_test/image/import-export.png
Please respond soon so i can get start working
Users browsing this forum: No registered users and 3 guests