Hi all
has anybody used the XML tasks (Read Node etc) to merge multiple XML files into a single output file? There is no documentation about this in the Help file so was hoping someone had managed to figure this out?
I have approximately 150,000 XML files to merge (from a billing system). I am using V.C V6 with the new Beta Looping functionality. In the Job I have three tasks:
1. List the XML files in a particular folder.
2. Start Loop - FOR EACH FILE IN STDOUT of previous task
XML READ NODE from XPath Expression '/CyBizXML[1]/Statement[1] using STDOUT variable from LOOP
3. Write File from previous task STDOUT to a default output file.
END LOOP
In this scenario, (i.e. Looping), in Read Node task I am using the variable {LOOP(CurrentValueXArray,0)} to reference each file identified in the loop (from task 1) but I am getting an error message (Exception in Task: Data at the root level is invalid. Line 1, position 1.) However, if I don't use the loop and specify a specific XML file (which will use the contents from one specific file 'x' times), I don't get the error
If anybody has tried this kind of thing before and can offer some guidance it would be very much appreciated
I have attached some screenshots showing what I have set up
Cheers
Andy
[EDIT]MOVED TO BETA FORUM[EDIT]
Edited by moderator
2011-10-07T06:20:49Z
|
Reason: Moved to Beta forum
osirisja attached the following image(s):