Import XMl File to Navision with XML Port

KeesMeuzelaar
KeesMeuzelaar Member Posts: 26
edited 2006-10-25 in NAV/Navision Classic Client
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?

Comments

  • SteveO
    SteveO Member Posts: 164
    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.
    This isn't a signature, I type this at the bottom of every message
  • Roelof
    Roelof Member Posts: 377
    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?
    Roelof de Jonghttp://www.wye.com

Categories