1 flat file to many XML

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › 1 flat file to many XML

Viewing 1 reply thread
  • Author
    Posts
    • April 28, 2006 at 1:14 PM #13456
      community-content

        hai friends,
        I have a flat file and i want to split into different XML documents.

        My flat file looks like this :
        @
        kavitha
        27
        @
        arava
        35
        @

        I want to split each record into separate XML document as Output.
        My output should look like

        <name>kavitha</name>
        <age>27</age>

        I tried many times but i did not get the results.Can anybody give me a clue to do this.

        Thanks in advance

        kavitha

        • April 28, 2006 at 3:38 PM #13457
          community-content

            Biztalk maps (and XSLT 1.0) can only output one XML file.
            Sounds like this is a case for a custom disassembler in a Receive Pipeline
            or use some type of C# preprocessor to split the file first.

            On this website (BiztalkGurus.com) Stephen Thomas has several examples of debatching, but I’m not sure that applies in your case, but you might get some ideas. Debatching is taking one big message, and breaking it into several smaller ones.

            Neal Walters
            http://Biztalk-Training.com

            • April 28, 2006 at 4:16 PM #13458
              community-content

                Use XPATH in The Orch…

                Root
                subroot
                <name>YYY</name>
                <age>11</age>

                xpath(msg, \”count(//subroot)\”)

                when ever you send input file, it will split on every subroot record.

                you always get out like Name and age in single file…

                try this hope this Helps

                Reddy-

          • April 29, 2006 at 3:43 AM #13455
            community-content

              This can be done by the Flat File disassembler.
              Although you need to know the exact character layout of the file.

              If you can email me an example of you input file I can show you how to create the schemas required.

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