multiple records

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › multiple records

Viewing 1 reply thread
  • Author
    Posts
    • February 4, 2010 at 8:23 AM #24196
      community-content

        I have a problem, i have a xsd with multiple records, the structure of flat file is:

        MSH

        NTE [0 to unbound]

        PID

        {

        ORC

        TQ1

        OBR

        OBX [0 to unbound]

        } [0 to unbound]

         

        I put a secuence in a structure delimited by {} but i dont know to do the NTE and OBX sequence because if i put unbount NTE all headers bellow are NTE and if i put in OBX the same.

        I dont know how to do the structure.

         

        Anyone can help me?

      • February 4, 2010 at 11:21 AM #24198
        community-content

          The easiest way to create flat file schema, is you create the flat file that you need (.txt) and import in Biztalk with wizard.

           

          • February 4, 2010 at 12:39 PM #24199
            community-content

              The key to structured flat files is using Tag Identifiers. A character sequence that the parser can use to identify a record type so that it knows when it has finished with a recurring set of records.

              Can you post a short  example of your flat file?

              • February 4, 2010 at 1:51 PM #24200
                community-content

                  MSH|aaaa|bbbb|cccc|dddd|eeee|ffff|gggg

                  NTE|aaaa|bb|ccc

                  NTE|aaaa|bb|cccc  (0 to unbound)

                  PID|sdasd|fasdas|sdfsdf|ferer|dfsers|fsersd|dsfsres|sdfser|sdfetq|adee|fsaerr

                  ORC|fisrt|time|dfaswr|asd

                  TQ1|asdaa|asda|free|

                  OBR|ada|aa|eedd|zzzz|xxxx|rrfra

                  OBX|aaa|bbbb|ccc

                  OBX|aaa|bbb|cccc

                  OBX|afrrr|fffee||

                  ORC|second|time|dfaswr|asd

                  TQ1|asdaa|asda|free|

                  OBR|ada|aa|eedd|zzzz|xxxx|rrfra

                  OBX|aaa|bbbb|ccc

                  ORC|third|time|dfaswr|asd

                  TQ1|asdaa|asda|free|

                  OBR|ada|aa|eedd|zzzz|xxxx|rrfra

                  OBX|aaa|bbbb|ccc

                  OBX|sea|sra|ffrtg

                   

                   

                  this is an example of my flat file

                  • February 4, 2010 at 5:10 PM #24204
                    community-content

                      Here is a sample schema show the basic structure:
                      http://cid-4e9c10425c5f8e8f.skydrive.live.com/self.aspx/Public/StructuredFlatFile.zip

                      • February 5, 2010 at 2:05 AM #24205
                        community-content

                           

                          Thanks, I solve the problem with Tag Identifier but if the node NTE or TQ1 (the two nodes with min Occurs = 0) not appear in the flat file throw an error:

                           

                           

                          Error

                                  Source:         Flat file disassembler

                                  Message:        An error occurred when parsing the incoming document: “Unexpected data found while looking for:

                          ‘TQ1’

                          ‘ORC’

                          The current definition being parsed is HL7_OML_O21. The stream offset where the error occured is 961. The line number where t

                          he error occured is 14. The column where the error occured is 0.”.

                           

                                  HRESULT:        c0c0146a

                          Mi Schema:

                          Any idea?

                          • February 5, 2010 at 2:38 AM #24207
                            community-content

                              I solve the problem with a choice and sequence combination. I put the solution for other users with the same problem.

                               

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