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.
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.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
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Can you please look at my question about openoffice rename the colums weard.JNeuhoff wrote: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.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
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.Xciso wrote: Can you please look at my question about openoffice rename the colums weard.
I also gave a link to image.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
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
You are using the wrong version of the Export/Import tool which doesn't match your OpenCart version.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 />
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
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 (11.9 KiB) Viewed 5126 times
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
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..
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.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.
But I am still getting the same error message.
Big thumbs up to JNeuhoff You are the MAN
Life is for the taking. It's everything else you need to pay for.
Anne Makes Lovely Candles
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..
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 (91.17 KiB) Viewed 6037 times
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.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é
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
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.
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é
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
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
Users browsing this forum: No registered users and 39 guests