|
Home > Archive > BizTalk Server General > December 2004 > Create one File Output for every input record ???
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 |
Create one File Output for every input record ???
|
|
| stiffler 2004-11-30, 5:49 pm |
| Hi all
I use BizTalk 2002 !
I have a stockItem Business Document with S Item Records in it.
For the target system i need to create for every <item> a file.
So i will have S output files with only one <item> tag.
Where can i acheive this ? Via Editor or via Mapper ?
Thanks a lot for helping me !
greets stiffler
| |
| David Downing [MSFT] 2004-12-01, 5:51 pm |
| This will depend alot on the structure of your data. If the data is flat
file, your schema can be set such that only a single record can exist. If
the data is XML and has some kind of envelope structure, then you can break
up the documents using the envelope.
If this did not answer you question, please provide more information on the
structure of your data... if possible cut/paste it into another post.
Dave
--------------------[vbcol=seagreen]
cpmsftngxa10.phx.gbl!TK2MSFTNGXS01.phx.gbl!cpmsftngxa06.phx.gbl!TK2MSFTNGP08
.phx.gbl!TK2MSFTNGXA03.phx.gbl[vbcol=seagreen]
This posting is provided "AS IS" with no warranties, and confers no rights.
EBusiness Server Team
| |
| stiffler 2004-12-02, 2:48 am |
| Hi David
My Input Data is Flatfile and looks very simple like this:
-----------------
abc 123 xxx
dfg 456 yyy
hij 789 zzz
-----------------
The Records are delimited by a CR LF.
So for each Record i have to create 1 file with only 1 record in it,
therefore the Ouput schould look like this:
File 1 File 2 File 3
---------------- ---------------- -----------------
abc 123 xxx dfg 456 yyy hij 789
zzz
---------------- ---------------- -----------------
What i read in a BizTalk Book ist that Mapping ist always tought to be
between 1 Input and only 1 Output ! Is that true.
I tried to map the input to the same output structure, but changed the max
record accurences to min=0, max=1, but in the output nothing changed then,
all records appeared in the output.
You told me about another solution with envelopes. I could do it also with
this, because i first map flat to flat and then in another channel flat to
xml.
Whats simpler? Do you have a sample how to split uf an xml message into many
whit envelopes.
I can not belife that there are not more people whitch have to split uf
Messages in many Msg's.
Thank you a lot for your help...
greets stiffler
""David Downing [MSFT]"" wrote:
> This will depend alot on the structure of your data. If the data is flat
> file, your schema can be set such that only a single record can exist. If
> the data is XML and has some kind of envelope structure, then you can break
> up the documents using the envelope.
>
> If this did not answer you question, please provide more information on the
> structure of your data... if possible cut/paste it into another post.
>
> Dave
>
> --------------------
> cpmsftngxa10.phx.gbl!TK2MSFTNGXS01.phx.gbl!cpmsftngxa06.phx.gbl!TK2MSFTNGP08
> .phx.gbl!TK2MSFTNGXA03.phx.gbl
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> EBusiness Server Team
>
>
| |
| Stiffler 2004-12-02, 2:48 am |
| Hi David
My Input Data is Flatfile and looks very simple like this:
-----------------
abc 123 xxx
dfg 456 yyy
hij 789 zzz
-----------------
The Records are delimited by a CR LF.
So for each Record i have to create 1 file with only 1 record in it,
therefore the Ouput schould look like this:
File 1 File 2 File 3
---------------- ---------------- -----------------
abc 123 xxx dfg 456 yyy hij 789
zzz
---------------- ---------------- -----------------
What i read in a BizTalk Book ist that Mapping ist always tought to be
between 1 Input and only 1 Output ! Is that true.
I tried to map the input to the same output structure, but changed the max
record accurences to min=0, max=1, but in the output nothing changed then,
all records appeared in the output.
You told me about another solution with envelopes. I could do it also with
this, because i first map flat to flat and then in another channel flat to
xml.
Whats simpler? Do you have a sample how to split uf an xml message into many
whit envelopes.
I can not belife that there are not more people whitch have to split uf
Messages in many Msg's.
Thank you a lot for your help...
greets stiffler
""David Downing [MSFT]"" <ddowning@online.microsoft.com> wrote in message
news:KtvsPz#1EHA.3152@cpmsftngxa10.phx.gbl...
> This will depend alot on the structure of your data. If the data is flat
> file, your schema can be set such that only a single record can exist. If
> the data is XML and has some kind of envelope structure, then you can
break
> up the documents using the envelope.
>
> If this did not answer you question, please provide more information on
the
> structure of your data... if possible cut/paste it into another post.
>
> Dave
>
> --------------------
>
cpmsftngxa10.phx.gbl!TK2MSFTNGXS01.phx.gbl!cpmsftngxa06.phx.gbl!TK2MSFTNGP08
> phx.gbl!TK2MSFTNGXA03.phx.gbl
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> EBusiness Server Team
>
| |
|
|
Hi,
In BizTalk 2004, I am having a flat file with multiple records. I am
converting into xml file in pipleline using xml disassembler and the in the
port i am mapping to another xml file. This xml data goes into orchestration
for further processing.
In this case, i want to send the records one by one to orchestration. ie i
want to split multiple records in to single records. Where i have to do it
(in mapping?) and how to do that.
I heard that if it is an xml file, the we can do it using envelope. in this
case, it is flat file and multiple records.
Thanks
Senthil
| |
| David Downing [MSFT] 2004-12-02, 5:48 pm |
| You should be able to accomplish this as follows:
1. Create a schema that has the flat file extension enabled. The schema
should look something like the following:
<Root> delimited child_delimiter_type="hex" child_delimiter="0x0D 0x0A"
child_order="postfix"
<Record> positional
<Field1> positional_length="7"
<Field2> positional_length="7"
<Field3> positional_length="3"
2. Create a receive pipeline with the flat file disassembler in the
dissassemble stage and the document schema set to above schema.
3. Create a send pipeline with the flat file assembler in the assemble
stage and the document schema set to above schema.
4. Build and Deploy this project.
5. Create a receive port using the receive pipeline above.
6. Create a send port using the send pipeline above.
7. Bind the send port to the receive port.
8. Start the send port.
9. Enable the receive port.
If you drop your example file into your receive location, you should get 3
files in your send location.
--
Dave
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------[vbcol=seagreen]
<KtvsPz#1EHA.3152@cpmsftngxa10.phx.gbl>[vbcol=seagreen]
many[vbcol=seagreen]
flat[vbcol=seagreen]
If[vbcol=seagreen]
break[vbcol=seagreen]
the[vbcol=seagreen]
cpmsftngxa10.phx.gbl!TK2MSFTNGXS01.phx.gbl!cpmsftngxa06.phx.gbl!TK2MSFTNGP08[vbcol=seagreen]
rights.[vbcol=seagreen]
| |
| David Downing [MSFT] 2004-12-02, 5:48 pm |
| One thing I forgot to mention: I'm assuming your referring to BizTalk 2004.
--
Dave
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------[vbcol=seagreen]
3[vbcol=seagreen]
rights.[vbcol=seagreen]
File 3[vbcol=seagreen]
-----------------[vbcol=seagreen]
-----------------[vbcol=seagreen]
max[vbcol=seagreen]
then,[vbcol=seagreen]
with[vbcol=seagreen]
to[vbcol=seagreen]
exist.[vbcol=seagreen]
on[vbcol=seagreen]
<stiffler@discussions.microsoft.com>[vbcol=seagreen]
08[vbcol=seagreen]
|
|
|
|
|