[RELEASED] Export/Import tool for OpenCart 1.5.5.x

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.

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.

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.

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.

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

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.

thank you

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.

See http://www.php.net/manual/en/zip.installation.php and http://phpexcel.codeplex.com/discussions/233977 for more details on how to install it.

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

JNeuhoff wrote:See http://www.php.net/manual/en/zip.installation.php and http://phpexcel.codeplex.com/discussions/233977 for more details on how to install it.

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.

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 You are the MAN

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

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é

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.

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.

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

@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é

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

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