First off, thanks for the module/extension and your hard work. Good stuff!
Two issues for developers attention...
Issue #1 - Bug/functionality ( or install intructions ):-
Importing into OC2 when import data contains customer_groups that don't exist yet.
Causes "Sub query returns more than one result" errors within front-end/shop. In this particular case the multiple result was returned on the "rewards" subquery. All reward-to-group rows were assigned to the only existing group that existed at the time ('Default' ...or '1'), including those belonging to my other customer_groups. Creating multiple reward records for each product in the 'Default' customer group.
Issue #2
Export from 1.5.4.6 version doesn't contain the Meta_Title(en) column in the product sheet that's needed for import into 2.0.1.1
As regards issue2: The spreadsheet formats between different OpenCart versions won't necessarily be the same!
About issue1: Will take a look at it and try to replicate this scenario so as to be able to create a proper bugfix to this. Thank you for bringing it to my attention.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Original Post:
Hi JNeuhoff: I have a fresh install of the latest OC, didn't do anything else (except enable ftp) and went straight to install of latest version of Export/Import... Everything perfect up until I have to assign permissions in User Groups - export/import doesn't show on the list of items needing permissions. I found one other post from December 2014 in this thread regarding same problem, but there was no resolution. Anything further anyone can give me on this issue?
admire your work btw...
tried to install opencart-2-0-x-export-import-multilingual-2-19.ocmod by following the instructions, but halfway through the extension installation I get an error message. I've checked the ftp is enabled and settings are correct. I installed the quickfix for ftp uploads, which installed without problems, but I still get the error message below.
Code: Select all
SyntaxError: JSON.parse: unexpected character at line 1 column 1 of the JSON data
OK
<b>Warning</b>: Invalid argument supplied for foreach() in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>333</b><b>Warning</b>: ftp_mkdir(): admin: Directory not empty in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>338</b><b>Warning</b>: Invalid argument supplied for foreach() in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>333</b><b>Warning</b>: ftp_mkdir(): system: Directory not empty in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>338</b><b>Warning</b>: Invalid argument supplied for foreach() in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>333</b><b>Warning</b>: ftp_mkdir(): admin/controller: Directory not empty in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>338</b><b>Warning</b>: Invalid argument supplied for foreach() in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>333</b><b>Warning</b>: ftp_mkdir(): admin/language: Directory not empty in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>338</b><b>Warning</b>: Invalid argument supplied for foreach() in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>333</b><b>Warning</b>: ftp_mkdir(): admin/model: Directory not empty in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>338</b><b>Warning</b>: Invalid argument supplied for foreach() in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>333</b><b>Warning</b>: ftp_mkdir(): admin/view: Directory not empty in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>338</b><b>Warning</b>: Invalid argument supplied for foreach() in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>333</b><b>Warning</b>: ftp_mkdir(): system/PHPExcel: Directory not empty in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>338</b><b>Warning</b>: Invalid argument supplied for foreach() in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>333</b><b>Warning</b>: ftp_mkdir(): admin/controller/tool: Directory not empty in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>338</b><b>Warning</b>: Invalid argument supplied for foreach() in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>333</b><b>Warning</b>: ftp_mkdir(): admin/language/english: Directory not empty in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>338</b><b>Warning</b>: Invalid argument supplied for foreach() in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>333</b><b>Warning</b>: ftp_mkdir(): admin/model/tool: Directory not empty in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>338</b><b>Warning</b>: Invalid argument supplied for foreach() in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>333</b><b>Warning</b>: ftp_mkdir(): admin/view/image: Directory not empty in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>338</b><b>Warning</b>: Invalid argument supplied for foreach() in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>333</b><b>Warning</b>: ftp_mkdir(): admin/view/stylesheet: Directory not empty in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>338</b><b>Warning</b>: Invalid argument supplied for foreach() in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>333</b><b>Warning</b>: ftp_mkdir(): admin/view/template: Directory not empty in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>338</b><b>Warning</b>: Invalid argument supplied for foreach() in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>333</b><b>Warning</b>: ftp_mkdir(): system/PHPExcel/Classes: Directory not empty in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>338</b><b>Warning</b>: ftp_put(): Illegal PORT command in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>345</b><b>Warning</b>: Invalid argument supplied for foreach() in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>333</b><b>Warning</b>: ftp_mkdir(): admin/language/english/tool: Directory not empty in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>338</b><b>Warning</b>: ftp_put(): Illegal PORT command in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>345</b><b>Warning</b>: Invalid argument supplied for foreach() in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>333</b><b>Warning</b>: ftp_put(): Illegal PORT command in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>345</b><b>Warning</b>: Invalid argument supplied for foreach() in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>333</b><b>Warning</b>: ftp_mkdir(): admin/view/template/tool: Directory not empty in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>338</b><b>Warning</b>: Invalid argument supplied for foreach() in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>333</b><b>Warning</b>: ftp_mkdir(): system/PHPExcel/Classes/PHPExcel: Directory not empty in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>338</b><b>Warning</b>: ftp_put(): Illegal PORT command in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>345</b><b>Warning</b>: ftp_put(): Illegal PORT command in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>345</b><b>Warning</b>: ftp_put(): Illegal PORT command in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>345</b><b>Warning</b>: ftp_put(): Illegal PORT command in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>345</b><b>Warning</b>: ftp_put(): Illegal PORT command in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>345</b><b>Warning</b>: Invalid argument supplied for foreach() in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>333</b><b>Warning</b>: ftp_put(): Illegal PORT command in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>345</b><b>Warning</b>: Invalid argument supplied for foreach() in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>333</b><b>Warning</b>: Invalid argument supplied for foreach() in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>333</b><b>Warning</b>: ftp_mkdir(): system/PHPExcel/Classes/PHPExcel/Calculation: Directory not empty in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>338</b><b>Warning</b>: ftp_put(): Illegal PORT command in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>345</b><b>Warning</b>: Invalid argument supplied for foreach() in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>333</b><b>Warning</b>: ftp_put(): Illegal PORT command in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>345</b><b>Warning</b>: Invalid argument supplied for foreach() in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>333</b><b>Warning</b>: ftp_mkdir(): system/PHPExcel/Classes/PHPExcel/Chart: Directory not empty in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>338</b><b>Warning</b>: ftp_put(): Illegal PORT command in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>345</b><b>Warning</b>: ftp_put(): Illegal PORT command in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>345</b><b>Warning</b>: ftp_put(): Illegal PORT command in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>345</b><b>Warning</b>: ftp_put(): Illegal PORT command in <b>/home/sites/mysite.co.uk/public_html/admin/controller/extension/installer.php</b> on line <b>345</b><b>Warning</b>: ftp_put(): Illegal PORT command in <b>/hom
First thank you for this excelent tool, works great with one language, in may site now add a second language (english en), and the tool only export and import in spanish, I added in the excel file the column for en, but the import function ingnore that, only import spanish.
What I do wrong?
Regards,
Don't know, you don't provide details to replicate the problem.kalin wrote:Hello,
First thank you for this excelent tool, works great with one language, in may site now add a second language (english en), and the tool only export and import in spanish, I added in the excel file the column for en, but the import function ingnore that, only import spanish.
What I do wrong?
Regards,
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
I have installed the Latest version of Export/Import Extenstion. For testing, I made a single product with a Option & few Attributes in a Single attribute group. I exported it and when i try to import the same exported file back i get the Error: "Export/Import: Option_name 'xxxx' not specified for product_id '23' in worksheet 'ProductOptions', but it is used in worksheet 'ProductAttributes'!" As u can notice "xxxx" is a product Attribute group, why is it asking to specify it in ProductOptions?? I am quite new to Opencart, so it would be really great if you could let me know what mistake im doing.
btw, when i try to import the excel file after removing all items in the ProductAttribute worksheet, then it imports fine.
Thanks a lot in advance.
Thanks, solved problems. But can you please add this options: filters. I think this is a function which many want. Thanks you!JNeuhoff wrote:See the discussion on github at https://github.com/opencart/opencart/issues/2085
This is already on my to-do list for a future release.vinhpk wrote: Thanks, solved problems. But can you please add this options: filters. I think this is a function which many want. Thanks you!
BTW.: Just uploaded V2.21 which has some important bugfixes.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Oh, a good news, thanks you for a great extension!JNeuhoff wrote:This is already on my to-do list for a future release.vinhpk wrote: Thanks, solved problems. But can you please add this options: filters. I think this is a function which many want. Thanks you!
BTW.: Just uploaded V2.21 which has some important bugfixes.
Erik
Thanks JNeuhoff for this great tool. I'm using it successfully on a 1.5.6 version of OpenCart. But I have just downloaded the latest versions of both OpenCart and Export/Import tool, I followed the exact steps from your readme.txt file and I don't see the tool/export_import in the administrator user group. Therefore, I get an error when I try to access the Export/Import tool under the "Tools" Menu: "You do not have permission to access this page, please refer to your system administrator." I'm the administrator, so I have to give permission to myself.
Maybe you can take a look at this.
Thanks in advance,
Andy
This is installing to a clean OC 2.0.1.1 with latest VQmod as the only other extension installed.SyntaxError: JSON.parse: unexpected character at line 1 column 1 of the JSON data
OK
<b>Warning</b>: ftp_login(): Login incorrect. in <b>/var/www/vhosts/mydomain.com/httpdocs/opencart/vqmod/vqcache/vq2-admin_controller_extension_installer.php</b> on line <b>295</b>{"error":"Could not login as ftp-user-id"}
The FTP user credentials are correct in - System - Settings - Store - FTP ... I even tried with the server's root admin login and got the same result. This is on a VPS server.
Now, I've seen the comments above about vqmod is not required and to uninstall it, but sorry ... I have identified both ocmod and vqmod extensions that I want to have in this store side-by-side, therefore removing vqmod is not an option.
However, at this point I'm not sure if the problem above is being generated because of the import/export tool upload, or is coming from vqmod trampling on ocmod, or if there simply an FTP credentials edit that I should have done somewhere in vqmod's config files ... anyone got any clues?
Edit to add ...
I've now removed VQmod and after refreshing the modifications cache ... success, I was finally able to get the import export tool to install
BUT ... when I go to import / export under tools menu in admin - I am denied permission to access that page, this is when logged in as the store admin - ... under user group administrators there are no options for tool/export import to select.
I HAVE used the installer fix and I still do not have the permissions check boxes in User Groups - Administrators, and I still get the permission denied page when trying to go to the export / import tool pageJNeuhoff wrote:At the danger of repeating myself (because it's always the same questions here): Please use the Installer fix, there are quite a few users who are unable to have a proper FTP server in local test machines. Also, after an install, go to Extensions > Modifications, and then click on the 'Refresh' button.
Send me a PM with your FTP as well as the OpenCart login details, then I can take a look at it.TLEwebdevs wrote:I HAVE used the installer fix and I still do not have the permissions check boxes in User Groups - Administrators, and I still get the permission denied page when trying to go to the export / import tool pageJNeuhoff wrote:At the danger of repeating myself (because it's always the same questions here): Please use the Installer fix, there are quite a few users who are unable to have a proper FTP server in local test machines. Also, after an install, go to Extensions > Modifications, and then click on the 'Refresh' button.
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 27 guests