Unable to reproduce your error, sorry.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. <p>some example text</p>
3. <p>some example text<br/></p>
4. <p><br/></p>
All is imported well except the description.
Any ideas?
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Again, un able to reproduce your error. It has been successfully tested on an OpenCart 2.0.x server.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?
Looks more like an issue with your FTP settings, maybe wrong OpenCart root folder?
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
yetdkhowawrd wrote:Went to Users.Groups.Administrators and looked for tool import/export. Nothing there.
A little confused by this, it's there but it is not there?dkhowawrd wrote:Went to Tools. The tool shows up in the menu but will not allow me access.
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
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.
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
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
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.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
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.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
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?
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
Thanks!
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.
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.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?
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
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?
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<br />Error No: 1064<br />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<br />Error No: 1064<br />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<br />Error No: 1064<br />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<br />Error No: 1064<br />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<br />Error No: 1064<br />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
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<br />Error No: 1064<br />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<br />Error No: 1064<br />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)
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
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.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?
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
"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??
Users browsing this forum: No registered users and 12 guests