Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
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.
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 "}
After about 50% of the install??
I don't see what this has to do with VQmod.
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
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
![Smiley :)](./images/smilies/smiley.gif)
Thank you
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
![Smiley :)](./images/smilies/smiley.gif)
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.
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
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).
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Users browsing this forum: No registered users and 32 guests