|
Home > Archive > BizTalk Server General > August 2004 > problem to construct a flat file...
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
problem to construct a flat file...
|
|
| jerome 2004-08-11, 7:49 am |
| Hi,
just novice in BizTalk I want to construct a flat file from a xml message.
until here no problem...
.... but i don't know how to construct my flat file:
my xml structure:
<Root>
<Header>
<IdCommand>Header001</IdCommand>
</Header>
<Details>
<Detail1>Detail1</Detail1>
<Detail2>Detail2</Detail2>
<Details>
</Root>
And i would have in the flat file:
Header001;Detail1
Header001;Detail2
I don't know how to specify I want repeat the header information for each
détails line.
Thanks for your help.
Jerome
| |
| Alan Smith 2004-08-11, 7:49 am |
| Hi jerome,
There's quite a few stages to go through, here is a rough outline:
First thing to do is to create a flat file schema. To do this, create a new
schema, then add the "Flat FIle Schema Extensions" using the properties
window.
You can then define the structure, and add properties, use 0x0D 0x0A for a
line feed delimiter, and ; for the field delimiter.
Then, create a map to map the input to the output schema. (You can use the
"Test Map" option to check the flat file schema is conigured correctly.)
Finally create a flat file send pipeline, add a flat file assembler, and set
the document schema to your flat file schema.
Post again if you need more help...
/Alan
"jerome" wrote:
> Hi,
>
> just novice in BizTalk I want to construct a flat file from a xml message.
> until here no problem...
> ... but i don't know how to construct my flat file:
>
> my xml structure:
> <Root>
> <Header>
> <IdCommand>Header001</IdCommand>
> </Header>
> <Details>
> <Detail1>Detail1</Detail1>
> <Detail2>Detail2</Detail2>
> <Details>
> </Root>
>
> And i would have in the flat file:
>
> Header001;Detail1
> Header001;Detail2
>
> I don't know how to specify I want repeat the header information for each
> détails line.
> Thanks for your help.
> Jerome
| |
| j.costan@NOSPAMvistali.com 2004-08-16, 7:53 am |
| Hi Alan
It's a very good solution, thanks!
|
|
|
|
|