Export/Import for 1.5.6.4 - Export not read by Excel

Hello,

I have recently upgraded my OpenCart installation to version 1.5.6.4. For some reason when I did so this Import/Export tool no longer appeared in my System menu. The simple fix for this was to download the version of the tool that was meant for my new version of OpenCart and install it, which I did.

It seems to work fine. I can now see the entry in the System menu once again, and I can Export a .xlsx file. However, when I attempt to open the file in Excel, I receive the following error:

"Excel cannot open the file 'backup_categories_products.xlsx' because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file."

Clearly, the extension is correct, which leaves me wondering if the file could be corrupt upon creation. Has anyone seen this before? Or does anyone know how this might be solvable? I use this tool a LOT for editing multiple similar products at the same time, and it's loss would be devastating.

Thank you in advance for any help.
Sincerely,

Walter Kaechele

I have an update to this problem that may help anyone interested in helping me fix this.

I tried to open the file by changing the extension from .xlsx to .xls. When I did, Excel informed me that this was not the original extension of the file, and asked if I wanted to open it anyway. I clicked <Yes>, and a spreadsheet opened with the following information in one of the cells:

<b>Fatal error</b>: Class 'ZipArchive' not found in <b>/home/mdancer/public_html/MDOpenCart/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php</b> on line <b>227</b><br />


This was the only data in the file.

I am not familiar with PHP, nor am I overly familiar with UNIX (just so you know who you're dealing with ). Again, any assistance with this would be MOST helpful.

Thanks again!

Walter

wkaechele wrote:I have an update to this problem that may help anyone interested in helping me fix this.

I tried to open the file by changing the extension from .xlsx to .xls. When I did, Excel informed me that this was not the original extension of the file, and asked if I wanted to open it anyway. I clicked <Yes>, and a spreadsheet opened with the following information in one of the cells:

<b>Fatal error</b>: Class 'ZipArchive' not found in <b>/home/mdancer/public_html/MDOpenCart/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php</b> on line <b>227</b><br />


This was the only data in the file.

I am not familiar with PHP, nor am I overly familiar with UNIX (just so you know who you're dealing with ). Again, any assistance with this would be MOST helpful.

Thanks again!

Walter

You need to ask your webhost to install the missing PHP ZIP library.

See e.g. http://stackoverflow.com/questions/3872 ... t-found-in