The Export/Import Tool (V2.x) is now available for OpenCart 2, with the same same features as the one for OpenCart 1.5.x.
Last edited by JNeuhoff on Tue Aug 30, 2022 6:08 pm, edited 2 times in total.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Thanks for the contribution.
Can we have 1 more option when export products?
Select what data you want to export:
All(including Categories, product data, options, specials, discounts, rewards and attributes)
Categories
Products (including product data, options, specials, discounts, rewards and attributes)
Option definitions
Attribute definitions
Thanks!
By the way, in your new version, the 'viewed' is missing. Can you add it?
Can we have 1 more option when export products?
Select what data you want to export:
All(including Categories, product data, options, specials, discounts, rewards and attributes)
Categories
Products (including product data, options, specials, discounts, rewards and attributes)
Option definitions
Attribute definitions
Thanks!
By the way, in your new version, the 'viewed' is missing. Can you add it?
I know nothing about PHP and SQL, but I still try my best to understand it.
It's not in there on purpose. During an Import, it preserves the existing viewed counts.By the way, in your new version, the 'viewed' is missing. Can you add it?
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
JNeuhoff wrote:It's not in there on purpose. During an Import, it preserves the existing viewed counts.By the way, in your new version, the 'viewed' is missing. Can you add it?
Yes, if for upgraded from old OC version, it is no need be there. But if I want upload all items for new installed OC version, it will be better have old data. Thanks!
I know nothing about PHP and SQL, but I still try my best to understand it.
HI
Im installing v2.0 now but I receive this error:
SyntaxError: JSON.parse: unexpected character at line 1 column 1 of the JSON data
OK
<b>Warning</b>: ftp_login(): This is a private system - No anonymous login in <b>/home/xxx/xxx/shop/vqmod/vqcache/vq2-admin_controller_extension_installer.php</b> on line <b>289</b>{"error":"Could not login as "}
Im installing v2.0 now but I receive this error:
SyntaxError: JSON.parse: unexpected character at line 1 column 1 of the JSON data
OK
<b>Warning</b>: ftp_login(): This is a private system - No anonymous login in <b>/home/xxx/xxx/shop/vqmod/vqcache/vq2-admin_controller_extension_installer.php</b> on line <b>289</b>{"error":"Could not login as "}
You don't need VQmod for the Export/Import tool for OpenCart 2.0, because it uses it's builtin OCmod. See the 'readme.txt' for details on how to install it.mickgraham wrote:HI
Im installing v2.0 now but I receive this error:
SyntaxError: JSON.parse: unexpected character at line 1 column 1 of the JSON data
OK
<b>Warning</b>: ftp_login(): This is a private system - No anonymous login in <b>/home/xxx/xxx/shop/vqmod/vqcache/vq2-admin_controller_extension_installer.php</b> on line <b>289</b>{"error":"Could not login as "}
The error happens when I am installing it from Extensions Installer.
After about 50% of the install??
I don't see what this has to do with VQmod.
After about 50% of the install??
I don't see what this has to do with VQmod.
Hi
I removed all the files via FTP and tried to install again but I still get the same error.
Any other ideas?
rgds
Mick
I removed all the files via FTP and tried to install again but I still get the same error.
Any other ideas?
rgds
Mick
Sorry, I am unable to help, I am not able to reproduce your error. Remove VQmod, or at least, remove the VQmod XML which modifies the admin/controller/extension/installer.php<b>Warning</b>: ftp_login(): This is a private system - No anonymous login in <b>/home/xxx/xxx/shop/vqmod/vqcache/vq2-admin_controller_extension_installer.php</b> on line <b>289</b>{"error":"Could not login as "}
BTW.: The offending line could be this one:
Code: Select all
$login = ftp_login($connection, $this->config->get('config_ftp_username'), $this->config->get('config_ftp_password'));
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Hello Mick,
I had the same problem, and then I noticed there was some newer files on github, so I download and replaced old files.
Download link:
https://github.com/opencart/opencart
After that, the error was fixed.
Please make use you change php.ini for the max execute value larger than 30 seconds and enable FTP on settings page.
I installed on localhost, have filezilla ftp server, open port 12121, enable but got this error
could not connect as 127.0.0.1:12121
Edit: after change the ftp port, your extension is installed successful
Thank you
I had the same problem, and then I noticed there was some newer files on github, so I download and replaced old files.
Download link:
https://github.com/opencart/opencart
After that, the error was fixed.
Please make use you change php.ini for the max execute value larger than 30 seconds and enable FTP on settings page.
I installed on localhost, have filezilla ftp server, open port 12121, enable but got this error
could not connect as 127.0.0.1:12121
Edit: after change the ftp port, your extension is installed successful
Thank you
hale: I think there will be many more users having problems when testing OC2 extensions on a local PC because of not having a properly running FTP server. I am not quite sure why Daniel has chosen to use FTP for the final storing of already uploaded files in his admin/controller/extension/installer.php.
Anyway, thanks for sharing your solution with us.
Anyway, thanks for sharing your solution with us.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
It should be under admin > System > Export/Importadb34 wrote:Hi
I have a fresh install with Opencart v2; vqmod v2 and this import/export v2
Under Admin, I could find the import/export under system tag. Where is it now? I cannot find it.
Thanks for your time and help
For OpenCart 2.0 it doesn't use vqmod. Have you followed the installation instructions from the 'readme.txt' file?
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
It is all my fault. I did not load the plug-in correctly. After fighting with the ftp all done and sorted. Yes you are right with the location.JNeuhoff wrote:It should be under admin > System > Export/Importadb34 wrote:Hi
I have a fresh install with Opencart v2; vqmod v2 and this import/export v2
Under Admin, I could find the import/export under system tag. Where is it now? I cannot find it.
Thanks for your time and help
For OpenCart 2.0 it doesn't use vqmod. Have you followed the installation instructions from the 'readme.txt' file?
andy
JNeuhoff wrote:Sorry, I am unable to help, I am not able to reproduce your error. Remove VQmod, or at least, remove the VQmod XML which modifies the admin/controller/extension/installer.php<b>Warning</b>: ftp_login(): This is a private system - No anonymous login in <b>/home/xxx/xxx/shop/vqmod/vqcache/vq2-admin_controller_extension_installer.php</b> on line <b>289</b>{"error":"Could not login as "}
BTW.: The offending line could be this one:
which indicates who haven't got a running FTP server, or haven't configured OpenCart with the needed FTP login details.Code: Select all
$login = ftp_login($connection, $this->config->get('config_ftp_username'), $this->config->get('config_ftp_password'));
I had the same problem, but got it sorted. As follows;
1. Systems/Setting; action - edit
2. tab - FTP
3. Complete the FTP info
4. FTP Root - is the root file where the opencart is E.G. /shops/OpenCart/opencart/
5. Enable FTP - Yes
I hope this sorts out your problem
andy
Welcome I'm a newbie to opencart, although I have some limited experience with joomla/worpress.
I have had the same problem as mickgraham.
I have removed vqmod and set up ftp and was able finally to install extension. Succesfully imported 'options' but for 'categories' and 'products' I have folowing error:
Much confusion.
From readme.txt:
Much confusion.
I'm a newbie to opencart, although I have some limited experience with joomla/worpress. I have had the same problem as mickgraham.
I have removed vqmod and set up ftp and was able finally to install extension. Succesfully imported 'options' but for 'categories' and 'products' I have folowing error:
.Export/Import: Invalid header in the Categories worksheet
Much confusion.
From readme.txt:
but in this thread I've read advise to Remove VQmodAlso, a pre-installed VQmod is required, get it from <https://github.com/vqmod/vqmod/wiki>
Much confusion.
Look guys, I can't help you unless you provide us with at least some basic details, such as:
OpenCart version
entries in system/logs/error.txt
entries in server's error_log
any other extensions installed
As regards VQmod: Versions for OpenCart 1.5.x does require it, for OpenCart 2.0 it's not needed, just follow the 'readme.txt' for installation.
OpenCart version
entries in system/logs/error.txt
entries in server's error_log
any other extensions installed
As regards VQmod: Versions for OpenCart 1.5.x does require it, for OpenCart 2.0 it's not needed, just follow the 'readme.txt' for installation.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Hi,
I have installed 2.0.0.0 from sratch, linux server, php 5.5.9
No plugins installed. (only this export/import plugin)
I have exported 3 files, options, categories, products with default plugin parameters to default xlsx file in opencart 1.5.6.4. 'File 'Options' was imported succesfully (although 2 extra checkboxes I found in imported options), while for 'categories' and 'products' I get message:
Uploaded file is not a valid spreadsheet file or its values are not in the expected formats!
See also 'System > Error Logs' for more details.
No server data has been changed.
and in opencart log: Export/Import: Invalid header in the Categories worksheet
I'm afraid I have no eccess to server's error_log (shared server).
I have installed 2.0.0.0 from sratch, linux server, php 5.5.9
No plugins installed. (only this export/import plugin)
I have exported 3 files, options, categories, products with default plugin parameters to default xlsx file in opencart 1.5.6.4. 'File 'Options' was imported succesfully (although 2 extra checkboxes I found in imported options), while for 'categories' and 'products' I get message:
Uploaded file is not a valid spreadsheet file or its values are not in the expected formats!
See also 'System > Error Logs' for more details.
No server data has been changed.
and in opencart log: Export/Import: Invalid header in the Categories worksheet
I'm afraid I have no eccess to server's error_log (shared server).
marmax, send me a PM with your FTP and OpenCart login details, and I can then take a look at your server. I am unable to reproduce your error. I assume you are using the latest version 2.13 of the Export/Import tool?
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Who is online
Users browsing this forum: No registered users and 12 guests
