Developer forum

Forum » PIM » Missing option in "Export to Excel" to export ProductImagePaths

Missing option in "Export to Excel" to export ProductImagePaths

E-mail notifications
Marie Louise Veigert
Reply
Posted on 01/02/2023 13:11:26

Hi,

Can't seem to be able to export ProductImageSmall, ProductImageMedium and ProductImageLarge with the PIM Export to Excel option.

Are this correct or am I missing something?


BR Marie Louise


Replies

 
Michael Knudsen
Posted on 01/02/2023 13:25:33
Reply
This post has been marked as an answer

Hello Marie Louise,

- currently it's not possible to include paths to any image or assets using the "Export to Excel" function.

If the products in the export are more and less is the same every time or selectable using a query, I would create a feed to XML, and then use the feed URL in Excel.

Br. Michael Knudsen

Votes for this answer: 1
 
Marie Louise Veigert
Posted on 01/02/2023 13:29:21
Reply

Thanks for the quick answer Michael.

There are set up a query in PIM for the products it's concerning.

Can you explain how you would do the "use the feed url" part?

 
Michael Knudsen
Posted on 01/02/2023 13:36:17
Reply
This post has been marked as an answer

When you have built you're feed, you'll take the Feed URL and paste it into Exel. Some of the fields from the feed will work out-of-the-box, while others might require some PowerQuery (Excel) skills, but it's easy to learn.

Br. Michael Knudsen

Votes for this answer: 1
 
Marie Louise Veigert
Posted on 06/02/2023 14:57:32
Reply

Hi Michael,

I have used your example and it works.
But Im having issues with custom fields rendered in the excel. Do you know why some fields loads in with [Table] and how to set it up not to do so?

There are data :) 

 
Marie Louise Veigert
Posted on 06/02/2023 15:08:38
Reply

I found out, that you need to Transform data before selecting "insert/read data" for the fields :)

 
Marie Louise Veigert
Posted on 10/02/2023 11:53:07
Reply

Hi again,

I can see, that if a product only have images in the fields: ImageSmall, ImageMedium or ImageLarge, it isn't possible to get the url to the file in the feed?
Is that correct or am I missing something maybe ?

 
Søren Jensen Dynamicweb Employee
Søren Jensen
Posted on 10/02/2023 13:16:03
Reply

Hi,

Image types "ImageSmall, ImageMedium and ImageLarge" belongs to the old way of managing Images on products.. It is not supported in PIM anymore

You should use the "Assets categories" to manage and organize Assets on product

/Søren

 

You must be logged in to post in the forum