Resolved: Excel Import/Export" tool JNeuhoff

Hi,
Just installed the module -Excel Import/Export" tool JNeuhoff in my opencart Versie 1.5.2.1. When exporting the file for the first time it only picks up categories and not products. I decided to export first so I can make changes and to have the correct tables. There doesn't seem to be an option to select what to export. Is the something I can do/modify ?
I have followed the instructions in the readmet.txt, changing user permissions and I'm baffled what could be wrong. I'm not that tech and would appreciate any help.

Kind regards

Have you looked in excel tabs in the bottom of your screen?

@ snakehult,
Sorry for a late reply. The problem wasn't the tabs but the wrong version. Happy to say it's resolved and I'll look carefully next time.
Thanks anyway

I have found this tool to be life saver for me up until now. I need some urgent help either from the developer or anyone who has bit of a time for me. Is there any way to make this tool to import product from multiple excel file instead of one huge one, because of the php memory limit and max execution time limitation on shared hosting.

Current problem I am having is, I have database of 2500 products. When tried import from one xls file I get "Memory Exhausted Error". When split the data into multiple files e.g file1.xls has 500 products, fle2.xls has another 500 products etc, I can import the product with no problems, however, it seems that data is being overwritten by the current file rather than adding to database (there are no duplicates). What I mean is data from file1.xls is overwritten by data from file2.xls after successful import.

May this script can be modified to have an option to select whether to ADD the data to the entries in current database or empty the current entries then insert the data. I am no expert in PHP or MYSQL, I hope I have made it as understandable as possible.

I do need this as soon as possible, so if anyone out there willing to help?

Noor

I've been struggling with this for a few days as well and I've finally resolved it.

You need to make these changes to php.ini

memory_limit = 512M;
post_max_size = 16M;
upload_max_filesize = 16M;

However, there may be more than one version of php.ini and you need to make the change to all of them. I found another version of php.ini in the admin directory and when I put these settings in there I was able to import successfully.

Good luck,

Andrew

Problem is I am on shared hosting and I have very restricted access to the server config files. I have spoken to server admin and they all the settings are on their max. Allowed and they won't able to change any. I have managed get work around by setting up a local server using WAMP and inserting all the products in to MySQL then copy the SQL text to my online server. It works a treat. Any of you using this method make sure your are not overriding any user settings.

Whilst this was a solution maybe you should look up an CSV Importer. CSV is just a simple text file with a , separating out the data. This is the smallest file type you could of used before you enter in compressing files.

Compared with a spreadsheet file the size is a lot lot smaller.