Home Page › Forums › BizTalk 2004 – BizTalk 2010 › CSV flat file in and a xml file out with a different schema must use mapping
- This topic has 2 replies, 1 voice, and was last updated 9 years, 2 months ago by
community-content.
-
AuthorPosts
-
-
May 21, 2009 at 8:04 AM #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, 1In 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 outputMost of the differences between the flat file schema and the output schema is different element names.
//Tony
-
May 21, 2009 at 12:34 PM #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 portAn orchestration is probably not suitable for your messaging only solution.
You can use the Biztalk Admin Console to specify a map on the ReceivePort-
May 21, 2009 at 1:17 PM #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
-
-
-
AuthorPosts
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.