OpenCart Community

Posted: **Tue Apr 28, 2015 10:38 pm**

DMTGMBH wrote:Import of category description multilingual doesn't work.
I have two languages installed and have in my table the columns:
description(de)
description(en)

I tried inserting in one or both:
1. some example text
2. some example text
3. some example text 
4. 

All is imported well except the description.
Any ideas?

Unable to reproduce your error, sorry.

Posted: **Tue Apr 28, 2015 10:40 pm**

dkhowawrd wrote:I just installed this mod. Installation went fine. No problems.

Followed the directions exactly. Did the refresh thing in the Modifications area.

Went to Users.Groups.Administrators and looked for tool import/export. Nothing there.

Went to Tools. The tool shows up in the menu but will not allow me access. Says to check with system administrator for permissions. No way to set permissions because it isn't showing up in the lists.

I know this has been an issue in the past but I can not find any answer to the problem in the forum posts.

Anyone have any suggestions or could the author chime in here with a solution?

Again, un able to reproduce your error. It has been successfully tested on an OpenCart 2.0.x server.

Looks more like an issue with your FTP settings, maybe wrong OpenCart root folder?

Posted: **Tue Apr 28, 2015 10:52 pm**

dkhowawrd wrote:Went to Users.Groups.Administrators and looked for tool import/export. Nothing there.

yet

dkhowawrd wrote:Went to Tools. The tool shows up in the menu but will not allow me access.

A little confused by this, it's there but it is not there?

Have you gone to
Dashboard > System > Users > User Group
Click the edit icon for your admin username.
Click Select All link for both boxes, or scroll down Access Permission and find
tool/backup and place a tick, do the same in the next box below Modify Permission.
Click the save Icon in the near top right of the page.

Then check Dashboard > Tools > Backup/Restore

Posted: **Thu Apr 30, 2015 5:17 am**

Edit: This is solved, it was being caused by a problem in OC itself, not the Export/Import tool.

For posterity: In OC version 2.0.0.0 the XML for modifications was stored in the code column of the modifications table. In newer versions, for no apparent reason, this column is now the title and it's char limit has been changed to 64 thus truncating the code in the database and making it invalid XML. This effectively breaks any modification written before the change.

But it doesn't break until the the next time the refresh button is clicked and the XML is read. Which, in this case, was months later.

I imagine this was in a release note somewhere so I probably shouldn't be annoyed... It's just the kind of non backwards compatible change that you should be able to count on never happening in a minor version update of a non alpha or beta application.

Anyway, no problem at all in Export/Import tool, all is well after fixing the above problem with a different modification.

[/edit]

We've been using the Export/Import tool for some time without problems in OC 2.

However after installing the latest version I'm getting this error when trying to refresh modifications in OC admin:
Call to a member function getElementsByTagName() on a non-object in /home/xxxxx/public_html/store/admin/controller/extension/modification.php on line 145

This continues to happen even after removing the Export/Import tool! I don't have time at the moment to go through the code to figure out what's going on. Any help would be appreciated.

Posted: **Fri May 01, 2015 9:17 pm**

You can try this one http://codelandriver.com/opencart-modul ... xport.html

Posted: **Sun May 03, 2015 9:03 pm**

I have had two problems one is a memory error regarding the file size for imort. File size is 1658kb and there are about 4500 products.What is the max file size or number of products you can upload at one time? I tried a sample size of just 10 products which came up with your data has been imported successfully but when I look at products they are nowhere to be found? I'm new to Opencart so not sure where to look other then under the products option? I checked under status enabled and disabled. Where would they go if they don't appear in the list?

I wanted to ask two other questions.

1) Will the import create categories like woocommerce imports do or do you have to create them first to import product data. I did make sure I had a category set up for the 10 products that supposedly uploaded succesfully.

") There is no field mapping from excel to opencart as part of the import procedure so does this mean the data has to be preset for opencart in excel for it to import correctly into opencart using your program?. The data is coming from another ecommerce software.

Thank you in advance

Posted: **Tue May 05, 2015 4:19 pm**

You will need to contact your host and ask them to increase your file upload limit.

If you have access to your php.ini file/s root and public_html try adding the following to it if not already exist...

Code: Select all

upload_max_filesize = 100M
post_max_size = 100M

Posted: **Tue May 05, 2015 5:01 pm**

fundesigns wrote:I have had two problems one is a memory error regarding the file size for imort. File size is 1658kb and there are about 4500 products.What is the max file size or number of products you can upload at one time? I tried a sample size of just 10 products which came up with your data has been imported successfully but when I look at products they are nowhere to be found? I'm new to Opencart so not sure where to look other then under the products option? I checked under status enabled and disabled. Where would they go if they don't appear in the list?

I wanted to ask two other questions.

1) Will the import create categories like woocommerce imports do or do you have to create them first to import product data. I did make sure I had a category set up for the 10 products that supposedly uploaded succesfully.

") There is no field mapping from excel to opencart as part of the import procedure so does this mean the data has to be preset for opencart in excel for it to import correctly into opencart using your program?. The data is coming from another ecommerce software.

Thank you in advance

You need to import your categories first. The same is true for the option definitions. Then import your products, you may have to do the latter in smaller batches if you experience memory_limit issues.

To see the exact format for the option definitions, category definitions, and products, do an Export first and use the resulting spreadsheets to overwrite with your own data.

Posted: **Tue May 05, 2015 10:30 pm**

Hi,
I'm using the tool to migrate data from a working V1.5 shop to a new V2 shop. Export from the 1.5 shop went fine but I'm unable to import the data into the new v2 shop. The error I'm getting is :-

Failed to load 'C:\Windows\Temp\phpA204.tmp' as a DOM Document
No server data has been changed.

Does anyone know how to fix this?

Posted: **Tue May 05, 2015 11:28 pm**

Hi!

First of all thank you for this great extension! Brilliant work!

I just installed it and managed to export the categories from my 1.6.4 store, but when I try to upload them to the new 2.0.2.0 store I get the following error:

Code: Select all

2015-05-05 18:03:43 - Export/Import: Invalid header in the Categories worksheet

How can I get rid of this error ?

Thanks!

Posted: **Wed May 06, 2015 2:18 am**

For both of the previous posts!

You should make sure the categories, options, images, etc are all ftp'd to the existing site location. Then export a sample product list and categories xls. Delete all the existing product info from these. Make sure the products have the new category IDs as well. Once you do that you can migrate your old data into the new formated xls and upload.

Posted: **Wed May 06, 2015 5:28 pm**

Ok, I exported a categories xlsx file from the new v2 shop. Deleted the data and copied the data into the matching columns on this spreadsheet from the v1.5 exported spreadsheet. Logged into the new v2 admin and deleted all the categories. When I tried to import this new spreadsheet I got same error.

Any more suggestions on a fix?

Posted: **Wed May 06, 2015 7:04 pm**

dynapta wrote:Ok, I exported a categories xlsx file from the new v2 shop. Deleted the data and copied the data into the matching columns on this spreadsheet from the v1.5 exported spreadsheet. Logged into the new v2 admin and deleted all the categories. When I tried to import this new spreadsheet I got same error.

Any more suggestions on a fix?

Your error has nothing to do with the Export/Import tool. It's an access rights issue for your C:\Windows\Temp\ folder, no write permission for that folder.

Posted: **Wed May 06, 2015 11:27 pm**

Thanks JNeuhoff,

Spot on I had a missing permission on the Temp folder. Once I added the IUSR account to the permissions the import worked!

Posted: **Tue May 12, 2015 2:52 pm**

Hi JNeuhoff, can I have purchase filter options for this module? I really want this options because my products have many filters. Thanks!

Posted: **Wed May 13, 2015 9:59 pm**

Hi,

probably it is a known issue, but i cant find a solution in forum.
After the import using this tool one can see new categories over web interface ... BUT ALL categories in Catalog->Categories of the Admin UI are disappeared. Same happened with products after import. I checked the DB, new products are in DB, openCart can see them, but Admin UI shows empty Product list. There were no errors in the log.
Can smbd help me?

Posted: **Thu May 14, 2015 2:20 am**

I installed OC 2.0.2.0 and only this export/import extension.
When I export, it works great, I can see all the demo data that is the clean install of OC.

That exported file I open and copy/past some other data in in.
I make sure every line is filled in like the demo data.

This error I get when I'm trying to upload the xlsx file.

2015-05-13 20:15:12 - PHP 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 ''A10U',11,'',1,40,0,'2009-02-03 16:06:50','2011-09-30 01:05:39','2009-02-03',0,1' at line 1 Error No: 1064 INSERT INTO `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 (28,12,'','','','','','','',,'A10U',11,'',1,40,0,'2009-02-03 16:06:50','2011-09-30 01:05:39','2009-02-03',0,1,1,9,0,0,0,0,'1','1','1','1'); in /home/users/A003196/poortautomatisatie.eu/maasland.poortautomatisatie.eu/system/library/db/mysqli.php on line 41
2015-05-13 20:15:12 - PHP 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 ''AP10U',11,'',1,42,0,'2009-02-03 16:42:17','2011-09-30 01:06:08','2009-02-03',0,' at line 1 Error No: 1064 INSERT INTO `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 (29,13,'','','','','','','',,'AP10U',11,'',1,42,0,'2009-02-03 16:42:17','2011-09-30 01:06:08','2009-02-03',0,1,1,9,0,0,0,0,'1','1','1','1'); in /home/users/system/library/db/mysqli.php on line 41
2015-05-13 20:15:12 - PHP 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 ''AI10U',11,'',1,45,0,'2009-02-03 16:59:00','2011-09-30 01:05:23','2009-02-03',0,' at line 1 Error No: 1064 INSERT INTO `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 (30,14,'','','','','','','',,'AI10U',11,'',1,45,0,'2009-02-03 16:59:00','2011-09-30 01:05:23','2009-02-03',0,1,1,9,0,0,0,0,'1','1','1','1'); in /home/users/A003196/poortautomatisatie.eu/maasland.poortautomatisatie.eu/system/library/db/mysqli.php on line 41
2015-05-13 20:15:12 - PHP 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 ''API10U',11,'',1,47,0,'2009-02-03 17:00:10','2011-09-30 01:06:00','2009-02-03',0' at line 1 Error No: 1064 INSERT INTO `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 (31,15,'','','','','','','',,'API10U',11,'',1,47,0,'2009-02-03 17:00:10','2011-09-30 01:06:00','2009-02-03',0,1,1,9,0,0,0,0,'1','1','1','1'); in /home/users/system/library/db/mysqli.php on line 41
2015-05-13 20:15:12 - PHP 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 ''R10E',11,'',1,55,0,'2009-02-03 17:07:26','2011-09-30 01:07:22','2009-02-03',0,1' at line 1 Error No: 1064 INSERT INTO `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 (32,16,'','','','','','','',,'R10E',11,'',1,55,0,'2009-02-03 17:07:26','2011-09-30 01:07:22','2009-02-03',0,1,1,9,0,0,0,0,'1','1','1','1'); in /home/users/system/library/db/mysqli.php on line 41

Posted: **Thu May 14, 2015 2:58 am**

SVN wrote:I installed OC 2.0.2.0 and only this export/import extension.
When I export, it works great, I can see all the demo data that is the clean install of OC.

That exported file I open and copy/past some other data in in.
I make sure every line is filled in like the demo data.

This error I get when I'm trying to upload the xlsx file.

2015-05-13 20:15:12 - PHP 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 ''A10U',11,'',1,40,0,'2009-02-03 16:06:50','2011-09-30 01:05:39','2009-02-03',0,1' at line 1 Error No: 1064 INSERT INTO `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 (28,12,'','','','','','','',,'A10U',11,'',1,40,0,'2009-02-03 16:06:50','2011-09-30 01:05:39','2009-02-03',0,1,1,9,0,0,0,0,'1','1','1','1'); in /home/users/A003196/poortautomatisatie.eu/maasland.poortautomatisatie.eu/system/library/db/mysqli.php on line 41
2015-05-13 20:15:12 - PHP 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 ''AP10U',11,'',1,42,0,'2009-02-03 16:42:17','2011-09-30 01:06:08','2009-02-03',0,' at line 1 Error No: 1064 INSERT INTO `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 (29,13,'','','','','','','',,'AP10U',11,'',1,42,0,'2009-02-03 16:42:17','2011-09-30 01:06:08','2009-02-03',0,1,1,9,0,0,0,0,'1','1','1','1'); in /home/users/system/library/db/mysqli.php on line 41

You forgot to set the stock_status_id. On a standard OpenCart 2.0.x
install, it can be one of the following numeric values:

5 (Out Of Stock)
6 (2-3 Days)
7 (In Stock)
8 (Pre-Order)

Posted: **Thu May 14, 2015 3:01 am**

oc4 wrote:Hi,

probably it is a known issue, but i cant find a solution in forum.
After the import using this tool one can see new categories over web interface ... BUT ALL categories in Catalog->Categories of the Admin UI are disappeared. Same happened with products after import. I checked the DB, new products are in DB, openCart can see them, but Admin UI shows empty Product list. There were no errors in the log.
Can smbd help me?

You are probably using langauges for the front end default language and the admin backend language, please fill in your categories and products data for all languages.

Posted: **Thu May 14, 2015 2:17 pm**

I upload the extension and it was fine, then went to modifications and click refresh and got the

"500 - Internal server error.
There is a problem with the resource you are looking for, and it cannot be displayed."

What does this mean?

When I went to change permissions I do see the tools/export_import and selected it. But I do not see export_import in "Tools." or anywhere else.

I know I need to refresh the modification in order for the extension to show up but I can't because it only gives me that 500 internal error.

Help??

OpenCart Community

Multilingual Export/Import for OpenCart 2.x / 3.x / 4.x

Re: [RELEASED] Multilingual Export/Import for OpenCart 2.x

Re: [RELEASED] Multilingual Export/Import for OpenCart 2.x

Re: [RELEASED] Multilingual Export/Import for OpenCart 2.x

Re: [RELEASED] Multilingual Export/Import for OpenCart 2.x

Re: [RELEASED] Multilingual Export/Import for OpenCart 2.x

Re: [RELEASED] Multilingual Export/Import for OpenCart 2.x

Re: [RELEASED] Multilingual Export/Import for OpenCart 2.x

Re: [RELEASED] Multilingual Export/Import for OpenCart 2.x

Re: [RELEASED] Multilingual Export/Import for OpenCart 2.x

Re: [RELEASED] Multilingual Export/Import for OpenCart 2.x

Re: [RELEASED] Multilingual Export/Import for OpenCart 2.x

Re: [RELEASED] Multilingual Export/Import for OpenCart 2.x

Re: [RELEASED] Multilingual Export/Import for OpenCart 2.x

Re: [RELEASED] Multilingual Export/Import for OpenCart 2.x

Re: [RELEASED] Multilingual Export/Import for OpenCart 2.x

Re: [RELEASED] Multilingual Export/Import for OpenCart 2.x

Re: [RELEASED] Multilingual Export/Import for OpenCart 2.x

Re: [RELEASED] Multilingual Export/Import for OpenCart 2.x

Re: [RELEASED] Multilingual Export/Import for OpenCart 2.x

Re: [RELEASED] Multilingual Export/Import for OpenCart 2.x