CSV flat file in and a xml file out with a different schema must use mapping

Home Page Forums BizTalk 2004 – BizTalk 2010 CSV flat file in and a xml file out with a different schema must use mapping

Viewing 1 reply thread
  • Author
    Posts
    • #22444

      Hello!

      I’m new to BizTalk. I have read a book called Foundations of BizTalk Server
      2006 up to chapter 10 Orchestration. So I have only basic knowledge about BizTalk.
      I have done some simple exercices but now I want to to something that I
      don’t know how to do. First some description.

      Below I have a CSV flat text file. I call it MyTest.csv. It’s text from the
      book I’m reading.
      I have set up BizTalk(File adapter) in such a way that I can move this
      MyTest.csv from one folder to another. The output is an xml
      file containing all the detail records from the CSV flat file because I use a Flat file disassembler
      in the receive pipeline.  I use the %MessageID%.xml so I get unique xml files every time which is what I want. All this works perfectly.

      10001, Acme warp drive component, 123.56, 2
      10013, Acme cloaking device, 234.99, 1
      10021, Acme Time Travel Device, 855.99, 9
      10045, Acme Personal Clone, 900.99, 1

      In the above exercise when I moved a file from one folder to another I had
      one folder called In and one folder called Out.

      I have now run into a problem that I don’t know how to solve.
      Here is what I want:
      I want to do almost the same thing as I did above when a moved a csv file from In folder
      and stored in in the Out folder as a XML file with all the records from the CSV file within.

      The difference is that the output XML file should be according to an example XML file that I have received.
      Based on this example XML file I have generate an XML schema.
      I have also created a map between the flat file schema and the schema for the output file.

      So my question is that I must in some way use the map file that I have created in my BizTalk application so
      I get the right xml output

      Most of the differences between the flat file schema and the output schema is different element names.

      //Tony

    • #22446

      There are three standard ways you can use a map in Biztalk.

      1. Use a transform shape in an orchestration.
      2. Add the map to the Receive Port
      3. Add the map to the Send port

      An orchestration is probably not suitable for your messaging only solution.
      You can use the Biztalk Admin Console to specify a map on the ReceivePort

      • #22447

        Hello!

        So if I just want to have a map to the output xml file I assume that I can chose  
        the receive port or the send port. It seems to me that it doesn’t matter.

         

        //Tony

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