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

JNeuhoff wrote:
This is a known issue which we will address in the next release of the Export/Import tool.

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.

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

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

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

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

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

mettty wrote: 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.

kromanluv wrote:After I install Export/Import tool for OpenCart 1.5.5.x, I got error "500 Internal Server Error" for my opencart control panel (www.[domain]/admin) but, my front panel is alright.

I am using OpenCart version 1.5.5.1, with custom theme.
Now I have to restore backup to get back previous working state.

I tried 2 times already, but still getting same error.
Could someone help me how can I install sucessfully?

Thanks & Regards,
Kromanluv

JNeuhoff wrote:The Export/Import tool is now available for OpenCart 1.5.5.x.

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

Pyrocrafter wrote:Further to my other posts. I've now managed to install the Import/Export tool but get this error log when I try to export the site. (I forgot to upload all the folders - as others before me have done)

2013-05-15 15:50:55 - PHP Warning: stream_wrapper_unregister() [<a href='function.stream-wrapper-unregister'>function.stream-wrapper-unregister</a>]: Unable to unregister protocol zip:// in /web2/user42276/website/upload/system/PHPExcel/Classes/PHPExcel/Shared/ZipStreamWrapper.php on line 69
2013-05-15 15:50:56 - PHP Fatal Error: Class 'ZipArchive' not found in /web2/user42276/website/upload/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php on line 234
....
Any info would be greatly appreciated. Thanks

burley wrote:HI, just upgraded to 1551 and the latest version of your mod.

Exporting go's without a hitch, importing is giving me problems thought.
I keep getting the following error;

Can't find anything bad in my xlsx file, any clues?

Maestroluc wrote:I have an installation of newly installed Opencart 1.5.5.1. The component works well in export but to import fails (Uploaded file is not a valid spreadsheet file or its values ​​are not in the expected formats!) Only when overtaking the 200 lines in the table "products" xlsx file. Any idea?

Thank you very much!

NITCO wrote:Just save you file as xls and then try upload. Worked for me!