Resolved Export Thumbnails into excel

Hello,

If you want the URL to the thumbnail you can use picture_url_thumb otherwise you can use file_url_thumb

Thanks, with the file_url_thumb details it would work. As I understood in excel and open office I would use the file_url_thumb information manually by insert > picture. It might wont be your field of profession but I would still ask if you know any way to embedd images automatically into Tables in order to create illustrated price lists; Excel/ opne offices tables with product images.

You can't embed images into an export file with CSVI as a CSV file is plain text. You would have to manually insert the images into the pricelist.

The only other way I can think of is to export an HTML file and create an HTML output instead of a CSV output, in that case you would use the picture_url_thumb.

Hey Rolandd, thanks for the advice with html export.
I exported picture_url_thumb and proudct_name.

In the export template I changed:
file > export type > HTML. Export worked but no pictures are visualized but text: /images/stories/virtuemart/product/IMG_2314.jpg

Did I forget something?

Hello,

You didn't forget anything, CSVI can't export the images themselves, they are not text but binary files. If you want an image to appear you can use the picture_url instead of the file_url. If you open the HTML file in the browser, you should see the image.

you can use the picture_url instead of the file_url. If you open the HTML file in the browser, you should see the image.

I did not use the file_url.
I ve used the picture_url_thumb and proudct_name in a HTML template and opened the table with my browser. So far it does not have images but text such as /images/stories/virtuemart/product/IMG_2314.jpg and then the name of the product. thanks again for your quick response !

Make sure you have set your domain name in the Settings of CSVI.

Including my domain name (e.g. http://www.name.de) in settings did change the text into http://www.name.de/images/stories/virtuemart/product/IMG_2314.jpg but the image still does not appear. What details of the domain name are needed? Sorry I am really a beginner in this..

I was wrong, of course you are not going to see the image because it is just a text string. You will need to use the replacement plugin to add the HTML image tag around it. To show an image in HTML you need this minimal setup

<img scr="path/to/image" />

So create a replacement rule where you search for the complete value and replace it with the image tag and the path becomes \1. See the Replacements documentation for more details.

I found a better way how to include images into the excel cells automatically> With the help of an excel add on (excel-image-assistant, 20$) images will be integrated into tables. Images relate to the image name e.g. IMG_001. Exporting file_url provides the name of the image but provides additional images too. eg. IMG_001|IMG_002. The excel add on does not understand two or more images with " | " symbol. Is there a way how I could export the first image name only so I do not have to delete the rest manually?

You can set in your export on the Options tab how many images should be exported. This is used by the picture_url field, so you could see if that is helpful for you.

worked! Perfect! Thank you!