flat file schema creation problem

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › flat file schema creation problem

Viewing 1 reply thread
  • Author
    Posts
    • February 6, 2008 at 12:52 AM #18877
      community-content

        hi,

        i am new to biztalk and i have a task to create schema for a complex file mentioned below

         

        VML0008/04Oct/LAXAUL/J.46/JA.44/D.35/Z.17/W.39/WA.39/S.34/H.25/K.19/Y.243/B.242/V.241/L.237/M.233/Q.231/X.218/N.193/C
        VMS0008/04OctU/LAXLHRMAX3
        VMS0008/04OctG/LAXLHRMAX6
        VMS0008/04OctI/LAXLHRMAX6
        VMS0008/04OctE/LAXLHRMAX25
        VMS0008/04OctT/LAXLHRMAX39
        VML0200/15Oct/LHRAUL/J.45/JA.39/D.34/Z.24/W.38/WA.29/S.27/H.10/K.10/Y.234/B.223/L.223/M.221/V.220/Q.209/X.149/N.1/C
        VML0200/16Oct/HKGAUL/J.45/JA.42/D.38/Z.20/W.39/WA.34/S.34/H.34/K.16/Y.232/B.232/L.226/M.224/V.219/Q.216/X.202/N.55/C
        VMS0200/15OctJ.JA.D.Z.I.G/LHRHKGMAX29.25.22.17.0.0/C
        VMS0200/15OctW.WA.S.H.K.U/LHRHKGMAX26.22.20.3.3.0/C
        VMS0200/15OctY.B.L.M.V/LHRHKGMAX138.127.127.125.124/C
        VMS0200/15OctQ.X.N.T.E/LHRHKGMAX115.62.0.0.0/C
        VMS0200/15OctQ.X.N.T.E/LHRHKGMAX115.62.0.0.0/C
        VMS0200/15OctJ.JA.D.Z.I.G/LHRSYDMAX16.14.12.7.0.0/C
        VMS0200/15OctW.WA.S.H.K.U.Y/LHRSYDMAX12.7.7.7.7.0.96/C
        VMS0200/15OctB.L.M.V.Q.X/LHRSYDMAX96.96.96.96.94.87/C
        VMS0200/15OctN.T.E/LHRSYDMAX1.0.0/C
        VMS0200/15OctN.T.E/LHRSYDMAX1.0.0/C
        VMS0200/16OctJ.JA.D.Z.I.G/HKGSYDMAX29.28.26.13.0.0/C
        VMS0200/16OctW.WA.S.H.K.U/HKGSYDMAX27.27.27.27.9.0/C
        VMS0200/16OctY.B.L.M.V/HKGSYDMAX136.136.130.128.123/C
        VMS0200/16OctQ.X.N.T.E/HKGSYDMAX122.115.54.2.0/C
        VML0200/22Oct/LHRAUL/J.45/JA.29/D.23/Z.2/W.39/WA.30/S.28/H.12/K.11/Y.234/B.231/L.231/M.230/V.229/Q.220/X.174/N.12/C
        VML0200/23Oct/HKGAUL/J.45/JA.40/D.34/Z.11/W.38/WA.36/S.36/H.36/K.23/Y.232/B.232/L.232/M.230/V.224/Q.220/X.212/N.80/C
        VMS0200/22OctJ.JA.D.Z.I.G/LHRHKGMAX29.17.14.2.0.0/C
        VMS0200/22OctW.WA.S.H.K.U/LHRHKGMAX30.23.21.5.5.0/C
        VMS0200/22OctY.B.L.M.V/LHRHKGMAX154.151.151.150.149/C
        VMS0200/22OctQ.X.N.T.E/LHRHKGMAX143.100.0.0.0/C
        VMS0200/22OctQ.X.N.T.E/LHRHKGMAX143.100.0.0.0/C
        VMS0200/22OctJ.JA.D.Z.I.G/LHRSYDMAX16.12.9.0.0.0/C
        VMS0200/22OctW.WA.S.H.K.U.Y/LHRSYDMAX9.7.7.7.6.0.80/C
        VMS0200/22OctB.L.M.V.Q.X/LHRSYDMAX80.80.80.80.77.74/C
        VMS0200/22OctN.T.E/LHRSYDMAX12.0.0/C
        VMS0200/22OctN.T.E/LHRSYDMAX12.0.0/C
        VMS0200/23OctJ.JA.D.Z.I.G/HKGSYDMAX29.28.25.11.0.0/C
        VMS0200/23OctW.WA.S.H.K.U/HKGSYDMAX29.29.29.29.17.0/C
        VMS0200/23OctY.B.L.M.V/HKGSYDMAX152.152.152.150.144/C
        VMS0200/23OctQ.X.N.T.E/HKGSYDMAX143.138.68.0.0/C
        VML0008/27Aug/LAXAUL/J.55/JA.55/D.49/Z.31/W.64/WA.64/S.60/H.59/K.38/Y.247/B.245/V.245/L.175/M.167/Q.145/X.45/N.0/C
        VMS0008/27AugU/LAXLHRMAX11
        VMS0008/27AugG/LAXLHRMAX12
        VMS0008/27AugI/LAXLHRMAX12
        VMS0008/27AugE/LAXLHRMAX0
        VMS0008/27AugT/LAXLHRMAX0
        VML0008/04Oct/LAXAUL/J.46/JA.44/D.35/Z.17/W.39/WA.39/S.34/H.25/K.19/Y.243/B.242/V.241/L.237/M.233/Q.231/X.218/N.193/C
        VMS0008/04OctU/LAXLHRMAX3
        VMS0008/04OctG/LAXLHRMAX6
        VMS0008/04OctI/LAXLHRMAX6
        VMS0008/04OctE/LAXLHRMAX25
        VMS0008/04OctT/LAXLHRMAX39

        in this file each new group start with vml and all subsequent vms are part of this group but the problem is there can be more than one vml lines in each group.how can i recognies that it is not a new group but it is a part of same group.Pls. tell me the way to create schema because though schema i have to debatch groups.

        Thanks

        Sudhanshu Jain 

         

      • February 6, 2008 at 2:20 AM #18881
        community-content
            <?xml
          version=”1.0″ encoding=”utf-16″           ?>
          – <xs:schema xmlns:b=”http://schemas.microsoft.com/BizTalk/2003“ xmlns=”http://ABCTrading2.Schema.FlatFileSchema1“ targetNamespace=”http://ABCTrading2.Schema.FlatFileSchema1“ xmlns:xs=”http://www.w3.org/2001/XMLSchema“>
          – <xs:annotation>
          – <xs:appinfo>
            <schemaEditorExtension:schemaInfo namespaceAlias=”b“ extensionClass=”Microsoft.BizTalk.FlatFileExtension.FlatFileExtension“ standardName=”Flat
          File          “
          xmlns:schemaEditorExtension          =”http://schemas.microsoft.com/BizTalk/2003/SchemaEditorExtensions“ />
            <b:schemaInfo standard=”Flat File“ codepage=”65001“
          default_pad_char          =”“ pad_char_type=”char“ count_positions_by_byte=”false“
          parser_optimization          =”speed“ lookahead_depth=”3“
          suppress_empty_nodes          =”false“ generate_empty_nodes=”true“
          allow_early_termination          =”false“ early_terminate_optional_fields=”false“
          allow_message_breakup_of_infix_root          =”false“
          compile_parse_tables          =”false“ root_reference=”Root“
          is_envelope          =”yes“ />
            </xs:appinfo>
            </xs:annotation>
          – <xs:element name=”Root“>
          – <xs:annotation>
          – <xs:appinfo>
            <b:recordInfo tag_name=”VML“ structure=”delimited“
          child_delimiter_type          =”hex“ child_delimiter=”0xD 0xA“
          child_order          =”postfix“ sequence_number=”1“
          preserve_delimiter_for_empty_data          =”true“ suppress_trailing_delimiters=”false“
          body_xpath          =”/*[local-name()=’Root’ and
          namespace-uri()=’http://ABCTrading2.Schema.FlatFileSchema1′%5D/*%5Blocal-name()=’Root_Child2&#8242;
          and namespace-uri()=”]          “ />
            </xs:appinfo>
            </xs:annotation>
          – <xs:complexType>
          – <xs:sequence>
          – <xs:annotation>
          – <xs:appinfo>
            <groupInfo sequence_number=”0“ xmlns=”http://schemas.microsoft.com/BizTalk/2003“ />
            </xs:appinfo>
            </xs:annotation>
          – <xs:element name=”Root_Child1“
          type          =”xs:string“>
          – <xs:annotation>
          – <xs:appinfo>
            <b:fieldInfo justification=”left“ sequence_number=”1“ />
            </xs:appinfo>
            </xs:annotation>
            </xs:element>
          – <xs:element maxOccurs=”unbounded“
          name          =”Root_Child2“>
          – <xs:annotation>
          – <xs:appinfo>
            <b:recordInfo tag_name=”VMS“ structure=”delimited“
          child_delimiter_type          =”hex“ child_delimiter=”0xD 0xA“
          child_order          =”infix“ sequence_number=”2“ preserve_delimiter_for_empty_data=”true“
          suppress_trailing_delimiters          =”false“ />
            </xs:appinfo>
            </xs:annotation>
          – <xs:complexType>
          – <xs:sequence>
          – <xs:annotation>
          – <xs:appinfo>
            <groupInfo sequence_number=”0“ xmlns=”http://schemas.microsoft.com/BizTalk/2003“ />
            </xs:appinfo>
            </xs:annotation>
          – <xs:element name=”Root_Child2_Child1“>
          – <xs:annotation>
          – <xs:appinfo>
            <b:recordInfo structure=”delimited“ child_delimiter_type=”char“
          child_delimiter          =”/“ child_order=”infix“ sequence_number=”1“
          preserve_delimiter_for_empty_data          =”true“ suppress_trailing_delimiters=”false“ />
            </xs:appinfo>
            </xs:annotation>
          – <xs:complexType>
          – <xs:sequence>
          – <xs:annotation>
          – <xs:appinfo>
            <groupInfo sequence_number=”0“ xmlns=”http://schemas.microsoft.com/BizTalk/2003“ />
            </xs:appinfo>
            </xs:annotation>
          – <xs:element name=”Root_Child2_Child1_Child1“ type=”xs:string“>
          – <xs:annotation>
          – <xs:appinfo>
            <b:fieldInfo justification=”left“ sequence_number=”1“ />
            </xs:appinfo>
            </xs:annotation>
            </xs:element>
          – <xs:element name=”Root_Child2_Child1_Child2“ type=”xs:string“>
          – <xs:annotation>
          – <xs:appinfo>
            <b:fieldInfo justification=”left“ sequence_number=”2“ />
            </xs:appinfo>
            </xs:annotation>
            </xs:element>
          – <xs:element name=”Root_Child2_Child1_Child3“ type=”xs:string“>
          – <xs:annotation>
          – <xs:appinfo>
            <b:fieldInfo justification=”left“ sequence_number=”3“ />
            </xs:appinfo>
            </xs:annotation>
            </xs:element>
            </xs:sequence>
            </xs:complexType>
            </xs:element>
            </xs:sequence>
            </xs:complexType>
            </xs:element>
            </xs:sequence>
            </xs:complexType>
            </xs:element>
            </xs:schema>
          • February 6, 2008 at 8:32 PM #18889
            community-content

              Please tell me the way to create this schema.

              Thanks

              Sudhanshu Jain

               

              • February 7, 2008 at 10:09 PM #18897
                community-content

                  Max, itz great job.

                  I would like to know the way in which you have created this schema.

                  – Pra

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