Support is online

problem importing big files #7134

Open delicati opened this topic Thursday, 12 February 2015 ยท 9 replies
Author

Database Version 5.5.40-cll
PHP Version 5.4.37
Joomla! Version Joomla! 3.3.6 Stable [ Ember ] 01-October-2014 02:00 GMT
VirtueMart 3.0.4

I am experiencing problems in importing a 9000 lines file with just two columns ( product_sku - product_s_desc ). If I perform a partial import will work and above all, it works on csvi 1.9.2 on another site with Joomla 1.5 !

Any advice? It seems that the php memory it is big enough. Maybe permissions or ??

Thanks

Dear R.

same with me. If I import test with 10 products everything is fine, when import 5700 blank white page.

J 336
VM 304
CSVI 520 Pro

Author

I have split the file i 4 files with 2000 records and it works...

Support

Hello,

Have a look at the Manage timeouts article. It should give you enough information to setup your import.

As for comparing a Joomla 1.5 site with VirtueMart 1 to a Joomla 3 site with VirtueMart 3 it is almost apples and eggs :) The differences are simply too big. Do know that CSVI 6 has major improvements in terms of speed. So that is dealt with this kind of issue a lot already but with so many products, the timeout is always an issue so the settings must be tweaked.

Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

That was enough with J 25.

  • 2015-02-1221-02-22.png
Author

What do you think of this message: 1062 Duplicate entry '' for key 'slug' SQL=INSERT INTO tdyx_virtuemart_manufacturers_it_it (virtuemart_manufacturer_id) VALUES (78)

p.s. there are no duplicates....

Dear R.,

I am not sure are you answered to delicati or me.

Thx in advance.

PS : Same problem

Support

@kelecz: those options only work on a VPS or dedicated server where you are allowed to change the server limits. Hosts put server limits on shared hosting accounts for a reason ;) As such you are not allowed to just change them. The same options exist for Joomla 3 but they are not Joomla related though.

@delicati: Please start another thread for that because it is unrelated to this topic. Post all the requested information so I can help you.

Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Author

Well, the error was related to this problem...

Support

In that case, it is not a problem of it being a big file but the problem is having no alias.

The manufacturer problem is further discussed in this thread

Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Log in to reply to this topic.