Anyone here have a solution to this issue? Thanks.
Not enough details to replicate your error. Please read our FAQ page on how to transfer data from an old to a newer OpenCart version.drjawn1962 wrote: ↑Thu Jun 11, 2020 10:37 pmUsing OC v2.0.1.1. When importing using Export/Import v3.22 product descriptions are being duplicated 11 times. Products were exported using Export/Import from OC v1.5.6.4.
Anyone here have a solution to this issue? Thanks.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
No, it's not a known issue, and we are unable to reproduce this error. Try LibreOffice Calc instead of MS Excel to open the XLSX file.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Thanks for the quick response.JNeuhoff wrote: ↑Thu Jun 11, 2020 11:58 pmNot enough details to replicate your error. Please read our FAQ page on how to transfer data from an old to a newer OpenCart version.drjawn1962 wrote: ↑Thu Jun 11, 2020 10:37 pmUsing OC v2.0.1.1. When importing using Export/Import v3.22 product descriptions are being duplicated 11 times. Products were exported using Export/Import from OC v1.5.6.4.
Anyone here have a solution to this issue? Thanks.
Not sure what furthers details you're looking for. However, looking at the exported spreadsheet I see where the product descriptions are duplicated. So I guess it's safe to assume that exporting is the issue and the importing worked properly, I did have to add 2 headers to the spreadsheet in the new OC version.
I used opencart-1-5-1-to-1-5-6-x-export-import-multilingual-3-22 to export, is there a support thread here that I could be reading?
Thanks.
Attachments
Capture.JPG (246.99 KiB) Viewed 9837 times
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Yes, I image it would be difficult to replicate when you don't have the same data I have. I was hoping someone would have experienced this issue and resolved it.
Using LibreOffice Calc, the exported spreadsheet looks the same.
Thanks again.
Did new export and opened it in OfficeLibre Calc. The duplication is not there! Thanks.drjawn1962 wrote: ↑Fri Jun 12, 2020 11:17 pmYes, I image it would be difficult to replicate when you don't have the same data I have. I was hoping someone would have experienced this issue and resolved it.
Using LibreOffice Calc, the exported spreadsheet looks the same.
Thanks again.
Thanks for the quick response. I will be able to try LibreOffice Calc shortly.
I import the file I just exported I get the following log messages
Code: Select all
2020-06-15 20:24:01 - PHP Warning: DOMDocument::loadHTML(): Invalid char in CDATA 0x3 in Entity, line: 2 in /var/www/vhosts/<<DOMAIN>>/httpdocs/system/library/export_import/Classes/PHPExcel/Reader/HTML.php on line 495
2020-06-15 20:24:01 - PHP Warning: DOMDocument::loadHTML(): Invalid char in CDATA 0x4 in Entity, line: 2 in /var/www/vhosts/<<DOMAIN>>/httpdocs/system/library/export_import/Classes/PHPExcel/Reader/HTML.php on line 495
2020-06-15 20:24:01 - PHP Warning: DOMDocument::loadHTML(): Invalid char in CDATA 0x14 in Entity, line: 2 in /var/www/vhosts/<<DOMAIN>>/httpdocs/system/library/export_import/Classes/PHPExcel/Reader/HTML.php on line 495
2020-06-15 20:24:01 - Export/Import: Invalid worksheet names
I can't help you. Your generated XLSX file is corrupt, and you still haven't tried to open it with LibreOffice Calc which at least might show you why it is corrupted with an embedded error message.BinkFour wrote: ↑Tue Jun 16, 2020 4:26 amThanks for the quick response. I will be able to try LibreOffice Calc shortly.
I import the file I just exported I get the following log messages
Perhaps this gives a clue why the file is seemingly not valid after export.Code: Select all
2020-06-15 20:24:01 - PHP Warning: DOMDocument::loadHTML(): Invalid char in CDATA 0x3 in Entity, line: 2 in /var/www/vhosts/<<DOMAIN>>/httpdocs/system/library/export_import/Classes/PHPExcel/Reader/HTML.php on line 495 2020-06-15 20:24:01 - PHP Warning: DOMDocument::loadHTML(): Invalid char in CDATA 0x4 in Entity, line: 2 in /var/www/vhosts/<<DOMAIN>>/httpdocs/system/library/export_import/Classes/PHPExcel/Reader/HTML.php on line 495 2020-06-15 20:24:01 - PHP Warning: DOMDocument::loadHTML(): Invalid char in CDATA 0x14 in Entity, line: 2 in /var/www/vhosts/<<DOMAIN>>/httpdocs/system/library/export_import/Classes/PHPExcel/Reader/HTML.php on line 495 2020-06-15 20:24:01 - Export/Import: Invalid worksheet names
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
https://www.opencart.com/index.php?rout ... _license=0
Exported the products from the old site (opencart 1.5), and I want to import them on my new site (opencart 3).
When I want to import the products I get an error
Error Logs :
Export/Import: Invalid header in the Products worksheet
Please help me
Slightly different worksheet formats between OpenCart 1.5.x and 3.0.x releases, see our FAQ page on how to handle it.Emanuel.C wrote: ↑Wed Jun 17, 2020 7:23 pmI installed the module "Export/Import Tool"
Exported the products from the old site (opencart 1.5), and I want to import them on my new site (opencart 3).
When I want to import the products I get an error
Error Logs :
Export/Import: Invalid header in the Products worksheet
Please help me
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
I try to import the categories, but I get an error
Export/Import: Worksheet 'CategorySEOKeywords' cannot use category_id '59' because it is not listed in worksheet 'Categories'!
can you help me ?
thanks
So what exactly do you need help with? Either remove this worksheet line, or add the missing category with category_id=59 to the 'Categories' worksheet.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
I am using opencart version: 2.1.0.1
Attachments
error.PNG (7.65 KiB) Viewed 9289 times
==============================
https://aspirewebsolution.com/
Do an Export first, to see the exact format of the Products worksheet, and then use that one for your future Imports.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Libre (roughly translated) states the following: The data cannot be loaded because the maximum numbers of characters in a cell is exceededJNeuhoff wrote: ↑Tue Jun 16, 2020 4:50 pmI can't help you. Your generated XLSX file is corrupt, and you still haven't tried to open it with LibreOffice Calc which at least might show you why it is corrupted with an embedded error message.BinkFour wrote: ↑Tue Jun 16, 2020 4:26 amThanks for the quick response. I will be able to try LibreOffice Calc shortly.
I import the file I just exported I get the following log messages
Perhaps this gives a clue why the file is seemingly not valid after export.Code: Select all
2020-06-15 20:24:01 - PHP Warning: DOMDocument::loadHTML(): Invalid char in CDATA 0x3 in Entity, line: 2 in /var/www/vhosts/<<DOMAIN>>/httpdocs/system/library/export_import/Classes/PHPExcel/Reader/HTML.php on line 495 2020-06-15 20:24:01 - PHP Warning: DOMDocument::loadHTML(): Invalid char in CDATA 0x4 in Entity, line: 2 in /var/www/vhosts/<<DOMAIN>>/httpdocs/system/library/export_import/Classes/PHPExcel/Reader/HTML.php on line 495 2020-06-15 20:24:01 - PHP Warning: DOMDocument::loadHTML(): Invalid char in CDATA 0x14 in Entity, line: 2 in /var/www/vhosts/<<DOMAIN>>/httpdocs/system/library/export_import/Classes/PHPExcel/Reader/HTML.php on line 495 2020-06-15 20:24:01 - Export/Import: Invalid worksheet names
Does this give more information on the reason of the error?
See also this: https://support.microsoft.com/en-us/off ... _2016-2013
Juergen
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Users browsing this forum: No registered users and 73 guests