Thank you for your reply and pointing me to the right direction. I did the following and it worked!!
Just curious, why all previous versions worked, just the latest didnt ?
ANYWAY, Am writing the SOLUTION BELOW for other to use, this solution can also be found at the link you directed to.
1) CREATE a Folder tmp inside of your system/
** NOTE ** Make sure the System & Temp folders have FULL Access ( READ & WRITE)
2) USING a Text Editor , open file /admin/model/tool/export/php
a) Search for "$objWriter->save('php://output');" and comment it suing //
//$objWriter->save('php://output');
b) PLACE below code below the just commented line
$filePath = '/tmp/' . rand(0, getrandmax()) . rand(0, getrandmax()) . ".tmp";
$objWriter->save($filePath);
readfile($filePath);
unlink($filePath);
HOPE this helps others!
Again thank you to JNeuhoff & user1005242 from Stackoverflow.com
Hi Robert,
As we discussed, here's what I found:
The export module you are currently using is causing the server to use an excessive amount of memory. Increasing the memory_limit to 2048 MB on shared hosting is excessive and will lead to server overloads. The majority of shared hosting providers either limit (through policy) or through implemented limits, the limit usually at no more than 256 MB. Occasionally I've seen it allowed up to 512 MB on shared hosting.
It is dangerous to allow more, because if you submit multiple requests through your browser for that export, it can quickly cause the server to run out of memory and cause an overload. For that reason, I'm afraid we could only offer a working solution on a Virtual Private Server (VPS).
From what I've read on the opencart website, the reason the export module uses so much memory and time is that it is converting the exported data into XLSX, which is a memory intensive task. I read on the opencart forums that if you exported the data into a CSV file instead, it would consume a lot less memory during the export process.
Hopefully you can work with the opencart module developer on a solution, or find a suitable alternative.
Rob M
http://www.onlinesupply.ca 1.5.6.1 (an upgrade from 1.5.0)
http://www.webfilter.onlinesupply.ca 1.5.4
You should use the new multi-lingual Export/Import Tool, which also works for single language only, and most importantly, allows you to export and import in smaller batches, thus avoiding the memory_limit issue.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Sure, I'll give that a try... Just wondering why, with the exact same database I had no issues when I was running OC 1.5.0?JNeuhoff wrote:skookumrob:
You should use the new multi-lingual Export/Import Tool, which also works for single language only, and most importantly, allows you to export and import in smaller batches, thus avoiding the memory_limit issue.
Rob M
http://www.onlinesupply.ca 1.5.6.1 (an upgrade from 1.5.0)
http://www.webfilter.onlinesupply.ca 1.5.4
Question... As I divide my database into id range sections (ie 10000-19999 = a particular range of products 20000-29999 is another range of products etc) this works quite nicely with your data range export. My question is... when I add items through the Admin panel it assigns the next available number (after the highest registered value) Can I Export this range... change the Product Id # to fall back within my defined range (ie: item # 54321 changed to 32101
[the next available number in the 30000 range} and Import and have it now show up in the correct id range?
Rob M
http://www.onlinesupply.ca 1.5.6.1 (an upgrade from 1.5.0)
http://www.webfilter.onlinesupply.ca 1.5.4
If you change the product_id and then re-import, it would effectively become a new product, and the old one with the previous product_id would still be there, too.Can I Export this range... change the Product Id # to fall back within my defined range (ie: item # 54321 changed to 32101
[the next available number in the 30000 range} and Import and have it now show up in the correct id range?
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Soooo... If I export range 30000-39999 and 50000-59999 as separate spreadsheets and then cut/paste from the 50000 export to the 30000 (and add the next available product_id in the 30000 range) and then Import both sheets... that should avoid the duplication right???JNeuhoff wrote:If you change the product_id and then re-import, it would effectively become a new product, and the old one with the previous product_id would still be there, too.Can I Export this range... change the Product Id # to fall back within my defined range (ie: item # 54321 changed to 32101
[the next available number in the 30000 range} and Import and have it now show up in the correct id range?
Rob M
http://www.onlinesupply.ca 1.5.6.1 (an upgrade from 1.5.0)
http://www.webfilter.onlinesupply.ca 1.5.4
I think so, never tried it.skookumrob wrote: Soooo... If I export range 30000-39999 and 50000-59999 as separate spreadsheets and then cut/paste from the 50000 export to the 30000 (and add the next available product_id in the 30000 range) and then Import both sheets... that should avoid the duplication right???
Why don't you just do Exports by batches instead of id ranges?
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Can you modify the tool to Export/Import by Manufacturer? (for price updates)
Also during the price update I would be deleting discontinued items and adding in new items.
Rob M
http://www.onlinesupply.ca 1.5.6.1 (an upgrade from 1.5.0)
http://www.webfilter.onlinesupply.ca 1.5.4
skookumrob wrote:Hi again,
Can you modify the tool to Export/Import by Manufacturer? (for price updates)
Also during the price update I would be deleting discontinued items and adding in new items.
Rob M
http://www.onlinesupply.ca 1.5.6.1 (an upgrade from 1.5.0)
http://www.webfilter.onlinesupply.ca 1.5.4
I would like to revisit this question... and am willing to contribute to the modification to Export/Import by Manufacturer. This would save me a lot of headaches!skookumrob wrote:skookumrob wrote:Hi again,
Can you modify the tool to Export/Import by Manufacturer? (for price updates)
Also during the price update I would be deleting discontinued items and adding in new items.
Please let me know asap.
Thanks,
Rob
Rob M
http://www.onlinesupply.ca 1.5.6.1 (an upgrade from 1.5.0)
http://www.webfilter.onlinesupply.ca 1.5.4
Can you tell me what may be wrong?
Rob M
http://www.onlinesupply.ca 1.5.6.1 (an upgrade from 1.5.0)
http://www.webfilter.onlinesupply.ca 1.5.4
hi, i know this is quite a while ago now, but did you ever find a fix for this issue?Manus wrote:Hey guys
So tell me, can one add fields to the import export tool? My Import/Export tool works fine, but I recently added the chained selects from ocextensions. Now the extension works fine, and the Import/Export tool works fine, however, when I import updated stock quantities, I have to remap child and parent options for products that use the chained selects. So surely if I can get the import export tool to export or import those extra fields, I won't have to redo this all the time... any thoughts or suggestions?
Users browsing this forum: No registered users and 28 guests