Post by BinkFour » Wed Jun 10, 2020 3:14 am

After the most recent update on the module to V3.22 on Opencart 3.0.2 I keep getting xlsx files that are invalid. Is this a known issue?

New member

Posts

Joined
Mon Jun 10, 2013 1:47 am


Post by drjawn1962 » Thu Jun 11, 2020 10:37 pm

Using 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.

New member

Posts

Joined
Fri Apr 24, 2020 5:40 am

Post by JNeuhoff » Thu Jun 11, 2020 11:58 pm

drjawn1962 wrote:
Thu Jun 11, 2020 10:37 pm
Using 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 enough details to replicate your error. Please read our FAQ page on how to transfer data from an old to a newer OpenCart version.

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig


User avatar
Guru Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by JNeuhoff » Fri Jun 12, 2020 12:00 am

BinkFour wrote:
Wed Jun 10, 2020 3:14 am
After the most recent update on the module to V3.22 on Opencart 3.0.2 I keep getting xlsx files that are invalid. Is this a known issue?
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


User avatar
Guru Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by drjawn1962 » Fri Jun 12, 2020 9:45 pm

JNeuhoff wrote:
Thu Jun 11, 2020 11:58 pm
drjawn1962 wrote:
Thu Jun 11, 2020 10:37 pm
Using 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 enough details to replicate your error. Please read our FAQ page on how to transfer data from an old to a newer OpenCart version.
Thanks for the quick response.

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

Capture.JPG (246.99 KiB) Viewed 9759 times

Last edited by drjawn1962 on Fri Jun 12, 2020 9:56 pm, edited 1 time in total.

New member

Posts

Joined
Fri Apr 24, 2020 5:40 am

Post by JNeuhoff » Fri Jun 12, 2020 9:53 pm

As I said, I am simply unable to replicate your error. Have you tried LibreOffice Calc?

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig


User avatar
Guru Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by drjawn1962 » Fri Jun 12, 2020 11:17 pm

JNeuhoff wrote:
Fri Jun 12, 2020 9:53 pm
As I said, I am simply unable to replicate your error. Have you tried LibreOffice Calc?
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.

New member

Posts

Joined
Fri Apr 24, 2020 5:40 am

Post by drjawn1962 » Fri Jun 12, 2020 11:26 pm

drjawn1962 wrote:
Fri Jun 12, 2020 11:17 pm
JNeuhoff wrote:
Fri Jun 12, 2020 9:53 pm
As I said, I am simply unable to replicate your error. Have you tried LibreOffice Calc?
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.

New member

Posts

Joined
Fri Apr 24, 2020 5:40 am

Post by apinango » Sun Jun 14, 2020 1:55 am

Hi, when I try to export my items the system show this error:

Trying to access array offset on value of type int

I'm using Opencart 3.0.3.3

thank you

Newbie

Posts

Joined
Tue Jan 31, 2017 9:30 am

Post by BinkFour » Tue Jun 16, 2020 4:26 am

JNeuhoff wrote:
Fri Jun 12, 2020 12:00 am
BinkFour wrote:
Wed Jun 10, 2020 3:14 am
After the most recent update on the module to V3.22 on Opencart 3.0.2 I keep getting xlsx files that are invalid. Is this a known issue?
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.
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
Perhaps this gives a clue why the file is seemingly not valid after export.

New member

Posts

Joined
Mon Jun 10, 2013 1:47 am


Post by JNeuhoff » Tue Jun 16, 2020 4:50 pm

BinkFour wrote:
Tue Jun 16, 2020 4:26 am
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
Perhaps this gives a clue why the file is seemingly not valid after export.
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.

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig


User avatar
Guru Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by Emanuel.C » Wed Jun 17, 2020 7:23 pm

I installed the module "Export/Import Tool"

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

New member

Posts

Joined
Mon Mar 25, 2019 5:26 pm

Post by JNeuhoff » Wed Jun 17, 2020 8:19 pm

Emanuel.C wrote:
Wed Jun 17, 2020 7:23 pm
I 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
Slightly different worksheet formats between OpenCart 1.5.x and 3.0.x releases, see our FAQ page on how to handle it.

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig


User avatar
Guru Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by Emanuel.C » Fri Jun 19, 2020 9:31 pm

I use the module Import/Export Tool

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

New member

Posts

Joined
Mon Mar 25, 2019 5:26 pm

Post by JNeuhoff » Fri Jun 19, 2020 9:39 pm

Emanuel.C wrote:
Fri Jun 19, 2020 9:31 pm
I use the module Import/Export Tool

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


User avatar
Guru Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by sesoft6 » Tue Jun 23, 2020 11:34 am

Can anyone help me please tell me How can i resolve this error "Export/Import: Invalid header in the Products worksheet"
I am using opencart version: 2.1.0.1

Attachments

error.PNG

error.PNG (7.65 KiB) Viewed 9211 times


==============================
https://aspirewebsolution.com/


Newbie

Posts

Joined
Thu Nov 27, 2014 5:42 pm
Location - Multan

Post by JNeuhoff » Tue Jun 23, 2020 4:40 pm

sesoft6 wrote:
Tue Jun 23, 2020 11:34 am
Can anyone help me please tell me How can i resolve this error "Export/Import: Invalid header in the Products worksheet"
I am using opencart version: 2.1.0.1
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


User avatar
Guru Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by BinkFour » Wed Jun 24, 2020 2:40 am

JNeuhoff wrote:
Tue Jun 16, 2020 4:50 pm
BinkFour wrote:
Tue Jun 16, 2020 4:26 am
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
Perhaps this gives a clue why the file is seemingly not valid after export.
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.
Libre (roughly translated) states the following: The data cannot be loaded because the maximum numbers of characters in a cell is exceeded

Does this give more information on the reason of the error?

New member

Posts

Joined
Mon Jun 10, 2013 1:47 am


Post by JNeuhoff » Wed Jun 24, 2020 3:56 am

There you got your answer. One of your spreadsheet cells has too many characters, probably in the description field.

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


User avatar
Guru Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by bigmarket » Fri Jul 03, 2020 2:03 am

have you got any solutions for that , i too having same problem.
please let me know if you found any solutions.

Newbie

Posts

Joined
Mon Jun 01, 2020 12:48 am
Who is online

Users browsing this forum: No registered users and 16 guests