I found a bug in the module and would like to know how to fix it? In my shop in the lines "Model" I put numbers such as 7890 or 0548, and when the first digit of the model number zero, such as 0548, when exporting the database and 0 disappears in the file corresponds to the field is the number 548 instead of 0548.
Tell me, please, how can I fix it?
In your spreadsheet software, such as Excel or OpenOffice Calc, when you enter the numbers into the cells, you need to format them as strings, not numbers!tok24ua wrote:Good afternoon.
I found a bug in the module and would like to know how to fix it? In my shop in the lines "Model" I put numbers such as 7890 or 0548, and when the first digit of the model number zero, such as 0548, when exporting the database and 0 disappears in the file corresponds to the field is the number 548 instead of 0548.
Tell me, please, how can I fix it?
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
I'm using 1.5.4.1 and version 13 of the Export/Import tool.
With the help of Qphoria a few years back I managed to make a little mod for the version 1.4.1.x I used. The problem is that after I upgraded to 1.5.4.1 this mod doesn't fully work.
What's it about:
I have around 2000 products. A few hundreds of them have a photo. On my server the photo's name are the same as product model, but with the .jpg extension.
Example: product model: 96535010. For this product, its' photo is 96535010.jpg
Well, the mod for your E/I tool did the following thing: checking for every product model if it has a productmodel.jpg on the server. If that product has it, show it. If not, put default no_image.jpg instead, for every product that doesn't have a photo on the server.
This is where the problem rises. It no longer shows no_image.jpg when I run the E/I Tool.
Qphoria replaced in admin/model/tool/export.php:
Code: Select all
$imageName = $product['image'];
Code: Select all
$imageName = (($product['image']) ? $product['image'] : (($model) ? "data/produse/$model.jpg" : ""));
I'm using Open Cart 1.5.4.1 on http://www.importpieseauto.ro
I use OpenCard Version 1.5.6.1.
I also use your - opencart-1-5-6-x-export-import-16.zip.
There is no problem with Export.
But when I import the same file as I export, I get this error.
PLease HELP:
Call to undefined method PHPExcel_Reader_HTML::setReadDataOnly()
No server data has been changed.
See also 'System > Error Logs' for more details.
I am unable to reproduce your error. Are you sure you have saved your spreadsheet file as an XLSX file?conq wrote:Hi,
I use OpenCard Version 1.5.6.1.
I also use your - opencart-1-5-6-x-export-import-16.zip.
There is no problem with Export.
But when I import the same file as I export, I get this error.
PLease HELP:
Call to undefined method PHPExcel_Reader_HTML::setReadDataOnly()
No server data has been changed.
See also 'System > Error Logs' for more details.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
JNeuhoff wrote:I am unable to reproduce your error. Are you sure you have saved your spreadsheet file as an XLSX file?conq wrote:Hi,
I use OpenCard Version 1.5.6.1.
I also use your - opencart-1-5-6-x-export-import-16.zip.
There is no problem with Export.
But when I import the same file as I export, I get this error.
PLease HELP:
Call to undefined method PHPExcel_Reader_HTML::setReadDataOnly()
No server data has been changed.
See also 'System > Error Logs' for more details.
Error LOG:
PHP Fatal Error: Call to undefined method PHPExcel_Reader_HTML::setReadDataOnly() in C:\..\www\o\admin\model\tool\export.php on line 1738
What is this?
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
I got the same error with ODS.JNeuhoff wrote:You almost certainly have not saved your spreadsheet in XLSX format. It is trying to read it as an HTML file which causes this error. Try OpenOffice or LibreOffice and save as an ODS file, that format is supported, too, for the Import.
Is there any folder to be changed writable property ?
Or what else?
If you did all of that, then the only way I can help you if you send me a PM with the FTP and Opencart login details so that I can take a look at it. It appears to be an issue with the PHPExcel_IOFactory::createReaderForFile which for some strange reason can't identify your uploaded file as a proper spreadsheet file type.conq wrote:I got the same error with ODS.JNeuhoff wrote:You almost certainly have not saved your spreadsheet in XLSX format. It is trying to read it as an HTML file which causes this error. Try OpenOffice or LibreOffice and save as an ODS file, that format is supported, too, for the Import.
Is there any folder to be changed writable property ?
Or what else?
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
JNeuhoff wrote:If you did all of that, then the only way I can help you if you send me a PM with the FTP and Opencart login details so that I can take a look at it. It appears to be an issue with the PHPExcel_IOFactory::createReaderForFile which for some strange reason can't identify your uploaded file as a proper spreadsheet file type.conq wrote:I got the same error with ODS.JNeuhoff wrote:You almost certainly have not saved your spreadsheet in XLSX format. It is trying to read it as an HTML file which causes this error. Try OpenOffice or LibreOffice and save as an ODS file, that format is supported, too, for the Import.
Is there any folder to be changed writable property ?
Or what else?
I have sent my ftp data to you as PM.
Thanks
Your FTP login details don't work, and I still haven't got your Opencart login details. Without these, I am unable to help you.conq wrote: I have sent my ftp data to you as PM.
Thanks
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Where i can find the latest version of import/export module for opencart version 1.5.2.1?
Is it available for multiple languages? i need it for EN and GR.
Also, how many products can hold in its database? i already have the module but after the products went more than 1500 when i export the xls gives error and some information is missing in the file. Please let me know how should i proceed to fix the issue.
The current versions available from the OpenCart extensions.AntCyWeb wrote:Hi,
Where i can find the latest version of import/export module for opencart version 1.5.2.1?
Is it available for multiple languages? i need it for EN and GR.
Also, how many products can hold in its database? i already have the module but after the products went more than 1500 when i export the xls gives error and some information is missing in the file. Please let me know how should i proceed to fix the issue.
We don't have a multi-lingual version of our Export/Import at the moment. As regards the number of products it can deal with: This is an issue with the PHP memory_limit setting. Most shared webhost account limit the amount of memory, hence for higher product numbers you'd need a more dedicated web host account.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
What can be the reason for this error below while importing (Openceart 1.5.6.1)
-------------------
Notice: Undefined variable: fileHandle in
C:\..\www\o\system\PHPExcel\Classes\PHPExcel\Reader\CSV.php on line 147Notice: iconv(): Detected an illegal character in input string in
C:\..\www\o\system\PHPExcel\Classes\PHPExcel\Shared\String.php on line 386Notice: iconv(): Detected an illegal character in input string in
The Export/Import tool doesn't support CSV format, please use XLS format.Notice: Undefined variable: fileHandle in
C:\..\www\o\system\PHPExcel\Classes\PHPExcel\Reader\CSV.php on line 147Notice: iconv(): Detected an illegal character in input string in
C:\..\www\o\system\PHPExcel\Classes\PHPExcel\Shared\String.php on line 386Notice: iconv(): Detected an illegal character in input string in
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 7 guests