Post by burley » Thu May 02, 2013 9:45 pm

try saving as .xls ?

User avatar
Active Member

Posts

Joined
Sun Oct 09, 2011 3:30 pm

Post by Affableaardvark » Thu May 02, 2013 9:55 pm

burley wrote:try saving as .xls ?
Thank you Burley that worked a Treat!!


Posts

Joined
Thu Apr 01, 2010 11:19 pm

Post by shahid21290 » Tue May 07, 2013 7:12 pm

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>

For quick, professional OpenCart support please email scf8127@gmail.com


User avatar
New member

Posts

Joined
Fri May 03, 2013 8:32 pm

Post by JNeuhoff » Wed May 08, 2013 12:00 am

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>
There is no product_tag table in OpenCart 1.5. You have installed the wrong version of the Export/Import tool.

MHC Web Design
Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * TrustPilot Reviews * Google Rich Snippets * Google Tag Manager * Export/Import Tool * Template Switcher PHP/Twig


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by shahid21290 » Wed May 08, 2013 12:32 pm

Thank You ,
it's work greats..

For quick, professional OpenCart support please email scf8127@gmail.com


User avatar
New member

Posts

Joined
Fri May 03, 2013 8:32 pm

Post by Articorse » Tue May 14, 2013 4:18 pm

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?

Newbie

Posts

Joined
Thu Dec 13, 2012 3:21 pm

Post by JNeuhoff » Tue May 14, 2013 10:45 pm

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?
Make sure each product has a unique Product ID. The same is true for the categeries' category ID.

MHC Web Design
Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * TrustPilot Reviews * Google Rich Snippets * Google Tag Manager * Export/Import Tool * Template Switcher PHP/Twig


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by Articorse » Wed May 15, 2013 4:54 pm

JNeuhoff wrote:
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?
Make sure each product has a unique Product ID. The same is true for the categeries' category ID.
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.

Newbie

Posts

Joined
Thu Dec 13, 2012 3:21 pm

Post by deltaguns » Wed May 15, 2013 7:22 pm

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.

New member

Posts

Joined
Wed Apr 24, 2013 7:03 pm

Post by deltaguns » Thu May 16, 2013 11:42 am

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.

New member

Posts

Joined
Wed Apr 24, 2013 7:03 pm

Post by deliveryman2 » Sun Jun 02, 2013 6:44 pm

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.

Newbie

Posts

Joined
Sun Jun 02, 2013 5:44 pm

Post by iocf051613 » Mon Jul 01, 2013 1:30 am

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

Newbie

Posts

Joined
Fri May 17, 2013 1:32 am

Post by 2des » Tue Jul 16, 2013 6:44 pm

Hi all,

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 378

Newbie

Posts

Joined
Tue Jul 16, 2013 6:42 pm

Post by jrrodkatandra » Mon Jul 22, 2013 1:58 am

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

Newbie

Posts

Joined
Mon Jul 22, 2013 1:56 am

Post by JNeuhoff » Mon Jul 22, 2013 6:13 pm

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

MHC Web Design
Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * TrustPilot Reviews * Google Rich Snippets * Google Tag Manager * Export/Import Tool * Template Switcher PHP/Twig


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by jrrodkatandra » Tue Jul 23, 2013 7:21 pm

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

Newbie

Posts

Joined
Mon Jul 22, 2013 1:56 am

Post by JNeuhoff » Tue Jul 23, 2013 11:05 pm

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
Use XLS format, not HTMl or CSV, for your Import!

MHC Web Design
Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * TrustPilot Reviews * Google Rich Snippets * Google Tag Manager * Export/Import Tool * Template Switcher PHP/Twig


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by jrrodkatandra » Wed Jul 24, 2013 2:30 pm

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

Newbie

Posts

Joined
Mon Jul 22, 2013 1:56 am

Post by Greenmaster » Thu Jul 25, 2013 6:44 pm

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.

Newbie

Posts

Joined
Thu Apr 26, 2012 1:03 am

Post by gartheman » Mon Aug 05, 2013 4:32 pm

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

New member

Posts

Joined
Tue Feb 16, 2010 5:12 pm
Who is online

Users browsing this forum: No registered users and 2 guests