XML to Flat File (Output)

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › XML to Flat File (Output)

Viewing 1 reply thread
  • Author
    Posts
    • July 19, 2006 at 7:44 PM #15079
      community-content

        Hello and thanks for your assistance.

        I need to map a xsd file to a flatfile, and i’m kinda confused.

        The output that I need is just a simple pipe \”|\” delimited file, similar to this scaled down sample:

        Id|FirstName|LastName|Line1|Line2|RegionCode|CountryCode
        Id|FirstName|LastName|Line1|Line2|RegionCode|CountryCode

        I have attempted to create a schema using the ‘Flat File Schema Wizard’, but my output is still in XML!

        Is thier some setting that i am missing?
        Does anyone know of any links, documentation or sample that can possibly help me out?

        Thanks Kindly;
        –Steven

      • July 20, 2006 at 2:08 PM #15080
        community-content

          Hi all,

          I’m new in BizTalk 2006. I have the same problem. I need to convert simple XML file to delimeted Flat File. I will be very gratefull for any example or explanation how to do that.

          Best regards,
          Georg

          • July 19, 2006 at 9:38 PM #15081
            community-content

              You’ll want to make sure you use a \”Flat File Assembler\” component in an send pipeline so that your XML content can be converted into a flat file.

              • July 20, 2006 at 4:17 PM #15082
                community-content

                  Hey Man,

                  It was much easier then i expected.

                  Inside vs.net, created a biztalk project, added new item, under the window that comes up, select – Pipeline Files, and then Send Pipeline

                  This will add a new file of type .btp to your project,
                  inside this file under the ‘Assemble’ Stage, I added a ‘Flat file assembler’ from the toolbox.

                  ** Added a reference to my schema file.

                  In the Properites of the added ‘Flat file assembler’ – under Document schema, i selected the appropriate schema.

                  Changed the Target charset to be ASCII (20127),

                  built and deployed the application to my Biztalk application.
                  Inside BizTalk Application Console, under my Biztalk Application -> Send Port -> Send Pipelines -> I selected my newly created Pipeline.

                  Everything works and my outfile is now delimied as expected.

                  Thanks,
                  –Steven

                  • December 6, 2007 at 8:21 AM #18574
                    community-content

                       I have done what you wrote….but my output is not separated in e.g. with “,”  I have only all data in one string!

                      What do i wrong?

                       

                      Thank you 

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