Use OpenOffice or LibreOffice to open the XLSX file, could be a bug in MSExcel.nortski wrote: ↑Fri Oct 06, 2017 12:34 amHi,
There appears to be a slight bug concerning the 'description(en)' field when I download my product catalogue. On some of my items it will repeat what's in the description multiple times underneath each other. Rather annoying as this means I have to check out every item to see if it has been affected.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Hi. OpenOffice is the program that I opened it in initially. This is where the bug occurs, seems to open fine in Excel.JNeuhoff wrote: ↑Fri Oct 06, 2017 12:43 amUse OpenOffice or LibreOffice to open the XLSX file, could be a bug in MSExcel.nortski wrote: ↑Fri Oct 06, 2017 12:34 amHi,
There appears to be a slight bug concerning the 'description(en)' field when I download my product catalogue. On some of my items it will repeat what's in the description multiple times underneath each other. Rather annoying as this means I have to check out every item to see if it has been affected.
The Alt Box, built using Opencart 2.0.3.1.
I am quite new here and i have a problem with the product import.
The error is quite simple ... but still is anoying as i have no idea why i do receive this error.
2017-10-16 9:44:54 - Export/Import: Missing product_ids in worksheet 'Products'!
Anybody has any idea why i do receive this error? If i save the excel sheet with product id or without id i receive the same error.
No idea what to modify.
Any help is welcome.
The product_ids are required. If you still get this error it could be because of hidden trailing blank lines in the worksheet, caused by a bug in MS Excel, in which case you should use LibreOffice or OpenOffice to save the file again.norbertm81 wrote: ↑Mon Oct 16, 2017 6:13 pmHi everybody!
I am quite new here and i have a problem with the product import.
The error is quite simple ... but still is anoying as i have no idea why i do receive this error.
2017-10-16 9:44:54 - Export/Import: Missing product_ids in worksheet 'Products'!
Anybody has any idea why i do receive this error? If i save the excel sheet with product id or without id i receive the same error.
No idea what to modify.
Any help is welcome.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Thanks for your reply! I already made a try with OpenOffice and i have the same error.. i will try with LibreOffice too.JNeuhoff wrote: ↑Mon Oct 16, 2017 6:29 pmThe product_ids are required. If you still get this error it could be because of hidden trailing blank lines in the worksheet, caused by a bug in MS Excel, in which case you should use LibreOffice or OpenOffice to save the file again.norbertm81 wrote: ↑Mon Oct 16, 2017 6:13 pmHi everybody!
I am quite new here and i have a problem with the product import.
The error is quite simple ... but still is anoying as i have no idea why i do receive this error.
2017-10-16 9:44:54 - Export/Import: Missing product_ids in worksheet 'Products'!
Anybody has any idea why i do receive this error? If i save the excel sheet with product id or without id i receive the same error.
No idea what to modify.
Any help is welcome.
I am using Export/Import Tool (V3.11) for OpenCart 2.3.0.2. It worked fine before (export and import I mean). Recently I got the error "The page you requested cannot be found" when I try to import the product and catgory csv file using incremental import. We checked the Opencart error log but nothing there. Is there anything that we can check for the problem ? Any idea for this issue ? The product CSV file just contains around 500+ products so I believe it should not be related to the Excel file size
Andrew
Sorry, can't help you, you simply don't provide enough information, unable to reproduce your error. Besides, the Export/Import tool only supports XLSX or ODS, not CSV. It's probably best to do a complete re-install.fungandrew wrote: ↑Wed Oct 18, 2017 12:31 amHello,
I am using Export/Import Tool (V3.11) for OpenCart 2.3.0.2. It worked fine before (export and import I mean). Recently I got the error "The page you requested cannot be found" when I try to import the product and catgory csv file using incremental import. We checked the Opencart error log but nothing there. Is there anything that we can check for the problem ? Any idea for this issue ? The product CSV file just contains around 500+ products so I believe it should not be related to the Excel file size
Andrew
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
The Alt Box, built using Opencart 2.0.3.1.
Now fixed, thank you for posting this issue. Please try the latest V3.19 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
Thank you, I will check it out shortly.
The Alt Box, built using Opencart 2.0.3.1.
You need to sort out your OpenCart extension installer, otherwise you won't be able to install any extensions via it. See http://docs.opencart.com/extension/installer/ for more details on how to configure it, especially for the FTP settings.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Downloading the zip and uploading it with Extensions/Installer/Upload does work and checking with my FTP client all files are at the right location on the server but the option Export/Import does not show up under System/Maintenance.
So I unzipped the files and checked the install.xml. This file shows two edits in two column_left.php files. These edits are not processed properly (maybe the [CDATA] ?) but after editing the two files manually with the updates from install.xml, the option appears on the left under System/Maintenance. So far, so good.
Trying to execute a product export from the fresh installation, I get an "Could not close zip file php://output." I've read that this could have to do with folder rights but there's plenty of access to /tmp.
Is it a rights problem? Is it an installation issue? Does all of the above have to do with rights control? Any suggestions?
Thanks for your time.
Léon
https://stackoverflow.com/questions/214 ... php-output
The install.xml works fine, it has been tested on standard OpenCart versions, you probably didn't follow the installation instructions as shown on the OpenCart marketplace page for the Export/Import product.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
As for the php://output." error, I changed
Code: Select all
$pFilename = @tempnam(PHPExcel_Shared_File::sys_get_temp_dir(), 'phpxltmp');
Code: Select all
$pFilename = 'c:\tmp\phpxltmp';
Thanks for this fantastic add-on. It saves me entering 1000+ products by hand. Great work!
Léon
Users browsing this forum: No registered users and 50 guests