Tuesday, March 15, 2016

Build a XML Tag using JDE Event Rules



Good Afternoon All,

we have a requirement to build a XML file using JDE Event Rules. There is report which currently generates a .txt file but the client now requires that same file to be generated in XML format.

I was wondering how to accomplish or build a XML tag for a header, detail etc.
txt file output goes one record in one line
.XML goes in a tree format. I have no experience in building a XML tags with simple JDE Event Rules and how it looks. Below is the XML format and I was wondering how I can a header and detail tags for this. Please provide your expert advice.
Do I have to construct one big String variable and concatenate these tags and after every close should I write to to the file or one insert at the end will be fine.
This report is for ROE and for every employee they generate a either a single or multi ROE depending on how many companies he was working.

<ROEHEADER Application="RoeWeb" FileVersion="1.00">

<Roe>

<B5>100000000RP9999</B5>

<B6>B</B6>

<B8>999999999</B8>

<B9>

<FN>Xxxxxx </FN>

<LN>Xxxxxxxxxxxxx</LN>

<A1>123 Xxxxxxxxxxx </A1>

</B9>

<B10>01012005</B10>

<B11>14012005</B11>

<B12>15012005</B12>

<B15A>80</B15A>

<B15B>800.00</B15B>

<B15C>

<PP nbr="1">

<AMT>800.00</AMT>

</PP>

</B15C>

<B16>

<CD>A</CD>

<FN>Xxxxxxxxx</FN>

<LN>Xxxxxxxxxxx</LN>

<AC>819</AC>

<TEL>6831234</TEL>

</B16>

</Roe>

<Roe>

<B5>100000000RP9999</B5>

<B6>B</B6>

<B8>999999998</B8>

<B9>

<FN>Xxxx</FN>

<LN>Xxxxxxxxxxxxxxxxx</LN>

<A1>789 XXXXXXXXXXXX</A1>

</B9>

<B10>01012005</B10>

<B11>14012005</B11>

<B12>15012005</B12>

<B15A>70</B15A>

<B15B>700.00</B15B>

<B15C>

<PP nbr="1">

<AMT>700.00</AMT>

</PP>

</B15C>

<B16>

<CD>A</CD>

<FN>Xxxxxxxxx</FN>

<LN>Xxxxxxxxxxxxxx</LN>

<AC>819</AC>

<TEL>1234567</TEL>

</B16>

</Roe>

<Roe>

</Roe>

</ROEHEADER>


from JDELIST - JD Edwards® EnterpriseOne Technical http://ift.tt/1UxnrNP
via IFTTT

No comments:

Post a Comment