creoton 12 years ago

on versions 1.5.5-1.5.6

creoton 12 years ago

Very nive module, but when i try to Export ~700 products with attributes, have error:

Error: MySQL server has gone away
Error No: 2006
SELECT pa.*, ag.attribute_group_id, ag.sort_order AS attribute_group_sort_order, agd.name AS attribute_group, a.attribute_id, a.sort_order, ad.name AS attribute_name FROM `oc_product_attribute` pa LEFT JOIN `oc_attribute` a ON a.attribute_id=pa.attribute_id LEFT JOIN `oc_attribute_description` ad ON ad.attribute_id=a.attribute_id AND ad.language_id=1 INNER JOIN `oc_attribute_group` ag ON ag.attribute_group_id=a.attribute_group_id LEFT JOIN `oc_attribute_group_description` agd ON agd.attribute_group_id=a.attribute_group_id AND agd.language_id=1 WHERE pa.language_id=1 ORDER BY pa.product_id, attribute_group_sort_order, ag.attribute_group_id, a.sort_order, a.attribute_id;
See also 'System > Error Logs' for more details.

RockWeb 12 years ago

Hi,

Soemehow the extension is not showing up in 'System' menu @ admin. using 1.5.6

Any ideas?

Thanks in advance.
Martti

deschis 12 years ago

Please help with this error:
Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 94 bytes) in ....../public_html/system/PHPExcel/Classes/PHPExcel/Worksheet.php on line 1123

eliros 12 years ago

Great tool, although it exports only one language you can easily export every language in separated files.
Just change the primary language in: System - > Settings - > Local - > Language and export the xls!

volkanozyilmaz 12 years ago

Hello,

I am getting 500 internal server error when I press the "export" button. I want to see what the error is.

I tried to add

php_flag log_errors on
php_value error_log /home/path/public_html/domain/PHP_errors.log

lines to the .htaccess file but my shared hosting doesn't let me to do this, I don't have permission for this.

After I tried to add

ini_set('display_errors', 'On');
error_reporting(E_ALL | E_STRICT);

lines your model/tool/export.php file but it doesn't show me the error.

I also looked vqmod error log and there is no information.

Could you tell me how I can see the errors?

Probably I need to put ini_set and error_reporting functions to the right place.

Best,

simonepom 12 years ago

hi, i have this error : "error_max_post_size"
any solutions?

jusho7 12 years ago

Hi JNeuhoff

First, thanks for your useful tool. :)

I am using 1.5.6, after I exported and imported back, there is coding issue on "Product Descrption", see the scree here: https://www.dropbox.com/s/p4ttgvs2i86432m/error-shown.jpg

I think encoding having problem there, am I install wrongly, the rest data are ok.

Thank you very much for reply.

James / jusho7 [at] yahoo [dot] com

dodesz01 12 years ago

Hi,

I download this extension and it is excellent!

But i have a question, is that possible to use this with hungarian characters like ( á,é,ü,ű,ó,ö,ő,ú )?

It can display these characters on frontend and backend too. But when i try to search for these characters for example ( karóra, karkötő ) it won't find anything. And it sure the problem with the hungarian characters.

I am waiting for your reply!

Thank you so much!

Regard,
Don

Violets 12 years ago

Screw this. I used it to export my products, filled in some more and then reimported and it buggered up my entire shop.

The products appeared but if I tried to edit them via the admin page, when I click save I get a blank screen.

Products entered manually work fine when editing, imported products don't.

Had to completely recreate my shop from scratch as it screwed my DB. Thanks for nothing!

sanyo8 12 years ago

Perfect!!!! Thank You! (opencart v. 1.5.6)

jelwin 12 years ago

When I am trying to export data I am getting an error "Could not close zip file php://output.
See also 'System > Error Logs' for more details."
temp folder have write permissions (777)
also Zip enabled
2013-11-23 3:16:21 - PHP Warning: realpath(): open_basedir restriction in effect. File(/tmp) is not within the allowed path(s): (/var/zpanel/hostdata/zadmin/public_html/domain_com:/var/zpanel/temp/) in /var/zpanel/hostdata/zadmin/public_html/domain_com/system/PHPExcel/Classes/PHPExcel/Shared/File.php on line 136

Unknowntramp 12 years ago

Hi!

After installing Export/Import Tool for Opencart 1.5.5.1 when I try to export file there are an error:
Could not close zip file php://output.
See also 'System > Error Logs' for more details.

In error log:
2013-11-18 19:37:11 - PHP Warning: realpath(): open_basedir restriction in effect. File(/tmp) is not within the allowed path(s): (/var/www/yzelianko/data:.) in /var/www/yzelianko/data/www/test.by-ava.com/system/PHPExcel/Classes/PHPExcel/Shared/File.php on line 136
2013-11-18 19:37:11 - PHP Warning: tempnam(): open_basedir restriction in effect. File() is not within the allowed path(s): (/var/www/yzelianko/data:.) in /var/www/yzelianko/data/www/test.by-ava.com/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php on line 205
2013-11-18 19:37:12 - PHP Exception: Could not close zip file php://output. in /var/www/yzelianko/data/www/test.by-ava.com/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php on line 378

sumaiya 12 years ago

I am using options import module, how can i import stock per sku (sku is different for every size in a product)

jmasril 12 years ago

I just reinstall the mod, and all the time my data is croped, when i open the file in the excell, it show a warnng that the file could be corrupted and when i click to continue, it just lost much product info.

there is no other errors. so how can i fix this?

Thanks

wazaus 12 years ago

@dtpcom: Just export first and that will give you the file to use. If you have the sample products still in the product database you can see how the fields all match up

robingupta 12 years ago

Hello Admin,

I am using opencart 1.5.5.1 and install your extension but its showing warning and error in error log when i am going to export. Errors in error log is:

2013-11-13 14:19:39 - PHP Warning: stream_wrapper_unregister(): Unable to unregister protocol zip:// in /sites/standard-overseas.nl/www/system/PHPExcel/Classes/PHPExcel/Shared/ZipStreamWrapper.php on line 69
2013-11-13 14:19:39 - PHP Warning: set_time_limit() has been disabled for security reasons in /sites/standard-overseas.nl/www/admin/model/tool/export.php on line 2569
2013-11-13 14:19:40 - PHP Fatal Error: Class 'ZipArchive' not found in /sites/standard-overseas.nl/www/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php on line 234

Can you help me please?

How can i fix these issues, i am not getting.

Thanks
Robin

kelownabaskets 12 years ago

opencart 1.5.6
Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 65536 bytes) in /var/www/opencart/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/CacheBase.php on line 155

earns this extension a fail

dtpcom 12 years ago

HI everybody...
where can i download a sample xslx file?

thank you in advance.

ontbijtkoe 12 years ago

Hello,

When I import products they dont show up on the product page on the backend. They DO show up in the front end. any suggestions?