Help in BizTalk 2006 R2 Mapping.

Home Page Forums BizTalk 2004 – BizTalk 2010 Help in BizTalk 2006 R2 Mapping.

Viewing 2 reply threads
  • Author
    Posts
    • #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.

    • #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.

    • #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.

       

Viewing 2 reply threads
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.