Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Help in BizTalk 2006 R2 Mapping.
- This topic has 2 replies, 1 voice, and was last updated 9 years ago by
community-content.
-
AuthorPosts
-
-
January 2, 2009 at 4:54 PM #21461
I need help in mapping the following:
Input XML
———<ISOAdjusterinfo>
<ISOAdjuster>
<AdjusterNum>10</AdjusterNum>
<Agency_Code>Agency10</Agency_Code>
<COL>10</COL>
<Coverage>10</Coverage>
<GivenName>Paul</GivenName>
<ID_Ref>IDRef_10</ID_Ref>
<Other_GivenName>Abc</Other_GivenName>
<Phone_Num>2484449999</Phone_Num>
<Surname>GUnter</Surname>
</ISOAdjuster>
<ISOAdjuster>
<AdjusterNum>10</AdjusterNum>
<Agency_Code>Agency10</Agency_Code>
<COL>11</COL>
<Coverage>11</Coverage>
<GivenName>Paul</GivenName>
<ID_Ref>IDRef_11</ID_Ref>
<Other_GivenName>Abc</Other_GivenName>
<Phone_Num>2484449999</Phone_Num>
<Surname>Gunter</Surname>
</ISOAdjuster>
<ISOAdjuster>
<AdjusterNum>20</AdjusterNum>
<Agency_Code>Agency20</Agency_Code>
<COL>20</COL>
<Coverage>20</Coverage>
<GivenName>John</GivenName>
<ID_Ref>IDRef_20</ID_Ref>
<Other_GivenName>Xyz</Other_GivenName>
<Phone_Num>2484448888</Phone_Num>
<Surname>Jacobs</Surname>
</ISOAdjuster>
</ISOAdjusterinfo>Output XML
———-<AdjusterParty>
<ItemIdInfo>
<AgencyId>Agency10</AgencyId>
</ItemIdInfo>
<GeneralPartyInfo>
<PersonName>
<Surname>>Gunter</Surname>
<GivenName>Paul</GivenName>
<Other_GivenName>Abc</Other_GivenName>
</PersonName>
<Communication>
<PhoneInfo>
<PhoneNumber>2484449999</PhoneNumber>
</PhoneInfo>
</Communication>
</GeneralPartyInfo>
<AdjusterPartyInfo id = “IDRef_10”>
<Coverage>10</Coverage>
</AdjusterPartyInfo>
<AdjusterPartyInfo id = “IDRef_11”>
<Coverage>11</Coverage>
</AdjusterPartyInfo>
</AdjusterParty>
<AdjusterParty>
<ItemIdInfo>
<AgencyId>Agency20</AgencyId>
</ItemIdInfo>
<GeneralPartyInfo>
<PersonName>
<Surname>>Jacobs</Surname>
<GivenName>John</GivenName>
<Other_GivenName>Xyz</Other_GivenName>
</PersonName>
<Communication>
<PhoneInfo>
<PhoneNumber>2484448888</PhoneNumber>
</PhoneInfo>
</Communication>
</GeneralPartyInfo>
<AdjusterPartyInfo id = “IDRef_20”>
<Coverage>20</Coverage>
</AdjusterPartyInfo>
</AdjusterParty>The Adjusterparty needs to be populated once for a particular Adjuster number but the coverage needs to be populated to the existing Adjusterparty for that AdjusterNum.
Thanks in advance.
-
January 3, 2009 at 12:57 PM #21463
Hi,
Better use a helper class to fix this.It wont be fixed through a simple mapping.You will need a XSLT if you dont want to use a Helper class.
-
January 4, 2009 at 11:42 PM #21469
If you cant use inline XSLT to do what you need (for example, you need to create your own xsl functions etc) I would use the helper class to call XSL with your C# (or VB) functions.
-
-
AuthorPosts
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.