https://www.youtube.com/watch?time_cont ... e=emb_logoharlemangel wrote: ↑Thu Aug 27, 2020 9:00 pmIs there a manual way of installing it? Just FTP the uploads folder?
Urgent Questions shoot here: khnaz35@gmail.com
Enjoy nature
Laptop repair specialist in Sofia, Bulgaria.
Maintaining own OC 3 shop for laptop screens
Laptop repair specialist in Sofia, Bulgaria.
Maintaining own OC 3 shop for laptop screens
Code: Select all
<?php phpinfo(); ?>
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Laptop repair specialist in Sofia, Bulgaria.
Maintaining own OC 3 shop for laptop screens
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?
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Attaching screenshots:
Attachments
import4.png (43.74 KiB) Viewed 5333 times
import5.png (38.02 KiB) Viewed 5333 times
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
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
----------------------------------------------------------------
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
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 .)
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.
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
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.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
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
Users browsing this forum: No registered users and 67 guests