Skip to Content
0

how to change the xml structure format in File to JMS

Mar 09, 2017 at 06:04 AM

91

avatar image
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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Mar 09, 2017 at 07:43 AM
0

HI

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

Regards

GB

Show 2 Share
10 |10000 characters needed characters left characters exceeded
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"?>

http://majorassembly.ve.xxx.com/ai"> " 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

0
Former Member

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

Regards

GB

0