problem to construct a flat file...
Web Server forum
Back To The Forum Home!Search!Private Messaging System

Web Server Talk Web Server Talk > Web Servers reviews > BizTalk Server > BizTalk Server General > problem to construct a flat file...




  Last Thread   Next Thread Next
  Show Printable Version Email this Page Subscribe to this Thread      Post New Thread    Post A Reply      

    problem to construct a flat file...  
jerome


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
08-11-04 12:49 PM

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





[ Post a follow-up to this message ]



    RE: problem to construct a flat file...  
Alan Smith


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
08-11-04 12:49 PM

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





[ Post a follow-up to this message ]



    RE: problem to construct a flat file...  
j.costan@NOSPAMvistali.com


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
08-16-04 12:53 PM

Hi Alan

It's a very good solution, thanks!






[ Post a follow-up to this message ]



    Sponsored Links  




 





   All times are GMT. The time now is 10:20 AM.      Post New Thread    Post A Reply      
  Last Thread   Next Thread Next


Most Popular forums 

Forum Jump:
Rate This Thread:

Forum Rules:
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is OFF
vB code is ON
Smilies are ON
[IMG] code is OFF
 
Medical and Health forum | Computer Games Reviews | Graphics design forum

Back To The Top
Home | Usercp | Faq | Register