Post by asagar » Thu May 24, 2012 8:02 pm

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

Newbie

Posts

Joined
Wed May 23, 2012 8:23 pm

Post by asagar » Fri May 25, 2012 2:06 am

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

Newbie

Posts

Joined
Wed May 23, 2012 8:23 pm

Post by hamidg84 » Wed Jul 04, 2012 6:14 am

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

Active Member

Posts

Joined
Wed Feb 29, 2012 6:18 am

Post by hamidg84 » Wed Jul 04, 2012 6:20 am

Now i got this

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

Active Member

Posts

Joined
Wed Feb 29, 2012 6:18 am

Post by metserve » Fri Jul 06, 2012 6:22 am

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?

Newbie

Posts

Joined
Fri Jul 06, 2012 6:19 am

Post by JNeuhoff » Fri Jul 06, 2012 6:15 pm

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.

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 fubin » Fri Aug 03, 2012 11:55 am

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

Newbie

Posts

Joined
Fri Aug 03, 2012 11:33 am

Post by JNeuhoff » Fri Aug 03, 2012 9:54 pm

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.

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 Kiwiboy » Thu Aug 30, 2012 3:13 am

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!

Newbie

Posts

Joined
Thu Aug 30, 2012 3:07 am

Post by JNeuhoff » Thu Aug 30, 2012 8:17 pm

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.

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 Kiwiboy » Fri Aug 31, 2012 5:14 am

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

Newbie

Posts

Joined
Thu Aug 30, 2012 3:07 am

Post by Tajx » Thu Sep 13, 2012 9:31 pm

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.

New member

Posts

Joined
Wed Aug 15, 2012 4:18 pm

Post by JNeuhoff » Thu Sep 13, 2012 10:50 pm

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.

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 Tajx » Thu Sep 13, 2012 10:59 pm

So sweet Thanks for Quick reply

New member

Posts

Joined
Wed Aug 15, 2012 4:18 pm

Post by bolai » Thu Oct 04, 2012 12:44 am

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

Newbie

Posts

Joined
Thu Oct 04, 2012 12:42 am

Post by aquilla » Mon Dec 03, 2012 5:30 am

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

Newbie

Posts

Joined
Thu Apr 26, 2012 3:31 pm

Post by JNeuhoff » Mon Dec 03, 2012 8:59 pm

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.

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 Yixuan_lee » Sat Jan 26, 2013 1:10 am

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.

Newbie

Posts

Joined
Sat Dec 08, 2012 6:16 pm

Post by gvb » Mon Feb 25, 2013 9:17 am

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

http://artefects.pt


User avatar
gvb
Newbie

Posts

Joined
Sat Feb 23, 2013 10:19 am
Location - Portugal

Post by felipe3191 » Thu Apr 04, 2013 12:38 am

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

Newbie

Posts

Joined
Thu Apr 04, 2013 12:36 am
Who is online

Users browsing this forum: No registered users and 2 guests