Categories
View Replies (13)

Resolved Import VM3 images

  1. magazzinilasorgente
    magazzinilasorgente
  2. RO CSVI
  3. Wednesday, 09 September 2015
  4.  Subscribe via email
Hello Roland,
I need some help in order to import multiple images on VM3. Configuration is:
- VM3.0.9
- Joomla 3.4.3
- CSVI Pro 6.1.2

I imported some products on VM3. Now I would like to use another csv file just for the images.
First question is: shall I use a "media" or "media product" type of import? The second one seems to be more correct but it contains less available fields.
I created a csv file like: "product_sku", "file_url", "file_title", "file_description". As told, skus already exist. Last 3 fields contain more than one value; I mean, in file_url I can have two or more urls, each starting with "http://" and separated by a "|" symbol. So also file_title and file_description are set as well.
Considering that:
- I want to create name of images based on product name
- I want to resize images
- I want CSVI to automatically create thumbnails of the images
is "setup.jpg" setup correct?

I tried to perform an import (media product type) but there are some troubles:
- an error like "error.jpg" occurs
- only a limited amount of images have been uploaded
- When time runs to 30 seconds, the screen becomes fixed showing "pending_import.jpg". The message is confusing, because I can't know how much time I shall wait...I can't understand if I have to wait because system is working or if system is blocked so I shall click on "close" interrupting the import. However, in my case after a certain time I get the error message mentioned before :-(

Can you help me?

Thanks
Regards
0
Responses (13)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

First question is: shall I use a "media" or "media product" type of import?
There is a difference between the two. The media import allows you to import media for everything and with all the media fields. The media product is for importing media into your products only. This is for example for speeding up large product imports. This way the images can be imported separately instead of using the product import.

Considering that:
- I want to create name of images based on product name
- I want to resize images
- I want CSVI to automatically create thumbnails of the images
is "setup.jpg" setup correct?
Not really, if you choose to have CSVI create the image names based on the product name, what you put in the file_url is ignored. So you will need to choose if you want to use the product name or the file_url for your images. The other settings are correct.

As you can see in the error, CSVI can't find the image you are trying to import. That I think is because your images do not yet exist with that name.

The message is confusing, because I can't know how much time I shall wait
You setup the server, so you should know how much time you have ;) Processing images takes time, you can either increase the timeout in your server setup or in your template click on Advanced and on the Limit tab set the number of lines per import. This may need to be a low number if you have a lot of images to process.

First step would be to solve the issue with the missing images.
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. # 1
magazzinilasorgente
magazzinilasorgente
Accepted Answer Pending Moderation
Thanks for the explanation, Roland.
I think that the issue here is the meaning of "file_url" field. I thought it was related to an url where to find the image (i.e. http://.......jpg for example; I set this field this way), but as far as I can understand by your answer it is the image name. If so, which is the field I shall use for the real url of the image?
I changed the "setup.jpg" setting "create image name" to no. This way, my file_url shall be used for the image name.
So my server shall download the images, CSVI shall use file_url for their name and file_title/file_description for their title and description.
As soon as you indicate me how to give CSVI the urls of the images, I can perform a test and see if all is ok and thank you again :)

Regards
Vittorio
  1. more than a month ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Vittorio,

I thought it was related to an url where to find the image (i.e. http://.......jpg for example; I set this field this way)
It can be both, external or internal location of a file. So you can use http:// if the image is external and let CSVI download it to your site or you can use /path/to/image/on/the/server and have CSVI process the image already on the server.

Nothing more to change now that you set the Create image name to No.
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. # 3
magazzinilasorgente
magazzinilasorgente
Accepted Answer Pending Moderation
Hi Roland,
it seems that actually the behaviour depends by the server and its configuration. I'll try to find out a way to accelerate import images process, since it is not related to csvi.
Maybe it's better to first download the images, then upload them in the proper folder and then provide the path in file_url field. Providing a direct url in file_url can generate some troubles, especially for large csv files.

In any case thank you!

Vittorio
  1. more than a month ago
  2. RO CSVI
  3. # 4
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Vittorio,

I'll try to find out a way to accelerate import images process, since it is not related to csvi.
There is a separate product image import called Media product. This import does only images for products. This import was made to run the product import and only process images. Perhaps that can be of use for you as well.

Providing a direct url in file_url can generate some troubles, especially for large csv files.
Correct, image processing especially downloading from an external source is resource and time intensive.
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. # 5
magazzinilasorgente
magazzinilasorgente
Accepted Answer Pending Moderation
Hi Roland,
I would like to continue this kind of discussion without opening another topic, since my question is still related to image import. Please move/create another topic if you think is better.
I am using CSVI Pro 6.5.3, virtuemart 3.0.12.
I downloaded both large images and thumbnails, then I uploaded them in the server (in images/stories/virtuemart/product and images/stories/virtuemart/product/resized/, respectively). Then I set csv file this way: file_url is "photo1.jpg" and file_url_thumb is "resized/photo2.jpg". Note that image name is different. I set import template like figure "import_settings.jpg".
After import, in frontend I can see all thumbnails in homepage. That's ok. If I open one product detail, I cannot see the large image (I see the yellow triangle with exclamation mark). But, if I click on it, I see the large image!

Can you help me understanding where's the issue?

Regards
Vittorio
Attachments (1)
import_settings.jpg import_settings.jpg
  1. more than a month ago
  2. RO CSVI
  3. # 6
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Vittorio,
Please post the debug log of the import, that will help me to find the cause for the issue and can find out how images are stored.
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. # 7
magazzinilasorgente
magazzinilasorgente
Accepted Answer Pending Moderation
Hi Tharuna,
I cleaned up all previous products/categories/manufacturers/medias and so on, even in the database, then I performed a first import. Its log file is #21. Then I noticed that clicking on any product in homepage lead to a 404 error - product not existing. So I performed another import of the same file, that produced log #22. Now I can open product details, but issue described yesterday is still here.
I am posting 2 log files.

Thanks
  1. more than a month ago
  2. RO CSVI
  3. # 8
magazzinilasorgente
magazzinilasorgente
Accepted Answer Pending Moderation
Sorry, how much is the maximum size of file uploads? Cannot attach them..
  1. more than a month ago
  2. RO CSVI
  3. # 9
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Try to compress and post them else please email them to tharuna@csvimproved.com.
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. # 10
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Vittorio,
I received your logs, i will check and update you on what i find.
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. # 11
magazzinilasorgente
magazzinilasorgente
Accepted Answer Pending Moderation
Hi,
issues about 404 error and "image not found" icon have been solved.
Actually, 404 error will occur if alias contains some "not SEF" characters. I mean, chars like "+", ":", "/", ";", """", and so on. I tried to change them into a "-", and after the import I did not found any 404 error. So it was slug problem, since I decided to create them manually in my import file and didn't let CSVI create them.

Image not found icon (large image not found) issue was solved thanks to Tharuna's suggestion. All the file names of the images in the server contained capital letters. Also file_url and file_url_thumb in the csv file were written in the same way. Changing both filenames and file_url fields using lower case, it works. I can see properly large images and thumbnails.

So lower case letters for these fields and proper slug "writing" are fundamental!

Thanks guys!
  1. more than a month ago
  2. RO CSVI
  3. # 12
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Vittorio,
Glad to hear that your issues are solved. Thank you so much for sharing your solution.
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. # 13
  • Page :
  • 1


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