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

I posted this in the 1.5.3 thread before I noticed this one:

Thanks for the great tool, it's saved me a lot of time. The problem I'm having though is that the product options don't link to their appropriate products. They appear in Catalog > Options, but the don't show up in the menus on the product's page.

First: Thanks for this wonderfull extension!

I have installed it, exported / imported, everything worked perfect!

Though i know have a excel document; i can import it, but when i try to EXPORT it gives a error 500...

What should i do?

Thanks!

HRR wrote:but when i try to EXPORT it gives a error 500...

What should i do?

Thanks!

Look up the server's error_log for more a more detailed error message, ask your web host for it if you can't access it.

Hello!
I am uploading file - 15 mb.
OpenCart 1.5.5.1

19000 products.
83000 options.
93000 attributes.
Loading takes a long time but succeeds.
But unloading - dont work.
Waited a long time, eventually the browser is closed the connection.
I increased all limits in php.ini which i know.
My configuration:
Intel® Core™ i7-2600 Quadcore
16 Gb DDR3

Thanks.

JNeuhoff wrote:

HRR wrote:but when i try to EXPORT it gives a error 500...

What should i do?

Thanks!

Look up the server's error_log for more a more detailed error message, ask your web host for it if you can't access it.

Nothing in the Log. When i remove some attributes (couple 100) then it works. So i think it just stops exporting beceause of the limitations?

Just an update:

Installed my webshop on WAMP, and the export worked. So i think its a Server side issue.

Question: Any plans to add the RELATED products to export? I would SOOOO love that! ;-)

HRR wrote:Just an update:

Installed my webshop on WAMP, and the export worked. So i think its a Server side issue.

Question: Any plans to add the RELATED products to export? I would SOOOO love that! ;-)

I know it's a server side issue, and there definately is a corresponding entry in your server's error_log for this, telling you the reason for the 500 error. Ask your web host for this. You won't see it in your in cPanel, if you are on a shared host.

I think you wanted this:

Script timed out before returning headers: index.php, referer: http://www.xxxx.xx/admin/index.php?rout ... c53f066a93

Hello, thankyou for the great tool.
Now, when i'm trying to export a file i'm getting the following error:

Fatal error: Class 'PHPExcel_Shared_ZipStreamWrapper' not found in /home/dirent/public_html/eshop/system/PHPExcel/Classes/PHPExcel/Autoloader.php on line 31

Any help please?

billkor wrote:Hello, thankyou for the great tool.
Now, when i'm trying to export a file i'm getting the following error:

Fatal error: Class 'PHPExcel_Shared_ZipStreamWrapper' not found in /home/dirent/public_html/eshop/system/PHPExcel/Classes/PHPExcel/Autoloader.php on line 31

Any help please?

Ask your web host to install the PHP ZIP library.

Hi Mr Neuhoff,


First, thanks for a great free extension.
Second, having spent the day trawling the internet trying to sort out a problem with export I can see you have the patience of a saint!


I'm tasked with upgrading an OC install from 1.5.3 to 1.5.5. I setup a local version of the 1.5.3 store to work on initially. I've upgraded OC, VQMod, and several extensions. All is good now apart from export/import (which worked fine on 1.5.3).

I've upgraded the export/import extension to the 1.5.5 version but when I try to export a save box appears after a time and I save the xlsx file, but MS Excel 2007 (sorry!) won't open the file, and says it cannot open the file because the file format or file extension is invalid.

Initially I was trying to export the same set of categories / products etc. as the live site. There are approx 850 products and the 1.5.3 export xls was 3,836Kb. The corresponding (non-opening) 1.5.5 export xslx was only 581Kb! This makes me think that the export is not being completed before I'm asked to save the file. So I thought maybe it's a memory limit thing or some such. php.ini-wise I've increased everything I've seen you mention in various forum threads but always the same result. So I tried culling my products down to just 30 or so. The save dialog appears quicker but I still have the same error when trying to open the file (It's only 58Kb now).

I've checked PHP log, apache log, OC log but there are no errors being logged at all anywhere that I can see, which is particularly frustrating.


Any pointers on some things to try next would be appreciated, but no worries if you can't think of anything off the top of your head. I could setup a password protected copy of the site on the interweb if that would help with finding the problem.


cheers
Jon

I've tried switching to default theme and the problem remains.

On the same localhost as the problem site I've done a fresh install of OC 1.5.5.1 and added vqmod and export/import extension and it works fine - so that rules out PHP settings I'm thinking?

Next up I tried hooking the fresh clean install up to the problem site database - The result is I can successfully do an export also - so that rules out iffy data, unexpected fields etc. I'm thinking? The successfully downloaded export xlsx is the same size as the unsuccessful one (581Kb). If I try to import it into the problem site I get an OC error message after the import file has been bprocessed: 'Uploaded file is not a valid spreadsheet file or its values are not in the expected formats!' and in the OC error log there is the message 'Export/Import: Invalid number of worksheets, 8 worksheets expected'. The 'good' xlsx does have 8 worksheets.

Next I've uninstalled all extensions from the problem site apart from VQmod and export/import. Still the xlsx cannot be opened (and I have tried with both Excel and OpenOffice).

Just wish I could find an error message somewhere to send me in the right direction!

blancy wrote:I've tried switching to default theme and the problem remains.

On the same localhost as the problem site I've done a fresh install of OC 1.5.5.1 and added vqmod and export/import extension and it works fine - so that rules out PHP settings I'm thinking?

Next up I tried hooking the fresh clean install up to the problem site database - The result is I can successfully do an export also - so that rules out iffy data, unexpected fields etc. I'm thinking? The successfully downloaded export xlsx is the same size as the unsuccessful one (581Kb). If I try to import it into the problem site I get an OC error message after the import file has been bprocessed: 'Uploaded file is not a valid spreadsheet file or its values are not in the expected formats!' and in the OC error log there is the message 'Export/Import: Invalid number of worksheets, 8 worksheets expected'. The 'good' xlsx does have 8 worksheets.

Next I've uninstalled all extensions from the problem site apart from VQmod and export/import. Still the xlsx cannot be opened (and I have tried with both Excel and OpenOffice).

Just wish I could find an error message somewhere to send me in the right direction!

Looks like you narrowed it down to the problem database. Can you provide me with a zipped copy of your problem database? You can use PHPMyAdmin to do a complete export, and attach it in a PM to me.

Please try this it would solve your non supported xlsx file problem
use the following procedure:
Go to:---
admin/model/tool/export.php
Find
go to line 2613 header('Content-Disposition: attachment;filename="backup_categories_products.xlsx"');
Replace
header('Content-Disposition: attachment;filename="backup_categories_products.xls"');

Find
go to line 2615 $objWriter = PHPExcel_IOFactory::createWriter($workbook, 'Excel2007');
Replace
$objWriter = PHPExcel_IOFactory::createWriter($workbook, 'Excel5');

Thanks

I installed php zip library and now i m getting this error

Fatal error: Class 'PHPExcel_Worksheet_PageSetup' not found in /home/dirent/public_html/eshop/system/PHPExcel/Classes/PHPExcel/Worksheet.php on line 344

Not so minor note, there are several flavors of .xls, and not even Microsoft's own array of "Excel" programs can open all of their several .xls formats. You might be caught up in that, along with the difficulty (likewise tripped) of accommodating all of them in the extension itself. We went through the same thing several years ago with 40-odd flavors of venerable .tif format. Nobody could open everybody's, even among the first rank of graphics and of conversion programs.

As the export import extension seems to work properly on a clean 1.5.5.1 install I have gone down the route of a fresh clean 1.5.5.1 install and have rebuilt the shop on top of that. Possibly something on the old 1.5.3.1 site was not playing ball with export extension, I don't know. So far all seems to be working. I can certainly export an openable xlsx file now. Before I try the import though I need to customise the export (and import) a bit to add a couple of new fields to products (cost & google product categories)

I m getting the following error:

PHP Fatal Error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 2 bytes) in /home/dirent/public_html/system/PHPExcel/Classes/PHPExcel/Cell.php on line 531

I changed the php.ini memory size to 256m but nothing changed

The size of the file is 200k

A minor issue - The mod was working perfectly until the web host had a PHP problem and had to reinstall PHP. I was then getting the ZipArchive error until I informed the host who had not switched this feature on again in PHP.

Now the module is exporting OK. On import, all the data is being added to the site, but instead of getting the green success message at the top of the import/export system page, I am now redirected to a blank page when the upload is complete.

Any ideas?

Thanks

estateP wrote:A minor issue - The mod was working perfectly until the web host had a PHP problem and had to reinstall PHP. I was then getting the ZipArchive error until I informed the host who had not switched this feature on again in PHP.

Now the module is exporting OK. On import, all the data is being added to the site, but instead of getting the green success message at the top of the import/export system page, I am now redirected to a blank page when the upload is complete.

Any ideas?

Thanks

No idea because you are simply not giving enough details, such as entries from server's error_log (ask web host for it), or Opencart's system/logs/error.txt.