Categories
View Replies (7)

Resolved The template IMPORT does not work

  1. rainbow69
    rainbow69
  2. RO CSVI
  3. Saturday, 30 April 2016
  4.  Subscribe via email
I apologize for my poor english.
I created an ecommerce site (http://www.smar-tech.it, I'm italian) using:
- joomla 3.5.1
- virtuemart 3.0.16
- csvi pro 6.5.7
I'm trying to import a catalog (file .csv of 130Mb) with about 40000 products.
Every time I try to upload the file the process ends after 120 seconds, and the program tells me the error that says the photos attached Cattura1.jpg.
I also tried to divide the .csv file (130 Mb) into smaller files to upload (3 Mb, 1200 products) but after 120 seconds the problem returns.
I tried to upload the csv file is from my pc.
I tried to upload it directly to a folder you created on the server.
After 120 seconds always the same problem.
To be precise, for each upload the csv file in virtuemart products cards I find a hundred products with its category, the manufacturer, the price etc., etc.
Then I would understand if:
1) Is a server problem (timing ?) ? I sent a message to report the problem to the manager of hosting.
2) I wrote incorrectly setting the csv file? If so why I find myself in virtuemart updated products?
3) Third and last, there is a problem in csv?

thank you all for the help.
0
Responses (7)
rainbow69
rainbow69
Accepted Answer Pending Moderation
I'm trying to upload report files but I can not? because?
I send them compressed.
Attachments (3)
com_csvi.log.34.zip
com_csvi.log.33.zip
com_csvi.log.35.zip
  1. more than a month ago
  2. RO CSVI
  3. # 1
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Have a look at the Manage Timeout documentation and see changing the import settings helps you.

1) Is a server problem (timing ?) ? I sent a message to report the problem to the manager of hosting.

Hosting people can help in increasing server limits which can also help in solving the issue. It is explained in the Manage timeout document linked above.

2) I wrote incorrectly setting the csv file? If so why I find myself in virtuemart updated products?

You CSV file has got a lot of unwanted semicolons which is not required as the field delimiter you have set is | so you need to clean that first.

3) Third and last, there is a problem in csv?

This is not a problem with CSVI, try changing the settings in import template as said above and see if it solves the issue.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 2
rainbow69
rainbow69
Accepted Answer Pending Moderation
Thanks tharuna.
I changed on the server max_execution_time value in php.ini. and using the procedure described in the Timeout Manage guidance I was able to load many products in sequence.
The operation works even if it is not fast (as explained in the guide because the file a little bigger).
Csv file have not changed, do you think changing the field delimiter "|" with "," the loading process will be faster?
  1. more than a month ago
  2. RO CSVI
  3. # 3
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

Changing the field delimiter won't make a difference. One thing you could look at is to see if there is an index on the product_sku column. If there is none, adding one may speed up the import process.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 4
rainbow69
rainbow69
Accepted Answer Pending Moderation
hi rolandd,

Surely I ask you a stupid question, but what do you mean by index in product_sku column?
An example?
  1. more than a month ago
  2. RO CSVI
  3. # 5
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Have a look at the documentation Speed up product import on how to do indexing for product_sku column.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 6
rainbow69
rainbow69
Accepted Answer Pending Moderation
thank you tharuna,

as soon as possible I try to set the index of the table and see what happens.
I'll let you know.
  1. more than a month ago
  2. RO CSVI
  3. # 7
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!