Pulling Content from a Node (XML files)

How-to(s), solutions to common problems, pearls of wisdom

leefate
Posts: 1
Joined: Mon Aug 28, 2017 10:22 pm

Pulling Content from a Node (XML files)

Postby leefate » Mon Aug 28, 2017 10:33 pm

Pulling Content from a Node (XML files)

I want to be able to pull one metadata item from hundreds of XML files. Is there a function that will allow CloverETL to 'look' in a folder where the xml files reside and extract the one piece of data I need from all of the files?

vazquezrosariop
Posts: 107
Joined: Mon Feb 29, 2016 5:33 pm

Re: Pulling Content from a Node (XML files)

Postby vazquezrosariop » Wed Aug 30, 2017 3:10 pm

Hi leefate

If I understand your question correctly, you want to extract a particular Element from multiple XML Files. If that's the case, you can accomplish this using the XMLExtract component and use a wild card in the URL. Assuming that all the XML files are the same structure, you will need to create the metadata upfront using the mapping field in the XMLExtract which will automatically create the XSD.

I have taken the liberty of building a project with an example of your use case.

XMLExample.zip
(417.51 KiB) Downloaded 13 times
---
Pedro Vazquez Rosario
CloverCARE Support
CloverETL | Rapid Data Integration

Visit us online at http://www.cloveretl.com
How to speed up communication with CloverCARE support


cron