Inserting Image URLs from Excel into XML File of Product Data

Hello,

a customer of us want us to implement image URLs in an PRICAT data (xml structure).

Since our Inventory managment system only supports internal links to images, which cannot be used from outside our system, I started uploading images to Postimage (website to create public links to images) and made a excel where every product has its own row of EAN/Imagenames/ImageURL1/ImageURL2 …

Now comes the tricky part and since i never realy worked with xml in KNIME im kinda lost.

The xml structure repeats for every product with all the product details like this:

25032652312020035.xml

There is also a header for the xml but im not to worried about that, because I could simply cut this out and put it back in when im finished adding the image data.

So my goal is, to match the EAN in the xml and add the “Bild URL 1-7” if there is content available to the xml. Naming of the xml tag isnt relevant because the data will get processed for the customer anyways so the data simply need to be unifyed before sending it out.

Thanks for any advice and solution, this would save us a lot of costs to development in out system.

221012_MASTERLISTE_EAN_ART-NO_DATEINAME.xlsx