Export/Import tool for OpenCart 1.5.0.x

Hi! Is there a way to add Downloads to this? I looked over the .xls and don't see a column for Downloads. Is this possible?

Ok, thanks for letting me know

whoops forgot to quote, was in reference to my post on formulas

When you say it uses a lot of memory...do you mean only when you are importing the products or just the files in the server ?

Looks like everything is good after installation (OpenCart 1.5.1/AyelCart/Joomla 2.5) - have Import/Export menu item, icons for import/export - but when I click the Export button, I get a 500 error blank page.

The website encountered an error while retrieving ..../index.php?option=com_ayelshop&route=tool/export/download&token=1418899474ba96a964eb36fcf865becd. It may be down for maintenance or configured incorrectly.
Here are some suggestions:
Reload this webpage later.
HTTP Error 500 (Internal Server Error): An unexpected condition was encountered while the server was attempting to fulfill the request.

Nothing is in either the server logs or the opencart logs - I've got no clue.
Can someone point me in a direction towards figuring this out?

Ayelshop has a modified version of this script at http://www.ayelshop.com/downloads/file/ ... ort-export

This fixed the issue.

For anyone getting the memory limit error with a small xls file on a shared hostgator, get them to check if the Apache rlimit needs tweeking, solved my problem.

I was just interested in knowing if the memory consumption happens when ONLY when you upload products ?

Or does it always use the memory even if you are not uploading/exporting anything

dony_b wrote:I was just interested in knowing if the memory consumption happens when ONLY when you upload products ?

Or does it always use the memory even if you are not uploading/exporting anything

The memory consumption is mainly during the Import, after uploading the XLS file, when it has to parse the whole file into memory.

Hi,

Great Mod - I only haev one problem at the moment.

Is there any way to get the options to support images? If I create the option in the backe ned and apply it to a product, it all works fine, but when I upload the spreadsheet all the options dissappear from the product and from the options menu.

If i change the option type back to 'Select' in the speadsheet and re-upload, they re-appear but the links to the images have gone so I have to re-apply them again.

Any ideas what I need to do to keep the images linked for options?

Thanks
Ian

JNeuhoff wrote:

dony_b wrote:I was just interested in knowing if the memory consumption happens when ONLY when you upload products ?

Or does it always use the memory even if you are not uploading/exporting anything

The memory consumption is mainly during the Import, after uploading the XLS file, when it has to parse the whole file into memory.

Well what I been doing is use the local server to upload the products and then import that database to the live server. This way I can preserve RAM. Wonder if there is another to go about uploading products but not using that specific servers ram.

I've installed the tool, was able to export fine. Upon trying to import, I receive this message...

I've re-uploaded the files a couple of times, making sure to check my ftp log and that nothing was missed or skipped. I can still export with no problem. I've tried uploading as an XLS as well as CSV to no avail....Still receiving this message upon trying to import:

Fatal error: Class 'ZipArchive' not found in /home/lelady/public_html/store/system/PHPExcel/Classes/PHPExcel/Shared/File.php on line 53

ANy help is appreciated...

lelady wrote:I've installed the tool, was able to export fine. Upon trying to import, I receive this message...

I've re-uploaded the files a couple of times, making sure to check my ftp log and that nothing was missed or skipped. I can still export with no problem. I've tried uploading as an XLS as well as CSV to no avail....Still receiving this message upon trying to import:

Fatal error: Class 'ZipArchive' not found in /home/lelady/public_html/store/system/PHPExcel/Classes/PHPExcel/Shared/File.php on line 53

ANy help is appreciated...

Looks like you don't have the standard ZIP library installed on your PHP, ask your webhost to set it up.

I am trying to export from my store 1.4.9.3 and then tried to import the products into my new store 1.5.1.3 and i get the follow message.
Uploaded file is not a valid spreadsheet file or its values are not in the expected formats!
Any ideas?

sbproduction wrote:I am trying to export from my store 1.4.9.3 and then tried to import the products into my new store 1.5.1.3 and i get the follow message.
Uploaded file is not a valid spreadsheet file or its values are not in the expected formats!
Any ideas?

The spreadsheet's worksheets are different between the 2 versions. Do an Export from your 1.5.1.3 server, and then use the resulting spreadsheetto overwrite the contents with yours, copying and pasting from your old spreadsheet.

Hi there J.Neuhoff!

Thankyou very much for your work on this mod, it has saved me a ridiculous amount of time getting everything imported. If you would be so kind I was just wondering if it is possible to store extra data in the import xls?

I have three price tiers and I need two prices to calculate the correct amount for each group. It would be really handy if I could paste this second price into the xls spreadsheet somewhere (at the end of the products in the 'AN' column for example). I have tried adding an additional column/sheet but it errors out whenever I attempt import. Is there anything I can do/set to tell it to ignore a certain bit of data?

Thanks very much in advance!

-Dan

Dufus wrote:Hi there J.Neuhoff!

Thankyou very much for your work on this mod, it has saved me a ridiculous amount of time getting everything imported. If you would be so kind I was just wondering if it is possible to store extra data in the import xls?

I have three price tiers and I need two prices to calculate the correct amount for each group. It would be really handy if I could paste this second price into the xls spreadsheet somewhere (at the end of the products in the 'AN' column for example). I have tried adding an additional column/sheet but it errors out whenever I attempt import. Is there anything I can do/set to tell it to ignore a certain bit of data?

Thanks very much in advance!

-Dan

Edit the admin/model/tool/export.php file to add support for additional field columns. In particular, look at the following functions:

storeProductsIntoDatabase
uploadProducts
validateProducts
populateProductsWorksheet

Thanks for replying, I will check it out!

I have just installed this extension on OC 1.5.1.3. But I'm getting following error while accessing System > Export / Import option.

Notice: Error: Could not load language tool/export! in /home/*****/public_html/*****/vqmod/vqcache/vq2-system_library_language.php on line 27

PlusCybernet wrote:I have just installed this extension on OC 1.5.1.3. But I'm getting following error while accessing System > Export / Import option.

Notice: Error: Could not load language tool/export! in /home/*****/public_html/*****/vqmod/vqcache/vq2-system_library_language.php on line 27

So have you checked what the error message suggests? Do you have a admin/language/tool/export.php installed?

Yes, I have checked and can see export.php file in "/public_html/*****/admin/language/english/tool" directory; and permission of this file/directory is 755.