Resolved export excel with product thumbs

Hello Pas,
You can use VirtueMart Product export and add fields product_sku, file_url_thumb as your export template fields to export product thumb images to CSV file.

Thanks Tharuna,

This shows the url of the thumbs, but how can I make this visible as the real image.
Guess it's more a excel/office issue but maybe you know how to make this work.

Thanks,
Pas

Hello Pas,

This shows the url of the thumbs, but how can I make this visible as the real image.

That is not possible with CSVI export and with CSV file. CSVI don't support Excel export.

Guess it's more a excel/office issue but maybe you know how to make this work.

Yes it is Excel thing and needs code to be written using Visual basic for Application(VBA). I don't know how to write codes with Excel to help here.

Thanks Tharuna,

Did find some info on this issue but didn't work for me.
Guess I need to find another way to create a visual list of products.
If you have any suggestions I really like to hear them.

Thanks,
Pas

Hello Pas,
Yes, you may need to find another way to do this. CSVI generates plain text file on export and not a binary file to support graphic data.

Hello Pascal,

The only thing that comes to mind with visual images, is an HTML export. Attached is an example HTML output, this file you can open in Excel and it will display the image itself. Of course the image is full URL because you cannot embed images as base64 because Excel can't read them.

The image should be available on the site anyway I would think.

You can massage your export to output the HTML file, which in essence is an XML, and use that if full URLs for images isn't a problem.

Let me know if that helps.

Thanks Roland,

I will try if this works for me.
In the end this file should be used to sort products in different categories.

Regards,
Pas