Some XML Help

tonystark622 · Post by **tonystark622** » Tue Jan 25, 2005 10:51 am

Can anyone help me get some data output in XML the way my customer wants it?

What they want is:

<Interfaces>
<Interface>Data from Row 1</Interface>
<Interface>Data from Row 2</Interface>
<Interface>Data from Row 3</Interface>
</Interfaces>

In the XPath I have
/Interfaces/Interface/Data1/text()
/Interfaces/Interface/Data2/text()
...

With Aggregate All Rows selected we get:
<Interfaces><Interface>Data from Row 1</Interface></Interfaces>
<Interfaces><Interface>Data from Row 2</Interface></Interfaces>
<Interfaces><Interface>Data from Row 3</Interface></Interfaces>

Can anyone direct me in the right direction????

Thanks, Tony

ray.wurlod · Post by **ray.wurlod** » Tue Jan 25, 2005 4:53 pm

What happens if you remove "/Interfaces" from XPath?

throbinson · Post by **throbinson** » Wed Jan 26, 2005 7:51 am

XML Pack 2.0? In the XML Output stage version 7.0, the XML generated is as you want it when Output mode is Aggregate all rows pretty much by default.

tonystark622 · Post by **tonystark622** » Wed Jan 26, 2005 3:20 pm

Ray and Tom,

Thanks for your help. The developer got it to do what he wanted by playing with Key Fields in the XML Writer.

Sorry about the delay in responding.

Tony