Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
DynDeveloper.com

DynDeveloper.com

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
Hosea 8/3/2011 8:22:44 AM

Problems with Integration Manager reading XML document attributes

This article can be found on the Integration Manager Menu

A client recently called with an issue with importing an XML file using Integration Manager (IM). Apparently, IM can't read the attributes in an XML document. After trying for a while to get it to work, we decided to write a small application that would parse the XML file and move the attributes to nodes.

Today’s task has to do with an XML document that has the form:


<OutboundReports>
    <InvoiceNotice>
        <InvoiceNoticeHeader InvoiceDate="20100607" InvoiceType="Invoice" invoiceID="60252726" purpose="PR">
        </InvoiceNoticeHeader>
    </InvoiceNotice>
    <InvoiceNotice>
        <InvoiceNoticeHeader InvoiceDate="20100607" InvoiceType="Invoice" invoiceID="60252727" purpose="PR">
        </InvoiceNoticeHeader>
    </InvoiceNotice>
</OutboundReports>

We need to move the InvoiceDate, InvoiceType, and invoiceID attributes to ‘nodes’, so that our integration program will see them, the current version will not read attributes. Here’s what we want it to look like in the end:

<OutboundReports>
    <InvoiceNotice>
        <InvoiceNoticeHeader InvoiceDate="20100607" InvoiceType="Invoice" invoiceID="60252726" purpose="PR">
            <InvoiceDate>20100607</InvoiceDate>
            <InvoiceType>Invoice</InvoiceType>
            <InvoiceID>60252726</InvoiceID>
        </InvoiceNoticeHeader>
    </InvoiceNotice>
    <InvoiceNotice>
        <InvoiceNoticeHeader InvoiceDate="20100607" InvoiceType="Invoice" invoiceID="60252727" purpose="PR">
            <InvoiceDate>20100607</InvoiceDate>
            <InvoiceType>Invoice</InvoiceType>
            <InvoiceID>60252726</InvoiceID>
        </InvoiceNoticeHeader>
    </InvoiceNotice>
</OutboundReports>

Here’s the code:



Version: Unknown or N/A
Section: Dynamics GP








Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables