XML Port problem with repeating Elements

Toddy_Boy

I'm having a little trouble understanding XMLPorts. This is the output I'm getting;



from this dataport



However I don't want to see the Products element repeating, it should be

<Products>
<SerialNumber>1000<SerialNumber>
<SerialNumber>2000<SerialNumber>
<SerialNumber>3000<SerialNumber>
<SerialNumber>4000<SerialNumber>
</Products>

Can't see where I'm going wrong

Toddy_Boy

Things have moved on and this was achieved using the XML DOM

kaspermoerch

You can't achieve that with an XMLport.

You can however get one of the following results:

<Products>
    <SerialNumber SerialNo=""/>
    <SerialNumber SerialNo=""/>
    <SerialNumber SerialNo=""/>
    <SerialNumber SerialNo=""/>
</Products>

<Products>
    <SerialNumber>
        <SerialNo></SerialNo>
    </SerialNumber>
    <SerialNumber>
        <SerialNo></SerialNo>
    </SerialNumber>
    <SerialNumber>
        <SerialNo></SerialNo>
    </SerialNumber>
</Products>

In both cases the Products element is a Text node and the SerialNumber element loops the Serial No. Information table. In the first example SerialNo is an Attribute and in the second an Element.

If neither of these formats suites you then you have to create the XML document by hand e.g. by using .NET.

Toddy_Boy

Things have moved on and this was achieved using the XML DOM