[RELEASED] Export/Import tool for OpenCart 1.5.5.x

HankMcSpank wrote:Hello,

I'm running 1.5.6 & seeing this error when I try to export...

"Class 'PHPExcel_Shared_String' not found"

...I keep staring at it, but after staring at this line for 3.3hrs, I haven't a clue what it means (or more importantly how to solve it), please help because I can't stare at the screen any longer

Have you uploadee all of the system/PHPExcel files? Have you checked your system/logs/error.txt, or your server's errror_log?

Runes wrote: Any clues?

Thank you....

Sorry, no, your problem description is so vague, I am not able to reproduce your problem.
The obvious solution would be to drastically increase your PHP setting for the memory_limit.

Runes, HankMcSpank, reset php high, http://forum.opencart.com/viewtopic.php ... 60#p441201 (same thread but above on prior page).

Thank you, Butte.

butte wrote: reset php high

I'm not sure what you mean?

Can I set the memory limit in the OC php- files? Or is this something my webhoster need to set? (I worked on this a year ago or so, but do not remember....)


Regards
RS

The four values given for resetting php at http://forum.opencart.com/viewtopic.php ... 60#p441201 (same thread but above on prior page)" are all high: 300 for timeout, 512M for memory, 999M for post max, 998M for upload max.

You may be able to reset those inside your host control panel under php settings. If you can do that, then also turn off both OC php.ini files. If you cannot make account changes, then make the changes in your php.ini file(s). If the server honors those files, then it will honor probably most of the settings in the file(s) even if they are bad directives. (Whenever you see 500 thrown, everything stops; initial files of your own to check include .htaccess and php.ini files, glitches in them can confuse the server, =500, full dead system stop.) If you cannot do any of that, then you are stuck.

For seeing whatchagot before and after changes, you can use the tiny one-line utility phpinfo.php (here: http://forum.opencart.com/download/file.php?id=18153). Upload it into OC or your admin (or your account, public) and address it there in the browser. It will show php version and settings that are in effect. It gives safe information safely, it does not disclose anything hazardous, it is a standard tool. You can confirm that global variables and magic quotes are both OFF.

butte wrote:Runes, HankMcSpank, reset php high, http://forum.opencart.com/viewtopic.php ... 60#p441201 (same thread but above on prior page).

Thanks.....are you saying the error I'm seeing .....

"Class 'PHPExcel_Shared_String' not found"

is a resource type error? (because the error to my woefully inexperienced eye, suggests it's more a missing variable or path.

I managed to do the thing to view the php config as per your suggestion....

For seeing whatchagot before and after changes, you can use the tiny one-line utility phpinfo.php (here: download/file.php?id=18153). Upload it into OC or your admin (or your account, public) and address it there in the browser. It will show php version and settings that are in effect. It gives safe informationa safetly, it does not disclose anything hazardous, it is a standard tool. You can confirm that global variables and magic quotes are both OFF.

my oh my, I'm outta my depth here ...with the returned results, I may as well be skimming the hubble space telescope service manual for the amount I understood! (& I had no idea this would get so involved so quickly - I only want to export 50 products from my opencart website, but when I look at all the php config....well, I hear voices, they tell me things)

(1) The "PHPExcel" snippet points to a probable shortfall in php settings to support the tool -- the type of error doesn't matter, what matters is that the tool was thwarted, one way or another php undercut the Excel tool, "PHPExcel" cuts to the chase. (2) The php settings can all be reviewed with phpinfo.php and there are particularly four values to raise enough to support the tool. There was no plain hint that additionally the server had neglected to install the php library modules such as for compression, or had bungled the most basic settings such as safe mode (to on rather than off as it belongs), as you'll see somewhere well above.

Hubble doesn't do well at short distances. The things, well, are why you make backups of files before touching them. You'll need to look inside php.ini yourself (not config.php), and you probably have two of them.

Edit: Actually, by shear luck I edited my php.ini files in httpdoc *and* /admin ...they memory_limit values were actually set to just 64M...upped them to 512MB & now when I export the error has gone & a spreadsheet is created...yay. - so you were correct, that whacky error message meant I had to up the memory_limit in my two php.ini files (many thanks....I'd have never got to the bottom of that one!)....and many thanks for creating the extension :-)

You can do this thing . . .

JNeuhoff's free Export/Import (Excel) tool works smoothly and well when four php values are amply high enough to support it. Then the tool is not a headache or an adventure, it becomes what it is, a tool for greatly expediting the tasks of adding, amending, and deleting category and product entries and their details.

The server's own master php.ini file is on the order of 1,900 to 2,000 lines long (including some 1,155 commented lines of switchable options and terse instructions, plus several dozen more blank lines), the meat of it is not short. Your pair of them in your OC root and in /admin/, are rather shorter than that, and they have effect only if the server honors them, as many servers do. Fix these four lines, at the top or the bottom is good enough, just ";" comment silent any counterparts elsewhere in the file. Remember: post exceeds upload. Each of these goes on its own line ending in no ; just ending in a hard return.

max_execution_time = 300
memory_limit = 256M ;[or even 512M]
post_max_size = 999M
upload_max_filesize = 998M

I hadn't refreshed the page when I finished checking something before posting (now bottom of prior page, after your edit). You got there, good! And no things, huh? Your server does honor your php.ini files. Go ahead and up the ante on the other three while you're at it.

Hey, i am having issues with this, im exporting from a 1.5.5.1 store, this goes fine and all the data is in the file, then i try to import it to another 1.5.5.1 store, it tells me success, but the store remains empty, and nothing imported

What are your php values, popo? Usually if it fails there are errors thrown, do your /system/logs/ say anything? The success means apparently that by the time the file got there it was empty or the contents were not replacing anything that was dropped for replacement. That is a different problem. Are you using the tool version for 1.5.5.1?

I managed to get export/import workingin 1.5.6 after a complete new install, as described in my other thread here http://forum.opencart.com/viewtopic.php ... 1&start=40

Many many thanks to butte for all his input

You're very welcome, TAC, and as to this thread it's also good to see that the tool works just fine.

hi dear JNeuhoff
thank you for this awesome Extension...

i have problem in my cart with this Extension!
i have this error when i want to backup my cart with this Extension =>

Products!AE1277 -> Formula Error: An unexpected error occured

is there any suggest to slove this problem!
is this my fault or something else!!!
please help me to fix this
thank you JNeuhoff

To save time, kianograph, please insert the actual complete error (or quick set of errors) exactly as they appear in the log.

From that snippet in isolation it seems somehow to have gone through nearly 1,300 rows and there through 1.2 alphabets before balking on one cell with apparently no usual sorts of php errors. That does not compute.

You were exporting rather than importing, so this part may not help unless an error was already imported this way and tainted a database cell (a field/row intersect cell) corresponding to spreadsheet AE1277. Just for kicks, look at cell AE1277 to see whether its format is goofy in comparison to those lying above and below it -- if so, then just copy/paste FORMAT ONLY onto it and retry ("General" may be wrong for it). Also see whether the value in it approximates very closely (but is not) the actual conversion factor between miles and kilometers (1.4..., 0.6...) -- if so, an Excel gremlin is back (Excel can't handle the number), change the value by hand. Granted, those ways out are perhaps too easy, and, again, you exporting rather than importing.

This also follows other but similar contexts at http://forum.opencart.com/viewtopic.php ... 23#p447623

Well, now, things are lookin' up for the long haul. The now fewer instances where workable adjustments don't work can be subdued.

newdepth27 contributed:
http://forum.opencart.com/viewtopic.php ... 06#p326417
export remedied in/admin/controller/tool/export.php on line 75,
// ini_set("memory_limit","128M");
and import remedied in admin/model/tool/export.php on line 1589,
// ini_set("memory_limit","512M");"

So, we know that the export.php overrides server-honored php.ini and .htaccess;
and that export.php is honored along with php.ini and .htaccess;
and that those two lines are the overrides (line numbers may vary among in versions).

JNeuhoff contributed:
http://forum.opencart.com/viewtopic.php ... 06#p326426
. . . "think I'll remove these lines . . . and let it always use whatever PHP settings are in the php.ini or .htaccess."

So, we know that export.php can kick in its own php.ini values AS IT NEEDS THEM ON THE SPOT.
and that routinely php.ini and .htaccess can sustain lower values than the tool needs.

Then the tricky part is whether the server honors those changes immediately. Tests with phpinfo.php suggest yes.

It appears, then, that there are a couple of potentially "complete" solutions.

(1) Use phpinfo.php to verify that changes have effect, i.e., server honors php.ini
how: upload into /admin/, address it as http: // [...]/admin/phpinfo.php in browser address bar
file: http://forum.opencart.com/download/file.php?id=18153

(2) Reset both php.ini files
to elevate execution, mem, post, upload maxima
to 300, 512M, 999M, 998M
or if appropriate
even to 300, 1024M, 999M, 998M

e.g., http://forum.opencart.com/viewtopic.php ... 80#p444711
max_execution_time = 300
memory_limit = 256M ;[or even 512M]
post_max_size = 999M
upload_max_filesize = 998M

(3) Reset inside export.php, at EACH of the two lines, for mem AND for three additional values,
to elevate execution, mem, post, upload maxima -- ALL FOUR PLUS ANY OTHERS FOUND TO BE CRUCIAL
to 300, 512M, 999M, 998M
or if appropriate
even to 300, 1024M, 999M, 998M

(3)(a) Modify in export.php the existing two lines plus six added lines (1+3, 1+3);

(3)(b) Equip export.php to require once an external short file with nothing more in it than those values;

(3)(c) Equip export.php with input from admin panel, which will be open anyway to export or import using the tool.

Item (1) is just a confirmation tool. Item (2) can support sustained php.ini settings, at lesser values than are required by item (3). Item (3) can support extraordinary demands by export.php. Items (3)(a), (3)(b), (3)(c) offer differing or mutually complementary means to change (3).

I am using 1.5.6 version, and i was wondering if/how to add an option for filters to this? i love how easy it is to use.. but this addition would make it so much easier!

Hi,

Firstly thank you for your work on a great extension! I have used it in the past with perfect success.

However I am getting an error on my site currently http://www.matchitliving.com.au

When I try to export I get the following error message:
Could not close zip file php://output.
See also 'System > Error Logs' for more details.

When I check the error log I see this error:
At the start of this thread I see someone else has this in their error log and JNeuhoff responds with the following:

Yes, it looks like your PHP runs in safe_mode, which restricts access to zipped files in the php://output stream. I am afraid the only option is to switch web host, or to ask your web host to remove this restriction.

Is this a problem caused by my hosting company restrictions?

I am running the latest version of Opencart 1.5.6 and I have re-downloaded and re-installed the Export/Import extension but have had no success.

Your help is greatly appreciated.

Thanks,

Warwick

wazaus, yes, it is the host, NOT your OC or your tool. The compression library may fail under several circumstances, such as not installed or not enabled or stuck in safe mode. You will need to ask your host support to turn off safe mode and ensure that the php compression library is active. You will also need to ask that registering globals be off, and that magic quotes be off.

It will be well to run phpinfo.php first, in order to see what you are up against, in order to hand all of the broken eggs to support all at once.

How: upload into /admin/, address it as http: // [...]/admin/phpinfo.php in browser address bar.
File: http://forum.opencart.com/download/file.php?id=18153 (I uploaded it a while ago and there must be several).