I have a big problem.
When I try to import a file Excel bigger than 2900 Kb, the application doesn't import it.
The system doesn't "say" anything. No error messages appear, and neither appears the "successfull upload" message.
When I use a file smaller than 2900 Kb everything works good.
I have the 1.4.8b version of Open Cart.
Thanks a lot in advance for your help!
The size is set to 40 Mb, and my file it's shorter than that.
Maybe it could be a matter of memory. I'm asking the hosting service of my site.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Does anyone know if it derives from my host settings or if is there any parameter that I could modify inside OpenCart?
Anyone here use the impot function to load a large amount of data?
You should check your memory_limit entry in your admin/php.ini file, should be something likepasswordsas wrote:Yes, we think it's a matter of memory, though no error message appears.
Does anyone know if it derives from my host settings or if is there any parameter that I could modify inside OpenCart?
Anyone here use the impot function to load a large amount of data?
memory_limit = xxxxM;
where xxxx is the amount in MBytes of your needed memory.
Note that with some web hosts, even with a higher memory_limit PHP setting, it won't accept it because they might restrict the allowed process, space especially on a shared web server.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Here are the site settings:
max_execution_time = 180
memory_limit = 128M
upload_max_filesize = 10M
post_max_size = 8M
The file is only 2 meg.
I also disabled my firewall and set IE to have the keep alive timeout at 2 minutes, and it fails well before then.
As I said, some web hosts restrict the allowed process memory, in which case a higher PHP memory_limit would be just ignored. Also, you can check whether your PHP settings are really accepted by your remoted server by executing a phpinfo() call.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Please send me your XLS file, and I can test it.EricP wrote:Just for kicks I did another experiment by halving the data file. It worked the first time, and subsequent tests with the exact same file came back with nothing. If the file is the same and nothing is updated, is it supposed to tell you that nothing was changed? Or should it come back and say that the import was successful?
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
I was poking around export.php and noticed the following code:
Code: Select all
switch ($errno) {
case E_NOTICE:
case E_USER_NOTICE:
$errors = "Notice";
break;
case E_WARNING:
case E_USER_WARNING:
$errors = "Warning";
break;
case E_ERROR:
case E_USER_ERROR:
$errors = "Fatal Error";
break;
default:
$errors = "Unknown";
break;
}
if (($errors=='Warning') || ($errors=='Unknown')) {
return true;
}
Yes, I got it and tested it. I can import and export it just fine.I sent it to you last week - did you get it?
Using the following PHP settings:
magic_quotes_gpc = Off;
register_globals = Off;
default_charset = UTF-8;
memory_limit = 64M;
max_execution_time = 18000;
max_upload_filesize = 999M;
safe_mode = Off;
mysql.connect_timeout = 20;
session.use_cookies = On;
session.use_trans_sid = Off;
session.gc_maxlifetime = 12000000;
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Is there any way to have it log every step that it does so that I can see how far it has gotten before the error? I tried modifying the code and having it write to the error log every time it reads a line but that didn't seem to work.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
We've had them change all the items to what you recommended, and it still just dies.
Here's where it does work. I was able to delete everything except one item, and that worked great. It seems to be fine if I remove a bunch of stuff or add a bunch of stuff. If I'm just doing a mass update of existing items, that's when it fails.
If I knew exactly where it was failing then I could tell the host what to change.
Ask your web host whether it supports a sufficient memory_limit PHP setting. On some web hosts, even when it appears to accepts the higher memory_limit, it still won't work because of the overall PHP process memory being more limited.EricP wrote:I don't have OpenCart locally, but you tested the same file above and said it worked.
We've had them change all the items to what you recommended, and it still just dies.
Here's where it does work. I was able to delete everything except one item, and that worked great. It seems to be fine if I remove a bunch of stuff or add a bunch of stuff. If I'm just doing a mass update of existing items, that's when it fails.
If I knew exactly where it was failing then I could tell the host what to change.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
If I import a 1 line spreadsheet, thus deleting almost everything, it works.
If I then import a 4,000 line spreadsheet, thus adding everything as new, it works.
If I then import a 4,000 line spreadsheet with the same items but with a few changes, it fails silently. To me this sounds like a problem with update statements hitting MySQL, since deletes and inserts appear to be working fine.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
I'm just wondering (and this is really basic I guess), how do i format the spreadsheet so it is compatible with OpenCart?
i.e. do I delete any columns that OpenCart doesn't need, do I have to give the columns the exact same title as the website, can I upload images to the spreadsheet etc...etc...
Appreciate your help as I have about 21,000 products to upload.
Kind Regards
Limegreen
http://www.limegreenofficeproducts.com
Limegreen, I take the export that it generates, modify it, then re-upload it. Leave any unneeded columns blank. But you're better off adding a few items with your various stock statuses, quantities, descriptions, etc. to use as an example so that you can set these values appropriately for new items. Recently my client discovered that many items in his store are not to be sold online due to his contract agreements, so I had to create a new stock status called Store Pickup and apply that to the items. Also I had to hide the Add To Cart button due to specific language in those contracts stating that they must not be added to a shopping cart.
Users browsing this forum: No registered users and 26 guests