Export/Import tool for OpenCart 1.5.0.x

JNeuhoff wrote:

aifel wrote:Hi

I got the following error
Fatal error: Class 'PHPExcel_Style' not found in /home/aifel/public_html/ocart/system/PHPExcel/Classes/PHPExcel.php on line 121

I am using
OpenCart v1.5.2.1 and using the opencart-1-5-2-x-export-import-6.zip

Any help is greatly appreciated

Thanks

The PHPExcel_Styleis defined on line 36 in the file /home/aifel/public_html/ocart/system/PHPExcel/Classes/PHPExcel.php, so clearly a wrong error message. What is your PHP version?

My PHP version is 5.2.17

Does the following file exist on your server?

/home/aifel/public_html/ocart/system/PHPExcel/Classes/PHPExcel/Style.php

JNeuhoff wrote:

Xciso wrote:Hi.
Every time i import products with this great tool my "view" been reset.
What can i do to not reset this?

If i have a box like "most viewed" in the store, it will be a problem.

Thanks!

Are you talking of the Products.viewed column?

Hi. Yes thats what i mean..

JNeuhoff wrote:Does the following file exist on your server?

/home/aifel/public_html/ocart/system/PHPExcel/Classes/PHPExcel/Style.php

Hi,

Thanks for the heads-up.
There are few files missing in my folder which is also missing from opencart-1-5-2-x-export-import-6.zip

However, I've downloaded and copied some missing files from http://phpexcel.codeplex.com/ and it now works perfectly.

Thanks again

aifel wrote:

JNeuhoff wrote:Does the following file exist on your server?

/home/aifel/public_html/ocart/system/PHPExcel/Classes/PHPExcel/Style.php

Hi,

Thanks for the heads-up.
There are few files missing in my folder which is also missing from opencart-1-5-2-x-export-import-6.zip

However, I've downloaded and copied some missing files from http://phpexcel.codeplex.com/ and it now works perfectly.

Thanks again

Which files exactly were missing?

I can export no problem, but if I reimport and unedited or edited version i get the following error?

can anyone help?

Notice: Trying to get property of non-object in /public_html/system/PHPExcel/Classes/PHPExcel/Reader/Excel2007.php on line 177

kylelnsn wrote:I can export no problem, but if I reimport and unedited or edited version i get the following error?

can anyone help?

Notice: Trying to get property of non-object in /public_html/system/PHPExcel/Classes/PHPExcel/Reader/Excel2007.php on line 177

Use the XLS format!

I did/Am using xls from mac office 2011

They are fine, open on windows and mac? just get the same error.

kylelnsn wrote:I did/Am using xls from mac office 2011

They are fine, open on windows and mac? just get the same error.

Obviously I am unable to reproduce your error. The error message indicates that a wrong format is used. Try OpenOffice to see if you can generate a proper XLS file.

I've been having some problems with this. I've used previous versions of the extension before, and found it to be really great, so was keen to use it again.

My OC version is 1.5.2.1
My php version is 5.3.6
I'm using the extension "opencart-1-5-2-x-export-import-6.zip"

It all installed fine, but when I export, I just get a junk corrupted xls file. There is only one product in the shop at the moment, I was exporting to get a xls to fill with products.

I've had a good read through this thread, and it's not the php ini settings for memory, as I have mine set pretty high. I also checked if anything was missing from the libraries (as that'd been mentioned) compared to http://phpexcel.codeplex.com/releases/view/26479 , but it looks fine, diff-ing the contents of once against the other. There are no errors, warnings or notices, so nothing much to go on.

So... any ideas anyone?

Some more info on the nature of the corrupted file...

Message on opening the file in Excel:


The corrupt file once opened in Excel:

Have you tried opening the file with OpenOffice? MS Office 2007 or later has some bugs as regards the support for XLS BIFF8 format, and, needless to say, trying to get Microsoft fix bugs is a futile exercise.

JNeuhoff wrote:Have you tried opening the file with OpenOffice? MS Office 2007 or later has some bugs as regards the support for XLS BIFF8 format, and, needless to say, trying to get Microsoft fix bugs is a futile exercise.

Thanks for the quick reply. I tried opening the xls file in Excel 2007 but also in Libre Office Calc 3.4.4 and it was the same in both.

I thought of a work around for the short term, OpenCart 1.5.1 has a very similar data structure for products, so I installed OpenCart 1.5.1 and installed opencart-1-5-1-x-export-import-6. That combination worked fine, so I exported a xls, filled out my product data, and imported it. Then, with phpMyAdmin I dumped the relevant tables from 1.5.1 and loaded them into 1.5.2.1. I know, it's a pretty clunky work around, but at least I got the products in.

It's odd that on my server the older version work fine, and the newer one doesn't. Initially I'd put the issue down to being some environment issue on my server, though maybe that's not the case.

AndyGaskell wrote: It's odd that on my server the older version work fine, and the newer one doesn't. Initially I'd put the issue down to being some environment issue on my server, though maybe that's not the case.

The Export/Import tools for OpenCart 1.5.1.x and 1.5.2.x are identical, so something else must be wrong with your new server. If it works on your old 1.5.1.x, then it should also work on 1.5.2.x.

It's always worth checking all the log files, e.g.OpenCart's system/logs/error.txt, your server's error_log etc, anything which could give you a clue as to why it goes wrong on 1.5.2.x.

Hey I'm using Export/Import on OC 1.5.2.1

Everything was working pewrfectly until I added 7,500 products to my shop... Now I have almost 10,000 products and when I try to export the .XLS file I get a "504 Gateway Time-out" error...

Any ideas?

This same error happened the first time I tried to upload my newly updated XLS file, but didn't happen the second try... So My new large database XLS file is imported but won't export....

Any help would be much appreciated as this really is a great extension!

Thanks in advance!

One other thing - the new multi language version for 1.5.2.1 doesn' have any readme.txt...

A life-save module. However, when the db grows this error can appear: Notice: Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if t etc etc....

I think I have found a fix (use with caution & back-up!). Open admin>model>tool>export.php

Around about line 1723 on this file, you will see the following line:
$query = "SELECT c.* , cd.*, ua.keyword FROM `".DB_PREFIX."category` c ";

*BEFORE* this add:
mysql_query("SET OPTION SQL_BIG_SELECTS=1");

I tested the module before making this change and I got the error. I applied the change and uploaded the file and the error went away - the entire db was downloaded as a csv file. Just to make sure, I uploaded the unchanged export.php file and the error came back. It certainly seems to be a reliable fix. I really hope that helps somebody.

JNeuhoff wrote:

AndyGaskell wrote: It's odd that on my server the older version work fine, and the newer one doesn't. Initially I'd put the issue down to being some environment issue on my server, though maybe that's not the case.

The Export/Import tools for OpenCart 1.5.1.x and 1.5.2.x are identical, so something else must be wrong with your new server. If it works on your old 1.5.1.x, then it should also work on 1.5.2.x.

It's always worth checking all the log files, e.g.OpenCart's system/logs/error.txt, your server's error_log etc, anything which could give you a clue as to why it goes wrong on 1.5.2.x.

Hi JNeuhoff, sorry, I should have worded that better, they are both on the same server, so same configuration. I checked the logs too, and there was nothing related to this.

First I want to say that this tool has been immensely helpful as long as I've been using Opencart.

I recently moved our 1.5.1.3 site from a shared hosting provider to a VPS, and it seems like the time it takes for the export/import tool to generate the backup_categories_products.xls file has quadrupled. The spreadsheet, once exported, comes out at about 2.5MB. Import is also taking longer than it was before. My guess is there's a setting or two that I've missed or is configured differently on the VPS.

Have any idea would could be causing it? Any suggestions on which settings to modify in php.ini or the like? What settings should I take a look at to help? Any help would be appreciated.

Thanks.

SDSkisDan wrote:First I want to say that this tool has been immensely helpful as long as I've been using Opencart.

I recently moved our 1.5.1.3 site from a shared hosting provider to a VPS, and it seems like the time it takes for the export/import tool to generate the backup_categories_products.xls file has quadrupled. The spreadsheet, once exported, comes out at about 2.5MB. Import is also taking longer than it was before. My guess is there's a setting or two that I've missed or is configured differently on the VPS.

Have any idea would could be causing it? Any suggestions on which settings to modify in php.ini or the like? What settings should I take a look at to help? Any help would be appreciated.

Thanks.

There could be many reasons as to why it's slower on your VPS. Perhaps the server has a slower CPU, or perhaps your PHP engine is slower, e.g. not a FastCGI engine.

Ok, so as long as it doesn't time out or blank page me I'm alright? phpinfo shows that the server API is CGI/FastCGI. I just wanted to check and see if there was something else I was missing.

Thanks for the quick response.