Read & Write to 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 > Read & Write to a flat file...




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

    Read & Write to a flat file...  
Madhu Sudhanan Ramanujam


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


 
09-23-04 02:53 AM

Hi,

Thanks for the information.

I have a scenario where I've to read a flat file and write the contents back
to a flat file again. The source file looks like this:

Madhu, Fusion Technologies, Senior Consultant
Dinesh, Fusion Technologies, Consultant

The destination flat file should look like this:

Senior Consultant, Fusion Technologies, Madhu
Consultant, Fusion Technologies, Dinesh

To achieve the above thing, I created two schemas one for the inbound and
another one for the outbound file. Next, I created a map to map both the
inbound & outbound schemas. Then I created a receive location & a send port
with the schemas and map that I've created. But still it doesn't work. I get
the following error. Can you help me please..

There was a failure executing the receive pipeline:
"FlatFileArranger.FFArrangerReceivePipeline" Source: "Flat file
disassembler" Receive Location: "C:\Program Files\Microsoft BizTalk Server
 2004\SDK\Samples\Pipelines\AssemblerDisa
ssembler\FlatFileReceive\FFOutput\*.
xml"
Reason: Unexpected data found while looking for:
$Delimited$
The current definition being parsed is ContactInfo. The stream offset where
the error occured is 0.

Madhu Sudhanan R







[ Post a follow-up to this message ]



    RE: Read & Write to a flat file...  
Tatyana Yakushev [MSFT]


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


 
09-23-04 02:53 AM

Did you created receive and send pipelines? (You need to create pipelines to
 receive or send flat-file documents).

Did you try to validate your message against the schema in Schema Editor? Do
 you see any errors?

Thanks,
Tatyana
--------------------
>From: "Madhu Sudhanan Ramanujam" <ramanum@fusiontech.com>
>Subject: Read & Write to a flat file...
>Date: Mon, 20 Sep 2004 14:38:23 +0530
>Lines: 33
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>X-RFC2646: Format=Flowed; Original
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>Message-ID: <uqwgKGvnEHA.2900@TK2MSFTNGP09.phx.gbl>
>Newsgroups: microsoft.public.biztalk.server
>NNTP-Posting-Host: 203.197.248.5
>Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
>Xref: cpmsftngxa06.phx.gbl microsoft.public.biztalk.server:10253
>X-Tomcat-NG: microsoft.public.biztalk.server
>
>Hi,
>
>Thanks for the information.
>
>I have a scenario where I've to read a flat file and write the contents bac
k
>to a flat file again. The source file looks like this:
>
>Madhu, Fusion Technologies, Senior Consultant
>Dinesh, Fusion Technologies, Consultant
>
>The destination flat file should look like this:
>
>Senior Consultant, Fusion Technologies, Madhu
>Consultant, Fusion Technologies, Dinesh
>
>To achieve the above thing, I created two schemas one for the inbound and
>another one for the outbound file. Next, I created a map to map both the
>inbound & outbound schemas. Then I created a receive location & a send port
>with the schemas and map that I've created. But still it doesn't work. I ge
t
>the following error. Can you help me please..
>
>There was a failure executing the receive pipeline:
>"FlatFileArranger.FFArrangerReceivePipeline" Source: "Flat file
>disassembler" Receive Location: "C:\Program Files\Microsoft BizTalk Server
> 2004\SDK\Samples\Pipelines\AssemblerDisa
ssembler\FlatFileReceive\FFOutput\*
.xml"
>Reason: Unexpected data found while looking for:
>$Delimited$
>The current definition being parsed is ContactInfo. The stream offset where
>the error occured is 0.
>
>Madhu Sudhanan R
>
>
>


--

This posting is provided "AS IS" with no warranties, and confers no rights. 
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Note:  For the benefit of the community-at-large, all responses to this mess
age are best directed to the newsgroup/thread from which they originated.






[ Post a follow-up to this message ]



    Re: Read & Write to a flat file...  
Madhu Sudhanan Ramanujam


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


 
09-23-04 02:53 AM

I've validated the schemas & the maps aswell. They are behaving fine. But
still nothing seems to work.

Madhu Sudhanan
"Tatyana Yakushev [MSFT]" <tatyanam@online.microsoft.com> wrote in messa
ge
news:iBC2ChznEHA.3356@cpmsftngxa06.phx.gbl...
> Did you created receive and send pipelines? (You need to create pipelines
> to receive or send flat-file documents).
>
> Did you try to validate your message against the schema in Schema Editor?
> Do you see any errors?
>
> Thanks,
> Tatyana
> -------------------- 
>
>
> --
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights. Use of included script samples are subject to the terms specified
> at
> http://www.microsoft.com/info/cpyright.htm
>
> Note:  For the benefit of the community-at-large, all responses to this
> message are best directed to the newsgroup/thread from which they
> originated.
>







[ Post a follow-up to this message ]



    Re: Read & Write to a flat file...  
Ruslan Yakushev [MSFT]


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


 
09-23-04 02:53 AM

One thing to try is:

Check the "Child order" property for the ContactInfo record and make sure
that the delimiters in your instance are located correctly.

Example: if your delimiter is <CR><LF> (0x0D 0x0A) and the child order is
postfix then the delimiters should be located as follows:

Madhu, Fusion Technologies, Senior Consultant<CR><LF>
Dinesh, Fusion Technologies, Consultant<CR><LF>

If child odrer is prefix then:

<CR><LF>
Madhu, Fusion Technologies, Senior Consultant<CR><LF>
Dinesh, Fusion Technologies, Consultant

If child order is infix then

Madhu, Fusion Technologies, Senior Consultant<CR><LF>
Dinesh, Fusion Technologies, Consultant

If this does not help please post your schema.

--------------------
>From: "Madhu Sudhanan Ramanujam" <ramanum@fusiontech.com>
>References: <uqwgKGvnEHA.2900@TK2MSFTNGP09.phx.gbl>
<iBC2ChznEHA.3356@cpmsftngxa06.phx.gbl>
>Subject: Re: Read & Write to a flat file...
>Date: Tue, 21 Sep 2004 11:02:24 +0530
>Lines: 84
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>X-RFC2646: Format=Flowed; Original
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>Message-ID: <uLV9Jy5nEHA.3324@TK2MSFTNGP15.phx.gbl>
>Newsgroups: microsoft.public.biztalk.server
>NNTP-Posting-Host: 203.197.248.5
>Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15.phx.gbl
>Xref: cpmsftngxa06.phx.gbl microsoft.public.biztalk.server:10261
>X-Tomcat-NG: microsoft.public.biztalk.server
>
>I've validated the schemas & the maps aswell. They are behaving fine. But
>still nothing seems to work.
>
>Madhu Sudhanan
>"Tatyana Yakushev [MSFT]" <tatyanam@online.microsoft.com> wrote in mess
age
>news:iBC2ChznEHA.3356@cpmsftngxa06.phx.gbl... 
pipelines[vbcol=seagreen] 
Editor?[vbcol=seagreen] 
Server[vbcol=seagreen] 
\*.xml"[vbcol=seagreen] 
specified[vbcol=seagreen] 
>
>
>

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Note:  For the benefit of the community-at-large, all responses to this
message are best directed to the newsgroup/thread from which they
originated.






[ Post a follow-up to this message ]



    Re: Read & Write to a flat file...  
Madhu Sudhanan Ramanujam


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


 
09-23-04 02:18 PM

I'm done with the job. Thank you for your help. Now I have a different
scenario. I have to read data from two flat files and merge them into one
flat file. Any help on this would be better.
Thank you,

Madhu Sudhanan

"Ruslan Yakushev [MSFT]" <RuslanY@online.microsoft.com> wrote in message
news:EnehlNOoEHA.3468@cpmsftngxa06.phx.gbl...
> One thing to try is:
>
> Check the "Child order" property for the ContactInfo record and make sure
> that the delimiters in your instance are located correctly.
>
> Example: if your delimiter is <CR><LF> (0x0D 0x0A) and the child order is
> postfix then the delimiters should be located as follows:
>
> Madhu, Fusion Technologies, Senior Consultant<CR><LF>
> Dinesh, Fusion Technologies, Consultant<CR><LF>
>
> If child odrer is prefix then:
>
> <CR><LF>
> Madhu, Fusion Technologies, Senior Consultant<CR><LF>
> Dinesh, Fusion Technologies, Consultant
>
> If child order is infix then
>
> Madhu, Fusion Technologies, Senior Consultant<CR><LF>
> Dinesh, Fusion Technologies, Consultant
>
> If this does not help please post your schema.
>
> -------------------- 
> <iBC2ChznEHA.3356@cpmsftngxa06.phx.gbl> 
> pipelines 
> Editor? 
> Server 
> \*.xml" 
> specified 
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
>
> Note:  For the benefit of the community-at-large, all responses to this
> message are best directed to the newsgroup/thread from which they
> originated.
>







[ Post a follow-up to this message ]



    Re: Read & Write to a flat file...  
Tatyana Yakushev [MSFT]


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


 
09-27-04 10:51 PM

You need to use orchestration to combine 2 messages into one.
From the orchestration you can create a map that takes 2 input messages and 
produces 1 output message (This can be done only from orchestraion).

Regards,
Tatyana

--------------------
>From: "Madhu Sudhanan Ramanujam" <ramanum@fusiontech.com>
>References: <uqwgKGvnEHA.2900@TK2MSFTNGP09.phx.gbl> <iBC2ChznEHA.3356@cpmsftngxa06.
phx.gbl> <uLV9Jy5nEHA.3324@TK2MSFTNGP15.phx.gbl>
<EnehlNOoEHA.3468@cpmsftngxa06.phx.gbl>
>Subject: Re: Read & Write to a flat file...
>Date: Thu, 23 Sep 2004 11:56:34 +0530
>Lines: 155
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>X-RFC2646: Format=Flowed; Original
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>Message-ID: <eAyi0ZToEHA.592@TK2MSFTNGP11.phx.gbl>
>Newsgroups: microsoft.public.biztalk.server
>NNTP-Posting-Host: 203.197.248.5
>Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MS
FTNGP11.phx.gbl
>Xref: cpmsftngxa06.phx.gbl microsoft.public.biztalk.server:10282
>X-Tomcat-NG: microsoft.public.biztalk.server
>
>I'm done with the job. Thank you for your help. Now I have a different
>scenario. I have to read data from two flat files and merge them into one
>flat file. Any help on this would be better.
>Thank you,
>
>Madhu Sudhanan
>
>"Ruslan Yakushev [MSFT]" <RuslanY@online.microsoft.com> wrote in messag
e
>news:EnehlNOoEHA.3468@cpmsftngxa06.phx.gbl... 
>
>
>


--

This posting is provided "AS IS" with no warranties, and confers no rights. 
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Note:  For the benefit of the community-at-large, all responses to this mess
age are best directed to the newsgroup/thread from which they originated.






[ Post a follow-up to this message ]



    Sponsored Links  




 





   All times are GMT. The time now is 11:46 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