i heve install Export/Import Module in latest version .
it display Error:
<b>Notice</b>: Error: Table 'ozarkbikershop_db.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 `product` p LEFT JOIN `product_description` pd ON p.product_id=pd.product_id AND pd.language_id=1 LEFT JOIN `product_to_category` pc ON p.product_id=pc.product_id LEFT JOIN `url_alias` ua ON ua.query=CONCAT('product_id=',p.product_id) LEFT JOIN `manufacturer` m ON m.manufacturer_id = p.manufacturer_id LEFT JOIN `weight_class_description` wc ON wc.weight_class_id = p.weight_class_id AND wc.language_id=1 LEFT JOIN `length_class_description` mc ON mc.length_class_id=p.length_class_id AND mc.language_id=1 LEFT JOIN `product_related` pr ON pr.product_id=p.product_id LEFT JOIN `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 <b>C:\wamp\www\ozarkbikershop\system\database\mysql.php</b> on line <b>50</b>
it display Error:
<b>Notice</b>: Error: Table 'ozarkbikershop_db.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 `product` p LEFT JOIN `product_description` pd ON p.product_id=pd.product_id AND pd.language_id=1 LEFT JOIN `product_to_category` pc ON p.product_id=pc.product_id LEFT JOIN `url_alias` ua ON ua.query=CONCAT('product_id=',p.product_id) LEFT JOIN `manufacturer` m ON m.manufacturer_id = p.manufacturer_id LEFT JOIN `weight_class_description` wc ON wc.weight_class_id = p.weight_class_id AND wc.language_id=1 LEFT JOIN `length_class_description` mc ON mc.length_class_id=p.length_class_id AND mc.language_id=1 LEFT JOIN `product_related` pr ON pr.product_id=p.product_id LEFT JOIN `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 <b>C:\wamp\www\ozarkbikershop\system\database\mysql.php</b> on line <b>50</b>
For quick, professional OpenCart support please email scf8127@gmail.com
There is no product_tag table in OpenCart 1.5. You have installed the wrong version of the Export/Import tool.shahid21290 wrote:i heve install Export/Import Module in latest version .
it display Error:
<b>Notice</b>: Error: Table 'ozarkbikershop_db.product_tag' doesn't exist<br />Error No: 1146<br />SELECT p.product_id, pd.name.....</b>
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Thank You ,
it's work greats..
it's work greats..
For quick, professional OpenCart support please email scf8127@gmail.com
First of all - thank you, this is a really useful tool.
But I'm having some trouble - everything works great until I try adding new products through the excel file. After some experimenting, I noticed that the problem is with the product ID. If I change it or if I add a new product with a new product ID, it doesn't import.
Is this intentional, or did I just mess up somewhere?
But I'm having some trouble - everything works great until I try adding new products through the excel file. After some experimenting, I noticed that the problem is with the product ID. If I change it or if I add a new product with a new product ID, it doesn't import.
Is this intentional, or did I just mess up somewhere?
Make sure each product has a unique Product ID. The same is true for the categeries' category ID.Articorse wrote:First of all - thank you, this is a really useful tool.
But I'm having some trouble - everything works great until I try adding new products through the excel file. After some experimenting, I noticed that the problem is with the product ID. If I change it or if I add a new product with a new product ID, it doesn't import.
Is this intentional, or did I just mess up somewhere?
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
I did - it still won't add the product if I change the ID or if I add a new product with a new ID. It only works with pre-existing product IDs for some reason.JNeuhoff wrote:Make sure each product has a unique Product ID. The same is true for the categeries' category ID.Articorse wrote:First of all - thank you, this is a really useful tool.
But I'm having some trouble - everything works great until I try adding new products through the excel file. After some experimenting, I noticed that the problem is with the product ID. If I change it or if I add a new product with a new product ID, it doesn't import.
Is this intentional, or did I just mess up somewhere?
Fatal error: Out of memory (allocated 167772160) (tried to allocate 67 bytes)
On a dedicated server. File size 3.5mb about 17,000 products.
1024M is the max memory limit already assigned on my server. I have also confirmed this with my host.
Can't seem to get passed that error message. I have already modified admin/php.ini
There seems to be a hard limit of 160MB, but I cannot seem to find the cause of it. 1024M is showing under phpinfo so I don't know whats going on.
On a dedicated server. File size 3.5mb about 17,000 products.
1024M is the max memory limit already assigned on my server. I have also confirmed this with my host.
Can't seem to get passed that error message. I have already modified admin/php.ini
There seems to be a hard limit of 160MB, but I cannot seem to find the cause of it. 1024M is showing under phpinfo so I don't know whats going on.
Was wondering if the programmer can add a feature where we can upload 5000 at a time without it being overwritten.
For example I import product 1-5000, then 5001-10000, 10001-15000 and so on. When I try that witht he 1.5.5.1 version it just overwrites it. So I'm here with only 5000 products uploaded to my site, and I have over 32,000 more to go.
For example I import product 1-5000, then 5001-10000, 10001-15000 and so on. When I try that witht he 1.5.5.1 version it just overwrites it. So I'm here with only 5000 products uploaded to my site, and I have over 32,000 more to go.
Hi
First, I would like to thank you for this wonderful extension, the Export/Import
Tool. It's great and above all, F.R.E.E. That's a plus for you, the developer.
Now, back to the reason why I'm writing...
I want to use the above mentioned extension to upload multiple products to my
store but the problem am having with this is because I use this Product Based
Shipping (http://bit.ly/11wUou3) that creates entries in my store Database.
On export, I found out the custom shipping column is missing. On import, the
shipping data set for each of the already existing products and the new products
are reset to default automatically. This is a pain in the eye* cos that simply
means I have to revisit each product and set the shipping data again each time
I make an import.
*Please, is there anything that can be done to include the shipping data in the
export and import. I don't want to die young uploading each product via the
default opencart system or worse still, go back to restore the shipping charge
for each product after every import made.
Any assistance would be very much appreciated.
Thanks
Richard O.
First, I would like to thank you for this wonderful extension, the Export/Import
Tool. It's great and above all, F.R.E.E. That's a plus for you, the developer.
Now, back to the reason why I'm writing...
I want to use the above mentioned extension to upload multiple products to my
store but the problem am having with this is because I use this Product Based
Shipping (http://bit.ly/11wUou3) that creates entries in my store Database.
On export, I found out the custom shipping column is missing. On import, the
shipping data set for each of the already existing products and the new products
are reset to default automatically. This is a pain in the eye* cos that simply
means I have to revisit each product and set the shipping data again each time
I make an import.
*Please, is there anything that can be done to include the shipping data in the
export and import. I don't want to die young uploading each product via the
default opencart system or worse still, go back to restore the shipping charge
for each product after every import made.
Any assistance would be very much appreciated.
Thanks
Richard O.
Hi,There,
Do you know how to uninstall export/import tool?I installed it on opencart v1.5.5.1,it works well.I really like it.but I need incremental function,however this export/import tool lack this function,and there is no sign that the author will update his version and add this feature in near future.so I have to buy some other import/export from somebody else.I installed other import/export tool on my opencart,but it did not show under admin. I am afraid this tool will have conflict with other import/export tool,I am trying to remove it.I tried to rename all the original file names,but I got a lot of errors.I read the readme file and seached this forum,I could not find any instruction on how to uninstall/remove this extension.
Thanks so much for your help in advance!
Joe
Do you know how to uninstall export/import tool?I installed it on opencart v1.5.5.1,it works well.I really like it.but I need incremental function,however this export/import tool lack this function,and there is no sign that the author will update his version and add this feature in near future.so I have to buy some other import/export from somebody else.I installed other import/export tool on my opencart,but it did not show under admin. I am afraid this tool will have conflict with other import/export tool,I am trying to remove it.I tried to rename all the original file names,but I got a lot of errors.I read the readme file and seached this forum,I could not find any instruction on how to uninstall/remove this extension.
Thanks so much for your help in advance!
Joe
Hi all,
I have an error:
I have an error:
Code: Select all
2013-07-16 13:40:24 - PHP Warning: realpath(): open_basedir restriction in effect. File(/tmp) is not within the allowed path(s): (/var/zpanel/hostdata/zadmin/public_html/DOMAIN:/var/zpanel/temp/) in /var/zpanel/hostdata/zadmin/public_html/DOMAIN/system/PHPExcel/Classes/PHPExcel/Shared/File.php on line 136
2013-07-16 13:40:24 - PHP Warning: tempnam(): open_basedir restriction in effect. File() is not within the allowed path(s): (/var/zpanel/hostdata/zadmin/public_html/DOMAIN:/var/zpanel/temp/) in /var/zpanel/hostdata/zadmin/public_html/bicicletafarapedale_ro/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php on line 205
2013-07-16 13:40:25 - PHP Exception: Could not close zip file php://output. in /var/zpanel/hostdata/zadmin/public_html/DOMAIN/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php on line 378please help!
im getting this message?
any ideas what it means?
2013-07-18 7:02:33 - PHP Warning: set_time_limit(): Cannot set time limit due to system policy in /customers/5/e/d/jacobj.co.uk/httpd.www/admin/model/tool/export.php on line 2474
2013-07-18 16:12:48 - PHP Warning: set_time_limit(): Cannot set time limit due to system policy in /customers/5/e/d/jacobj.co.uk/httpd.www/admin/model/tool/export.php on line 2474
2013-07-21 17:42:09 - PHP Fatal Error: Call to undefined method PHPExcel_Reader_HTML::setReadDataOnly() in /customers/5/e/d/jacobj.co.uk/httpd.www/admin/model/tool/export.php on line 1643
2013-07-21 17:42:09 - PHP Warning: Cannot modify header information - headers already sent by (output started at /customers/5/e/d/jacobj.co.uk/httpd.www/admin/model/tool/export.php:1643) in /customers/5/e/d/jacobj.co.uk/httpd.www/admin/model/tool/export.php on line 49
2013-07-21 17:42:09 - PHP Warning: Cannot modify header information - headers already sent by (output started at /customers/5/e/d/jacobj.co.uk/httpd.www/admin/model/tool/export.php:1643) in /customers/5/e/d/jacobj.co.uk/httpd.www/admin/model/tool/export.php on line 50
2013-07-21 17:42:40 - PHP Fatal Error: Call to undefined method PHPExcel_Reader_HTML::setReadDataOnly() in /customers/5/e/d/jacobj.co.uk/httpd.www/admin/model/tool/export.php on line 1643
2013-07-21 17:42:40 - PHP Warning: Cannot modify header information - headers already sent by (output started at /customers/5/e/d/jacobj.co.uk/httpd.www/admin/model/tool/export.php:1643) in /customers/5/e/d/jacobj.co.uk/httpd.www/admin/model/tool/export.php on line 49
2013-07-21 17:42:40 - PHP Warning: Cannot modify header information - headers already sent by (output started at /customers/5/e/d/jacobj.co.uk/httpd.www/admin/model/tool/export.php:1643) in /customers/5/e/d/jacobj.co.uk/httpd.www/admin/model/tool/export.php on line 50
2013-07-21 17:42:57 - PHP Fatal Error: Call to undefined method PHPExcel_Reader_HTML::setReadDataOnly() in /customers/5/e/d/jacobj.co.uk/httpd.www/admin/model/tool/export.php on line 1643
2013-07-21 17:42:57 - PHP Warning: Cannot modify header information - headers already sent by (output started at /customers/5/e/d/jacobj.co.uk/httpd.www/admin/model/tool/export.php:1643) in /customers/5/e/d/jacobj.co.uk/httpd.www/admin/model/tool/export.php on line 49
2013-07-21 17:42:57 - PHP Warning: Cannot modify header information - headers already sent by (output started at /customers/5/e/d/jacobj.co.uk/httpd.www/admin/model/tool/export.php:1643) in /customers/5/e/d/jacobj.co.uk/httpd.www/admin/model/tool/export.php on line 50
2013-07-21 17:44:21 - PHP Fatal Error: Call to undefined method PHPExcel_Reader_HTML::setReadDataOnly() in /customers/5/e/d/jacobj.co.uk/httpd.www/admin/model/tool/export.php on line 1643
2013-07-21 17:44:21 - PHP Warning: Cannot modify header information - headers already sent by (output started at /customers/5/e/d/jacobj.co.uk/httpd.www/admin/model/tool/export.php:1643) in /customers/5/e/d/jacobj.co.uk/httpd.www/admin/model/tool/export.php on line 49
2013-07-21 17:44:21 - PHP Warning: Cannot modify header information - headers already sent by (output started at /customers/5/e/d/jacobj.co.uk/httpd.www/admin/model/tool/export.php:1643) in /customers/5/e/d/jacobj.co.uk/httpd.www/admin/model/tool/export.php on line 5
im getting this message?
any ideas what it means?
2013-07-18 7:02:33 - PHP Warning: set_time_limit(): Cannot set time limit due to system policy in /customers/5/e/d/jacobj.co.uk/httpd.www/admin/model/tool/export.php on line 2474
2013-07-18 16:12:48 - PHP Warning: set_time_limit(): Cannot set time limit due to system policy in /customers/5/e/d/jacobj.co.uk/httpd.www/admin/model/tool/export.php on line 2474
2013-07-21 17:42:09 - PHP Fatal Error: Call to undefined method PHPExcel_Reader_HTML::setReadDataOnly() in /customers/5/e/d/jacobj.co.uk/httpd.www/admin/model/tool/export.php on line 1643
2013-07-21 17:42:09 - PHP Warning: Cannot modify header information - headers already sent by (output started at /customers/5/e/d/jacobj.co.uk/httpd.www/admin/model/tool/export.php:1643) in /customers/5/e/d/jacobj.co.uk/httpd.www/admin/model/tool/export.php on line 49
2013-07-21 17:42:09 - PHP Warning: Cannot modify header information - headers already sent by (output started at /customers/5/e/d/jacobj.co.uk/httpd.www/admin/model/tool/export.php:1643) in /customers/5/e/d/jacobj.co.uk/httpd.www/admin/model/tool/export.php on line 50
2013-07-21 17:42:40 - PHP Fatal Error: Call to undefined method PHPExcel_Reader_HTML::setReadDataOnly() in /customers/5/e/d/jacobj.co.uk/httpd.www/admin/model/tool/export.php on line 1643
2013-07-21 17:42:40 - PHP Warning: Cannot modify header information - headers already sent by (output started at /customers/5/e/d/jacobj.co.uk/httpd.www/admin/model/tool/export.php:1643) in /customers/5/e/d/jacobj.co.uk/httpd.www/admin/model/tool/export.php on line 49
2013-07-21 17:42:40 - PHP Warning: Cannot modify header information - headers already sent by (output started at /customers/5/e/d/jacobj.co.uk/httpd.www/admin/model/tool/export.php:1643) in /customers/5/e/d/jacobj.co.uk/httpd.www/admin/model/tool/export.php on line 50
2013-07-21 17:42:57 - PHP Fatal Error: Call to undefined method PHPExcel_Reader_HTML::setReadDataOnly() in /customers/5/e/d/jacobj.co.uk/httpd.www/admin/model/tool/export.php on line 1643
2013-07-21 17:42:57 - PHP Warning: Cannot modify header information - headers already sent by (output started at /customers/5/e/d/jacobj.co.uk/httpd.www/admin/model/tool/export.php:1643) in /customers/5/e/d/jacobj.co.uk/httpd.www/admin/model/tool/export.php on line 49
2013-07-21 17:42:57 - PHP Warning: Cannot modify header information - headers already sent by (output started at /customers/5/e/d/jacobj.co.uk/httpd.www/admin/model/tool/export.php:1643) in /customers/5/e/d/jacobj.co.uk/httpd.www/admin/model/tool/export.php on line 50
2013-07-21 17:44:21 - PHP Fatal Error: Call to undefined method PHPExcel_Reader_HTML::setReadDataOnly() in /customers/5/e/d/jacobj.co.uk/httpd.www/admin/model/tool/export.php on line 1643
2013-07-21 17:44:21 - PHP Warning: Cannot modify header information - headers already sent by (output started at /customers/5/e/d/jacobj.co.uk/httpd.www/admin/model/tool/export.php:1643) in /customers/5/e/d/jacobj.co.uk/httpd.www/admin/model/tool/export.php on line 49
2013-07-21 17:44:21 - PHP Warning: Cannot modify header information - headers already sent by (output started at /customers/5/e/d/jacobj.co.uk/httpd.www/admin/model/tool/export.php:1643) in /customers/5/e/d/jacobj.co.uk/httpd.www/admin/model/tool/export.php on line 5
Over-restrictive security settings on your web host. In your file admon/model/tool/export.php, just comment out the line 2474 calling the set_time_limit() function.jrrodkatandra wrote:please help!
im getting this message?
any ideas what it means?
2013-07-18 7:02:33 - PHP Warning: set_time_limit(): Cannot set time limit due to system policy in /customers/5/e/d/jacobj.co.uk/httpd.www/admin/model/tool/export.php on line 2474
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
hi thanks for getting back to me so quickly,
i have done what you said and now getting this error?
Fatal error: Call to undefined method PHPExcel_Reader_HTML::setReadDataOnly() in /customers/5/e/d/jacobj.co.uk/httpd.www/admin/model/tool/export.php on line 1643
thanks
i have done what you said and now getting this error?
Fatal error: Call to undefined method PHPExcel_Reader_HTML::setReadDataOnly() in /customers/5/e/d/jacobj.co.uk/httpd.www/admin/model/tool/export.php on line 1643
thanks
Use XLS format, not HTMl or CSV, for your Import!jrrodkatandra wrote:hi thanks for getting back to me so quickly,
i have done what you said and now getting this error?
Fatal error: Call to undefined method PHPExcel_Reader_HTML::setReadDataOnly() in /customers/5/e/d/jacobj.co.uk/httpd.www/admin/model/tool/export.php on line 1643
thanks
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
JNeuhoff thank you so much, as soon as i changed the format it poped straight in within a few seconds, one question that i have, the data is all there but the links to the product image do not work, does this support external links of the pictures at all? is this somthing that can happen?
thanks
thanks
Hi jNeuhoff,
Currently running your export-import tool on my OpenCart shop with version 1.5.4.
And I'm very happy with it.
Everything worked fine till I increased the size of my new productlist.
My old list was about 3-4 MB in size. My new list (with more products) is about 7-8 MB in size.
Uploading the old list was no problem at all, however when I upload my new list I'm getting the following error:
Error occurred: 500 - internal server error
What could be the problem here? Size limitations?
Thanks in advance for your help.
Currently running your export-import tool on my OpenCart shop with version 1.5.4.
And I'm very happy with it.
Everything worked fine till I increased the size of my new productlist.
My old list was about 3-4 MB in size. My new list (with more products) is about 7-8 MB in size.
Uploading the old list was no problem at all, however when I upload my new list I'm getting the following error:
Error occurred: 500 - internal server error
What could be the problem here? Size limitations?
Thanks in advance for your help.
Hi jNeuhoff,
Currently running ver. 1.5.4 of your extension, and it works great. I have a question though: Is it possible to preserve 'line breaks/carraige returns' from the 'product name', to give control over the product name layout, instead of just having the text wrap around instead. A lot of my products need to use two lines for the name, but I can't find a way to import and keep the layout as it is in excel??
Regards,
Garry
Currently running ver. 1.5.4 of your extension, and it works great. I have a question though: Is it possible to preserve 'line breaks/carraige returns' from the 'product name', to give control over the product name layout, instead of just having the text wrap around instead. A lot of my products need to use two lines for the name, but I can't find a way to import and keep the layout as it is in excel??
Regards,
Garry
Who is online
Users browsing this forum: No registered users and 4 guests
