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
    • December 6, 2008 at 6:42 PM #21317
      community-content

        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>
        – <imports xmlns=”http://schemas.microsoft.com/BizTalk/2003“>
          <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>
        – <properties xmlns=”http://schemas.microsoft.com/BizTalk/2003“>
          <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.

         

         

         

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