Post by Xciso » Wed Feb 27, 2013 2:12 pm

Is it anyone more that have the same problem that i wrote above about that some colums get weard names.

One more thing. Do you know how we can do to also insert the new filter to all products?
If we cant insert them with this extension we still need to edit all products from admin.

Active Member

Posts

Joined
Fri Jul 15, 2011 5:20 am

Post by JNeuhoff » Wed Feb 27, 2013 10:42 pm

Xciso wrote:J. Can you please try to reply my questions above?
I'm a fan of your extension and sittning here and wait for your answar ;)
If you are referring to the product filter, I haven't done it yet. However, as long as you don't change the product_id, the Export/Import tool won't destroy any product filters on your database.

Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Rich Snippets * Google Tag Manager * Export/Import Tool * SpamBot Buster * Survey Plus


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by Xciso » Wed Feb 27, 2013 10:47 pm

JNeuhoff wrote:
Xciso wrote:J. Can you please try to reply my questions above?
I'm a fan of your extension and sittning here and wait for your answar ;)
If you are referring to the product filter, I haven't done it yet. However, as long as you don't change the product_id, the Export/Import tool won't destroy any product filters on your database.
Can you please look at my question about openoffice rename the colums weard.
I also gave a link to image.

Active Member

Posts

Joined
Fri Jul 15, 2011 5:20 am

Post by JNeuhoff » Wed Feb 27, 2013 11:55 pm

Xciso wrote: Can you please look at my question about openoffice rename the colums weard.
I also gave a link to image.
No idea why it would do that. Looks like your spreadsheet software can't cope with Unix-style line endings in a header field. Post a link to your XLSX file so I can try and open it, too see what happens.

Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Rich Snippets * Google Tag Manager * Export/Import Tool * SpamBot Buster * Survey Plus


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by synthcube » Sat Mar 02, 2013 7:45 pm

Hello! I am looking forward to using this extension.

When trying an export for the first time, here is the error log:

2013-03-02 4:43:32 - PHP Notice: Error: Table 'shopdbuser99.oc_product_tag' doesn't exist<br />Error No: 1146<br />SELECT p.product_id, pd.name, GROUP_CONCAT( DISTINCT CAST(pc.category_id AS CHAR(11)) SEPARATOR "," ) AS categories, p.sku, p.upc, p.location, p.quantity, p.model, m.name AS manufacturer, p.image AS image_name, p.shipping, p.price, p.points, p.date_added, p.date_modified, p.date_available, p.weight, wc.unit, p.length, p.width, p.height, p.status, p.tax_class_id, p.viewed, p.sort_order, pd.language_id, ua.keyword, pd.description, pd.meta_description, pd.meta_keyword, p.stock_status_id, mc.unit AS length_unit, p.subtract, p.minimum, GROUP_CONCAT( DISTINCT CAST(pr.related_id AS CHAR(11)) SEPARATOR "," ) AS related, GROUP_CONCAT( DISTINCT pt.tag SEPARATOR "," ) AS tags FROM `oc_product` p LEFT JOIN `oc_product_description` pd ON p.product_id=pd.product_id AND pd.language_id=1 LEFT JOIN `oc_product_to_category` pc ON p.product_id=pc.product_id LEFT JOIN `oc_url_alias` ua ON ua.query=CONCAT('product_id=',p.product_id) LEFT JOIN `oc_manufacturer` m ON m.manufacturer_id = p.manufacturer_id LEFT JOIN `oc_weight_class_description` wc ON wc.weight_class_id = p.weight_class_id AND wc.language_id=1 LEFT JOIN `oc_length_class_description` mc ON mc.length_class_id=p.length_class_id AND mc.language_id=1 LEFT JOIN `oc_product_related` pr ON pr.product_id=p.product_id LEFT JOIN `oc_product_tag` pt ON pt.product_id=p.product_id AND pt.language_id=1 GROUP BY p.product_id ORDER BY p.product_id, pc.category_id; in /home/content/75/8897975/html/cart/system/database/mysql.php on line 49

What do I need to change or fix?
thanks

Newbie

Posts

Joined
Sat Mar 02, 2013 9:31 am

Post by JNeuhoff » Sat Mar 02, 2013 9:05 pm

synthcube wrote:Hello! I am looking forward to using this extension.

When trying an export for the first time, here is the error log:

2013-03-02 4:43:32 - PHP Notice: Error: Table 'shopdbuser99.oc_product_tag' doesn't exist<br />
You are using the wrong version of the Export/Import tool which doesn't match your OpenCart version.

Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Rich Snippets * Google Tag Manager * Export/Import Tool * SpamBot Buster * Survey Plus


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by synthcube » Sat Mar 02, 2013 9:12 pm

thank you

Newbie

Posts

Joined
Sat Mar 02, 2013 9:31 am

Post by sjmaceyful » Tue Mar 05, 2013 11:45 pm

Hi,

Running version 1.5.5.1 of OC with correct version of Export/Import and latest VQMod.

I get the following error log entries after trying to Export:

"2013-03-05 15:36:04 - PHP Warning: stream_wrapper_unregister() [<a href='function.stream-wrapper-unregister'>function.stream-wrapper-unregister</a>]: Unable to unregister protocol zip:// in /home/firstcla/public_html/system/PHPExcel/Classes/PHPExcel/Shared/ZipStreamWrapper.php on line 69
2013-03-05 15:36:04 - PHP Fatal Error: Class 'ZipArchive' not found in /home/firstcla/public_html/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php on line 234
2013-03-05 15:36:04 - PHP Warning: Cannot modify header information - headers already sent by (output started at /home/firstcla/public_html/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php:234) in /home/firstcla/public_html/admin/model/tool/export.php on line 49
2013-03-05 15:36:04 - PHP Warning: Cannot modify header information - headers already sent by (output started at /home/firstcla/public_html/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php:234) in /home/firstcla/public_html/admin/model/tool/export.php on line 50"

Excel doesn't open the file but using notepad I can open it to see this:

"Fatal error: Class 'ZipArchive' not found in home/firstcla/public_html/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php on line 234"

After much battling with PHP configurations (such fun!) I managed to get ZIP and ZLIB both working on my server, however I am still getting the same issues. Have attached the php info to confirm it is installed.

I have tried everything I can think of and yes, I have Googled, but still can't find an answer. Any help would be much appreciated. I have used this for a long time on 1.5.1.3 and it has always worked without issue.

Thanks.

Attachments

phpinfo.png

phpinfo.png (11.9 KiB) Viewed 4594 times


Newbie

Posts

Joined
Thu Jun 16, 2011 5:11 pm

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 5505 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.

Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Rich Snippets * Google Tag Manager * Export/Import Tool * SpamBot Buster * Survey Plus


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
Who is online

Users browsing this forum: No registered users and 6 guests