Categories
View Replies (11)

Resolved Importing VM Product images from remote location not working

  1. marquissoftware
    marquissoftware
  2. RO CSVI
  3. Thursday, 23 February 2017
  4.  Subscribe via email
Hello,
I hope you can assist please. I have been struggling to import product images into Virtuemart for an unrealistic period of time with little success.

I have been successful in importing images when the images are stored on the same server as the website in the default folders. However eventually I am needing to import 100’s of products each with a full image and a thumbnail. All the full images are stored on a remote server and I am hoping to keep them there yet still have them appear in my Virtuemart store. I believe this can be done.

The latest I have managed to achieve is import all product data however none of the images (full or thumbnail) are showing. Some images display the default “No image available” Virtuemart image and others show the broken link icon.

After importing a sample batch of records from a csv file (attached), I am not presented with any error or failed message.

I have spent a great deal of time going through the Forum posts and tried various things with no success and I do not know where I am going wrong. I am hoping you will be able to assist please.
Following are the system specs:
CSVI Pro 7.0.2
Virtuemart 3.0.18
Joomla 3.6.5
PHP 5.6.30

The website is located at http://www.mogo.co.za/mmix (full path /usr/www/users/mogocnndfc/mmix/)
The images are stored at http://musicmix.dedicated.co.za/Images/ and in sub folders per the URL’s in the csv file.

Many thanks!
0
Responses (11)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Your debug log explains it all, checking the first product, the image response code is as below. Copying the image URL in browser shows the same 404 error. The images are missing in the remote location and so they are not imported in to VirtueMart. I can see the same for most of the product images in your debug log.

 HTTP response:HTTP/1.1 404 Not Found

2017-02-23	10:59:41	1	[DEBUG]	Remote file does not exist: http://musicmix.dedicated.co.za/Images/01/0000768400128.jpg
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. # 1
marquissoftware
marquissoftware
Accepted Answer Pending Moderation
Thank you Tharuna but that 404 error will only explain some of the problem. I am expecting quite a lot of images will be missing and therefore give that error however, there are indeed images available for some products within the sample csv provided and used, yet not even those available images are being imported.
  1. more than a month ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

I would just want to step in here. You said:
All the full images are stored on a remote server and I am hoping to keep them there yet still have them appear in my Virtuemart store. I believe this can be done.
How would that work though? I can't enter a remote URL as image in VirtueMart. Even if CSVI would store the full URL in the media table, it still won't load the image because VirtueMart prefixes it with the image path.
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
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Can you provide an example product where you say image is available and not imported correct? I can check with your debug log and you import file so It is easy to track the problem.
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. # 4
marquissoftware
marquissoftware
Accepted Answer Pending Moderation
I have attached various screen shots and an xls file to explain:

"Poducts to import.xlsx" = Copy of the previously posted csvi import sample but this time with record that have verified images available highlighted in GREEN. Images for all other records are not on the remote host and therefore, logically, give the 404 error in the log.

"frontend.jpg" = Screen grab of CD category on frontend. Images that are NOT on the remote host display the default VM "Product Image Unavailable" thumbnail, which is fine. Images that ARE available as highlighted green in the xlsx file attached show as broken linked thumbnails. This is my concern.

1 product, for example and reference, where an image exists on remote host is SKU 28947560166 Cello Adagios
1 product where an image does not exist on the remote host is 28946740125 Messiah/Arias & Choruses

I have attached screen grabs of the front end product details page and the VM backend Product Images tab for both of these example products.
Attachments (6)
Products to Import.xlsx
frontend.jpg frontend.jpg
VM fronted Product Detail for SKU 28946740125 Messiah-Arias & Choruses .jpg VM fronted Product Detail for SKU 28946740125 Messiah-Arias & Choruses .jpg
VM backend Product Images tab for SKU 28946740125 Messiah-Arias & Choruses .jpg VM backend Product Images tab for SKU 28946740125 Messiah-Arias & Choruses .jpg
VM frontend Product Detail for SKU 28947560166 Cello Adagios.jpg VM frontend Product Detail for SKU 28947560166 Cello Adagios.jpg
VM backend Product Images tab for SKU 28947560166 Cello Adagios.jpg VM backend Product Images tab for SKU 28947560166 Cello Adagios.jpg
  1. more than a month ago
  2. RO CSVI
  3. # 5
marquissoftware
marquissoftware
Accepted Answer Pending Moderation
Hello Roland. Thank you for stepping in but your reply raises a fundamental question - which is probably best directed at Virtuemart. So Virtuemart does not allow one to point to product images on a remote host then? I would need to have each image on the remote host downloaded to the same location as the store I'm working on?
  1. more than a month ago
  2. RO CSVI
  3. # 6
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
1 product, for example and reference, where an image exists on remote host is SKU 28947560166 Cello Adagios

Thank you for the details. The example product SKU 28947560166 as per the debug log says that large image has been downloaded but thumbnail is not created. The error in debug log is "Thumnail has not been created because the image cannot be converted". I see the same error for other products you have highlighted with green in your excel file. So let us check with the example product you have provided. Can you confirm if the large image has been downloaded at this location images/stories/virtuemart/product/0028947560166.jpg? Do you see the image in there?
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
marquissoftware
marquissoftware
Accepted Answer Pending Moderation
Hello Tharuna,

Yes, i can confirm that sample product's full image is there. See jpg attached which is a screen grab of my FTP client.

One interesting discovery that may or may be worth pointing out: When I went to take that screen grab, I happened to notice the file permissions. On further investigation I see all the images that were copied from the remote host are 0644.

I changed them all to 0777 and re imported the csv file again but no change. Images still not showing.
Attachments (1)
ftp screen grab.jpg ftp screen grab.jpg
  1. more than a month ago
  2. RO CSVI
  3. # 8
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Your screenshot explains it :).
The image files has been created but image is not downloaded so the file size is 0. You can see that in your screenshot. There were two users who has the same issue and you can check on the solutions they posted. The first post here and the second here. Let me know if it helps.
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. # 9
marquissoftware
marquissoftware
Accepted Answer Pending Moderation
Thank you Tharuna,

Wow, I have obviously been looking at this problem too long if I noticed the file permissions but not the 0kb file sizes, so thank you for that. Thank you also for the links to the other two posts regarding that. I shall work through them.
  1. more than a month ago
  2. RO CSVI
  3. # 10
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

So Virtuemart does not allow one to point to product images on a remote host then? I would need to have each image on the remote host downloaded to the same location as the store I'm working on?
Correct. That is why CSVI offers the option to download the files to your own server.

Give it a try through the interface and see if you can add a remote image. I haven't been able to at least.
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. # 11
  • Page :
  • 1


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