|
Home > Archive > BizTalk Server > September 2004 > Read & Write to 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 |
Read & Write to a flat file...
|
|
| Madhu Sudhanan Ramanujam 2004-09-22, 9:53 pm |
| 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
| |
| Tatyana Yakushev [MSFT] 2004-09-22, 9:53 pm |
| 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 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
>
>
>
--
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.
| |
| Madhu Sudhanan Ramanujam 2004-09-22, 9:53 pm |
| 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 message
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.
>
| |
| Ruslan Yakushev [MSFT] 2004-09-22, 9:53 pm |
| 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 message
>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.
| |
| Madhu Sudhanan Ramanujam 2004-09-23, 9:18 am |
| 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.
>
| |
| Tatyana Yakushev [MSFT] 2004-09-27, 5: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!TK2MSFTNGP11.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 message
>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 message are best directed to the newsgroup/thread from which they originated.
|
|
|
|
|