BizTalk Server Tools - functoid mapping question

This is Interesting: Free IT Magazines  
Home > Archive > BizTalk Server Tools > March 2005 > functoid mapping question





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 functoid mapping question
H

2005-03-07, 5:49 pm

I have couple sample schemas listed below, and I'd like to map from source
schema, to dest. schema.

Can this be done by using functoid mapping? ( I know the mapping can be done
via xslt)
-------------------------------------
Source schema:
-------------------------------------
<SalesOrder>
<Header>
<Company>ABC</Company>
<OrderNumber>12345</OrderNumber>
</Header>
<OrderLineItems>
<OrderLineItem>
<LineNum>1</LineNum>
<qty>15</qty>
<UnitPrice>10.5</UnitPrice>
</OrderLineItem>
<OrderLineItem>
<LineNum>2</LineNum>
<qty>12</qty>
<UnitPrice>9.99</UnitPrice>
</OrderLineItem>
<OrderLineItem>
<LineNum>3</LineNum>
<qty>8</qty>
<UnitPrice>29.95</UnitPrice>
</OrderLineItem>
</OrderLineItems>
</SalesOrder>

-------------------------------------
Dest schema:
-------------------------------------
<ProcessOrder>
<Process type="callmethod" user="userabc" pwd="password">
<callmethod name="insertOrder">
<params>
<param name="Company">ABC</param>
<param name="OrderNumber">12345</param>
<param name="LineNum">1</param>
<param name="qty">15</param>
<param name="UnitPrice">10.5</param>
</params>
</callmethod>
<callmethod name="insertOrder">
<params>
<param name="Company">ABC</param>
<param name="OrderNumber">12345</param>
<param name="LineNum">2</param>
<param name="qty">12</param>
<param name="UnitPrice">9.99</param>
</params>
</callmethod>
<callmethod name="insertOrder">
<params>
<param name="Company">ABC</param>
<param name="OrderNumber">12345</param>
<param name="LineNum">3</param>
<param name="qty">8</param>
<param name="UnitPrice">29.95</param>
</params>
</callmethod>
</ProcessOrder>

-H
Tan Nguyen

2005-03-08, 5:49 pm

Use the Table Looping functoid. Refer to the BizTalk Server documentation
for more info on the Table Looping functoid.

Regards,
Tan Nguyen
Microsoft BizTalk Server

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
| Thread-Topic: functoid mapping question
| thread-index: AcUja8Yz4xaVLLCOTyONqaZpc90npg==
| X-WBNR-Posting-Host: 205.142.247.254
| From: "=?Utf-8?B?SA==?=" <H@discussions.microsoft.com>
| Subject: functoid mapping question
| Date: Mon, 7 Mar 2005 15:17:04 -0800
| Lines: 67
| Message-ID: <30543B67-1990-44CC-8C98-340482B71AA7@microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.biztalk.tools
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.biztalk.tools:4252
| X-Tomcat-NG: microsoft.public.biztalk.tools
|
| I have couple sample schemas listed below, and I'd like to map from
source
| schema, to dest. schema.
|
| Can this be done by using functoid mapping? ( I know the mapping can be
done
| via xslt)
| -------------------------------------
| Source schema:
| -------------------------------------
| <SalesOrder>
| <Header>
| <Company>ABC</Company>
| <OrderNumber>12345</OrderNumber>
| </Header>
| <OrderLineItems>
| <OrderLineItem>
| <LineNum>1</LineNum>
| <qty>15</qty>
| <UnitPrice>10.5</UnitPrice>
| </OrderLineItem>
| <OrderLineItem>
| <LineNum>2</LineNum>
| <qty>12</qty>
| <UnitPrice>9.99</UnitPrice>
| </OrderLineItem>
| <OrderLineItem>
| <LineNum>3</LineNum>
| <qty>8</qty>
| <UnitPrice>29.95</UnitPrice>
| </OrderLineItem>
| </OrderLineItems>
| </SalesOrder>
|
| -------------------------------------
| Dest schema:
| -------------------------------------
| <ProcessOrder>
| <Process type="callmethod" user="userabc" pwd="password">
| <callmethod name="insertOrder">
| <params>
| <param name="Company">ABC</param>
| <param name="OrderNumber">12345</param>
| <param name="LineNum">1</param>
| <param name="qty">15</param>
| <param name="UnitPrice">10.5</param>
| </params>
| </callmethod>
| <callmethod name="insertOrder">
| <params>
| <param name="Company">ABC</param>
| <param name="OrderNumber">12345</param>
| <param name="LineNum">2</param>
| <param name="qty">12</param>
| <param name="UnitPrice">9.99</param>
| </params>
| </callmethod>
| <callmethod name="insertOrder">
| <params>
| <param name="Company">ABC</param>
| <param name="OrderNumber">12345</param>
| <param name="LineNum">3</param>
| <param name="qty">8</param>
| <param name="UnitPrice">29.95</param>
| </params>
| </callmethod>
| </ProcessOrder>
|
| -H
|

H

2005-03-11, 8:50 pm

thanks, I got it work by using the looping functoid on this one... do you
know if functoid provide the nest looping logic functoid(s)

"Tan Nguyen" wrote:

> Use the Table Looping functoid. Refer to the BizTalk Server documentation
> for more info on the Table Looping functoid.
>
> Regards,
> Tan Nguyen
> Microsoft BizTalk Server
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> --------------------
> | Thread-Topic: functoid mapping question
> | thread-index: AcUja8Yz4xaVLLCOTyONqaZpc90npg==
> | X-WBNR-Posting-Host: 205.142.247.254
> | From: "=?Utf-8?B?SA==?=" <H@discussions.microsoft.com>
> | Subject: functoid mapping question
> | Date: Mon, 7 Mar 2005 15:17:04 -0800
> | Lines: 67
> | Message-ID: <30543B67-1990-44CC-8C98-340482B71AA7@microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.biztalk.tools
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
> | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.biztalk.tools:4252
> | X-Tomcat-NG: microsoft.public.biztalk.tools
> |
> | I have couple sample schemas listed below, and I'd like to map from
> source
> | schema, to dest. schema.
> |
> | Can this be done by using functoid mapping? ( I know the mapping can be
> done
> | via xslt)
> | -------------------------------------
> | Source schema:
> | -------------------------------------
> | <SalesOrder>
> | <Header>
> | <Company>ABC</Company>
> | <OrderNumber>12345</OrderNumber>
> | </Header>
> | <OrderLineItems>
> | <OrderLineItem>
> | <LineNum>1</LineNum>
> | <qty>15</qty>
> | <UnitPrice>10.5</UnitPrice>
> | </OrderLineItem>
> | <OrderLineItem>
> | <LineNum>2</LineNum>
> | <qty>12</qty>
> | <UnitPrice>9.99</UnitPrice>
> | </OrderLineItem>
> | <OrderLineItem>
> | <LineNum>3</LineNum>
> | <qty>8</qty>
> | <UnitPrice>29.95</UnitPrice>
> | </OrderLineItem>
> | </OrderLineItems>
> | </SalesOrder>
> |
> | -------------------------------------
> | Dest schema:
> | -------------------------------------
> | <ProcessOrder>
> | <Process type="callmethod" user="userabc" pwd="password">
> | <callmethod name="insertOrder">
> | <params>
> | <param name="Company">ABC</param>
> | <param name="OrderNumber">12345</param>
> | <param name="LineNum">1</param>
> | <param name="qty">15</param>
> | <param name="UnitPrice">10.5</param>
> | </params>
> | </callmethod>
> | <callmethod name="insertOrder">
> | <params>
> | <param name="Company">ABC</param>
> | <param name="OrderNumber">12345</param>
> | <param name="LineNum">2</param>
> | <param name="qty">12</param>
> | <param name="UnitPrice">9.99</param>
> | </params>
> | </callmethod>
> | <callmethod name="insertOrder">
> | <params>
> | <param name="Company">ABC</param>
> | <param name="OrderNumber">12345</param>
> | <param name="LineNum">3</param>
> | <param name="qty">8</param>
> | <param name="UnitPrice">29.95</param>
> | </params>
> | </callmethod>
> | </ProcessOrder>
> |
> | -H
> |
>
>
Tan Nguyen

2005-03-29, 8:47 pm

No. The looping functoid only loops on the record where it is connected.

Regards,
Tan Nguyen
Microsoft BizTalk Server

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
| Thread-Topic: functoid mapping question
| thread-index: AcUmmV+vbTS3PwCdQWyMWiiA95HcIg==
| X-WBNR-Posting-Host: 205.142.247.134
| From: "=?Utf-8?B?SA==?=" <H@discussions.microsoft.com>
| References: <30543B67-1990-44CC-8C98-340482B71AA7@microsoft.com>
<aQbJssAJFHA.132@TK2MSFTNGXA02.phx.gbl>
| Subject: RE: functoid mapping question
| Date: Fri, 11 Mar 2005 16:21:02 -0800
| Lines: 110
| Message-ID: <31F9DAEB-DB6C-4B84-B813-63A3C19C9D51@microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.biztalk.tools
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.biztalk.tools:4267
| X-Tomcat-NG: microsoft.public.biztalk.tools
|
| thanks, I got it work by using the looping functoid on this one... do you
| know if functoid provide the nest looping logic functoid(s)
|
| "Tan Nguyen" wrote:
|
| > Use the Table Looping functoid. Refer to the BizTalk Server
documentation
| > for more info on the Table Looping functoid.
| >
| > Regards,
| > Tan Nguyen
| > Microsoft BizTalk Server
| >
| > This posting is provided "AS IS" with no warranties, and confers no
rights.
| >
| > --------------------
| > | Thread-Topic: functoid mapping question
| > | thread-index: AcUja8Yz4xaVLLCOTyONqaZpc90npg==
| > | X-WBNR-Posting-Host: 205.142.247.254
| > | From: "=?Utf-8?B?SA==?=" <H@discussions.microsoft.com>
| > | Subject: functoid mapping question
| > | Date: Mon, 7 Mar 2005 15:17:04 -0800
| > | Lines: 67
| > | Message-ID: <30543B67-1990-44CC-8C98-340482B71AA7@microsoft.com>
| > | MIME-Version: 1.0
| > | Content-Type: text/plain;
| > | charset="Utf-8"
| > | Content-Transfer-Encoding: 7bit
| > | X-Newsreader: Microsoft CDO for Windows 2000
| > | Content-Class: urn:content-classes:message
| > | Importance: normal
| > | Priority: normal
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| > | Newsgroups: microsoft.public.biztalk.tools
| > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| > | Path:
TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| > | Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.biztalk.tools:4252
| > | X-Tomcat-NG: microsoft.public.biztalk.tools
| > |
| > | I have couple sample schemas listed below, and I'd like to map from
| > source
| > | schema, to dest. schema.
| > |
| > | Can this be done by using functoid mapping? ( I know the mapping can
be
| > done
| > | via xslt)
| > | -------------------------------------
| > | Source schema:
| > | -------------------------------------
| > | <SalesOrder>
| > | <Header>
| > | <Company>ABC</Company>
| > | <OrderNumber>12345</OrderNumber>
| > | </Header>
| > | <OrderLineItems>
| > | <OrderLineItem>
| > | <LineNum>1</LineNum>
| > | <qty>15</qty>
| > | <UnitPrice>10.5</UnitPrice>
| > | </OrderLineItem>
| > | <OrderLineItem>
| > | <LineNum>2</LineNum>
| > | <qty>12</qty>
| > | <UnitPrice>9.99</UnitPrice>
| > | </OrderLineItem>
| > | <OrderLineItem>
| > | <LineNum>3</LineNum>
| > | <qty>8</qty>
| > | <UnitPrice>29.95</UnitPrice>
| > | </OrderLineItem>
| > | </OrderLineItems>
| > | </SalesOrder>
| > |
| > | -------------------------------------
| > | Dest schema:
| > | -------------------------------------
| > | <ProcessOrder>
| > | <Process type="callmethod" user="userabc" pwd="password">
| > | <callmethod name="insertOrder">
| > | <params>
| > | <param name="Company">ABC</param>
| > | <param name="OrderNumber">12345</param>
| > | <param name="LineNum">1</param>
| > | <param name="qty">15</param>
| > | <param name="UnitPrice">10.5</param>
| > | </params>
| > | </callmethod>
| > | <callmethod name="insertOrder">
| > | <params>
| > | <param name="Company">ABC</param>
| > | <param name="OrderNumber">12345</param>
| > | <param name="LineNum">2</param>
| > | <param name="qty">12</param>
| > | <param name="UnitPrice">9.99</param>
| > | </params>
| > | </callmethod>
| > | <callmethod name="insertOrder">
| > | <params>
| > | <param name="Company">ABC</param>
| > | <param name="OrderNumber">12345</param>
| > | <param name="LineNum">3</param>
| > | <param name="qty">8</param>
| > | <param name="UnitPrice">29.95</param>
| > | </params>
| > | </callmethod>
| > | </ProcessOrder>
| > |
| > | -H
| > |
| >
| >
|

Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com