• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Build a XML Tag using JDE Event Rules

Sheen

Member
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>
 

adeel

VIP Member
Set up processing options for path in p776031 or try p77031 in case the first one is not the one. You can create single or multiple roe. this apps call ube.
 
Top