[RELEASED] Export/Import tool for OpenCart 1.5.4.x

nfs wrote: The server get a PHP Fatal Error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 3145728 bytes)
It is not a memory error in my server. File is corrupt
.....
How to resolve this? Is there other export import tool I can use, so I dont loose my 150pcs of products data.

pcp1917 wrote:Magnificent extension.

I'm trapped with a problem about the encoding when importing data.

If I insert the name "Aceitería" through the opencart admin panel, when creating a category (for example), the field in the database is right ("Aceitería"). If I insert "Aceitería" directly via mySQLAdmin, the field in the database is right too.

In export.php of the tool, the variable "name" just before inserting it into the table contains the right value -> "Aceitería". But after the insertion, the field in the database has wrong chars-> "Aceitería"

Then, I don't know why the "INSERT INTO" of the import tool stores "Aceitería" instead of "Aceitería".

Please help me!

Regards.

JNeuhoff wrote:

nfs wrote: The server get a PHP Fatal Error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 3145728 bytes)
It is not a memory error in my server. File is corrupt
.....
How to resolve this? Is there other export import tool I can use, so I dont loose my 150pcs of products data.

You need to resolve your memory error first, see e.g. http://www.opencartnews.com/tutorials/c ... olve-them/

It do not mater if I add 10 products or 100pcs. File size jump to 550kb.

nfs wrote: So What Im saying is that filesize jump from about 250kb to 550kb if only add one product. File is corrupt how to resolve this. Is there any other export import tool I can try if working then I export from my opencart and get a working file again.


An other problem I have had since installed is this error message in log.
PHP Notice: Cannot find controller class file for route '' in /home/user1901/public_html/system/engine/factory.php on line 152

anat wrote: also, go to lines: 112 and 146 (where the jqeury code is):

if (image != null) {
html += '<div class="image">' + image + '</div>';
}


and replace it with this:

if (image != null) {
html += '<div class="image">' + image + '</div>';
}

else {
html += '<div class="image">' + '<a href="<?php echo $product['href']; ?>"><img src="http://www.yourdomain.com/image/cache/d ... -80x80.jpg" title="<?php echo $product['name']; ?>" alt="<?php echo $product['name']; ?>" /></a>' + '</div>';
}

(or just add the "else" segment).
Notice - the path I gave for the image placeholder is where my placeholder is (no_image.jpg). You should choose the right path for your pic of course.
This will work on category pages. If you have other pages that display products (like "manufacturers-info.tpl for example) you need to find the lines in those file which match those I've mentioned above, and do the same thing.
Hope this was helpful.

SamNabz wrote:Hi J.Neuhoff,

We are using your extension, which works perfectly. However, we have installed an extension called "Multicurrency" (http://www.opencart.com/index.php?route ... on_id=7084) which allows you to insert product pricing in various currencies which then automatically get converted to the store's default currency choice.

Now, the Multicurrency fields are not included when we do an export and so we were wondering what modification(s) we have to make to your extension in order for it to include the custom fields in the export, as well as allows us to edit those fields offline and re-import them back in.

Your earliest reply is appreciated.

Thank you.

SamNabz wrote:Hi J.Neuhoff,

We are using your extension, which works perfectly. However, we have installed an extension called "Multicurrency" (http://www.opencart.com/index.php?route ... on_id=7084) which allows you to insert product pricing in various currencies which then automatically get converted to the store's default currency choice.

Now, the Multicurrency fields are not included when we do an export and so we were wondering what modification(s) we have to make to your extension in order for it to include the custom fields in the export, as well as allows us to edit those fields offline and re-import them back in.

Your earliest reply is appreciated.

Thank you.

Lao wrote:

anat wrote: also, go to lines: 112 and 146 (where the jqeury code is):

if (image != null) {
html += '<div class="image">' + image + '</div>';
}


and replace it with this:

if (image != null) {
html += '<div class="image">' + image + '</div>';
}

else {
html += '<div class="image">' + '<a href="<?php echo $product['href']; ?>"><img src="http://www.yourdomain.com/image/cache/d ... -80x80.jpg" title="<?php echo $product['name']; ?>" alt="<?php echo $product['name']; ?>" /></a>' + '</div>';
}

(or just add the "else" segment).
Notice - the path I gave for the image placeholder is where my placeholder is (no_image.jpg). You should choose the right path for your pic of course.
This will work on category pages. If you have other pages that display products (like "manufacturers-info.tpl for example) you need to find the lines in those file which match those I've mentioned above, and do the same thing.
Hope this was helpful.

I don't have these lines in my product.tpl I'm using OCTheme2.

JNeuhoff wrote:

cabicon wrote:Hey Guys.

Getting this error msg.

Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '=52,0,'','','','','','','',5,'Multimeter DMM 902 4mm probe',0,'',1,389,0,NOW(),N' at line 1
Error No: 1064
INSERT INTO `oc_product` (`product_id`,`quantity`,`sku`,`upc`,`ean`,`jan`,`isbn`,`mpn`,`location`,`stock_status_id`,`model`,`manufacturer_id`,`image`,`shipping`,`price`,`points`,`date_added`,`date_modified`,`date_available`,`weight`,`weight_class_id`,`status`,`tax_class_id`,`viewed`,`length`,`width`,`height`,`length_class_id`,`sort_order`,`subtract`,`minimum`) VALUES (=52,0,'','','','','','','',5,'Multimeter DMM 902 4mm probe',0,'',1,389,0,NOW(),NOW(),NOW(),0,1,1,9,0,0,0,0,'1','1','1','1'); in /hsphere/local/home/cabicon/test.test/xto/system/database/mysql.php on line 49

I think ive tried everything, but nothing works.. Please help me..

and happy new year

Regards

Wrong product_id, it should be an integer value, not something like '=52'.

From there, select 'Top Administrator', then click on the 'Edit' link to the right.
This will open up an edit window with multichoice dropdown lists for 'Access' and 'Modify' rights.
In both of them, you'll see a new entry for 'tool/export' which you can select by clicking
on their check boxes.

bertjeb wrote: I'm not able to find these options, after setting select all I still don't have access to the tool.

JNeuhoff wrote:
Looks like you haven't uploaded all the files from the admin folder.

bertjeb wrote:

JNeuhoff wrote:
Looks like you haven't uploaded all the files from the admin folder.

Thank you for your replay I copied everything again but it didn't change. Any other suggestions or specific files where I need to look for?

Many thanks!