XML to Flatfile: request for information

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › XML to Flatfile: request for information

Viewing 0 reply threads
  • Author
    Posts
    • #21317

      Could someone recommend a reference?

      I want to generate a flatfile containing the string of one node. To do this I had created a map from my node to a flatfile schema. I’m guessing this is a very simple process since the formats are pretty basic. The groups assistance with this would be greatly appreciated.

      this is the inbound document:

      <ENVELOPE>
      <HEADER>
      <TranCode>270</TranCode>
      <MessageFormat>X12</MessageFormat>
      <Sender>AETNA</Sender>
      <Receiver>ORHS</Receiver>
      <Session>null</Session>
      <ProviderOfficeNbr>ORLANDOHEALTH-PFS</ProviderOfficeNbr>
      <ProviderTransID>001854367</ProviderTransID>
      </HEADER>
      <BODY>ISA*01*          *01*          *ZZ*xxxxxxxxx      *ZZ*zzzzzzzzzz     *081125*1625*U*00401*0
      </BODY></ENVELOPE> 

      I just want the <BODY> dumped to a flat file. Oh, and yes, there is a different subscription if there is an <Interchange> sub element. I have not determined the disposition for that filter.

      My Schema is (BizTalk generated):

        <?xml version=”1.0″ encoding=”utf-16″ ?>
      – <xs:schema xmlns:ns0=”http://ORHS.B2B.AVAILITY.PropertySchema.PropertySchema“ xmlns:b=”http://schemas.microsoft.com/BizTalk/2003“ attributeFormDefault=”unqualified“ elementFormDefault=”qualified“ xmlns:xs=”http://www.w3.org/2001/XMLSchema“>
      – <xs:annotation>
      – <xs:appinfo>
        <namespace prefix=”ns0“ uri=”http://ORHS.B2B.AVAILITY.PropertySchema.PropertySchema“ location=”..\propertyschema.xsd“ />
        </imports>
        </xs:appinfo>
        </xs:annotation>
      – <xs:element name=”ENVELOPE“>
      – <xs:annotation>
      – <xs:appinfo>
        <property name=”ns0:TranCode“ xpath=”/*[local-name()=’ENVELOPE’ and namespace-uri()=”]/*[local-name()=’HEADER’ and namespace-uri()=”]/*[local-name()=’TranCode’ and namespace-uri()=”]“ />
        <property name=”ns0:MessageFormat“ xpath=”/*[local-name()=’ENVELOPE’ and namespace-uri()=”]/*[local-name()=’HEADER’ and namespace-uri()=”]/*[local-name()=’MessageFormat’ and namespace-uri()=”]“ />
        <property name=”ns0:ProviderTransID“ xpath=”/*[local-name()=’ENVELOPE’ and namespace-uri()=”]/*[local-name()=’HEADER’ and namespace-uri()=”]/*[local-name()=’ProviderTransID’ and namespace-uri()=”]“ />
        </properties>
        </xs:appinfo>
        </xs:annotation>
      – <xs:complexType>
      – <xs:sequence>
      – <xs:element name=”HEADER“>
      – <xs:complexType>
      – <xs:sequence>
        <xs:element name=”TranCode“ type=”xs:string“ />
        <xs:element name=”MessageFormat“ type=”xs:string“ />
        <xs:element name=”Sender“ type=”xs:string“ />
        <xs:element name=”Receiver“ type=”xs:string“ />
        <xs:element name=”Session“ type=”xs:string“ />
        <xs:element name=”ProviderOfficeNbr“ type=”xs:string“ />
        <xs:element name=”ProviderTransID“ type=”xs:unsignedInt“ />
        </xs:sequence>
        </xs:complexType>
        </xs:element>
      – <xs:element minOccurs=”1“ maxOccurs=”1“ name=”BODY“>
      – <xs:complexType>
      – <xs:sequence>
      – <xs:element minOccurs=”0“ maxOccurs=”unbounded“ name=”Interchange“>
      – <xs:complexType>
      – <xs:sequence>
      – <xs:element name=”Error“>
      – <xs:complexType>
      – <xs:sequence>
        <xs:element name=”ErrorCode“ type=”xs:string“ />
        <xs:element name=”ErrorDesc“ type=”xs:string“ />
        </xs:sequence>
        </xs:complexType>
        </xs:element>
        </xs:sequence>
        </xs:complexType>
        </xs:element>
        </xs:sequence>
        </xs:complexType>
        </xs:element>
        </xs:sequence>
        </xs:complexType>
        </xs:element>
        </xs:schema>
       

      I just want the <BODY> string dumped to a flatfile.

       

       

       

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