[RELEASED] Export/Import tool for OpenCart 1.5.5.x

Hi JNeuhoff,

I have problem when importing datasheet. My OC version is 1.5.5.1.

There's several errors in error log:

2013-03-26 6:28:21 - PHP Unknown: Only variables should be assigned by reference in C:\xampp\htdocs\xxxxxxx\admin\model\tool\export.php on line 1512
2013-03-26 6:28:21 - PHP Unknown: Only variables should be assigned by reference in C:\xampp\htdocs\xxxxxxx\admin\model\tool\export.php on line 1521
2013-03-26 6:28:21 - PHP Unknown: Only variables should be assigned by reference in C:\xampp\htdocs\xxxxxxx\admin\model\tool\export.php on line 1539
2013-03-26 6:28:21 - PHP Unknown: Only variables should be assigned by reference in C:\xampp\htdocs\xxxxxxx\admin\model\tool\export.php on line 1548
2013-03-26 6:28:21 - PHP Unknown: Only variables should be assigned by reference in C:\xampp\htdocs\xxxxxxx\admin\model\tool\export.php on line 1557
2013-03-26 6:28:21 - PHP Unknown: Only variables should be assigned by reference in C:\xampp\htdocs\xxxxxxx\admin\model\tool\export.php on line 1566
2013-03-26 6:28:21 - PHP Unknown: Only variables should be assigned by reference in C:\xampp\htdocs\xxxxxxx\admin\model\tool\export.php on line 1575

These errors appears when I'm using finnish translation in Opencart.

Hi your mod is working fine while importing products, but when i try to export it i cannot able to export it.

Also the file which i tried to import was about 1.99mb but the file which i downloaded was only 235 kb. Pls see the attachment for the error.

I tried to remove the line 110 by following your previous solution http://forum.opencart.com/viewtopic.php ... 18#p384112, but the line seems empty in my files.

Can you help me out?

pls someone help me.. i am waiting here i badly need it now..

coolbreeze86 wrote:pls someone help me.. i am waiting here i badly need it now..

Yours, like so many of the other messages on this forum thread, simply doesn't provide enough details to reproduce your error, so we are unable to help you.

How about telling us what online error messages you got? Or what messages you got in your OpenCart system/logs/error.txt? Or those from your server's error_log?

Also, try openingn your XLSX file in OpenOffice or LibreOffice.

Hi JNeuhoff, apologies if the post below does not contain sufficient information to troubleshoot (let me know if that is the case and what further information you might require)... any help would be greatly appreciated.

Attached below is the error from System\Error Log

"2013-04-08 22:04:44 - PHP Warning: stream_wrapper_unregister() [<a href='function.stream-wrapper-unregister'>function.stream-wrapper-unregister</a>]: Unable to unregister protocol zip:// in /home/elitep/public_html/home2/system/PHPExcel/Classes/PHPExcel/Shared/ZipStreamWrapper.php on line 69
2013-04-08 22:07:39 - PHP Notice: Error: MySQL server has gone away<br />Error No: 2006<br />SELECT `product_id`, `image`, `sort_order` FROM `product_image` pi ORDER BY pi.`product_id`, pi.`sort_order`, pi.`image`; in /home/elitep/public_html/home2/system/database/mysql.php on line 50"

tmorgan wrote:Hello JNeuhoff,

Thanks again for your work on this free extension!!!

I have OC V1.5.5.1 configured matched with your export/import tool opencart-1-5-5-x-export-import-15.zip.

I am receiving the following error when attempting to export my products:

"Error: MySQL server has gone away
Error No: 2006
SELECT `product_id`, `image`, `sort_order` FROM `product_image` pi ORDER BY pi.`product_id`, pi.`sort_order`, pi.`image`;
See also 'System > Error Logs' for more details."

Categories: 102
Products: 3360

Could you please advise some tips to resolve this issue ? If not related to your extension but rather a MYSQL configuration item any advice would be greatly appreciated.

Thanks

Tim

JNeuhoff wrote:

coolbreeze86 wrote:pls someone help me.. i am waiting here i badly need it now..

Yours, like so many of the other messages on this forum thread, simply doesn't provide enough details to reproduce your error, so we are unable to help you.

How about telling us what online error messages you got? Or what messages you got in your OpenCart system/logs/error.txt? Or those from your server's error_log?

Also, try openingn your XLSX file in OpenOffice or LibreOffice.

first of all my thanks to give support.
I didn't get any online error messages when i try to download it. It just saved the file perfectly without error. But the size of the file is very low comparing to my file which i used to import. (that means the file is not fully saved no...)

BTW, here is the error message i found in the system/logs/error.txt

2013-04-09 5:11:12 - PHP Fatal Error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 84 bytes) in /home/xxxxxx/public_html/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/CacheBase.php on line 155
2013-04-09 5:11:12 - PHP Warning: Cannot modify header information - headers already sent by (output started at /home/xxxxxx/public_html/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/CacheBase.php:155) in /home/xxxxxx/public_html/admin/model/tool/export.php on line 49
2013-04-09 5:11:12 - PHP Warning: Cannot modify header information - headers already sent by (output started at /home/xxxxxx/public_html/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/CacheBase.php:155) in /home/xxxxxx/public_html/admin/model/tool/export.php on line 50

coolbreeze86 wrote:

JNeuhoff wrote:

coolbreeze86 wrote:pls someone help me.. i am waiting here i badly need it now..

Yours, like so many of the other messages on this forum thread, simply doesn't provide enough details to reproduce your error, so we are unable to help you.

How about telling us what online error messages you got? Or what messages you got in your OpenCart system/logs/error.txt? Or those from your server's error_log?

Also, try openingn your XLSX file in OpenOffice or LibreOffice.

first of all my thanks to give support.
I didn't get any online error messages when i try to download it. It just saved the file perfectly without error. But the size of the file is very low comparing to my file which i used to import. (that means the file is not fully saved no...)

BTW, here is the error message i found in the system/logs/error.txt

2013-04-09 5:11:12 - PHP Fatal Error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 84 bytes) in /home/xxxxxx/public_html/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/CacheBase.php on line 155
2013-04-09 5:11:12 - PHP Warning: Cannot modify header information - headers already sent by (output started at /home/xxxxxx/public_html/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/CacheBase.php:155) in /home/xxxxxx/public_html/admin/model/tool/export.php on line 49
2013-04-09 5:11:12 - PHP Warning: Cannot modify header information - headers already sent by (output started at /home/xxxxxx/public_html/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/CacheBase.php:155) in /home/xxxxxx/public_html/admin/model/tool/export.php on line 50

Increase your PHP setting for the memory_limit

JNeuhoff wrote: Increase your PHP setting for the memory_limit

My present memory limit is 512M.

what is the best value, so that i can increase it and give a try.

I need to add another column to the products table.

We have a cost field in products in the database, is there a way to add this to the export? I dont want to fudge it myself can someone shed some light?

JNeuhoff wrote:Increase your PHP setting for the memory_limit

Hey thank you JNeuhoff... Increased server memory_limit to 1024m.. and it worked fine. Exporting correctly. Thanks for your timely help.

I just installed this tool for OpenCart 1.5.5.1 and I added the permissions to 'tool/export' in the User Groups panel but the Import/Export option doesn't appear in the Systems tab or anywhere that I can find. Am I just missing it or is something wrong?

As a side note: I did correctly install CVS Import/Export correctly because it's operation did appear but I think I made a mistake in code changing because I received an error and wasn't able to use the tool.

Hi!

Is there a limit in the name of product because when I import/export xlsx get this character --> &alpha,
after a number of chars...I think around 60.If I edited the name from the admin panel and then the name was displayed correctly...

Is that correct? Can we fix this somehow!?

Thanks in advance for any answer!!

Hi
Just upgraded to 1.5.5.x from 1.5.1.x. I have been using the Export/Import tool no problem until I upgraded, now I can see the files on the server but it's not showing up under the system menu so I can't do anything.
Hopefully a simple thing I'm missing but I am at a loss.
Thanks

Hi,
Excellent tool, A real time saver!!
Everything is working great so far, but I would like to start using the new filter module for opencart.
Any idea when the new filter module will work with this tool?

Cheers.

jewellerstore wrote:Hi
Just upgraded to 1.5.5.x from 1.5.1.x. I have been using the Export/Import tool no problem until I upgraded, now I can see the files on the server but it's not showing up under the system menu so I can't do anything.
Hopefully a simple thing I'm missing but I am at a loss.
Thanks

It was me being dim, I hadn't installed vqmod properly.

I still really need to know how to add an extra column from the database :|

Hi,
I have the same problem as qaso. There are restrictions on my webhost, so I can't export the file. But I want to try, if I can import the file. And for that I need at least one sample.
Someone who can share with me?

Thanks.

I have noticed that after using import/export the search function does not work for products with "swedish" characters åäö. If doing a search including a å,ä or ö, no products are found.
However a newly created product, which has not been included in a import/export, with swedish characters is found in search.
If I open a product with åäö in admin and resave it, it is found by search again.

Any ideas how I can fix this? I cant not go through all products and resave them.

Thank you

gemini99 wrote:I have noticed that after using import/export the search function does not work for products with "swedish" characters åäö. If doing a search including a å,ä or ö, no products are found.
However a newly created product, which has not been included in a import/export, with swedish characters is found in search.
If I open a product with åäö in admin and resave it, it is found by search again.

Any ideas how I can fix this? I cant not go through all products and resave them.

Thank you

This is a known issue which we will address in the next release of the Export/Import tool.

mettty wrote:Hi,
I have the same problem as qaso. There are restrictions on my webhost, so I can't export the file. But I want to try, if I can import the file. And for that I need at least one sample.
Someone who can share with me?

Thanks.

Maybe I found the problem with restrictions. My webhost don't allow me use functions sys_get_temp_dir() and tempnam(), which needs server root temp folder. So tool can't make the export file. I tried to modify PHPExcel files to set tmp folder manually (like 'data/folder/tmp') without result.
Problem is in opencartfolder/system/PHPExcel/classes/PHPExcel/Shared/file.php line 106 function sys_get_temp_dir()
and in opencartfolder/system/PHPExcel/classes/PHPExcel/Writer/Excel2007.php line 205.

Please help, if someone have any idea how to edit this code. Could not imagine how to use opencart without this tool.