Import/Export module - products won't import anymore

I realised that since opencart is using utf8_bin to store data, the tool is not exporting the blob data as text into excel. Why am I the only one facing this problem? Nobody seems to be facing this when all must be using the same collation in database. What am I missing? Anybody?

Thanks,
Anil

Everything seems to be working fine on windows+wamp+openoffice but does not show text in the exported xls (shows only numbers) on mac osx+mamp+excel/openoffice/neooffice

Im facing almost similar issue with import. I upgraded to new version and since then it's all messed up.

system/PHPExcel/Classes/PHPExcel/Worksheet.php on line 1031

I have even uploaded the previous version but still no luck

Now i got this

public_html/admin/model/tool/export.php on line 539

Hi everyone, been using this script for a few days now with no problems .... added around 120 items, imported them no probs.

I've now added like another 100 items and I'm getting this error:

Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0,NOW(),NOW(),NOW(),0,0,1,9,0,0,0,0,'2','0','1','1')' at line 1
Error No: 1064
INSERT INTO `product` (`product_id`,`quantity`,`sku`,`upc`,`location`,`stock_status_id`,`model`,`manufacturer_id`,`image`,`shipping`,`price`,`points`,`date_added`,`date_modified`,`date_available`,`weight`,`weight_class_id`,`status`,`tax_class_id`,`viewed`,`length`,`width`,`height`,`length_class_id`,`sort_order`,`subtract`,`minimum`) VALUES (252,999,'FRAMEKIT','','',5,'FRAMEKIT',0,'',1,,0,NOW(),NOW(),NOW(),0,0,1,9,0,0,0,0,'2','0','1','1'); in /home/********/public_html/system/database/mysql.php on line 49

I thought it may have been that the CSV file contained ' and & characters so I removed them and tried again but still the same error!

Ideas?

VALUES (252,999,'FRAMEKIT','','',5,'FRAMEKIT',0,'',1,,0,NOW(),NOW(),NOW(),0,0,1,9,0,0,0,0,'2','0','1','1');

One of your required fields (the 11th one in your list of fields) is empty.

Hi, I have a problem with importing my file...
when I import a file over 700 KB it will show an error like below
"Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, webmaster@opencart1.hsinglu.idv.tw and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request."

how can I fix it??
thx..

fubin wrote:Hi, I have a problem with importing my file...
when I import a file over 700 KB it will show an error like below
"Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, webmaster@opencart1.hsinglu.idv.tw and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request."

how can I fix it??
thx..

Look up your server's error_log for the details of the error message.

Hi JNeuhoff,

I am new to your import / export tool, and are not a designer/ developer,
I am running version 1.5.1.3 successfully, do you think that if I download your tool I will be able to successfully use it, given if I have little HTML experience, and no php experience ?

Thanks in advance!

Kiwiboy wrote:Hi JNeuhoff,

I am new to your import / export tool, and are not a designer/ developer,
I am running version 1.5.1.3 successfully, do you think that if I download your tool I will be able to successfully use it, given if I have little HTML experience, and no php experience ?

Thanks in advance!

As long as you know how to use FTP to upload the unzipped files from the downloaded upload folder to the correct remote Opencart directory, and follow the readme.txt instructions, you should be fine.

The Export/Import tool also requires a pre-installed VQMod.

Sweet, thankyou for your quick reply, I will give it a go!

Hi i m using 1.5.2.1

i m facing a prob during import. here is error lines:
Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 96 bytes) in /home/omar/public_html/system/PHPExcel/Classes/PHPExcel/Worksheet.php on line 961
Fatal Error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 96 bytes) in /home/omar/public_html/system/PHPExcel/Classes/PHPExcel/Worksheet.php on line 961

please help me.

Tajx wrote:Hi i m using 1.5.2.1

i m facing a prob during import. here is error lines:
Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 96 bytes) in /home/omar/public_html/system/PHPExcel/Classes/PHPExcel/Worksheet.php on line 961
Fatal Error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 96 bytes) in /home/omar/public_html/system/PHPExcel/Classes/PHPExcel/Worksheet.php on line 961

please help me.

Increase the memory_limit setting in a admin/php.ini, do a forum search for details on this, this question has been asked hundreds of times now.

So sweet Thanks for Quick reply

Thanks for a good job!
but I have a problem.
I have two stores, both with version 1.4.9.1 but different themes.
Everything works fine I exportadomas of 3900 products.
But there are some categories that are not boxed products.
I think it is better than what you see:
This is good:
http://www.tienda.motored.es/index.php? ... =43&page=3
here is wrong
http://www.tienda.motored.es/index.php? ... urer_id=24

Is there any solution?
thank you very much

Hello,

Can you help me with this error?

I'm using opencart-1-5-3-x-export-import-11 and my opencart version is 1.5.3.1.

2012-12-02 21:19:29 - PHP Notice: Error: Unknown column 'pl.layout_id' in 'on clause'<br />

Error No: 1054<br />

SELECT pl.*, l.name FROM `product_to_layout` pl LEFT JOIN `layout` l ON pl.layout_id = l.layout_id ORDER BY pl.product_id, pl.store_id; in /home/sflo/public_html/mywebsite/system/database/mysql.php on line 49


I'm also using opencart-1-5-2-x-export-import-11 with oc v1.5.2.1 and have no problems there.

Best regards,
Florin

aquilla wrote: I'm using opencart-1-5-3-x-export-import-11 and my opencart version is 1.5.3.1.

2012-12-02 21:19:29 - PHP Notice: Error: Unknown column 'pl.layout_id' in 'on clause'<br />

Error No: 1054<br />

SELECT pl.*, l.name FROM `product_to_layout` pl LEFT JOIN `layout` l ON pl.layout_id = l.layout_id ORDER BY pl.product_id, pl.store_id; in /home/sflo/public_html/mywebsite/system/database/mysql.php on line 49

Looks like your database you use for your OpenCart 1.5.3.1is somehow corrupted, or wasn't correctly upgraded from an older version. In particular, it doesn't have the column 'layout_id' in your 'product_to_layout' table.

Hallo,

I need some help with this module.

I Just downloaded and installed free multiple language import/export module followed this link:
http://www.opencart.com/index.php?route ... ort&page=2

The exported excel file does not contain any product information, in both language versions.

Here is the error log
2013-01-25 17:44:37 - PHP Notice: Trying to get property of non-object in /home/...admin/model/tool/export.php on line 2173
2013-01-25 17:44:37 - PHP Notice: Trying to get property of non-object in /home/...admin/model/tool/export.php on line 2173
2013-01-25 17:44:37 - PHP Notice: Trying to get property of non-object in /home/...admin/model/tool/export.php on line 2416
2013-01-25 17:44:37 - PHP Notice: Trying to get property of non-object in /home/...admin/model/tool/export.php on line 2458
2013-01-25 17:44:37 - PHP Notice: Trying to get property of non-object in /home/...admin/model/tool/export.php on line 2493

Can anybody help to take a look how to fix it? I use opencart 1.5.4.1 on host PHP5. Thanks.

Hello Lee, i have exacly the same problem has you! exact same lines. Did you fixed it, or anyone else fixed it?? Thank you.

Hi! Can you help me with this error: Fatal error: Call to undefined method PHPExcel_Reader_CSV::setReadDataOnly() in /home/fabricat/www/admin/model/tool/export.php on line 1644

Thanks!!!!