[UPDATED] Export/Import tool for OpenCart 1.4.9

JNeuhoff wrote:

interaction wrote:Hi Jneuhoff

I have use this import/export ver 1.4.9.3 module recently for my opencart 1.4.9.3 version

The export function is working well except for the import function. Whenever I import the XLS file, it will direct me to a blank page after several minutes. I have less than thousand products and I use microsoft excel for edit

Is there any way to fix this?

Regards
Johnson

This is likely an issue with your PHP settings, e.g. timeout or the maximum allowed upload file size. Check your admin/php.ini fior this. Also, check your error messages in your server's error_log and Opencart's system/logs/error.txt for any hints as to why the import has problems.

I have check the error log under the opencart admin but no error is shown there.

My admin/php.ini setting is
magic_quotes_gpc = Off;
register_globals = Off;
default_charset = UTF-8;
memory_limit = 64M;
max_execution_time = 18000;
upload_max_filesize = 999M;
safe_mode = Off;
mysql.connect_timeout = 20;
session.use_cookies = On;
session.use_trans_sid = Off;
session.gc_maxlifetime = 12000000;
allow_url_fopen = on;

Do I need to edit anything in there?

Thanks

I have check the error log under the opencart admin but no error is shown there.

Please also check your server's error_log!

JNeuhoff wrote:

I have check the error log under the opencart admin but no error is shown there.

Please also check your server's error_log!

sorry I'm not so good in oc. Where can I check the server error log? Thanks

sorry I'm not so good in oc. Where can I check the server error log? Thanks

You can access it via the cPanel used by most webhosts.

JNeuhoff wrote:

sorry I'm not so good in oc. Where can I check the server error log? Thanks

You can access it via the cPanel used by most webhosts.

Hi


I have just check the server error logs and no error message is display there

I have just check the server error logs and no error message is display there

Send me a PM with a zipped copy of your XLS file, and I can test the import on my test server with your given PHP settings from your admin/php.ini.

JNeuhoff wrote:

I have just check the server error logs and no error message is display there

Send me a PM with a zipped copy of your XLS file, and I can test the import on my test server with your given PHP settings from your admin/php.ini.

Ok have just PM you

interaction wrote:

JNeuhoff wrote:

I have just check the server error logs and no error message is display there

Send me a PM with a zipped copy of your XLS file, and I can test the import on my test server with your given PHP settings from your admin/php.ini.

Ok have just PM you

Have you made sure that your PHP setting for post_max_size is greater than 2MB? Your XLS file size is 2.1MB in size!

Have you made sure that your PHP setting for post_max_size is greater than 2MB? Your XLS file size is 2.1MB in size![/quote]
Hi

where can I check the PHP setting for post_max_size?

This is the information I get from admin/php/ini and I dont see the post_max_size

magic_quotes_gpc = Off;
register_globals = Off;
default_charset = UTF-8;
memory_limit = 64M;
max_execution_time = 18000;
upload_max_filesize = 999M;
safe_mode = Off;
mysql.connect_timeout = 20;
session.use_cookies = On;
session.use_trans_sid = Off;
session.gc_maxlifetime = 12000000;
allow_url_fopen = on;

Just add it to your admin/php.ini file, e.g.
Also, create an admin/phpinfo.php file with the contents:
and then run it from your web browser:

http://www.your-domain/admin/phpinfo.php

This will show your current PHP settings.

JNeuhoff wrote:Just add it to your admin/php.ini file, e.g.

Code: Select all

post_max_size = 4MB;

Also, create an admin/phpinfo.php file with the contents:

Code: Select all

<?php phpinfo(); ?>

and then run it from your web browser:

http://www.your-domain/admin/phpinfo.php

This will show your current PHP settings.

Hi


I have add the code post_max_size = 4MB; but the same problem occured.

Can I know how to create a configuration file for the admin/phpinfo.php ?

Can I know how to create a configuration file for the admin/phpinfo.php ?

You need to know how to use a programmer's text editor and some FTP software in order to create and upload this new file.

JNeuhoff wrote:

Can I know how to create a configuration file for the admin/phpinfo.php ?

You need to know how to use a programmer's text editor and some FTP software in order to create and upload this new file.

Hi JNeuhoff


Will you be able to create the new file for me? I don't mind paying for your service



Regards
Johnson

Im having the same problem as the origional poster, but so far havent been able to solve it.

Using the latest import/export tool on OC version 1.4.9.4

catergories/Products upload fine except image paths
in the xls file, I use the path data/imagename.jpg

when going to my store, I get the white square/red x combo, on clicking inspect element, its just pointing at the path of the store eg http://www.domain.co.uk rather than http://www.domain.co.uk/data/imagename.jpg

I have checked in cpanel, the correct path of data/imagename.jpg shows there so the problem appears to be within the uload/script/oc itself

Can anybody shed any light on what I may have missed please?

danejayne wrote:Im having the same problem as the origional poster, but so far havent been able to solve it.

Using the latest import/export tool on OC version 1.4.9.4

catergories/Products upload fine except image paths
in the xls file, I use the path data/imagename.jpg

when going to my store, I get the white square/red x combo, on clicking inspect element, its just pointing at the path of the store eg http://www.domain.co.uk rather than http://www.domain.co.uk/data/imagename.jpg

I have checked in cpanel, the correct path of data/imagename.jpg shows there so the problem appears to be within the uload/script/oc itself

Can anybody shed any light on what I may have missed please?

You to upload the actual image files to your Opencart server via FTP or the cPanel file manager. The import froman XLS file only cause the image names to be written tothe database.

Thanks I am awear of that, perhaps I havent explained myself properly

The images are uploaded, its the image names that are not being written, the none loading images are pointing to the site url rather than the image path.

eg when I right click an image x in IE and choose properties it points to http://www.mysite.co.uk, not http://www.mysite.co.uk/image/cache/data/image.jpg

Update

Opened and resaved the .xls file in openoffice calc and its all working.

Thank you for the mod, its a great time saver.

Dear JNeuhoff,

could you please answer your emails you got from me? Or the private messages?

It would be nice to at least know why you're ignoring my emails. You are quite active in this forum so I'm confident you got my messages.

We have paid for a service from you which is not working a 100% and/or has a bug.

Thanks,
Bjorn

PS: sorry for hijacking this thread but I simply try to get this guy to reply.

Hi Bjorn,

Apologies for the problems, lost some e-mails due to change of PC hardware. Anyway, I sent you an update which should fix the support for the Global Options.

Hi JNeuhoff,

Thanks for your awesome module. I installed and exported my store. Then, I added 2 more products, but when I imported the new XLS file, the product tags for all the products disappear. I double checked the file and the product tag column looks fine to me; it just does not seem to be working. I PMed you the XLS file I used to upload, I hope you can take a look for me.

Thank you,

SupraTT