SAP Knowledge Base Article - Preview

3038611 - XML load Issue

Symptom

missing data from xml source

<xs:element name="letter">
  <xs:complexType mixed="true">
    <xs:sequence>
      <xs:element name="name" type="xs:string"/>
      <xs:element name="orderid" type="xs:positiveInteger"/>
      <xs:element name="shipdate" type="xs:date"/>
    </xs:sequence>
  </xs:complexType>
</xs:element>

 

DS will create a template (the structure like this:

 

   letter

       I------name

       |------orderid

       |------shipdate

So when we processing the runtime data like this:

 

  <letter>
       Dear Mr. <name>John Smith</name>.
       Your order <orderid>1032</orderid>
       will be shipped on <shipdate>2001-07-13</shipdate>.
  </letter>

 

We will capture the data for <name>, <orderid>, and <shipdate>, but the character data like "Dear Mr." et cetera will be ignored, because they don't belong to any element or attribute.


Read more...

Environment

  • SAP Data Services 14.2.x
  • XML Source

Product

SAP Data Services 4.2

Keywords

DS , KBA , EIM-DS-EXE , Job Execution , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.