[UPDATED] Export/Import module for Opencart 1.3.2

Ok. I am really baffled now.

JNeuhoff was able to export my data from his server.

I have another OpenCart installation that can export its data - so I know it's not a server configuration issue because it is the same version of OpenCart and Export/Import.

Now, this database is slightly larger than the one that can export, so I was thinking that I shouldn't disregard the server so quickly. So thinking it still may still be a configuration issue I did the following:

Increased memory_limit to 128M. Increased max_execution_time to 400!. Even though this only applies to uploading files and not downloading, I increased upload_max_filesize to 10M. All this was done in the php.ini file and not .htaccess.

Is there something else on the server end that would prevent the xls file from being built before it is passed to the browser for download? I recap that it still is providing me with a 0 kb xls file. There is no data in the file.

It has me baffled...and it has JNeuhoff baffled. Any help would be appreciated!! Even if it is just a suggestion, if you are not sure.

Great contribution! Would definitely support its inclusion in the core. Only recommendation I'd make is adding the ability to import/export manufacturer data.

Now I am really baffled.

I can not even export any data from a base install of OpenCart! I downloaded 1.3.2 again and the import/export mod. Installed and attempted to export - after setting the user group permissions. I still get a blank database.
I double checked the other OpenCart installation I have on the server and it exports just fine. Same version for everything!!

Now that is weird.

Can you do some testing by moving the database from the working shop to the broken shop?
It might help to show you if its the actual files or the database that is causing the issue

Eliminating the database and the files, I did not import my database or custom core modules to a clean install of OpenCart. I used the example data only.

Eliminating the server, I installed WAMP on my computer. I imported the database to a clean install of OpenCart - no changes to the core files. I exported the database to the spreadsheet - blank spreadsheet. Same when I did a clean install of OpenCart with the example data.

Also Jeurgen, the creator of this mod, took my database and imported it to a OpenCart installation on his server and was able to export it without any problems.

So if it is not the server, it's not the files and it's not the database...what else is there?? Especially when another opencart installation is able to export without incident. Worst of all there are no errors reported in my error log.

I did find this when I first transferred over to the WAMP server and made a error with the path to the system/log. I am not sure if it would apply:

Unknown: Assigning the return value of new by reference is deprecated in D:\wamp\www\testuser\admin\Spreadsheet\Excel\Writer\Workbook.php on line 191
Warning: fopen(D:/wamp/www/testuser/dev/system/logs/systemlog.log) [function.fopen]: failed to open stream: No such file or directory in D:\wamp\www\testuser\admin\Spreadsheet\Excel\Writer\Workbook.php on line 191

Warning: fwrite() expects parameter 1 to be resource, boolean given in D:\wamp\www\testuser\admin\Spreadsheet\Excel\Writer\Workbook.php on line 191

Warning: fclose() expects parameter 1 to be resource, boolean given in D:\wamp\www\testuser\admin\Spreadsheet\Excel\Writer\Workbook.php on line 191
Unknown: Assigning the return value of new by reference is deprecated in D:\wamp\www\testuser\admin\Spreadsheet\Excel\Writer\Workbook.php on line 200
Warning: fopen(D:/wamp/www/testuser/dev/system/logs/systemlog.log) [function.fopen]: failed to open stream: No such file or directory in D:\wamp\www\testuser\admin\Spreadsheet\Excel\Writer\Workbook.php on line 200

Warning: fwrite() expects parameter 1 to be resource, boolean given in D:\wamp\www\testuser\admin\Spreadsheet\Excel\Writer\Workbook.php on line 200

Warning: fclose() expects parameter 1 to be resource, boolean given in D:\wamp\www\testuser\admin\Spreadsheet\Excel\Writer\Workbook.php on line 200

I am confused about why there would be further errors beyond the problem with writing to the system log. I should also note that no further reference is found after the path has been corrected in admin/config.php for the system log.

Getting this error when trying to import xls file

The filename /tmp/phpdyVhwB is not readable

Increase your upload_max_filesize and make sure your cache directory is writable.

Jeurgen,

What did you change from your 1.3.0 compatible version to the 1.3.2 compatible version? I installed OC 1.3.0 and the 1.3.0 export/import compatible version and it worked fine. From what I can see you added the error handler and storeMeasurementClassesIntoDatabase.

The only thing that I could see that may prevent the spreadsheet from being created would be the error handler. Is there something that I am missing on the server end that this class requires?

Thanks!

Of course I had to double check that pear is enabled and it is. I was able to run this:
and received this displayed in my browser:

bool(true)

It seems I have similar issues with export/import. I just installed xampplite and opencart (last version 1.3.2), then followed instructions to install export/import (last version for 1.3.2 of 14/08/2009).
When I try to perform my first export I receive following error page:

Unknown: Assigning the return value of new by reference is deprecated in D:\xampplite\htdocs\admin\Spreadsheet\Excel\Writer\Workbook.php on line 191Unknown: Assigning the return value of new by reference is deprecated in D:\xampplite\htdocs\admin\Spreadsheet\Excel\Writer\Workbook.php on line 200Warning: Cannot modify header information - headers already sent by (output started at D:\xampplite\htdocs\admin\Spreadsheet\Excel\Writer\Workbook.php:191) in D:\xampplite\htdocs\admin\Spreadsheet\Excel\Writer.php on line 68Warning: Cannot modify header information - headers already sent by (output started at D:\xampplite\htdocs\admin\Spreadsheet\Excel\Writer\Workbook.php:191) in D:\xampplite\htdocs\admin\Spreadsheet\Excel\Writer.php on line 69Warning: Cannot modify header information - headers already sent by (output started at D:\xampplite\htdocs\admin\Spreadsheet\Excel\Writer\Workbook.php:191) in D:\xampplite\htdocs\admin\Spreadsheet\Excel\Writer.php on line 70Warning: Cannot modify header information - headers already sent by (output started at D:\xampplite\htdocs\admin\Spreadsheet\Excel\Writer\Workbook.php:191) in D:\xampplite\htdocs\admin\Spreadsheet\Excel\Writer.php on line 71Warning: Cannot modify header information - headers already sent by (output started at D:\xampplite\htdocs\admin\Spreadsheet\Excel\Writer\Workbook.php:191) in D:\xampplite\htdocs\admin\Spreadsheet\Excel\Writer.php on line 72ÐÏࡱá;þÿ ‚þÿÿÿƒ
..................

I love your Export/Import module! I am also using the new text option contrib... Any chance on updating export/import to include the text options? I would hate to have to update all of my items with text options manually.

Obviously the two separate versions would have to be maintained as not everyone uses the text option feature...unless it was added to the core?? *hint* - but I guess that would be for another forum huh?

Anyway, please add support for text options to be updated "en masse" from the spreadsheet and imported back to opencart via your wonderful contribution. Thanks again for your awesome update!

hello .. I have installed the activated form ... ... but when I go to click on "Export" gives me blank page with these error messages:
because it does not work and does not export the file and I leave these errors?

How can I fix this?

You require PEAR to be enabled.

Find your php.ini file for your local server install. Once you find that you will need to enable PEAR in php.ini.

You are quite right; i had the wrong version.

Hi JNeuhoff,

In 1-3-2-3, the categories are repeated, and it shows the second seo as one for a product name, so when this gets imported, the categories now all link to a single product.

My store has been like this for over a week, might explain my lack of orders :p

Hi Leon,

Can you e-mail me your spreadsheet file so I can take a look at it?

I have this same problem and it is when trying to use either SEO or meta tags. I am not sure but I think it has to do with the format of the description for example it doesn't like " ' " in the description.

Hi reefnut,

Can you send me your XLS file so I can pin down the problem and fix it? Thanks.

At the moment I do not have the problem since I did a new install and am not using SEO or meta tags at the moment. However once I get these set up again and if I have the problem and it's not solved I will happily send it to you.

Hi JNeuhoff,

Would a screenshot of the problem worksheet be ok? Because if it's alright, i'd rather not hand over the details to my entire catalog.

Cheers