help with free import/export tool

You guys keep reporting problems with the Export/Import tool which on one else can reproduce. Hence, at the very least, please take a look in your server's error_log (ask web host for it if you can't acess it from the cPanel), at the vqmod/logs and system/logs/error.txt.

Having same problem as silentsid83, uploaded admin and system files and vqmod with no joy so checked the three files read me.txt says to alter and admin/view/template/common/header.tpl is empty?
Any ideas greatly appreciated.

Seem to be having an odd issue and a search of the forum found zero results though similar errors.

Had to manually edit the header files but seemed to have no issues there. When trying to run the export commands, screen goes blank. Following is the error it's throwing.
Tracking that to the specific line shows it's trying to call the PHPExcel.php file. I've changed the permissions on this file to 777 and verified that it's the same user/group that the rest of the site is running, neither with any effect at all. Also tried hardcoding the entire path to PHPExcel.php but that didn't seem to work either.

Any suggestions?

A file permission of 644 usually works just fine on our server for the Classes/PHPExcel.php. if it doesn't work, change web host!

Even with 777 it didn't fix the issue. Clearly something else going on.

Quick update - trashed the entire folder and reuploaded via SFTP. Issue resolved.

Hi All,

Thank you for the Mod - very very helpful.

Need some expert advice:

Opencart v 1.5.4.1
Products count 1545

I am experiencing a bit of a problem.

When I export all works fine, and when I import after changes. Changes do not appear, and I don't get a confirmation that the file was imported like previously.

So I then exported and imported the same file with no changes, still no confirmation of import.

Nothing in error log.

Please help all.

Server's error_log (ask webhost for it) should have some entries.

I must say that your export/import tool is fantastic. It is clean, user friendly, and amazingly helpful.

I am curious though, can I call for images through it.

Basically what I do is name all my product images via part number.
I have a part number/model column on the excel file.
I make another column with .jpg.
Another with /data
I make a combine function between the part number, and .jpg column.

so it gives me /data/product.jpg, down the whole column. In theory I could bulk upload pictures via ftp and this code would call for the pics on the product without me needing to manually add them to each product. Does this seem feasible, or not?

I recently tried it and it didn't seem to work, but I uploaded the pictures after I had the excel file uploaded. So I was thinking perhaps it wasn't calling for the pics.

Thanks

barnone : I'm working on a big OsCommerce export > OpenCart import with this module, which is great.
If you upload images, and put the correct path in the import file (starting with /data/file.jpg or /data/large/file.jpg, etc.), it will work

barnone wrote:.. I uploaded the pictures after I had the excel file uploaded. So I was thinking perhaps it wasn't calling for the pics.

I am new to this tool, but like you I wanted to ftp the images. A test with a handfull worked fine. First the xlsx, no images, no "image not found" or so in the shop, no problem. Then uploaded the pictures, hit F5 and there they were.

After setting up this particular module in the administrative end of my cart (version 1.5.3.1), I am able to export my list of products along with its corresponding categories, attributes, and options. However, I receive a "500 http" error when I attempt to upload the same but updated XLS file. What could be the reason(s) for this? I am working on a test/development environment (opencarttest): do I need to be in a LIVE environment for the "import" side of this module to work?

Please help.

Thanks!

If there was a Internal Server 500 Error, you should find some log entries in your server's error_log which will tell you exactly of what went wrong. My guess is that it was a time-out issue.

For a few days I was getting the Internal 500 server error when I installed the import/export tool v 1.5.6.1 zip 17

Finally found the problem, when uploaded, the extension automatically caused the permissions to my directories (admin, vqmod and system) to change from 755 to an unrecognized 775. I changed them back to 755 and my server recognized the 755 permissions. I also had to change the xml directory to 755 from 775. That fixed the server error problem for me.

Hope this helps someone

hi, i get opencart 1.5.5.1 i downloaded and installed extension "opencart-1-5-5-x-export-import-17.zip" i exoorted the file and it seems it is ok. When i try to import it in a new shop i get a big problem, import operation goes ok i have no error on it but the result is no categories and no products. Everything is deleted.
What do i mistake?

Have been using Import/Export tool for several months now, awesome mod.
two weeks ago everything was fine.. no problem exporting or importing.
was gone for 2 weeks on trip. returned and tried to export.
Nothing had been done to opencart on my site, nor have any updates or changes been made by myself or the server isp.

received the following:
Error is 500 Internal Server error.
The server encountered an internal error or misconfiguration and was unable to complete your request

I can still import using my last xls file.
I CANNOT export a new xls file.
Please let me know what has happened.

the following are set in php ini and worked without problem

memory_limit 512M
post_max_size 16M
upload_max_filesize 16M

system\logs\error.txt contains:

2014-06-23 22:07:14 - PHP Unknown: Only variables should be assigned by reference in /home/realbud3/public_html/ros/admin/model/tool/export.php on line 1570
2014-06-23 22:07:14 - PHP Unknown: Only variables should be assigned by reference in /home/realbud3/public_html/ros/admin/model/tool/export.php on line 1583
2014-06-23 22:07:14 - PHP Unknown: Only variables should be assigned by reference in /home/realbud3/public_html/ros/admin/model/tool/export.php on line 1609
2014-06-23 22:07:14 - PHP Unknown: Only variables should be assigned by reference in /home/realbud3/public_html/ros/admin/model/tool/export.php on line 1622
2014-06-23 22:07:14 - PHP Unknown: Only variables should be assigned by reference in /home/realbud3/public_html/ros/admin/model/tool/export.php on line 1635
2014-06-23 22:07:15 - PHP Unknown: Only variables should be assigned by reference in /home/realbud3/public_html/ros/admin/model/tool/export.php on line 1648
2014-06-23 22:07:15 - PHP Unknown: Only variables should be assigned by reference in /home/realbud3/public_html/ros/admin/model/tool/export.php on line 1661

Please help, I love the tool but will have to switch to something else if this cannot be corrected.
Thx

IndieJones wrote: Error is 500 Internal Server error.
The server encountered an internal error or misconfiguration and was unable to complete your request

Ask your webhost for the server's error_log entries from exactly the same time where your export failed. The error_log will have an entry about the exact nature of the error. Could be a timeout issue of some sort.

Hi J.Neuhoff,

I'm a total newbie on OpenCart but have a site I'm working on & will be using your plugin.

I've carefully installed it but am too getting a white screen after clicking on the menu option.

All other steps in your read me have been followed.

I would be very grateful for some help.

Regards


Ben

ben@blazegroup.co.uk wrote:Hi J.Neuhoff,

I'm a total newbie on OpenCart but have a site I'm working on & will be using your plugin.

I've carefully installed it but am too getting a white screen after clicking on the menu option.

All other steps in your read me have been followed.

I would be very grateful for some help.

Regards


Ben

At the danger of repeating myself: Check your server's error_log (ask webhost for it), and OpenCart's system/logs/error.txt, for any log entries which will tell you exactly what went wrong.

Having some trouble with import/export tool. It goes to white screen after showing upload %. Displays no success message.

It also only uploaded 293/600 new products that I had on csv sheet.

Error Log:
2014-08-23 1:11:28 - PHP Unknown: Only variables should be assigned by reference in /home/barnon5/public_html/admin/model/tool/export.php on line 1570
2014-08-23 1:11:28 - PHP Unknown: Only variables should be assigned by reference in /home/barnon5/public_html/admin/model/tool/export.php on line 1583
2014-08-23 1:11:28 - PHP Unknown: Only variables should be assigned by reference in /home/barnon5/public_html/admin/model/tool/export.php on line 1609
2014-08-23 1:11:28 - PHP Unknown: Only variables should be assigned by reference in /home/barnon5/public_html/admin/model/tool/export.php on line 1622
2014-08-23 1:11:28 - PHP Unknown: Only variables should be assigned by reference in /home/barnon5/public_html/admin/model/tool/export.php on line 1635
2014-08-23 1:11:28 - PHP Unknown: Only variables should be assigned by reference in /home/barnon5/public_html/admin/model/tool/export.php on line 1648
2014-08-23 1:11:28 - PHP Unknown: Only variables should be assigned by reference in /home/barnon5/public_html/admin/model/tool/export.php on line 1661