Post by Valentine88 » Fri Mar 08, 2013 12:20 pm

_x000D_

If anyone gets this showing up on their product pages try this..
I don't know if this is the correct way to fix this but here's what I did and it fixed it in a jiffy:

Export everything, open in excel or openoffice

find all: "_x000D_"
replace all with: "<br>"

import back

Fixed..

Newbie

Posts

Joined
Sun Jan 20, 2013 5:02 pm

Post by sjmaceyful » Mon Mar 11, 2013 10:52 pm

I made the post very clear and even posted a screen shot, zip IS installed, the phpinfo for the site quite clearly shows that it is enabled.

But I am still getting the same error message.

Newbie

Posts

Joined
Thu Jun 16, 2011 5:11 pm

Post by ForgetfulGuru » Tue Mar 12, 2013 4:45 pm

I would just like to take the time to say thank you for this excellent modification. It would really be nice to see something like this as a standard part of OC.

Big thumbs up to JNeuhoff 8) You are the MAN :D

Life is for the taking. It's everything else you need to pay for.
Anne Makes Lovely Candles


User avatar
New member

Posts

Joined
Sun Jul 22, 2012 11:12 pm
Location - Left hand corner as you enter the room, better feng shui.

Post by octhebest » Thu Mar 14, 2013 5:48 am

Dear Mates,
I am Running on OpenCart 1.5.5.1 with Import/Export Tool Updates.
But i am getting the following Error always.

PHP Fatal Error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 76 bytes) in /home/sc/public_html/mydomain.com.com/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/Memory.php on line 46


Please any solution ??Thanks alot..
Last edited by octhebest on Tue Mar 19, 2013 12:44 am, edited 1 time in total.

Newbie

Posts

Joined
Tue Jan 08, 2013 9:24 pm

Post by rbakkers » Fri Mar 15, 2013 5:06 am

Hi, I've updated Opencart to 1.5.5.1 and also your great Export/Import tool but suddenly it's not working anymore. The previous version worked perfectly. I've got the same error as previously described and I've checked, php_safe mode is off.

2013-03-14 21:48:45 - PHP Exception: Could not close zip file php://output. in /public/sites/www.-x-.nl/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php on line 378

What am I doing wrong? Should I give write permissions to a folder?

But beyond that you have done an excellent job with this tool. Thx!

Regards, René

Attachments

Clipboard01.jpg

Clipboard01.jpg (91.17 KiB) Viewed 5001 times


Newbie

Posts

Joined
Sun Oct 14, 2012 7:56 pm

Post by JNeuhoff » Sat Mar 16, 2013 7:47 am

rbakkers wrote:Hi, I've updated Opencart to 1.5.5.1 and also your great Export/Import tool but suddenly it's not working anymore. The previous version worked perfectly. I've got the same error as previously described and I've checked, php_safe mode is off.

2013-03-14 21:48:45 - PHP Exception: Could not close zip file php://output. in /public/sites/www.-x-.nl/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php on line 378

What am I doing wrong? Should I give write permissions to a folder?

But beyond that you have done an excellent job with this tool. Thx!

Regards, René
Take a look at http://phpexcel.codeplex.com/discussions/402403 , maybe changing the temp dir in yourPHP settings (e.g. using system/cache) helps with the problem of not having write access to your temp dir.

MHC Web Design
Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * TrustPilot Reviews * Google Rich Snippets * Google Tag Manager * Export/Import Tool * Template Switcher PHP/Twig


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by zigzag253 » Tue Mar 19, 2013 7:31 pm

PHP Fatal Error: Call to undefined method PHPExcel_Reader_HTML::setReadDataOnly() in C:\Domains\*****\wwwroot\admin\model\tool\export.php on line 1643

Thank you for a wonderful tool which is working perfectly on another 1.5.5.1 installation. I was trying to move products and categories from it to a new installation on another domain/server and get the above error message. There are very few categories and products (around 25/90). Is it possible to do this and if so could you please give me an idea of the problem and solution? Many thanks.

Newbie

Posts

Joined
Tue Jan 22, 2013 7:52 am

Post by zigzag253 » Tue Mar 19, 2013 8:18 pm

Getting the same result exporting from new install is OK, updating and trying to import back fails as above.

Newbie

Posts

Joined
Tue Jan 22, 2013 7:52 am

Post by rbakkers » Wed Mar 20, 2013 4:40 am

@J.Neuhoff
I've contacted the provider and temp dir is accesable. Next I've checked Owner/Group rights (FTP) and they are all the same. What to do next? Is there a possibilty that the syteem is working with other rights than the FTP one?
Regards, René

Newbie

Posts

Joined
Sun Oct 14, 2012 7:56 pm

Post by ultraspoon » Thu Mar 21, 2013 9:10 am

Hi there JNeuhoff,

I am having a problem with your extension. When importing, the information goes into the database, but does not show in the catalog or in the admin. When I then export again, it does not export any new information only what was originally in the store to start with. I have tested this on a fresh install of Opencart. Any help would be greatly appreciated. This is the only error I get.

2013-03-21 1:02:09 - PHP Notice: iconv_substr() [<a href='function.iconv-substr'>function.iconv-substr</a>]: Unknown error (0) in /home/vhosts/httpdocs/new2/system/PHPExcel/Classes/PHPExcel/Shared/String.php on line 306

Active Member

Posts

Joined
Mon Oct 18, 2010 5:56 pm

Post by tmorgan » Fri Mar 22, 2013 10:12 am

Hello JNeuhoff,

Thanks again for your work on this free extension!!!

I have OC V1.5.5.1 configured matched with your export/import tool opencart-1-5-5-x-export-import-15.zip.

I am receiving the following error when attempting to export my products:

"Error: MySQL server has gone away
Error No: 2006
SELECT `product_id`, `image`, `sort_order` FROM `product_image` pi ORDER BY pi.`product_id`, pi.`sort_order`, pi.`image`;
See also 'System > Error Logs' for more details."

Categories: 102
Products: 3360

Could you please advise some tips to resolve this issue ? If not related to your extension but rather a MYSQL configuration item any advice would be greatly appreciated.

Thanks

Tim

Newbie

Posts

Joined
Wed Sep 16, 2009 11:59 am

Post by Ralba » Tue Mar 26, 2013 1:52 pm

Hi JNeuhoff,

I have problem when importing datasheet. My OC version is 1.5.5.1.

There's several errors in error log:

2013-03-26 6:28:21 - PHP Unknown: Only variables should be assigned by reference in C:\xampp\htdocs\xxxxxxx\admin\model\tool\export.php on line 1512
2013-03-26 6:28:21 - PHP Unknown: Only variables should be assigned by reference in C:\xampp\htdocs\xxxxxxx\admin\model\tool\export.php on line 1521
2013-03-26 6:28:21 - PHP Unknown: Only variables should be assigned by reference in C:\xampp\htdocs\xxxxxxx\admin\model\tool\export.php on line 1539
2013-03-26 6:28:21 - PHP Unknown: Only variables should be assigned by reference in C:\xampp\htdocs\xxxxxxx\admin\model\tool\export.php on line 1548
2013-03-26 6:28:21 - PHP Unknown: Only variables should be assigned by reference in C:\xampp\htdocs\xxxxxxx\admin\model\tool\export.php on line 1557
2013-03-26 6:28:21 - PHP Unknown: Only variables should be assigned by reference in C:\xampp\htdocs\xxxxxxx\admin\model\tool\export.php on line 1566
2013-03-26 6:28:21 - PHP Unknown: Only variables should be assigned by reference in C:\xampp\htdocs\xxxxxxx\admin\model\tool\export.php on line 1575

These errors appears when I'm using finnish translation in Opencart.

Newbie

Posts

Joined
Tue Mar 26, 2013 1:31 pm

Post by coolbreeze86 » Mon Apr 08, 2013 11:27 pm

Hi your mod is working fine while importing products, but when i try to export it i cannot able to export it.

Also the file which i tried to import was about 1.99mb but the file which i downloaded was only 235 kb. Pls see the attachment for the error.

I tried to remove the line 110 by following your previous solution http://forum.opencart.com/viewtopic.php ... 18#p384112, but the line seems empty in my files.

Can you help me out?

Attachments

excel error.png

excel error.png (156.02 KiB) Viewed 4798 times


New member

Posts

Joined
Sun Mar 17, 2013 4:36 am

Post by coolbreeze86 » Tue Apr 09, 2013 4:45 am

pls someone help me.. i am waiting here i badly need it now..

New member

Posts

Joined
Sun Mar 17, 2013 4:36 am

Post by JNeuhoff » Tue Apr 09, 2013 5:07 am

coolbreeze86 wrote:pls someone help me.. i am waiting here i badly need it now..
Yours, like so many of the other messages on this forum thread, simply doesn't provide enough details to reproduce your error, so we are unable to help you.

How about telling us what online error messages you got? Or what messages you got in your OpenCart system/logs/error.txt? Or those from your server's error_log?

Also, try openingn your XLSX file in OpenOffice or LibreOffice.

MHC Web Design
Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * TrustPilot Reviews * Google Rich Snippets * Google Tag Manager * Export/Import Tool * Template Switcher PHP/Twig


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by tmorgan » Tue Apr 09, 2013 5:52 am

Hi JNeuhoff, apologies if the post below does not contain sufficient information to troubleshoot (let me know if that is the case and what further information you might require)... any help would be greatly appreciated.

Attached below is the error from System\Error Log

"2013-04-08 22:04:44 - PHP Warning: stream_wrapper_unregister() [<a href='function.stream-wrapper-unregister'>function.stream-wrapper-unregister</a>]: Unable to unregister protocol zip:// in /home/elitep/public_html/home2/system/PHPExcel/Classes/PHPExcel/Shared/ZipStreamWrapper.php on line 69
2013-04-08 22:07:39 - PHP Notice: Error: MySQL server has gone away<br />Error No: 2006<br />SELECT `product_id`, `image`, `sort_order` FROM `product_image` pi ORDER BY pi.`product_id`, pi.`sort_order`, pi.`image`; in /home/elitep/public_html/home2/system/database/mysql.php on line 50"
tmorgan wrote:Hello JNeuhoff,

Thanks again for your work on this free extension!!!

I have OC V1.5.5.1 configured matched with your export/import tool opencart-1-5-5-x-export-import-15.zip.

I am receiving the following error when attempting to export my products:

"Error: MySQL server has gone away
Error No: 2006
SELECT `product_id`, `image`, `sort_order` FROM `product_image` pi ORDER BY pi.`product_id`, pi.`sort_order`, pi.`image`;
See also 'System > Error Logs' for more details."

Categories: 102
Products: 3360

Could you please advise some tips to resolve this issue ? If not related to your extension but rather a MYSQL configuration item any advice would be greatly appreciated.

Thanks

Tim

Newbie

Posts

Joined
Wed Sep 16, 2009 11:59 am

Post by coolbreeze86 » Tue Apr 09, 2013 1:19 pm

JNeuhoff wrote:
coolbreeze86 wrote:pls someone help me.. i am waiting here i badly need it now..
Yours, like so many of the other messages on this forum thread, simply doesn't provide enough details to reproduce your error, so we are unable to help you.

How about telling us what online error messages you got? Or what messages you got in your OpenCart system/logs/error.txt? Or those from your server's error_log?

Also, try openingn your XLSX file in OpenOffice or LibreOffice.
first of all my thanks to give support. :)
I didn't get any online error messages when i try to download it. It just saved the file perfectly without error. But the size of the file is very low comparing to my file which i used to import. (that means the file is not fully saved no...)

BTW, here is the error message i found in the system/logs/error.txt

2013-04-09 5:11:12 - PHP Fatal Error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 84 bytes) in /home/xxxxxx/public_html/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/CacheBase.php on line 155
2013-04-09 5:11:12 - PHP Warning: Cannot modify header information - headers already sent by (output started at /home/xxxxxx/public_html/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/CacheBase.php:155) in /home/xxxxxx/public_html/admin/model/tool/export.php on line 49
2013-04-09 5:11:12 - PHP Warning: Cannot modify header information - headers already sent by (output started at /home/xxxxxx/public_html/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/CacheBase.php:155) in /home/xxxxxx/public_html/admin/model/tool/export.php on line 50

New member

Posts

Joined
Sun Mar 17, 2013 4:36 am

Post by JNeuhoff » Tue Apr 09, 2013 4:57 pm

coolbreeze86 wrote:
JNeuhoff wrote:
coolbreeze86 wrote:pls someone help me.. i am waiting here i badly need it now..
Yours, like so many of the other messages on this forum thread, simply doesn't provide enough details to reproduce your error, so we are unable to help you.

How about telling us what online error messages you got? Or what messages you got in your OpenCart system/logs/error.txt? Or those from your server's error_log?

Also, try openingn your XLSX file in OpenOffice or LibreOffice.
first of all my thanks to give support. :)
I didn't get any online error messages when i try to download it. It just saved the file perfectly without error. But the size of the file is very low comparing to my file which i used to import. (that means the file is not fully saved no...)

BTW, here is the error message i found in the system/logs/error.txt

2013-04-09 5:11:12 - PHP Fatal Error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 84 bytes) in /home/xxxxxx/public_html/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/CacheBase.php on line 155
2013-04-09 5:11:12 - PHP Warning: Cannot modify header information - headers already sent by (output started at /home/xxxxxx/public_html/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/CacheBase.php:155) in /home/xxxxxx/public_html/admin/model/tool/export.php on line 49
2013-04-09 5:11:12 - PHP Warning: Cannot modify header information - headers already sent by (output started at /home/xxxxxx/public_html/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/CacheBase.php:155) in /home/xxxxxx/public_html/admin/model/tool/export.php on line 50
Increase your PHP setting for the memory_limit

MHC Web Design
Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * TrustPilot Reviews * Google Rich Snippets * Google Tag Manager * Export/Import Tool * Template Switcher PHP/Twig


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by coolbreeze86 » Tue Apr 09, 2013 11:23 pm

JNeuhoff wrote: Increase your PHP setting for the memory_limit
My present memory limit is 512M.

what is the best value, so that i can increase it and give a try.
Last edited by coolbreeze86 on Wed Apr 10, 2013 12:55 am, edited 1 time in total.

New member

Posts

Joined
Sun Mar 17, 2013 4:36 am

Post by kylelnsn » Wed Apr 10, 2013 12:34 am

I need to add another column to the products table.

We have a cost field in products in the database, is there a way to add this to the export? I dont want to fudge it myself can someone shed some light?

New member

Posts

Joined
Mon Apr 09, 2012 9:52 pm
Who is online

Users browsing this forum: No registered users and 4 guests