Use our new Export/Import tool V2.18 which supportss incremental imports. Do an export first with this new version as the spreadsheet format is different.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Dear all,
I having problem with this tool. My products are missing - it disappeared.
As first I exported product list then I imported (Deleted all old data before Import).
And now I can't see then in admin panel - but they are displaying on web and in xls file while exporting again.
Please help me. How can I recover produt list ?
http://ortopediko.pl/import-export-tool.jpg
//Best regards
Przemek
I having problem with this tool. My products are missing - it disappeared.
As first I exported product list then I imported (Deleted all old data before Import).
And now I can't see then in admin panel - but they are displaying on web and in xls file while exporting again.
Please help me. How can I recover produt list ?
http://ortopediko.pl/import-export-tool.jpg
//Best regards
Przemek
Dear all,
I found out this issue is conected to multilanguage options.
After import, all product data in table: "oc_product_description" exist but only for 1 language - this is the reason I can't see product list in admin panel.
After I copied all rows in table "oc_product_description" with different "language_id" parameter, products appered.
Please help me. Why the tool is not working ?
I found out this issue is conected to multilanguage options.
After import, all product data in table: "oc_product_description" exist but only for 1 language - this is the reason I can't see product list in admin panel.
After I copied all rows in table "oc_product_description" with different "language_id" parameter, products appered.
Please help me. Why the tool is not working ?
If your admin language is different from your default frontend language, then yes, you'd have to specify your product and category descriptions (name, description etc) in both languages.wilek666 wrote:Dear all,
I found out this issue is conected to multilanguage options.
After import, all product data in table: "oc_product_description" exist but only for 1 language - this is the reason I can't see product list in admin panel.
After I copied all rows in table "oc_product_description" with different "language_id" parameter, products appered.
Please help me. Why the tool is not working ?
See also the discussion on this at https://github.com/opencart/opencart/issues/2085
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Dear JNeuhoff,
Thank you.
After I changed admin language to same as default frontend language, this tool works like a charm. Great extention.
Thank you.
After I changed admin language to same as default frontend language, this tool works like a charm. Great extention.
Hi JNeuhoff,JNeuhoff wrote:Your additional fields such as tyre_type etc are not part of a standard OpenCart.
You have 2 choices:
1) Add support for these additional fields youself in file admin/model/tool/export.php
2) Or I can do it for you for a small charge, send me a PM if interested, with details.
I too have an extension to products that I require to export/import. I am a complete novice so wouldn't know where to start to add support to additional fields in the export.php. How much would you charge to do this please?
Many thanks
Send me a PM with details about yoiur additional fields (name,type) in your DB that need support in the Export/Import tool, and I can work out a quote.Tinkerbe11 wrote: Hi JNeuhoff,
I too have an extension to products that I require to export/import. I am a complete novice so wouldn't know where to start to add support to additional fields in the export.php. How much would you charge to do this please?
Many thanks
Hello!
I use OpenCart 1.5.6.1
I installed this tool
Export/Import Tool V2.x OpenCart 1.5.1-1.5.6.x
http://www.mhccorp.com/news/new-export-import-tool-v2
according to the rules in the readme file
but when I load the page from the admin panel via the menu
System -> Export/Import
I get the error
'Permission Denied!'
How do I solve the problem?
Thank you
I use OpenCart 1.5.6.1
I installed this tool
Export/Import Tool V2.x OpenCart 1.5.1-1.5.6.x
http://www.mhccorp.com/news/new-export-import-tool-v2
according to the rules in the readme file
but when I load the page from the admin panel via the menu
System -> Export/Import
I get the error
'Permission Denied!'
How do I solve the problem?
Thank you
Please follow the instructions in the readme.txt file:
Step 3)
Before using this newly installed Export/Import feature for the first time, you must set the
access rights for top administrator as follows:
In the admin interface, choose
System > Users > User Group
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.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Hi, I hAve tried to reply back to your PM but it will not leave my outbox, I'm new to this forum and not sure how to get the message to send.
hi
OC v1.5.3.1, tool opencart-1-5-1-to-1-5-6-x-export-import-multilingual-2-20.zip
VQmos installed, works.
All files uploaded. in System > Users > User Group Top Administrator selected but not see 'tool/export_import' entry.
What I had missed?
OC v1.5.3.1, tool opencart-1-5-1-to-1-5-6-x-export-import-multilingual-2-20.zip
VQmos installed, works.
All files uploaded. in System > Users > User Group Top Administrator selected but not see 'tool/export_import' entry.
What I had missed?
Attachments
oc_ie.png (182.63 KiB) Viewed 6127 times
That works, which is good. The problem with that is I need it so my client can just export the file, then change things he needs to change, then re-import it. Since it exports with values of "1" not "true" that doesn't work. This is the case with the category "status enabled", category "top" and products "status enabled". That is how it worked on previous versions I've used. For now I just changed the model file myself, but thought you'd like to know since I do think that is the intended behavior.
Thanks for the quick help!
Thanks for the quick help!
Hi,
I have 1.5.6.4 and have just loaded that version of the tool.
It seems to work fine as I can see all the info in the xls file we loaded.
I would like to know how do we delele these categories and products from the site as they are just the samples that came with it.
I want to then import our new cats and prods.
I already have them on another 1.5.2.1 site.
Would I use this tool to export them from that site then import them into the new site, or would I import the whole sql or ?
Thanks
oz
I have 1.5.6.4 and have just loaded that version of the tool.
It seems to work fine as I can see all the info in the xls file we loaded.
I would like to know how do we delele these categories and products from the site as they are just the samples that came with it.
I want to then import our new cats and prods.
I already have them on another 1.5.2.1 site.
Would I use this tool to export them from that site then import them into the new site, or would I import the whole sql or ?
Thanks
oz
I am also getting problems using the import/export tool in a brand new install of OC 2.0.1.2 - the only other extension installed is vQmod as per the OC installation guide.
Trying to upload the import export tool via the Extensions Installer I get the error -
Internal Server Error
Internal Server Error
<HTML>
<HEAD>
<TITLE>500 Internal Server Error</TITLE>
</HEAD><BODY>
<H1>Internal Server Error</H1>
The server encountered an internal error or
misconfiguration and was unable to complete
your request.<P>
Please contact the server administrator to inform of the time the error occurred
and of anything you might have done that may have
caused the error.<P>
More information about this error may be available
in the server error log.<P>
<HR>
<ADDRESS>
Web Server at mydomain.com
</ADDRESS>
</BODY>
</HTML>
In the server error logs, I see the error -
mod_fcgid: HTTP request length 135223 (so far) exceeds MaxRequestLen (131072), referer: http://mydomain.com/tradeshop/newnamefo ... 278dba34da
This is running on a Linux / Apache / PHP / MySQL VPS. I have downloaded the correct version of the import/export tool.
I have no idea how to resolve this - can you give me a clue please?
Thanks in advance.
Trying to upload the import export tool via the Extensions Installer I get the error -
Internal Server Error
Internal Server Error
<HTML>
<HEAD>
<TITLE>500 Internal Server Error</TITLE>
</HEAD><BODY>
<H1>Internal Server Error</H1>
The server encountered an internal error or
misconfiguration and was unable to complete
your request.<P>
Please contact the server administrator to inform of the time the error occurred
and of anything you might have done that may have
caused the error.<P>
More information about this error may be available
in the server error log.<P>
<HR>
<ADDRESS>
Web Server at mydomain.com
</ADDRESS>
</BODY>
</HTML>
In the server error logs, I see the error -
mod_fcgid: HTTP request length 135223 (so far) exceeds MaxRequestLen (131072), referer: http://mydomain.com/tradeshop/newnamefo ... 278dba34da
This is running on a Linux / Apache / PHP / MySQL VPS. I have downloaded the correct version of the import/export tool.
I have no idea how to resolve this - can you give me a clue please?
Thanks in advance.
I tried to import the 1.5.2.1. db into the 1.5.6.4 site however I got this error..
Would this be because xls is the 1.5.6.1 spreadsheet and xlsx is the 1.5.6.4 one.
I opened the xls in Excel then saved it as xlsx then tried to import it but still got the same message.
What is the best way for me to import the 1.5.2.1 into the 1.5.6.4
oz
Code: Select all
'Uploaded file is not a valid spreadsheet file or its values are not in the expected formats!'Code: Select all
From the OC Error logs I get..
2015-03-18 13:28:02 - Export/Import: Invalid number of worksheets, 8 worksheets expectedCode: Select all
Error log also said the same:
2015-03-18 14:50:50 - Export/Import: Invalid number of worksheets, 8 worksheets expectedCode: Select all
I noticed that the..
1.5.6.4 db has
Categories,Products,AdditionalImages,Options,Attributes,Specials,Discounts,Rewards
and the
1.5.2.1.db has
Categories,Products,Options,Attributes,Specials,Discounts,Rewards
oz
Do an Export first off your OpenCrt 1.5.6.4, and then use that format.
The sporeadsheet formats are different between OpenCart versions.
The sporeadsheet formats are different between OpenCart versions.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
@J.Neuhoff: First I thank you for providing this great extension free of cost and I appreciate the time and effort you have put into the making of this mod.
I have just installed the latest ver2-26-OC1564 and I exported category and products from 1 oc1564 shop(all default) to another oc1564 shop(all default), the option I choose for exporting was all default that is 1-category for category export and 2- Products (including product data, options, specials, discounts, rewards and attributes) for products export and then imported the same to a fresh new install of OC-1564(all default), now the category import using option-2-No (Delete all old data before Import) went through properly and all was good. In product import I choose the same option-2-No(Delete all old data before Import) and did the import but I get error message
"Uploaded spreadsheet file has validation errors!
See also 'System > Error Logs' for more details.
No server data has been changed."
and the error logs shows the following:
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Screensize' used in worksheet 'ProductOptions'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Color' used in worksheet 'ProductOptions'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Color' used in worksheet 'ProductOptions'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Length' used in worksheet 'ProductOptions'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Length' used in worksheet 'ProductOptions'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Length' used in worksheet 'ProductOptions'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Color' used in worksheet 'ProductOptions'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Length' used in worksheet 'ProductOptions'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Length' used in worksheet 'ProductOptions'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Length' used in worksheet 'ProductOptions'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Length' used in worksheet 'ProductOptions'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Screensize' used in worksheet 'ProductOptionValues'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Screensize' used in worksheet 'ProductOptionValues'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Screensize' used in worksheet 'ProductOptionValues'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Color' used in worksheet 'ProductOptionValues'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Color' used in worksheet 'ProductOptionValues'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Color' used in worksheet 'ProductOptionValues'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Color' used in worksheet 'ProductOptionValues'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Length' used in worksheet 'ProductOptionValues'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Length' used in worksheet 'ProductOptionValues'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Length' used in worksheet 'ProductOptionValues'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Length' used in worksheet 'ProductOptionValues'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Length' used in worksheet 'ProductOptionValues'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Length' used in worksheet 'ProductOptionValues'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Length' used in worksheet 'ProductOptionValues'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Color' used in worksheet 'ProductOptionValues'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Color' used in worksheet 'ProductOptionValues'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Length' used in worksheet 'ProductOptionValues'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Length' used in worksheet 'ProductOptionValues'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Length' used in worksheet 'ProductOptionValues'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Length' used in worksheet 'ProductOptionValues'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Length' used in worksheet 'ProductOptionValues'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Length' used in worksheet 'ProductOptionValues'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Length' used in worksheet 'ProductOptionValues'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Length' used in worksheet 'ProductOptionValues'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Length' used in worksheet 'ProductOptionValues'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Length' used in worksheet 'ProductOptionValues'!
I don't know why the error should come at all when I have selected the option "Delete all old data before Import" and anybody who does an import/export is bound to have new data so then why the error should come at all ?
Anyway then I deleted all the "Products" and all "options" from admin but still I am getting the error message as given above, no matter if I select option-1- Yes(Update and/or add data) or option-2-No(Delete all old data before Import).
I would like you help in this matter urgently.
Thank You.
I have just installed the latest ver2-26-OC1564 and I exported category and products from 1 oc1564 shop(all default) to another oc1564 shop(all default), the option I choose for exporting was all default that is 1-category for category export and 2- Products (including product data, options, specials, discounts, rewards and attributes) for products export and then imported the same to a fresh new install of OC-1564(all default), now the category import using option-2-No (Delete all old data before Import) went through properly and all was good. In product import I choose the same option-2-No(Delete all old data before Import) and did the import but I get error message
"Uploaded spreadsheet file has validation errors!
See also 'System > Error Logs' for more details.
No server data has been changed."
and the error logs shows the following:
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Screensize' used in worksheet 'ProductOptions'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Color' used in worksheet 'ProductOptions'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Color' used in worksheet 'ProductOptions'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Length' used in worksheet 'ProductOptions'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Length' used in worksheet 'ProductOptions'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Length' used in worksheet 'ProductOptions'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Color' used in worksheet 'ProductOptions'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Length' used in worksheet 'ProductOptions'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Length' used in worksheet 'ProductOptions'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Length' used in worksheet 'ProductOptions'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Length' used in worksheet 'ProductOptions'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Screensize' used in worksheet 'ProductOptionValues'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Screensize' used in worksheet 'ProductOptionValues'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Screensize' used in worksheet 'ProductOptionValues'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Color' used in worksheet 'ProductOptionValues'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Color' used in worksheet 'ProductOptionValues'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Color' used in worksheet 'ProductOptionValues'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Color' used in worksheet 'ProductOptionValues'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Length' used in worksheet 'ProductOptionValues'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Length' used in worksheet 'ProductOptionValues'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Length' used in worksheet 'ProductOptionValues'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Length' used in worksheet 'ProductOptionValues'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Length' used in worksheet 'ProductOptionValues'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Length' used in worksheet 'ProductOptionValues'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Length' used in worksheet 'ProductOptionValues'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Color' used in worksheet 'ProductOptionValues'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Color' used in worksheet 'ProductOptionValues'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Length' used in worksheet 'ProductOptionValues'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Length' used in worksheet 'ProductOptionValues'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Length' used in worksheet 'ProductOptionValues'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Length' used in worksheet 'ProductOptionValues'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Length' used in worksheet 'ProductOptionValues'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Length' used in worksheet 'ProductOptionValues'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Length' used in worksheet 'ProductOptionValues'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Length' used in worksheet 'ProductOptionValues'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Length' used in worksheet 'ProductOptionValues'!
2015-05-02 23:01:56 - Export/Import: Undefined option_name 'Length' used in worksheet 'ProductOptionValues'!
I don't know why the error should come at all when I have selected the option "Delete all old data before Import" and anybody who does an import/export is bound to have new data so then why the error should come at all ?
Anyway then I deleted all the "Products" and all "options" from admin but still I am getting the error message as given above, no matter if I select option-1- Yes(Update and/or add data) or option-2-No(Delete all old data before Import).
I would like you help in this matter urgently.
Thank You.
Regards,
Sun Systems
Industrial Electronics and Instrumentation
Who is online
Users browsing this forum: No registered users and 10 guests
