Mapping to a repeating node

• Author
  Posts
• • November 14, 2008 at 5:39 AM #21195
    community-content

     

    Guys,

     

    A question about mapping…

     

    The source contains some nodes with an address, such as a street, a housenumber, a city, …

    That is how one usually saves an address in XML.

     

    The target schema is rather strage…

     

    – <xs:element minOccurs=”0“ maxOccurs=”unbounded“ name=”Address-long“>

    – <xs:complexType>

    – <xs:sequence>

    – <xs:element minOccurs=”0“ maxOccurs=”unbounded“ name=”AddressLine“>

    – <xs:complexType>

    – <xs:sequence>

      <xs:element msdata:Ordinal=”0“ minOccurs=”0“ name=”addressfieldname“ type=”xs:string“ />

      <xs:element msdata:Ordinal=”1“ minOccurs=”0“ name=”addressfieldvalue“ type=”xs:string“ />

      </xs:sequence>

      <xs:attribute form=”unqualified“ name=”LineNumber“ type=”xs:string“ />

      </xs:complexType>

      </xs:element>

      </xs:sequence>

      </xs:complexType>

      </xs:element>

     

    That gives something like this…

     

    – <ns0:Address-long>

    – <ns0:AddressLine LineNumber=”1“>

      <ns0:addressfieldname>street</ns0:addressfieldname>

      <ns0:addressfieldvalue>My Street Name</ns0:addressfieldvalue>

      </ns0:AddressLine>

    – <ns0:AddressLine LineNumber=”2“>

      <ns0:addressfieldname>housenumber</ns0:addressfieldname>

      <ns0:addressfieldvalue>13</ns0:addressfieldvalue>

      </ns0:AddressLine>

    – <ns0:AddressLine LineNumber=”3“>

      <ns0:addressfieldname>city</ns0:addressfieldname>

      <ns0:addressfieldvalue>My City</ns0:addressfieldvalue>

      </ns0:AddressLine>

    </ns0:Adres-long>

     

    I have no clue how to map those two…

    Can anyone help me please?

     

    Thanks,

    Christophe
• Author
  Posts