Import/Export Tool - Internal Error (How to fix) ?

Hello, Everybody,
Installed this extension on OC v.1.5.6 but can't make export file (I need all categories and product to export to xls).
When I picked Export butto, I got this error:

Categories!C13 -> internal error
See also 'System > Error Logs' for more details.

And one row in error.log:

2013-12-03 9:02:40 - PHP PHPExcel_Exception: Categories!C13 -> internal error in path_to_OC/system/PHPExcel/Classes/PHPExcel/Cell.php on line 307

How can I fix it ? Does this extension correctly wotk if I have other exts for category and product that adds color options for product, qnt by cats.

Regrads, Alex

It balks specifically over not finding the disc path for one file: "internal error in path_to_OC/system/PHPExcel/Classes/PHPExcel/Cell.php". When you uploaded the tool, which I assume is JNeuhoff's free export/import tool, . . .

(a) DID YOU upload even the /upload/ directory itself? IF you did that, then all of it is too high one notch but in its own /upload/ tree, to boot. IF you did that, then just send up everything INSIDE the /upload/ tree, INTO THE OC ROOT (which will be either the / root or a directory /directoryname/). (You can also just Select All of everything in the already uploaded /upload/ tree and drag it down a notch into the store root, en masse.) When you're done with that you can delete the /upload/ directory from the server.

(b) IF INSTEAD you did not do that, then double-check whether you sent all of it up. IF you used the host control panel's file manager, you cannot send up a directory with all of its files inside it, that is a basic html limitation and control panels' file managers do not go around the limitation. Redo it using FileZilla Client or another good ftp client.

. . . and after checking those, is the problem still there?

I am currently getting "Could not close zip file php://output. See also 'System > Error Logs' for more details."

This appears a red error message when I try to export my products?

My error log is as follows:

2013-12-10 0:18:27 - PHP Warning: realpath() [<a href='function.realpath'>function.realpath</a>]: open_basedir restriction in effect. File(/tmp) is not within the allowed path(s): (/var/www/error:/usr/share/pear/:/home/bleepparts.com/) in /home/bleepparts.com/system/PHPExcel/Classes/PHPExcel/Shared/File.php on line 136
2013-12-10 0:18:28 - PHP Exception: Could not close zip file php://output. in /home/bleepparts.com/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php on line 378


Any ideas? My client needs this working ASAP.

Thanks in advance...

charlton_68, the server setup seems suboptimal. Your errors (as shown) do not mention, but from the language seem to invoke or to derive from, underlying php safe mode being on. The php safe mode must be off or OC (and the tool) won't work right. The realpath objection fusses about basedir (where shop is root or directory), the sessions directory (tmp), the pear directory (pear is software that supports and extends php), and those raise likelihood that (otherwise unmentioned) safe mode is on. The Exception seems to mean that the compression library for php is not properly installed or firing. Several seriously different aspects of php are not right at the same time. Those would require attention before we would even reach the customary concern for php.ini settings.

We need php setup values, so please just peruse these but download the little phpinfo.php and run it:

On php.exe and php.ini:
http://forum.opencart.com/viewtopic.php ... ni#p426535
On master php.ini:
http://forum.opencart.com/viewtopic.php ... 80#p444711
http://forum.opencart.com/viewtopic.php ... r+#p445305

You will NOT need to post the entirety of what phpinfo.php shows, just let us know about these:
(a) php.exe version;
(b) whether these are on or off: safe mode, register global variables (loosely, globals), magic quotes;
(c) and what values these have: execution time, completion time.

hi, thanks for your response.

I have downloaded the phpinfo file and ran: http://www.bleepparts.com/admin/phpinfo.php

I have also looked at the /php.ini file: php.ini

However i'm not really sure about what either really mean to be honest??

Thanks in advance,
Joe

php.ini file results:

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;

Those are okay except for these:
memory_limit = 64M;
upload_max_filesize = 999M;

You should try for these:
memory_limit = 512M;
post_max_size = 999M;
upload_max_filesize = 998M;

The post max is supposed to be bigger than the upload max; 999 is bigger than 998. As it sits your post max is 50M, so the upload 999M has no effect.

If you're getting away with max_execution_time = 18000; keep it. You do not particularly need sessions to last an academic semester (session.gc_maxlifetime = 12000000;).

Thanks for your reply,

I have updated my php.ini file to the following:

magic_quotes_gpc = Off;
register_globals = Off;
default_charset = UTF-8;
memory_limit = 512M;
max_execution_time = 18000;
post_max_size = 999M;
upload_max_filesize = 998M;
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 have also contacted my web hosts and their response was:

"I can confirm all the options you have requested are already in place and are the default PHP options. The PHP Zip module is already installed and active. Safe Mode is off, the compression library is active, register globals is off and magic quotes is off."

I am still getting the error when I click export (in a red warning box):

"Could not close zip file php://output.
See also 'System > Error Logs' for more details."

The Error Log is still showing:

2013-12-11 20:40:12 - PHP Warning: realpath() [<a href='function.realpath'>function.realpath</a>]: open_basedir restriction in effect. File(/tmp) is not within the allowed path(s): (/var/www/error:/usr/share/pear/:/home/bleepparts.com/) in /home/bleepparts.com/system/PHPExcel/Classes/PHPExcel/Shared/File.php on line 136
2013-12-11 20:40:13 - PHP Exception: Could not close zip file php://output. in /home/bleepparts.com/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php on line 378

Any more ideas? Thanks in advance

You might try uploading a fresh set of the tool's own files via ftp, preferably using robust FileZilla Client in order to minimize chances for transfer errors. (If you uploaded directories from an Apple or via host control panel's file manager, then you might actually not, and in the file manager's case would not, have uploaded everything in the first place.)

Make sure that there is (and if not, make) a /tmp/ directory in the public area (such as home/public_html/tmp/), as well as one below it in the full account root if you can get down there (such as home/tmp/). It seems to want one.

You can also retry with other extensions (except the tool's export.xml and the required open_cart one) set aside (such as into subdir xml/setaside/).

I'm seeing correct settings and syntax. Maybe JNeuhoff will weigh in with something he spots.

. . . and for good measure be certain that you have the correct tool version for the OC version. Your theme is default, which version is OC (admin doesn't show it)?

I'm using version 1.5.5.1 and have just re-downloaded and reuploaded via FileZilla.

I'm struggling to find any more ideas/solutions. I've been searching the forums and the internet for hours

I really appreciate your responses by the way, it's just unfortunate I cannot get this working!

Sometimes we try to field one that just requires hunches and long shots that might trigger an idea that solves it, and you seem to have one of those. A while ago JNeuhoff saw it, a couple of times, so he'll be thinking about it. Whatever the mismatch is it is subtle, among OC in a stable installation, tool in a dead match, and server with support paying well informed attention.

The tool for it runs well on 1.5.5.1 when that is running smoothly, and the only other approach I can think of at the moment to OC itself is to review 1.5.5.1 CE RC1 (RC2 will be out shortly) and decide whether you want to use CE RC. You would pro forma back up database and fileset first, but may need just to upload the fileset, since the install/upgrade script would ordinarily not be necessary to run unless the standard script had stumbled. If just the fileset of CE RC works, then "stop" there. If not, then you could let the CE RC upgrade script run through the database, while keeping the config.php pair as-is but giving it new index.php pair and then rerunning vqmod's installer to rewrite the upper lines of the index.php pair. See
http://forum.opencart.com/viewtopic.php ... 82#p444959
and practicalities at
http://forum.opencart.com/viewtopic.php ... 20#p445975
http://forum.opencart.com/viewtopic.php ... 40#p450692

In reviewing the thread, I'm seeing failure to export, as you never got to the point of trying to import, so your Excel version is not yet on the table. That usually IS NOT a problem and would not arise anyway till you reach the open or import step. Toward that eventuality, opening, amending, and then importing, you might well have no difficulty. However, another point to look at if import balks will be your Excel version relative to the .xlsx version (many file extensions do have versions or "flavors" -- .tif/.tiff being among examples of numerous flavors that many graphics programs and file converters cannot open or save). Excel versions cannot all handle all .xls and .xlsx file extensions (in part, .xlsx has embedded .xml elements that aren't in prior .xls). If that problem arises, then if you can, try another Excel version. We're not that far along, yet, since you're still stuck on initial export.

Cross-reference http://forum.opencart.com/viewtopic.php ... 19#p461385 and http://forum.opencart.com/viewtopic.php ... 19#p462019 . . . where solved.

Failure to export, given that everything works on another server, probably sprang from incapacity of this host's mysql setup to export and import .csv and .xls -- as should be possible to ascertain via phpMyAdmin. Even knowledgeable support will often not think of that.