how to change the xml structure format in File to JMS

[Former Member]

Hi All,

My requirement is file to jms. in this how to change the xml structure for receiver

sender xml format:

<tab>

<item>
<objectnumbervariant>e400950000</objectnumbervariant>
<delta>false</delta>
<datacardavailable>true</datacardavailable>
<modeldesignation>engine</modeldesignation>
<id>engine321654</id>

<activeassignedfpd>
<item>
<saadesignation>40100201</saadesignation>
<amountpersaa>1</amountpersaa>
</item>

<item>
<saadesignation>40100901</saadesignation>
<amountpersaa>1</amountpersaa>
</item>

<item>
<saadesignation>40101503</saadesignation>
<amountpersaa>1</amountpersaa>
<item>

<item>
<saadesignation>40101504</saadesignation>
<amountpersaa>1</amountpersaa>
</item>

<item>
<saadesignation>40111403</saadesignation>
<amountpersaa>1</amountpersaa>
</item>
</activeassignedfpd>

<shipmentdate>20150129</shipmentdate>
<technicalapprovaldate>20150129</technicalapprovaldate>
<productionnumber>0000200003</productionnumber>
<plant>p6365</plant>
<userid_rpt>vedoc_tec_63</userid_rpt>
<unresolvedconflictaction>notifyadmin</unresolvedconflictaction>
<systempriority>10</systempriority>
<issuethreshold>err</issuethreshold>
<date>20170220181647</date>
<causation>plant</causation>
</item>
</tab>

Receiver : xml format to jms

<saa amountPerSaa="1" saaDesignation="40100201"/>
<saa amountPerSaa="1" saaDesignation="40100901"/>
<saa amountPerSaa="1" saaDesignation="40101503"/>
<saa amountPerSaa="1" saaDesignation="40101504"/>
<saa amountPerSaa="1" saaDesignation="40111403"/>

Please let me know how to meet this requirement,

Thanks,

Regards,

Vinoth

[gagandeep_batra]

HI

import both XSD's in your ESR and map them as Reqiure

Regards

GB

[Former Member]

Hi Gagandeep,

Thanks for your reply.

After converting XML structure into XSD, I could able to get the output as required format

"<saa amountPerSaa="1" saaDesignation="40111403"/>"

But the problem here is, after converting it as XSD the structure is splitted into header, body and footer. In mapping I could able to choose either one.

Kindly let me know how to include header, Body and footer in the output.

Header:

<?xml version="1.0" encoding="UTF-8"?>

<ns1:storeEngineRequestversion="15.2.1.1" category="MajorAssemblyAdapter" xmlns:ns1="http://majorassembly.ve.xxx.com/ai"><requestHeaderuserId="VEDOC_tec_63" credentials=""/>

Body:

<engine objectNumberVariant="X110096002" delta="false" dataCardAvailable="true" modelDesignation="471904" id="471904C0106156">

<activeAssignedFpd>

<saasaaDesignation="53705608" amountPerSaa="1"/>

<saasaaDesignation="53709701" amountPerSaa="1"/>

<saasaaDesignation="53712010" amountPerSaa="1"/>

<saasaaDesignation="53700010" amountPerSaa="1"/>

<saasaaDesignation="53700113" amountPerSaa="1"/>

</activeAssignedFpd>

<activeProductDateshipmentDate="20140714" technicalApprovalDate="20140712"/>

<activeStateproductionNumber="8812200" plant="tbd"/>

</engine>

Footer:

<executionSettings userId="VE_tec_63" unresolvedConflictAction="notifyAdmin" systemPriority="10" issueThreshold="err" date="currentDateTime" causation="plant"/>

</ns1:storeEngineRequest>

Regards,

Vinoth

[gagandeep_batra]

Make another datatype with referecnce to all three and create message typre frpm that datatype

Regards

GB