Page 4 of 5

Re: [RELEASED] Export/Import module for Opencart 1.1.x

Posted: Tue Jan 25, 2011 5:24 am
by JNeuhoff
successsor wrote:no one know about this? maybe creator of this function limit the size of XLS to upload maybe?
Increase the values of the appropriate PHP settings (memory_limit, post_max_size, upload_max_filesize) in your admin/php.ini file. If that doesn't help, kindly ask your webhost to double the allowed process memory.

Re: [RELEASED] Export/Import module for Opencart 1.1.x

Posted: Thu Feb 03, 2011 9:03 pm
by msblack7of9
Hi Hazymat, the changes you made for this file: \admin\model\tool\export.php for using options plus was ok but when i opened the export file the weight is under the Prefix column, the Prefix is under the Sort column and the sort has no row title.

Maybe I did something wrong?
Thanks
7 :)

Re: [RELEASED] Export/Import module for Opencart 1.1.x

Posted: Thu Feb 03, 2011 9:16 pm
by msblack7of9
Nevermind I fixed:)

Re: [RELEASED] Export/Import module for Opencart 1.1.x

Posted: Thu Feb 03, 2011 9:46 pm
by msblack7of9
sorry hazymat i thought i fixed. ok all the columns fields data are there but they are in the wrong columns (product tab and options tab). please help? thanks. 7:) let me know if you need me to attach image.

Re: [RELEASED] Export/Import module for Opencart 1.1.x

Posted: Sun Feb 06, 2011 1:26 am
by successsor
JNeuhoff wrote:
successsor wrote:no one know about this? maybe creator of this function limit the size of XLS to upload maybe?
Increase the values of the appropriate PHP settings (memory_limit, post_max_size, upload_max_filesize) in your admin/php.ini file. If that doesn't help, kindly ask your webhost to double the allowed process memory.
Thanks for reply. Tried but still same problem :

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 1910 bytes) in /home/worldofm/public_html/admin/model/tool/export.php on line 413

already contact the webhost they said i have enuf process memory to upload the file. So should be no problem. That webhost said. BTW, this is my php.ini file
magic_quotes_gpc = Off;
register_globals = Off;
default_charset = UTF-8;
memory_limit = 99999999999MB;
max_execution_time = 18000000;
upload_max_filesize = 99999999999MB;
safe_mode = Off;
mysql.connect_timeout = 20;
session.use_cookies = On;
session.use_trans_sid = Off;
session.gc_maxlifetime = 12000000;
allow_url_fopen = on;
i find this php.ini on admin/php.ini and public_html/php.ini. Maybe got another php.ini in another file i need to edit?

thanks in advance

Re: [RELEASED] Export/Import module for Opencart 1.1.x

Posted: Sun Feb 06, 2011 2:47 am
by JNeuhoff
Try some more reasonable values for your admin/php.ini (only the latter is relevant for the Export/Import).

Also, you can check your actual values with a simple phpinfo() call.

Re: [RELEASED] Export/Import module for Opencart 1.1.x

Posted: Thu Mar 17, 2011 8:37 pm
by successsor
I getting sick with these error :-

Code: Select all

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 1910 bytes) in /home/worldofm/public_html/admin/model/tool/export.php on line 413
i plan to change the hosting. Anyone can recommend me any superb hosting? Thanks

Re: [RELEASED] Export/Import module for Opencart 1.1.x

Posted: Sun Mar 20, 2011 6:41 am
by JNeuhoff
successsor wrote:I getting sick with these error :-

Code: Select all

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 1910 bytes) in /home/worldofm/public_html/admin/model/tool/export.php on line 413
i plan to change the hosting. Anyone can recommend me any superb hosting? Thanks
Depends on how categories/products you use for your Export/Import. Looks like your current webhost restricts the process memory space to 32MB.With HostGator it would be 64MB as far as I know.

Re: [RELEASED] Export/Import module for Opencart 1.1.x

Posted: Wed Jun 01, 2011 4:22 am
by SupraTwinTurbo
Anyone tried this with 1.5.0?

Re: [RELEASED] Export/Import module for Opencart 1.1.x

Posted: Mon Jun 06, 2011 2:27 am
by JNeuhoff
SupraTwinTurbo wrote:Anyone tried this with 1.5.0?
The current 1.4.9.x Export/Import tool won't work with Opencart 1.5.0.x.

However, I am currently working on a 1.5.0.x release of the Export/Import tool.

Re: [RELEASED] Export/Import module for Opencart 1.1.x

Posted: Mon Jun 06, 2011 7:22 am
by cmebd
JNeuhoff wrote:
SupraTwinTurbo wrote:Anyone tried this with 1.5.0?
The current 1.4.9.x Export/Import tool won't work with Opencart 1.5.0.x.

However, I am currently working on a 1.5.0.x release of the Export/Import tool.
Thanks :-)

Re: [RELEASED] Export/Import module for Opencart 1.1.x

Posted: Sat Jun 25, 2011 6:37 am
by kkhan
JNeuhoff wrote:
SupraTwinTurbo wrote:Anyone tried this with 1.5.0?
The current 1.4.9.x Export/Import tool won't work with Opencart 1.5.0.x.

However, I am currently working on a 1.5.0.x release of the Export/Import tool.
any luck so far?

Edit: Got it here:
http://forum.opencart.com/viewtopic.php?f=119&t=33513

Re: [RELEASED] Export/Import module for Opencart 1.1.x

Posted: Tue Jun 28, 2011 5:23 am
by davidh6781
hi just after a little help, usung 1.4.9 opencart with this script and been working a treat untill i get to product 3036, which then it tries to upload and gets half through loading then just reverts back to the import export screen,

no successfull messages and no errors in the logs either?

any ideas i only have 500 products to go,

cheers
Dave

Re: [RELEASED] Export/Import module for Opencart 1.1.x

Posted: Sat Jul 16, 2011 3:00 am
by silanli_53
pliz help

Is it possible to add a module option, the authors excel..?

best regarts
thanks

Re: [RELEASED] Export/Import module for Opencart 1.1.x

Posted: Sat Aug 27, 2011 11:03 pm
by Russell Mann
I'm trying to find how the spreadsheet needs to be layed out to import properly. I can't seem to find documentation on it. Any help?

I'm getting this error.
Uploaded file is not a valid spreadsheet file or its values are not in the expected formats!

Re: [RELEASED] Export/Import module for Opencart 1.1.x

Posted: Tue Oct 18, 2011 8:43 am
by victor.gatto
works perfectly on 1.5.1.1

only problem is i have 15 thousand products,
how am i going to import this if its going to take me ages to do it by hand
is there any software or rules i can use?

Re: [RELEASED] Export/Import module for Opencart 1.1.x

Posted: Wed Nov 02, 2011 3:33 pm
by Kamahl
Hey guys, is this module working on 1.5.1.3 ?

Re: [RELEASED] Export/Import module for Opencart 1.1.x

Posted: Mon Nov 21, 2011 3:36 pm
by Brett888
Hi Guys,

The import/export fatal memory was driving me crazy trying to find a solution to this problem. Had luck on my side had an IT from a hosting websie with cpanel added and change the following files, which has enabled me to go through all of these fatal memory errors with a simple adjustments of two both memory allocator in php.ini. I started off with 256M and put down 1024M, everything is working fine now. Make sure you do back up of .htaccess & php.ini before you start so you can reverese if issue arises. You only change these files in public_html/, only 1 php.ini to change not admin/php.ini. Not sure if he changed any other files though, but from what I have read it seems to come back to these two files. Hope this works for you, as I am not able to help you further on this further. If this solves the problem fatal memory problem, then can someone confirm this and put solved.

/home/metrogro/public_html/.htaccess

# Inserted By Customer Control Panel
SetEnv PHPRC /home/metrogro/public_html

/home/metrogro/public_html/php.ini

disable_functions = show_source, passthru, exec, popen, proc_open, allow_url_fopen
memory_limit = 256M
max_execution_time = 30
magic_quotes_gpc = on
magic_quotes_runtime = off
max_input_time = 60
upload_max_filesize = 24M
post_max_size = 24M
extension_dir = "/usr/local/lib/php/extensions/no-debug-non-zts-20060613"
realpath_cache_size = 16K
realpath_cache_ttl = 120
register_globals = off
zend_extension = "/usr/local/IonCube/ioncube_loader_lin_5.2.so"
zend_extension_ts = "/usr/local/IonCube/ioncube_loader_lin_5.2_ts.so"
zend_extension = /usr/local/Zend/lib/Optimizer-3.3.9/php-5.2.x/ZendOptimizer.so
extension = mcrypt.so
extension = pdo.so
extension = pdo_sqlite.so
extension = sqlite.so
extension = pdo_mysql.so
extension = suhosin.so
suhosin.executor.include.max_traversal = 6
suhosin.apc_bug_workaround = On
suhosin.memory_limit = 256
suhosin.upload.disallow_elf = On
suhosin.post.max_vars = 2000
suhosin.request.max_vars = 2000
suhosin.log.syslog.facility = 9
suhosin.log.use-x-forwarded-for = Off

Re: [Solved] Export/Import module for Opencart 1.1.x

Posted: Wed Nov 30, 2011 2:16 pm
by Brett888
Have had a different problem happen and had to reset the opencart from beginning, reinstalled the export/import and used above solution, works fine. Replace the metrogro with your home name, to follow the right area to edit php.ini & .htaccess. Correct if I am wrong, but appears to be the solution to this problem, get a secondary confirmation with this.

Re: [RELEASED] Export/Import module for Opencart 1.1.x

Posted: Wed Nov 30, 2011 2:21 pm
by Brett888
The above solution is for opencart 1.5.1.3 & 1.5.1.3.1. Haven't tried on earlier versions.