Post by khnaz35 » Thu Aug 27, 2020 9:23 pm

harlemangel wrote:
Thu Aug 27, 2020 9:00 pm
Is there a manual way of installing it? Just FTP the uploads folder?
https://www.youtube.com/watch?time_cont ... e=emb_logo

Urgent Questions shoot here: khnaz35@gmail.com
Enjoy nature ;) :) :-*


User avatar
Active Member

Posts

Joined
Mon Aug 27, 2018 11:30 pm
Location - Malaysia

Post by ilian359 » Mon Sep 14, 2020 9:09 pm

Version 4.5 does not work on my Opencart 3.0.3.2 / PHP7.3. Where can I download and test older versions 4.3 and 4.4?

Image Image
Laptop repair specialist in Sofia, Bulgaria.
Maintaining own OC 3 shop for laptop screens


Newbie

Posts

Joined
Tue Aug 11, 2020 4:37 am

Post by khnaz35 » Mon Sep 14, 2020 10:48 pm

ilian359 wrote:
Mon Sep 14, 2020 9:09 pm
Version 4.5 does not work on my Opencart 3.0.3.2 / PHP7.3. Where can I download and test older versions 4.3 and 4.4?
What is the error ?

Urgent Questions shoot here: khnaz35@gmail.com
Enjoy nature ;) :) :-*


User avatar
Active Member

Posts

Joined
Mon Aug 27, 2018 11:30 pm
Location - Malaysia

Post by ilian359 » Tue Sep 15, 2020 3:13 am

PHP version check - requires at least 7.2, although I am running 7.3. I disabled the version check, but then another error occurred, like "Unexpected '.' on line 18 .....in add.php"

Image Image
Laptop repair specialist in Sofia, Bulgaria.
Maintaining own OC 3 shop for laptop screens


Newbie

Posts

Joined
Tue Aug 11, 2020 4:37 am

Post by JNeuhoff » Tue Sep 15, 2020 3:27 am

I am unable to reproduce any of your errors. You are most likely not using a PHP version 7.2 or later. You can verify this by creating a 'phpinfo.php' file with this in it:

Code: Select all

<?php phpinfo(); ?>
And then upload it to your OpenCart server, and call it from your web browser.

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 ilian359 » Tue Sep 15, 2020 4:06 am

Thank you! You are right. The actual php version appeared to be 5.5, although 7.3 is set. I will contact the hosting company.

Image Image
Laptop repair specialist in Sofia, Bulgaria.
Maintaining own OC 3 shop for laptop screens


Newbie

Posts

Joined
Tue Aug 11, 2020 4:37 am

Post by robinpecha » Sun Sep 20, 2020 9:54 pm

Hello, I also have problem with installing. PHP Version 7.2.24, OC 3.0.3.2.
I succeslfuly did all 5 points of you how to install, extension is visible in Ext > Modifications. Everything ok but no Export/Import tool in System > Maintenance.
Im using cs-cz language and have seen some language files inside your zip which are stored in en-gb language. I switched admin page and frontend to en-gb but still withou success .(
Reseting caches, etc.

I have manualy checked if all files from zip are on right places and I found there is no system/export_import.ocmod.xml as mentioned in https://helpforsite.com/blog/articles/i ... 3x-modules for manual instalation. Anyway I renamed install.xml and put in system but still without success.

PS: in the begining I have installed vqmod in oc, about ocmod i didnt found any info how to install and I belive its integrated by default, isnt it?
Last edited by robinpecha on Sun Sep 20, 2020 10:30 pm, edited 1 time in total.

Newbie

Posts

Joined
Mon Aug 03, 2020 11:36 pm

Post by JNeuhoff » Sun Sep 20, 2020 11:02 pm

Our FAQ should help, most likely you missed out on an installation step.

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 robinpecha » Sun Sep 20, 2020 11:40 pm

Im sorry but it didnt help. Double checked everything as in FAQ.

Attaching screenshots:
import0.png

import0.png (148.71 KiB) Viewed 5239 times

Attachments

import4.png

import4.png (43.74 KiB) Viewed 5239 times

import5.png

import5.png (38.02 KiB) Viewed 5239 times


Newbie

Posts

Joined
Mon Aug 03, 2020 11:36 pm

Post by JNeuhoff » Mon Sep 21, 2020 12:02 am

Try our Export/Import tool, you are using a different modified version.

Also check for the existence of a modified admin/controller/common/column_left.php in your DIR_STORAGE folder. And check the OCmod log.

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 robinpecha » Mon Sep 21, 2020 12:23 am

Modifed was by me, adding cs-cz folder. But previously i did it with original zip. Ok, uninstalling moded version, deleting. Fresh download from your site, install, activating, unassing rights to admin group + save, assign right to admins + save, refresh cache, reload browser, logout user, deleting storage/cache.... but still nothing.

BUT admin/controller/common/column_left.php is untouched because have same modify time as other files, it means not modified from installation, here should be problem. Is there some direct url to open tool without using link from menu?

last content of ocmod.log:
----------------------------------------------------------------
MOD: Export/Import Tool (V4.6) for OpenCart 3.x

FILE: admin/controller/common/column_left.php
CODE: if ($this->user->hasPermission('access', 'tool/upload')) {
LINE: 601

FILE: admin/language/cs-cz/common/column_left.php
CODE: $_['text_backup']
LINE: 7

FILE: admin/language/en-gb/common/column_left.php
CODE: $_['text_backup']
LINE: 8
----------------------------------------------------------------
MOD: Export/Import Tool (V4.6) for OpenCart 3.x
CODE: if ($this->user->hasPermission('access', 'tool/upload')) {
LINE: 610
CODE: $_['text_backup']
LINE: 7
CODE: $_['text_backup']
LINE: 8
----------------------------------------------------------------

Newbie

Posts

Joined
Mon Aug 03, 2020 11:36 pm

Post by JNeuhoff » Mon Sep 21, 2020 1:00 am

You need to sort out your other extensions modifying the same admin/controller/common/column_left.php.

Just clear the whole modifications cache and the OCmod log first, then do a refresh and then check for the existence of a modified admin/controller/common/column_left.php. If the latter doesn't show up, then there have to be errors in the OCmod log.

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 robinpecha » Tue Sep 22, 2020 5:32 am

SOLVED
I did it like you describe now and it shows in menu. Whole time was problem in sequence of hitting clear and refresh button. I allways hit refresh first and then clear (extensions/modifications).
Wov. Thanks .)

Newbie

Posts

Joined
Mon Aug 03, 2020 11:36 pm

Post by robinpecha » Tue Sep 22, 2020 8:22 pm

Please is possible modify extension to pair items by model or something editable in admin, instead of invisible IDs?

Newbie

Posts

Joined
Mon Aug 03, 2020 11:36 pm

Post by tav105 » Tue Nov 10, 2020 6:16 pm

Thanks for your program.
I used it on this platform:
1 Core, 1GB, SSD, Opencart 2.3.0.2, FreeBSD 9.2, php55-5.5.1, apache24-2.4.6, mysql-server-5.5.33
for a long time and everything worked fine.

I decided to upgrade my system and switch to Ubuntu at the same time.

I noticed that on my chosen bundle Opencart 2.3.0.2, Ubuntu 20.04, php7.4-fpm, nginx 1.18.0-0, mariadb-server-10.3 Export / Import is very slow.
And on the alternative Opencart 2.3.0.2, Ubuntu 20.04, php7.4.3-4, apache2.4.41-4, mariadb-server-10.3, the speed is also high.

The site itself works faster on php7.4-fpm, nginx 1.18.0-0. And this software handles the load better.

I have base with 15915 goods.

1 Core, 1GB, Opencart 2.3.0.2, Ubuntu 20.04, php7.4.3-4, apache2.4.41-4, mariadb-server-10.3
Update 6930 goods, 91 sec
Delete all goods and Insert 6930 goods, 27 sec

1 Core, 1GB, Opencart 2.3.0.2, Ubuntu 20.04, php7.4-fpm, nginx 1.18.0-0, mariadb-server-10.3
Update 6930 goods, 138 sec
Delete all goods and Insert 6930 goods, 266 sec

I also noticed earlier that using mysql-server 8.0.21 on both FreeBSD and Ubuntu slows down export / import even more.

Maybe you have any recommendations for using Export / Import with php7.4-fpm, nginx 1.18.0-0.

Or maybe you are planning to do an optimization.

Thank you.

Newbie

Posts

Joined
Tue Nov 10, 2020 6:07 pm

Post by JNeuhoff » Tue Nov 10, 2020 7:36 pm

Have you tried the newer version 4.6 of the Export/Import tool? It uses a different library, namely the PHPSpreadsheet instead of PHPExcel.

The nginx performance issues are not uncommon, see e.g. https://serverfault.com/questions/29410 ... pm-is-slow

Either way, the issue is not the Export/Import tool, but the server configuration.

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 tav105 » Wed Nov 11, 2020 3:06 pm

Thank you.
I already use 4.6 version of 4.6 of the Export/Import tool.

I've tried changing the values,
pm.max_children = , pm.start_servers = , pm.min_spare_servers = , pm.max_spare_servers =, pm.max_requests =
but all the changes in runtime are within 1-5%.

I analyzed the CPU load in Top when importing on platforms.
1 Core, 1GB, SSD, Opencart 2.3.0.2, Ubuntu 20.04, php7.4.3-4, apache2.4.41-4, mariadb-server-10.3
1 Core, 1GB, SSD, Opencart 2.3.0.2, Ubuntu 20.04, php7.4-fpm, nginx 1.18.0-0, mariadb-server-10.3
First, the maximum processor load from apache2.4.41-4 or php7.4-fpm (in both cases, CPU load 90% -100% memory usage 400-600mb), then the maximum processor load from mariadb-server-10.3 (CPU load ~90% memory usage 50-150mb)
Moreover, the operating time, processor load and memory usage of mariadb-server-10.3 are almost identical in both cases.

Loss of performance due to php7.4-fpm taking much longer to execute than apache2.4.41-4.

1 Core, 1GB, SSD, Opencart 2.3.0.2, Ubuntu 20.04, php7.4.3-4, apache2.4.41-4, mariadb-server-10.3
15915 goods in base
Update 6300 goods A (file 3,62 Mb), 80 sec
Update 3000 goods A (file 1,73 Mb), 41 sec
Update 6930 goods B (file 2,6 Mb), 91 sec
Update 3000 goods B (file 1,14 Mb), 41 sec

Delete all goods and Insert 6300 goods A (file 3,62 Mb), 27 sec
Delete all goods and Insert 3000 goods A (file 1,73 Mb), 14 sec
Delete all goods and Insert 6930 goods B (file 2,6 Mb), 28 sec
Delete all goods and Insert 3000 goods B (file 1,14 Mb), 14 sec

1 Core, 1GB, SSD, Opencart 2.3.0.2, Ubuntu 20.04, php7.4-fpm, nginx 1.18.0-0, mariadb-server-10.3
15915 goods in base
Update 6300 goods A (file 3,62 Mb), 339 sec
Update 3000 goods A (file 1,73 Mb), 155 sec
Update 6930 goods B (file 2,6 Mb), 138 sec
Update 3000 goods B (file 1,14 Mb), 60 sec

Delete all goods and Insert 6300 goods A (file 3,62 Mb), 266 sec
Delete all goods and Insert 3000 goods A (file 1,73 Mb), 129 sec
Delete all goods and Insert 6930 goods B (file 2,6 Mb), 75 sec
Delete all goods and Insert 3000 goods B (file 1,14 Mb), 31 sec

The main difference is in the file.
There are around 5881 characters in a cell description(en-gb) goods A.
There are around 2281 characters in a cell description(en-gb) goods B.

By results the tests for the php7.4.3-4 and apache2.4.41-4 platform, the import speed depends only on the number of goods.
The import time for files with the same number of products and different sizes is the same.

At the same time, for the php7.4-fpm and nginx 1.18.0-0 platform,
the import speed depends on the number of products and on the number of characters in the cell description (en-gb).

Maybe in php7.4-fpm and nginx 1.18.0-0 platform there is a BUG due to which the number of characters in the cell affects the speed of the module?

If anyone has improved the productivity of Importing 7000-10000 products on the platform php-fpm and nginx please let me know ruscarparts(@)gmail.com.

Newbie

Posts

Joined
Tue Nov 10, 2020 6:07 pm

Post by JNeuhoff » Wed Nov 11, 2020 7:49 pm

I think php7.4-fpm on nginx is the main culprit here, judging by the many user reports on this according to a Google search.

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 tav105 » Fri Nov 13, 2020 12:59 pm

JNeuhoff wrote:
Wed Nov 11, 2020 7:49 pm
I think php7.4-fpm on nginx is the main culprit here, judging by the many user reports on this according to a Google search.
I have reduced the number of characters in the description(en-gb) cell from 5881 to 242 characters.
After that, the import time in php7.4-fpm and nginx 1.18.0-0 became the same as in php7.4.3-4 and apache2.4.41-4.

I think that somewhere in the nginx 1.18.0-0, php7.4-fpm, PHPSpreadsheet section, there is an incorrect handling of long text elements.

Except for this annoying situation. nginx 1.18.0-0 php7.4-fpm performs much better under high load when serving content.

Given the popularity of php7.4-fpm and nginx, I hope you can take some time to look at why imports slow down so much when the cell size is increased.

Thanks for the module

Newbie

Posts

Joined
Tue Nov 10, 2020 6:07 pm
Who is online

Users browsing this forum: No registered users and 16 guests