Better XML handling in Design

Posted by: Ryan.Barrett

Better XML handling in Design - 03/20/09 02:15 PM

Basically, it would be great to have full control over the XPath. To at least have the ability to manually iterate.

When doing iteration you are locked into a specific level. For example: /Levels[1]/Level[1]/info, Locked in Level[1]
Posted by: Anonymous

Re: Better XML handling in Design - 03/20/09 02:48 PM

Hello,

You can iterate already on any node in your xml file. This has been available since the release of the XML data input.

For example if you have a file that looks like this

Code:
<root>
  <items>
    <item>
      <info>
    </item>
    <item>
      <info>
    </item>
    <item>
      <info>
    </item>
    <item>
      <info>
    </item>
</root>
You can already iterate on the item node. You can map out one info node and then go into the repeat section. In the repeat section you can iterate on the item node.
Posted by: Ryan.Barrett

Re: Better XML handling in Design - 03/25/09 02:56 PM

I had opened a Case about this, There was not a satisfactory resolution(it would have involved a lot of coding).

Basically, It is unable to overflow at the Line level, only Package level.

Code:
<SHIPMENT>
	<ORDER_NUMBER>TEST090226001</ORDER_NUMBER>
	<PACKAGE>
		<BOX_NUMBER>1</BOX_NUMBER>
		<LINE>
			<LINE_INDEX>1</LINE_INDEX>
			<PRODUCT_ID>PRODUCTA1</PRODUCT_ID>
		</LINE>
		<LINE>
			<LINE_INDEX>2</LINE_INDEX>
			<PRODUCT_ID>PRODUCTA2</PRODUCT_ID>
		</LINE>
		<LINE>
			<LINE_INDEX>3</LINE_INDEX>
			<PRODUCT_ID>PRODUCTA3</PRODUCT_ID>
		</LINE>
		<LINE>
			<LINE_INDEX>4</LINE_INDEX>
			<PRODUCT_ID>PRODUCTA4</PRODUCT_ID>
		</LINE>
		<LINE>
			<LINE_INDEX>5</LINE_INDEX>
			<PRODUCT_ID>PRODUCTA5</PRODUCT_ID>
		</LINE>
		<LINE>
			<LINE_INDEX>6</LINE_INDEX>
			<PRODUCT_ID>PRODUCTA6</PRODUCT_ID>
		</LINE>
		<LINE>
			<LINE_INDEX>7</LINE_INDEX>
			<PRODUCT_ID>PRODUCTA7</PRODUCT_ID>
		</LINE>
	</PACKAGE>
	<PACKAGE>
		<BOX_NUMBER>2</BOX_NUMBER>
		<LINE>
			<LINE_INDEX>1</LINE_INDEX>
			<PRODUCT_ID>PRODUCTB1</PRODUCT_ID>
		</LINE>
		<LINE>
			<LINE_INDEX>2</LINE_INDEX>
			<PRODUCT_ID>PRODUCTB2</PRODUCT_ID>
		</LINE>
	</PACKAGE>
</SHIPMENT>