Export/Import tool for OpenCart 1.5.0.x

In OC 1.5.2.1 with impoer/export, I'm getting this error when trying to import my database now (after adding a few thousand more products)....

Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 93 bytes) in /home/mikroweb/public_html/opm/system/PHPExcel/Classes/PHPExcel/Worksheet.php on line 961

Fatal Error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 93 bytes) in /home/mikroweb/public_html/opm/system/PHPExcel/Classes/PHPExcel/Worksheet.php on line 961


Any way around this?

I have 4806 unique products and 10,132 product options in total...
Does this exceed the possible size of a shops database?
My Excel filesize is 7.5MB

Any help would be much appreciated!

[quote="liamcaff"
Any way around this?

I have 4806 unique products and 10,132 product options in total...
Does this exceed the possible size of a shops database?
My Excel filesize is 7.5MB

Any help would be much appreciated![/quote]

I am afraid you have reached the upper memory limits supported by your web server. Future versions of the Export/Import will include incremental imports, but it is still in the making and not yet relased.

Hi JNeuhoff,

Thanks for a great tool..

I have an issue here..

Am unable to make the tool appear in Admin panel -- System

After I copied the files over and make those permissions in System, User Groups... It still doesn't appear.

This happens to most of my setups in different sub-domains (eshop, tshop1, tshop2, tshop3)...... but only 1 sub-domain (tshop) works.... I do not know why.. and need a solution to this.. so that I can have the tool in the correct / official sub-domain (eshop)

I'm unable to copy the files from the Tshop that is working fine.. as there is Apsona shopadmin in there.. I do not wish to have that installed in my other sub-domains....

Kindly enlighten.

Also, we're looking forward to your Incremental Export / Import system! That would be wonderful!

Thank you.

thegeekz wrote:Hi JNeuhoff,

Thanks for a great tool..

I have an issue here..

Am unable to make the tool appear in Admin panel -- System

After I copied the files over and make those permissions in System, User Groups... It still doesn't appear.

This happens to most of my setups in different sub-domains (eshop, tshop1, tshop2, tshop3)...... but only 1 sub-domain (tshop) works.... I do not know why.. and need a solution to this.. so that I can have the tool in the correct / official sub-domain (eshop)

I'm unable to copy the files from the Tshop that is working fine.. as there is Apsona shopadmin in there.. I do not wish to have that installed in my other sub-domains....

Kindly enlighten.

Also, we're looking forward to your Incremental Export / Import system! That would be wonderful!

Thank you.

Sigh - people keep asking the same questions here. Please follow the insructions from the readme.txt file.

Hi Jneuhoff!

I followed your readme.txt to the T, and still can't get it working..


I have VQMOD preinstalled... Copied everything in your zip folder to the OC folder.. and enabled the access rights in TOP Administrator, but still its not working.

Also the Permission rights to the folder Admin in your zip file was not correctly set instead of 755, it was 775, thus initially.. I had problems even -- it does not allow me to access ADMIN panel after installing your tool... My host corrected that for me.. and it works now, but still doesn't see the Tool in System Menu... after following all the steps in your readme.txt.

Kindly clarify, should all the folders in Export Import Tool be set to 755 by default or 775? It seem only 755, then the tool will be able to work properly.. - I'm retrying my setup now..

Kindly enlighten.

** Please do not assume everyone is asking the same question..... when I have followed everything but it doesn't work....

I tried to search the forums for solution, but there is none... that's why I had to ask here...

Thanks!

Update~ to all :
I have set all the Export Import Tool folders permissions to 755 instead of 775, reload the VQMOD installation, as well as the Export Import Tool, and set the Access rights in Top Administrator. The tool works now! Perfectly! This would hopefully help the rest of the fellow OC users....

Somehow the Export Import tool came with 775 Persmissions.. I do not know why.....

Thank you!

Just had the unreadable content error when trying to export with excel 2007, read where others had the same problem and it was suggested to use a different version of excel or openoffice. I've never had a problem before but noticed that a client had recently updated a description & pasted some html content. There was an open paragraph tag at the bottom that caused the problem.

&nbsp;</p>

Removed that and all is well.

virtualgeorge wrote:Just had the unreadable content error when trying to export with excel 2007</p>

The Export is done with system/pear/Spreadsheet/Excel/Writer.php, called from admin/model/tool/export.php, not by any MS Excel.

Are you talking about trying to open the exported XLS file with Excel 2007?

Yeah, I meant opening the exported xls file with 2007.
Then excel shows the error & attempts to repair.

Hi,

Just installed Export/Import plugin on my OpenCart v1.5.2.1. Great plugin!
Everything is fine but when I export, it returns garbage in xls file. Can anyone please tell me why is this and how to fix?

Thanks.

Hannan

Im using OC 1.5.2.1 and the opencart-1-5-2-x-export-import-6.zip

Seems to work out well, but, when i try to import, the newly added products doesnt show up in admin? Any solution?

hannan wrote:Hi,

Just installed Export/Import plugin on my OpenCart v1.5.2.1. Great plugin!
Everything is fine but when I export, it returns garbage in xls file. Can anyone please tell me why is this and how to fix?

Thanks.

Hannan

Might be a similar issue as reported by virtualgeorge. Have you checked yourproduct descriptions?

ShopOholic wrote:Im using OC 1.5.2.1 and the opencart-1-5-2-x-export-import-6.zip

Seems to work out well, but, when i try to import, the newly added products doesnt show up in admin? Any solution?

Are your products all set to 'true' in the 'status enabled' column?
Is the language_id correct?
Is the store_ids column set? (use 0 for a single store site)

When I import I get this:
Uploaded file is not a valid spreadsheet file or its values are not in the expected formats!

Log:
2012-05-15 08:16:15 - Export/Import: Invalid header in the Options worksheet

Example of a the first 2 rows
category_id parent_id name top columns sort_order image_name date_added date_modified language_id seo_keyword description meta_description meta_keywords store_ids layout "status
enabled"
221 0 Pakketten false 1 0 data/curly-hair-custom-large.jpg 2012-05-07 21:56:22 2012-05-07 21:56:22 2 Pakketten <p>Diverse pakketten &nbsp;van samengestelde producten. Het pakket is goedkoper dan de artikelen los.</p> Diverse pakketten van samengestelde producten. Het pakket is goedkoper dan de artikelen los. 0 true

UPDATE! Got it to work.

JNeuhoff wrote:Are your products all set to 'true' in the 'status enabled' column?
Is the language_id correct?
Is the store_ids column set? (use 0 for a single store site)

Yes, i've checked that and they are set right.
But, i was thinking about something. If i put in a new product that doesn't got any product ID and category yet, do i have to create that in the OC admin first?

JNeuhoff wrote:

hannan wrote:Hi,

Just installed Export/Import plugin on my OpenCart v1.5.2.1. Great plugin!
Everything is fine but when I export, it returns garbage in xls file. Can anyone please tell me why is this and how to fix?

Thanks.

Hannan

Might be a similar issue as reported by virtualgeorge. Have you checked yourproduct descriptions?

Yes, I am working on a fresh installation of OpenCart and trying to export sample data.
Tested same version of plugin and OpenCart on my other hosting, everything is working fine there. Can you give me an idea whats going wrong?

hannan wrote:

JNeuhoff wrote:

hannan wrote:Hi,

Just installed Export/Import plugin on my OpenCart v1.5.2.1. Great plugin!
Everything is fine but when I export, it returns garbage in xls file. Can anyone please tell me why is this and how to fix?

Thanks.

Hannan

Might be a similar issue as reported by virtualgeorge. Have you checked yourproduct descriptions?

Yes, I am working on a fresh installation of OpenCart and trying to export sample data.
Tested same version of plugin and OpenCart on my other hosting, everything is working fine there. Can you give me an idea whats going wrong?

No idea, I am unable to reproduce your error. Have you checked your PHP settings? And done a file compare ofthe one that was fine on your other hosting and the one which is broken? Have you tried opening the file in OpenOffice?

When I import I get this:
Uploaded file is not a valid spreadsheet file or its values are not in the expected formats!

Log:
2012-05-15 08:16:15 - Export/Import: Invalid header in the Options worksheet

Example of a the first 2 rows
category_id parent_id name top columns sort_order image_name date_added date_modified language_id seo_keyword description meta_description meta_keywords store_ids layout "status
enabled"
221 0 Pakketten false 1 0 data/curly-hair-custom-large.jpg 2012-05-07 21:56:22 2012-05-07 21:56:22 2 Pakketten <p>Diverse pakketten &nbsp;van samengestelde producten. Het pakket is goedkoper dan de artikelen los.</p> Diverse pakketten van samengestelde producten. Het pakket is goedkoper dan de artikelen los. 0 true

JNeuhoff wrote:
No idea, I am unable to reproduce your error. Have you checked your PHP settings? And done a file compare ofthe one that was fine on your other hosting and the one which is broken? Have you tried opening the file in OpenOffice?

Yes, also tried OpenOffice.

These are the URLs to check PHP settings. Can you please check it in your way?

http://bit.ly/JVs4gI (Good)
http://bit.ly/LfjMmF (Bad)

Thank You.

I would really like to finish my site but cant upload the products. I installed Aceshop before and exported the products now trying to import it into Opencart but getting:

Uploaded file is not a valid spreadsheet file or its values are not in the expected formats!

What to do?

Thanks for this great extension. I can export and open the excel file.

However, after clicking on the "Import" button; (trying to import the same excel file back)..This is what happen:-

1) It automatically logged me out of the OpenCart Administration and
2) immediately linked to my Store Front (http://...../admin/index.php?route=tool/export&token=...) with the message "The page you requested cannot be found!"

Can please help with this problem?