flat file schema creation problem

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

Viewing 1 reply thread
  • Author
    Posts
    • #18877

      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 

       

    • #18881
        <?xml
      version=”1.0″ encoding=”utf-16″
      ?>
      – <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>
      • #18889

        Please tell me the way to create this schema.

        Thanks

        Sudhanshu Jain

         

        • #18897

          Max, itz great job.

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

          – Pra

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