Import XMl File to Navision with XML Port

KeesMeuzelaar

I am trying to import an xml file, it seems to be very simple.

Below is an extract of the file.

<?xml version="1.0" encoding="UTF-8"?>
<articlelist>
<article id="00K7900">
<field name="Field1" type="text" size=" 8 "><![CDATA[waarde1]]></field>
<field name="Field2" type="text" size=" 8 "><![CDATA[waarde2]]></field>
</article>
</articlelist>

The result must be 2 lines so for every field there will be made an extra line in the table with the fields

Article id | Fieldname | Value
00k7900 | Field1 | waarde1
00k7900 | Field2 | waarde2

I cannot succeed in importing this simple file.
I think because it has more than 1 record to create per item.

I hoped to catch the fields in variables and then create records myself it does not seem to be possible.

Can anybody help me out?

SteveO

Try using the MSXML DOM control, this gives you more control on how your XML Document is handled and it doesn't take too long develop with either.

Roelof

I have an additional question on that:
I am importing a SalesOrder XML file in a DOM. That works fine. However, some SalesOrders do have more then 1 SalesLine. How can I read/parse more then 1 salesline from the DOM? Somekinda repeat until loop? or how does that work in a DOM?