Post by harap » Mon Mar 13, 2023 11:45 pm

JNeuhoff wrote:
Mon Mar 13, 2023 7:22 pm
harap wrote:
Mon Mar 13, 2023 12:05 pm
@JNeuhoff,
It seems your extension for OC v2.2.0.0. has not update yet. I just downloaded and found it is V3.22.
I don't know what you are talking about. There clearly is a version 4.13 of the Export/Import tool for OpenCart 2.2.0.0.
Also read the docs which states:
If I download it from Opencart site, it is still V3.22.
Yes if I download it from your developer site, it is version 4.13.

Active Member

Posts

Joined
Wed Sep 16, 2015 12:34 am
Location - United States

Post by xxvirusxx » Mon Mar 13, 2023 11:57 pm

Only version for 4.x.x.x.y.z was updated.......
You don't need new version for 2.2.0.0...

Attachments

export_import.png

export_import.png (36.71 KiB) Viewed 1140 times


Upgrade Service | OC 2.3.0.2 PHP 8 | My Custom OC 3.0.3.8 | Buy me a beer


User avatar
Expert Member

Posts

Joined
Tue Jul 17, 2012 10:35 pm
Location - România

Post by harap » Tue Mar 14, 2023 10:33 am

xxvirusxx wrote:
Mon Mar 13, 2023 11:57 pm
Only version for 4.x.x.x.y.z was updated.......
You don't need new version for 2.2.0.0...
In my case, The extension v4.13.2 for OC v4.x.x.x. can only be installed into my OC v4.0.1.1.
I tried to install it to my OC v2.2.0.0. it was failed.

I successfully installed the extension v4.13 for OC v2.x.x.x to my OC v2.2.0.0.

Hope the developer to clarify it if the extension v4.13.2 for OC v4.x.x.x. is on purpose also for OC v2.x.x.x.
Last edited by harap on Tue Mar 14, 2023 10:50 am, edited 2 times in total.

Active Member

Posts

Joined
Wed Sep 16, 2015 12:34 am
Location - United States

Post by xxvirusxx » Tue Mar 14, 2023 2:49 pm

harap wrote:
Tue Mar 14, 2023 10:33 am
Hope the developer to clarify it if the extension v4.13.2 for OC v4.x.x.x. is on purpose also for OC v2.x.x.x.
No. Because that bug is only in oc 4.x.....
harap wrote:
Fri Mar 10, 2023 2:47 am
Unknown column 'wishlist' in 'field list'<br/>Error No: 1054<br/>INSERT INTO `oc_customer`.........
Also you use 4.13 on 2.2.0.0 only if php version is 7.3 or bigger.
3.22 if php is lower (7.2, 7.1 ....)

Upgrade Service | OC 2.3.0.2 PHP 8 | My Custom OC 3.0.3.8 | Buy me a beer


User avatar
Expert Member

Posts

Joined
Tue Jul 17, 2012 10:35 pm
Location - România

Post by harap » Wed Mar 15, 2023 12:04 am

The error log report from my OpenCart v4.0.1.1 admin site read as beblow:
2023-03-13 07:55:08 - Export/Import: Invalid header in the Customers worksheet

What's wrong? Please advise.

Active Member

Posts

Joined
Wed Sep 16, 2015 12:34 am
Location - United States

Post by xxvirusxx » Wed Mar 15, 2023 1:01 am

I have write once....
xxvirusxx wrote:
Thu Mar 09, 2023 2:43 pm
harap wrote:
Wed Mar 08, 2023 12:37 am
Invalid header in the Customers worksheet.
Download LibreOffice, open the file and save. Ater that extension should import the file.

Upgrade Service | OC 2.3.0.2 PHP 8 | My Custom OC 3.0.3.8 | Buy me a beer


User avatar
Expert Member

Posts

Joined
Tue Jul 17, 2012 10:35 pm
Location - România

Post by JNeuhoff » Wed Mar 15, 2023 1:06 am

harap wrote:
Wed Mar 15, 2023 12:04 am
The error log report from my OpenCart v4.0.1.1 admin site read as beblow:
2023-03-13 07:55:08 - Export/Import: Invalid header in the Customers worksheet

What's wrong? Please advise.
The header in the Customers worksheet is wrong, the error message is clear enough.
And it will also advise you to look into the OpenCart error log for more details.

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 harap » Wed Mar 15, 2023 1:19 am

JNeuhoff wrote:
Wed Mar 15, 2023 1:06 am
And it will also advise you to look into the OpenCart error log for more details.
How can I get the OpenCart error log that you mentioned?

This is what I get:
https://ibb.co/Ph5tBRm

Active Member

Posts

Joined
Wed Sep 16, 2015 12:34 am
Location - United States

Post by JNeuhoff » Wed Mar 15, 2023 2:01 am

Just do an Export of the customers off your OC 4.0.1.1 site first, to see the required header format which will be slightly different from what you had exported from your old OC 2 site.

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 harap » Thu Mar 23, 2023 12:40 am

xxvirusxx wrote:
Wed Mar 15, 2023 1:01 am
Download LibreOffice, open the file and save. Ater that extension should import the file.
Import accepts also xls and odt file, I tried both but still failed. It seems use LibreOffice doesn't help.

Active Member

Posts

Joined
Wed Sep 16, 2015 12:34 am
Location - United States

Post by harap » Thu Mar 23, 2023 12:46 am

JNeuhoff wrote:
Wed Mar 15, 2023 2:01 am
Just do an Export of the customers off your OC 4.0.1.1 site first, to see the required header format which will be slightly different from what you had exported from your old OC 2 site.
I did an Export of the customers off your OC 4.0.1.1 site first, and used this file to add the data from old OC 2.2.0.0. the problem persists.
The file name matter?

Active Member

Posts

Joined
Wed Sep 16, 2015 12:34 am
Location - United States
Who is online

Users browsing this forum: No registered users and 50 guests