I am aware of this issue, I'll probably switch from XLS to ODS in the next version, in order to get proper UTF-8 support implemented, Microsoft's XLS format simply has too many issues with UTF-8.baillie11 wrote:Hi,
I have downloaded opencart-1-5-4-x-export-import-13.zip for OpenCart 1.5.4.1 and have been able to export without any problems, however, when I import products, I receive a message saying it has worked, however, none of the products appear in the admin-catalog-products area, nor on the front end.
I have checked and error logs in VQModManager & System-Error Logs and have even cleared them.
I have opened cart in different browser (in case the cache hasn't cleared properly). I even exported the data back out and it still doesn't appear in the spreadsheet.
Any suggestions on what I could be doing wrong (im presuming it me, not your software - lol).
Thanks
Andrew
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
It would be very useful to import/export the links for the download. + the download itself (to create it).
My shop has only products to be downloaded. So if you import - the link to the download has gone. It cannot be used for this purpose at the moment?! :-(
Could you include this in your tool?
best regards,
Axel
Any luck getting this sorted? I'm in the same boat - have been for quite a while...meggabecca wrote:Hi
Because of memory issues, I spilt my spreadsheets into sections, but the problem is everytime I upload a spreadsheet, it gets rid of all the other products, so now back to square one, it seems most have memory problems this rubbish, can anyone suggest something else other than paying out £30 per month for dedicated server, which seems extreme, and can not validate paying that, so any other suggestions of finding a work around, to solve these memory issues...
Thanks in Advance
Does anyone know how to do incremental uploads or if it is even possible?
Thanks,
L
I use your extension since my first opening of my shop. I now encountered a big problem with memory limits.
I have a 1.7 MB excel file, so I don't know what can cause this (maybe it's because I have a few romanian characters in UTF-8?):
Fatal Error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 93 bytes) in /clients/HR7409/domains/importpieseauto.ro/system/PHPExcel/Classes/PHPExcel/Worksheet.php on line 961
Especially since it worked well so far.
I'm on 1.5.1.3 with 8.1 version of your extension.
Info.php file says:
memory_limit 230M 230M
I'm using Open Cart 1.5.4.1 on http://www.importpieseauto.ro
Can you someone send me one .xls file redy to use (only one product inside or more)
I just want to see how to make this .xls file to be redy for use in Impot.
I cant make this file.
Could you send or show me one .xls file ready to Import (with one or more products).
I can't make xls file which is Ok for Import.
I just need to see one corectly made.
Thanks in advance.
Do an Export first, and use the resulting spreadsheet to overwriteitwith your own values. Then import it.tidusbg wrote:Hello!
Could you send or show me one .xls file ready to Import (with one or more products).
I can't make xls file which is Ok for Import.
I just need to see one corectly made.
Thanks in advance.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
JNeuhoff wrote:Do an Export first, and use the resulting spreadsheet to overwriteitwith your own values. Then import it.tidusbg wrote:Hello!
Could you send or show me one .xls file ready to Import (with one or more products).
I can't make xls file which is Ok for Import.
I just need to see one corectly made.
Thanks in advance.
When i export xls I recive this massage in xls file:
Code: Select all
<b>Notice</b>: Error: Table '.........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=2 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=2 LEFT JOIN `oc_length_class_description` mc ON mc.length_class_id=p.length_class_id AND mc.language_id=2 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=2 GROUP BY p.product_id ORDER BY p.product_id, pc.category_id; in <b>public_html/openchart/system/database/mysql.php</b> on line <b>50</b>
You are using the wrong version of the Export/Import tool, there is no longer a product_tag table in OpenCart.tidusbg wrote:
Do an Export first, and use the resulting spreadsheet to overwriteitwith your own values. Then import it.
When i export xls I recive this massage in xls file:
<b>Notice</b>: Error: Table '.........oc_product_tag' doesn't exist
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
You are using the wrong version of the Export/Import tool, there is no longer a product_tag table in OpenCart.[/quote]JNeuhoff wrote:tidusbg wrote:
Do an Export first, and use the resulting spreadsheet to overwriteitwith your own values. Then import it.
When i export xls I recive this massage in xls file:
Code: Select all
<b>Notice</b>: Error: Table '.........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=2 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=2 LEFT JOIN `oc_length_class_description` mc ON mc.length_class_id=p.length_class_id AND mc.language_id=2 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=2 GROUP BY p.product_id ORDER BY p.product_id, pc.category_id; in <b>public_html/openchart/system/database/mysql.php</b> on line <b>50</b>
Yes now I see. I use 1.5.3 and i have OC 1.5.5
Thanks
Can I import more than 1500 products?
I try but it gives me an error.
If I try a second import - tool deletes older products.
If there is a way to import product more of 1500, could you share.
How to remove this isntallation, so that i can install the new Export/Import tool for OpenCart 1.5.4
Use 1.5.5.1maney wrote:Hey,
Installed on 1.5.5 and I'm getting this error, can you help?
Fatal error: Call to undefined method Loader::language() in /var/sites/r/reliablereptile.co.uk/public_html/admin/controller/tool/export.php on line 6
Thanks!
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
one possible solutions might be following:
1. go to your site with an ftp client
2. find and open .htaccess file or htaccess.txt
add this line into the file:
3. php_value memory_limit 1024M
4. if you have htaccess.txt then rename it to .htaccess
usually there are limitations set by providers, but they almost always have a backdoor by editing this into the htaccess file.
this is a small piece of my file:
# Prevent Directoy listing
Options -Indexes
# Memory allocation
php_value memory_limit 1024M
# Prevent Direct Access to files
<FilesMatch "\.(tpl|ini|log)">
Order deny,allow
Deny from all
</FilesMatch>
hope this helps!
Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 1048576 bytes) in /home/dx4455/www/stor/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/Memory.php on line 47
Fatal Error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 1048576 bytes) in /home/dx4455/www/stor/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/Memory.php on line 47
Users browsing this forum: No registered users and 40 guests