Rebuild multiple XML files into a single XML

OL Connect Enterprise Workflow
1

Hello,

How would you go about merging a folder full of XML files into a single XML ready for processing through a datamapper?

Regards,

Mark

2

You could use XSLT. See this post

3

Thanks @hamelj how would I apply that in workflow?

4

You would need to use the XSLT plugin of Workflow. More than that, sorry…I have to say I do not understand XSLT.

5

Reach out for XSLT assistance.

6

Hi @jim3108, that would be great thanks - I have a folder full of XML files which I am pre-processing with additional data, these are then being written out to a temp folder of XML files again. At which point I want to grab that folder using the folder capture plugin and then use the XSLT plugin to merge them into a single XML file.

Would something like this be possible?

7

Just thinking but have you thought about just trimming off the root nodes and outputting to a single file using Send to Folder with concatenate files switched on?

8

Hi @jim3108,

I had but wasn’t sure how I can remove the root nodes using workflow - would it be best to run a script over each XML file being read? Similar to the javascript I’m using to add the extra nodes into the dataset?

Mark

9

Just use the Add/Remove Text plugin three times. Once to remove 2 lines from the top - the XML header and the top tag. Second time to add the XML header back in. Third time to remove the bottom tag.

Make sense?

10

Yup, thanks @jim3108.

First loop through the folder - removing the XML headers, top tags and bottom tags for each record, concatenating the result. Effectively leaving just the node data. Then finally add the XML header, top tag and bottom tag back in to the ‘combined’ results…