Importing an XML File with repeating, interspersed siblings.

I am importing an XML file from Amazon that reports my client's sales for two weeks.

The file gives the complete information on all orders, refunds and coupons used.

My XMLPort is set up to read in all orders, then all refunds and then all coupons.

However, the file contains the coupons intermingled with the refunds.

Example below.  XMLPort dies when is sees a refund after a coupon.

<Order>
Order Data
</Order>
<Order>
Order Data
</Order
<Refund>
Refund data
</Refund>
<Coupon>
Coupon data
</Coupon>
<Refund>
Refund data
</Refund>

Any way to handle this?

Related
Recommended