|
Home > Archive > BizTalk Server Orchestration > April 2004 > orchestration processing bulk / row by row ???
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 |
orchestration processing bulk / row by row ???
|
|
|
| hi all,
i have two steps in orchestration:
step1 has Xml document. the schema for step1 is very loose. all nodes
are generally declaired strings even if they hold integer values.
step2 is again Xml document but it has a very strict schema.
lets say there are 5 records in the Xml documents in step1.
when biztalk orchestration procedes to the second step it'll try to
move those 5 records into the second step but for this to be
successful all these 5 records should confer to the strict schema
defined in step2.
lets say one of these records does not confer to the schema in step2.
Would biztalk orchestration move rest of the 4 records to step2 ??
or would it just error and not move even a single record to the step2
??
basically i'm trying to find out if i can do row by row processing in
biztalk orchestration ?
i have to move correct records to the next step and erronious records
to a different documnet from a single source document ?
-
thanks
siddharth
| |
| larry franks 2004-04-14, 5:44 pm |
| Hi Siddharth, how exactly are you using orchestration to transform from the
inbound loose schema to the outbound restrictive schema? The reason I ask
is that you can't do a straight assignment of Message_2=Message_1 since
they are using different schemas. You can use a map, but at that point
it's your map logic that determines what records map across. Can you
clarify your question a bit further with the process you'd be using to
transform the data from the inbound schema to the outbound?
Larry Franks
This posting is provided "AS IS" with no warranties,and confers no rights.
Subscribe at
http://support.microsoft.com/defaul...msdn/nospam.asp
&SD=msdn
--------------------
| From: siddharthkhare@hotmail.com (sidd)
| Newsgroups:
microsoft.public.biztalk.orchestration,microsoft.public.biztalk.general
| Subject: orchestration processing bulk / row by row ???
| Date: 14 Apr 2004 00:00:02 -0700
| Organization: http://groups.google.com
| Lines: 26
| Message-ID: <af96a2d7.0404132300.4e12644e@posting.google.com>
| NNTP-Posting-Host: 172.198.175.118
| Content-Type: text/plain; charset=ISO-8859-1
| Content-Transfer-Encoding: 8bit
| X-Trace: posting.google.com 1081926003 29003 127.0.0.1 (14 Apr 2004
07:00:03 GMT)
| X-Complaints-To: groups-abuse@google.com
| NNTP-Posting-Date: Wed, 14 Apr 2004 07:00:03 +0000 (UTC)
| Path:
cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-onlin
e.de!border2.nntp.ash.giganews.com!border1.nntp.ash.giganews.com!nntp.gigane
ws.com!news.glorb.com!postnews1.google.com!not-for-mail
| Xref: cpmsftngxa06.phx.gbl microsoft.public.biztalk.general:13999
microsoft.public.biztalk.orchestration:5499
| X-Tomcat-NG: microsoft.public.biztalk.orchestration
|
| hi all,
| i have two steps in orchestration:
|
| step1 has Xml document. the schema for step1 is very loose. all nodes
| are generally declaired strings even if they hold integer values.
|
| step2 is again Xml document but it has a very strict schema.
|
| lets say there are 5 records in the Xml documents in step1.
| when biztalk orchestration procedes to the second step it'll try to
| move those 5 records into the second step but for this to be
| successful all these 5 records should confer to the strict schema
| defined in step2.
|
| lets say one of these records does not confer to the schema in step2.
| Would biztalk orchestration move rest of the 4 records to step2 ??
| or would it just error and not move even a single record to the step2
| ??
|
| basically i'm trying to find out if i can do row by row processing in
| biztalk orchestration ?
| i have to move correct records to the next step and erronious records
| to a different documnet from a single source document ?
| -
| thanks
| siddharth
|
| |
|
| Hi Larry,
i have a xml document like..
<Records>
<Record ID=1 Success = true>
<Record ID=2 Success = false>
</Records>
i want to write a orchestartion where i can load this document.
and then depending on the value of the 'Success ' attribute
create two separate documents
first one is "Sucess.XML"
it would look like...
<Records>
<Record ID=1 Success = true>
</Records>
second one is "Fail.XML"
it would look like...
<Records>
<Record ID=1 Success = false>
</Records>
basically i am trying to undestand if it is possible to break records
from a single document(Message) to go to two different routs in a
orcehstartion(Without using envelope)?
i am asking this because i thought whole message is one entity..you
can not make part of the message(records) to go to different route.
thanks
siddharth
| |
| Matt Milner 2004-04-26, 11:35 pm |
| You should be able to do conditional mapping of one message to two output
messages. Use conditional logic and looping functoid to copy your success
items to one destination and failure items to the other destination.
matt
"sidd" <siddharthkhare@hotmail.com> wrote in message
news:af96a2d7.0404261450.5e8c1dd9@posting.google.com...
> Hi Larry,
> i have a xml document like..
> <Records>
> <Record ID=1 Success = true>
> <Record ID=2 Success = false>
> </Records>
> i want to write a orchestartion where i can load this document.
> and then depending on the value of the 'Success ' attribute
> create two separate documents
>
> first one is "Sucess.XML"
> it would look like...
> <Records>
> <Record ID=1 Success = true>
> </Records>
>
>
> second one is "Fail.XML"
> it would look like...
> <Records>
> <Record ID=1 Success = false>
> </Records>
>
>
> basically i am trying to undestand if it is possible to break records
> from a single document(Message) to go to two different routs in a
> orcehstartion(Without using envelope)?
> i am asking this because i thought whole message is one entity..you
> can not make part of the message(records) to go to different route.
> thanks
> siddharth
| |
| larry franks 2004-04-27, 2:36 pm |
| You could do this, as Matt suggested in another post you could do
conditional mapping but that might get ugly if more than one record was
equal to true or false.
Another option would be to do code to evaluate and create new XML messages
by selecting individual nodes and sticking them into new documents.
There's nothing built into orchestration that will split the message
automatically for you. Also this process is going to involve more overhead
than using an envelope on the inbound port. So while it's possible, I
don't have any sample code for this and it would be fairly complex.
Larry Franks
This posting is provided "AS IS" with no warranties,and confers no rights.
Subscribe at
http://support.microsoft.com/defaul...msdn/nospam.asp
&SD=msdn
--------------------
| From: siddharthkhare@hotmail.com (sidd)
| Newsgroups: microsoft.public.biztalk.orchestration
| Subject: Re: orchestration processing bulk / row by row ???
| Date: 26 Apr 2004 15:50:18 -0700
| Organization: http://groups.google.com
| Lines: 31
| Message-ID: <af96a2d7.0404261450.5e8c1dd9@posting.google.com>
| References: <af96a2d7.0404132300.4e12644e@posting.google.com>
<6Y12PSmIEHA.2368@cpmsftngxa06.phx.gbl>
| NNTP-Posting-Host: 63.166.226.88
| Content-Type: text/plain; charset=ISO-8859-1
| Content-Transfer-Encoding: 8bit
| X-Trace: posting.google.com 1083019819 26503 127.0.0.1 (26 Apr 2004
22:50:19 GMT)
| X-Complaints-To: groups-abuse@google.com
| NNTP-Posting-Date: Mon, 26 Apr 2004 22:50:19 +0000 (UTC)
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA05.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.s
ul.t-online.de!t-online.de!news.glorb.com!postnews1.google.com!not-for-mail
| Xref: cpmsftngxa10.phx.gbl microsoft.public.biztalk.orchestration:5716
| X-Tomcat-NG: microsoft.public.biztalk.orchestration
|
| Hi Larry,
| i have a xml document like..
| <Records>
| <Record ID=1 Success = true>
| <Record ID=2 Success = false>
| </Records>
| i want to write a orchestartion where i can load this document.
| and then depending on the value of the 'Success ' attribute
| create two separate documents
|
| first one is "Sucess.XML"
| it would look like...
| <Records>
| <Record ID=1 Success = true>
| </Records>
|
|
| second one is "Fail.XML"
| it would look like...
| <Records>
| <Record ID=1 Success = false>
| </Records>
|
|
| basically i am trying to undestand if it is possible to break records
| from a single document(Message) to go to two different routs in a
| orcehstartion(Without using envelope)?
| i am asking this because i thought whole message is one entity..you
| can not make part of the message(records) to go to different route.
| thanks
| siddharth
|
|
|
|
|
|