frosto 12 years ago

Hi, got this message from Error logs:

2013-11-04 7:54:25 - PHP Fatal Error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 84 bytes) in /home/2/r/domain/www/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/CacheBase.php on line 155
2013-11-04 7:54:25 - PHP Warning: Cannot modify header information - headers already sent by (output started at /home/2/r/domain/www/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/CacheBase.php:155) in /home/2/r/domain/www/admin/model/tool/export.php on line 49
2013-11-04 7:54:25 - PHP Warning: Cannot modify header information - headers already sent by (output started at /home/2/r/domain/www/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/CacheBase.php:155) in /home/2/r/domain/www/admin/model/tool/export.php on line 50

Any suggenstion?

Frode :-)

Dionis 12 years ago

Installed the app to version Opencart 1.5.5.1 did everything according to the instructions and eventually errors

2013-11-03 20:40:42 - PHP Warning: realpath(): open_basedir restriction in effect. File(/tmp) is not within the allowed path(s): (/var/www/delcapi1/data:.) in /var/www/delcapi1/data/www/delcapitano.ru/system/PHPExcel/Classes/PHPExcel/Shared/File.php on line 136
2013-11-03 20:40:42 - PHP Warning: tempnam(): open_basedir restriction in effect. File() is not within the allowed path(s): (/var/www/delcapi1/data:.) in /var/www/delcapi1/data/www/delcapitano.ru/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php on line 205
2013-11-03 20:40:43 - PHP Exception: Could not close zip file php://output. in /var/www/delcapi1/data/www/delcapitano.ru/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php on line 378

how to solve?

CvanRij 12 years ago

I've installed opencart-1-5-5-x-export-import-15
When importing I get: Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 36 bytes) in ...public_html/system/PHPExcel/Classes/PHPExcel/Cell.php on line 531

It seems that the error only comes up if I have more than ±3900 attributes in the Excel file, but I need to import a lot more.
Is there a solution?

er.rahulkumar 12 years ago

I have installed this for OC 1.5.5.1, but its generated excel file is giving while opening it. when i reload Export/Import page in admin after exporting the file, it shows:

'Class 'ZipArchive' not found
See also 'System > Error Logs' for more details.

in Error logs it shows following details:

2013-10-31 7:44:36 - PHP Warning: Cannot modify header information - headers already sent by (output started at /home/uniqe/public_html/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php:234) in /home/uniqe/public_html/admin/model/tool/export.php on line 49

2013-10-31 7:44:36 - PHP Warning: Cannot modify header information - headers already sent by (output started at /home/uniqe/public_html/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php:234) in /home/uniqe/public_html/admin/model/tool/export.php on line 50

Please help me...

jagdish2157 12 years ago

Nice Extension works for 1.5.5.1
Thanks @JNeuhoff for this
five stars

karanthakkar 12 years ago

hi,
i have OC 1.5.6
can any1 please help me.
when i click on export.
(havent tried import yet.)

im getting following error

Could not open php://output for writing.
See also 'System > Error Logs' for more details.

and in error log

2013-10-23 5:55:52 - PHP Exception: Could not open php://output for writing. in /mounted-storage/****/****/****/****/upload/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php on line 248

how to get rid of this problem.

levybee 12 years ago

I installed version 1.5.5.x of your plugin in OpenCart version 1.5.5.1. I get this error when I try to export:

Error: Unknown column 'p.ean' in 'field list'
Error No: 1054
SELECT p.product_id, pd.name, GROUP_CONCAT( DISTINCT CAST(pc.category_id AS CHAR(11)) SEPARATOR "," ) AS.....

Is there a way to fix that. Thanks.

jethrochong1491 12 years ago

Hi. Good day.

Just need to enquiry is your module compatible is it compatible with Extra Product Tab & Additional Product Tabs?

Meaning the extra tabs information can be import and export at any time?

I tried todate but no extra tab colume and informtions appeared in the extracted table, and cannot be re-import with the import table.

ajojavi 12 years ago

Hi, first af all I want to tell you THANKS! for this great module, You really save my life!, on the other hand I have to suggest a very important thing to me. Could be great if in the products sheet, one of the column was the download link (the name of the mask or file, which is allways in the download folder and created the download mask before...). I don´t know how it can not come with this absoluty necesary column. After create almost 400 products, I have to open one by one and writte the attached file. I don´t know almost nothing about programming, but I thing this could be forgoten because the person who created this module maybe was thinking in other kind of products, now download items...and it seems not be a big deal...
Someone has any idea to solve this?
Thanks!

Gizzlo 12 years ago

A Very big thank you, to the Person that made this Module you should have been two!!!

pradra 12 years ago

Hello,

I installed this extension on my site, however it gives errors when I try to export or import, problems with the zip archive it says in the logs, can you please help me.

If you want a login, please send your email, thanks in advance.

Kind regards,
Roger

looserfoot 12 years ago

Question..can I install this extension to export previously added (before extension) product data?
Lasa2

Dakkafex 12 years ago

it exports fine and when i try to import its to another store it says it worked but the store and categories are still empty

Yustas 12 years ago

I download the extension, install by instructions, all is fine. But when i tried to export database ~3000 products, there is an error:
Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 93 bytes) in /home/xxx/public_html/system/PHPExcel/Classes/PHPExcel/Style.php on line 470
Is is a problem with big memory needs? Is ir possible to export database partially?

James Parry-Jones 12 years ago

Hi

I have installed the 1.5.5.1 version of the import export tool which is great by the way! However I have noticed that it has started to duplicate some of the headers text so my spreadsheet will read for example 'status enabled status enabled status enabled' which will obviously not get imported back into opencart because of the incorrect headings, meaning everytime I have to go into the document and tidy up the heading before allowing me to import. However more importantly I have noticed that on export the tool also seems to be duplicating the product descriptions a countless number of times which I have then accidently re-imported into the store and now have lines and lines of repeated description text for every product. When I then try to edit the spreadsheet its so slow which im guessing is down to the duplication of all the data. I appreciate it is most probably down to an error I have made along the way but I dont suppose you can help?

Thanks in advance

matteoraggi 12 years ago

When I import products then it overwrite my old products.
So I decided to change the product id making it bigger and products are showed on the site, but they don't appear on the admin area: I can't edit the categories and the products and I need it. How to patch it?
How to delete the products and categories tht are into db but are not showed and or managable?

mozyapar 13 years ago

Multi-language support does not work. Help me.

techwrath 13 years ago

hi,
i have installed the module in 1.5.2.1 version. it looks ok. but when i export the file and open the file it gives me error message and says that "the file has another extension as it is displaying xls, and it cannot be opened. when i open it anyways it shows coding with the data. it shows like <br> <tr>data</tr> etc"

I have tested it 3-4 times, its giving the same error.
Can anyone please help. im using it on www.bargainmarket.com.au

bagobongo 13 years ago

Went to edit settings and got this error message;

Fatal error: Cannot access private property Document::$title in /home/shopweid/domains/bagobongo.com/public_html/admin/controller/shipping/canadapost.php on line 18

bagobongo 13 years ago

Just installed on open cart 1.5.6 - getting error message:

Fatal error: require_once() [function.require]: Failed opening required 'Spreadsheet/Excel/Writer.php' (include_path='.:/usr/local/lib/php') in /home/shopweid/domains/bagobongo.com/public_html/admin/model/tool/export.php on line 2393