|
Home > Archive > BizTalk Server General > March 2004 > Grouping in Mapper (xsl:for-each-group, Muenchian, Other) BizTalk 2002
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 |
Grouping in Mapper (xsl:for-each-group, Muenchian, Other) BizTalk 2002
|
|
| CMarsh 2004-03-25, 6:52 pm |
| BizTalk 2002, Win 2000
I am attempting to group using BizTalk mapper. I cannot find a built-in solution for doing this.
Couple of questions:
1. Can Muenchian Grouping be used? How?
2. Can the XSLT 2.0 directive xsl:for-each-group be used? How?
If none of the above:
3. Can a standard XSL file be used in a channel for mapping (one that was not created with the BizTalk metadata in it or by the BizTalk mapper)?
Consider:
<orderdata>
<orderitem orderid="001" itemid ="A001" />
<orderitem orderid="002" itemid ="B002" />
<orderitem orderid="002" itemid ="C003" />
</orderdata>
Maps to:
<orders>
<order id="001">
<item id="A001" />
</order>
<order id="002">
<item id="B002" />
<item id="C002" />
</order>
</orders>
Warm Regards,
Chris
cmarsh.biznews@@aviacode..com
| |
| larry franks 2004-03-26, 2:14 pm |
| There's no way to do grouping in the BizTalk 2000/2002 mapper. You will
have to use a custom XSLT to do the mapping. Just store the custom XSLT to
the repository and then use it as the map in your channel.
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
--------------------
| Reply-To: "CMarsh" <cmarsh@aviacode.com>
| From: "CMarsh" <cmarsh@aviacode.com>
| Subject: Grouping in Mapper (xsl:for-each-group, Muenchian, Other)
BizTalk 2002
| Date: Thu, 25 Mar 2004 16:09:28 -0700
| Lines: 117
| Organization: Aviacode
| MIME-Version: 1.0
| Content-Type: multipart/alternative;
| boundary="----=_NextPart_000_000C_01C41283.8CF2BAB0"
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
| Message-ID: <OqU244rEEHA.2804@tk2msftngp13.phx.gbl>
| Newsgroups: microsoft.public.biztalk.general
| NNTP-Posting-Host: saltlake-ut-aviacode.com 66.89.110.18
| Path:
cpmsftngxa06.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13
.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.biztalk.general:13494
| X-Tomcat-NG: microsoft.public.biztalk.general
|
| BizTalk 2002, Win 2000
| I am attempting to group using BizTalk mapper. I cannot find a built-in
solution for doing this.
| Couple of questions:
| 1. Can Muenchian Grouping be used? How?
| 2. Can the XSLT 2.0 directive xsl:for-each-group be used? How?
| If none of the above:
| 3. Can a standard XSL file be used in a channel for mapping (one that was
not created with the BizTalk metadata in it or by the BizTalk mapper)?
| Consider:
| <orderdata>
| <orderitem orderid="001" itemid ="A001" />
| <orderitem orderid="002" itemid ="B002" />
| <orderitem orderid="002" itemid ="C003" />
| </orderdata>
| Maps to:
| <orders>
| <order id="001">
| <item id="A001" />
| </order>
| <order id="002">
| <item id="B002" />
| <item id="C002" />
| </order>
| </orders>
| Warm Regards,
| Chris
| cmarsh.biznews@@aviacode..com
|
| |
| CMarsh 2004-03-29, 1:42 pm |
| I tried your suggestion with the attached XSLT. (Which implements a Muenchian Style grouping).
This XSL is valid and works using XSL1.0 (tested with a simple vb script)
In the BizTalk Channel I created, it gave me an error saying that the "MapSource" node did not exist in the XSL.
This is due to, I gather, it not being created in the Mapper application?
Questions:
Can I created my own XSL and have a channel use it as a map?
If "YES" ...
What are the "required" nodes that the channel is looking for? Is there a MSDN article on any of this?
Warm Regards,
Chris
cmarsh.biznews@@aviacode..com
-----------------------------------------------------------------------------------------------
""larry franks"" <larryfr@online.microsoft.com> wrote in message news:BXsUO91EEHA.660@cpmsftngxa06.phx.gbl...
There's no way to do grouping in the BizTalk 2000/2002 mapper. You will
have to use a custom XSLT to do the mapping. Just store the custom XSLT to
the repository and then use it as the map in your channel.
Larry Franks
This posting is provided "AS IS" with no warranties,and confers no rights.
Subscribe at
http://support.microsoft.com/defaul...pam.asp&SD=msdn
-----------------------------------------------------------------------------------------------
Reply-To: "CMarsh" <cmarsh@aviacode.com>
From: "CMarsh" <cmarsh@aviacode.com>
Subject: Grouping in Mapper (xsl:for-each-group, Muenchian, Other) BizTalk 2002
Date: Thu, 25 Mar 2004 16:09:28 -0700
Lines: 117
BizTalk 2002, Win 2000
I am attempting to group using BizTalk mapper. I cannot find a built-in solution for doing this.
Couple of questions:
1. Can Muenchian Grouping be used? How?
2. Can the XSLT 2.0 directive xsl:for-each-group be used? How?
If none of the above:
3. Can a standard XSL file be used in a channel for mapping (one that was not created with the BizTalk metadata in it or by the BizTalk mapper)?
Consider:
<orderdata>
<orderitem orderid="001" itemid ="A001" />
<orderitem orderid="002" itemid ="B002" />
<orderitem orderid="002" itemid ="C003" />
</orderdata>
Maps to:
<orders>
<order id="001">
<item id="A001" />
</order>
<order id="002">
<item id="B002" />
<item id="C002" />
</order>
</orders>
Warm Regards,
Chris
cmarsh.biznews@@aviacode..com
| |
| Matt Cable 2004-03-30, 12:37 am |
| Yes, I've done it a number of times. You're on the right track. You will need the root "mapsource" element (with all attributes), a child "CompiledXSL" element (note no schema (SrcTree, TrgTree, TreeValues, Pages) information - much slimmer file), with your stylesheet code nested inside.
2002 XSLT Map Example:
<?xml version="1.0" ?>
<mapsource Name="BizTalk Map" BizTalkServerMapperTool_Version="1.5" Version="1.5" XRange="100" YRange="420">
<CompiledXSL>
... Your Stylesheet code here ...
</CompiledXSL>
</mapsource>
Note: I beleive BizTalk 2000 maps utilize a "1.0" version number in "mapsource" attibutes, instead of a "1.5".
- - Matt Cable
"CMarsh" <cmarsh@aviacode.com> wrote in message news:OdYD%23mbFEHA.1512@TK2MSFTNGP11.phx.gbl...
I tried your suggestion with the attached XSLT. (Which implements a Muenchian Style grouping).
This XSL is valid and works using XSL1.0 (tested with a simple vb script)
In the BizTalk Channel I created, it gave me an error saying that the "MapSource" node did not exist in the XSL.
This is due to, I gather, it not being created in the Mapper application?
Questions:
Can I created my own XSL and have a channel use it as a map?
If "YES" ...
What are the "required" nodes that the channel is looking for? Is there a MSDN article on any of this?
Warm Regards,
Chris
cmarsh.biznews@@aviacode..com
-----------------------------------------------------------------------------------------------
""larry franks"" <larryfr@online.microsoft.com> wrote in message news:BXsUO91EEHA.660@cpmsftngxa06.phx.gbl...
There's no way to do grouping in the BizTalk 2000/2002 mapper. You will
have to use a custom XSLT to do the mapping. Just store the custom XSLT to
the repository and then use it as the map in your channel.
Larry Franks
This posting is provided "AS IS" with no warranties,and confers no rights.
Subscribe at
http://support.microsoft.com/defaul...pam.asp&SD=msdn
-----------------------------------------------------------------------------------------------
Reply-To: "CMarsh" <cmarsh@aviacode.com>
From: "CMarsh" <cmarsh@aviacode.com>
Subject: Grouping in Mapper (xsl:for-each-group, Muenchian, Other) BizTalk 2002
Date: Thu, 25 Mar 2004 16:09:28 -0700
Lines: 117
BizTalk 2002, Win 2000
I am attempting to group using BizTalk mapper. I cannot find a built-in solution for doing this.
Couple of questions:
1. Can Muenchian Grouping be used? How?
2. Can the XSLT 2.0 directive xsl:for-each-group be used? How?
If none of the above:
3. Can a standard XSL file be used in a channel for mapping (one that was not created with the BizTalk metadata in it or by the BizTalk mapper)?
Consider:
<orderdata>
<orderitem orderid="001" itemid ="A001" />
<orderitem orderid="002" itemid ="B002" />
<orderitem orderid="002" itemid ="C003" />
</orderdata>
Maps to:
<orders>
<order id="001">
<item id="A001" />
</order>
<order id="002">
<item id="B002" />
<item id="C002" />
</order>
</orders>
Warm Regards,
Chris
cmarsh.biznews@@aviacode..com
| |
| CMarsh 2004-03-30, 2:43 pm |
| Great Suggestion ...
Using a Muenchian Style grouping this works!!!
Awesome
"Matt Cable" <mcable@nospam.quilogy.com> wrote in message news:#MJLFOhFEHA.3080@tk2msftngp13.phx.gbl...
Yes, I've done it a number of times. You're on the right track. You will need the root "mapsource" element (with all attributes), a child "CompiledXSL" element (note no schema (SrcTree, TrgTree, TreeValues, Pages) information - much slimmer file), with your stylesheet code nested inside.
2002 XSLT Map Example:
<?xml version="1.0" ?>
<mapsource Name="BizTalk Map" BizTalkServerMapperTool_Version="1.5" Version="1.5" XRange="100" YRange="420">
<CompiledXSL>
... Your Stylesheet code here ...
</CompiledXSL>
</mapsource>
Note: I beleive BizTalk 2000 maps utilize a "1.0" version number in "mapsource" attibutes, instead of a "1.5".
- - Matt Cable
"CMarsh" <cmarsh@aviacode.com> wrote in message news:OdYD%23mbFEHA.1512@TK2MSFTNGP11.phx.gbl...
I tried your suggestion with the attached XSLT. (Which implements a Muenchian Style grouping).
This XSL is valid and works using XSL1.0 (tested with a simple vb script)
In the BizTalk Channel I created, it gave me an error saying that the "MapSource" node did not exist in the XSL.
This is due to, I gather, it not being created in the Mapper application?
Questions:
Can I created my own XSL and have a channel use it as a map?
If "YES" ...
What are the "required" nodes that the channel is looking for? Is there a MSDN article on any of this?
Warm Regards,
Chris
cmarsh.biznews@@aviacode..com
-----------------------------------------------------------------------------------------------
""larry franks"" <larryfr@online.microsoft.com> wrote in message news:BXsUO91EEHA.660@cpmsftngxa06.phx.gbl...
There's no way to do grouping in the BizTalk 2000/2002 mapper. You will
have to use a custom XSLT to do the mapping. Just store the custom XSLT to
the repository and then use it as the map in your channel.
Larry Franks
This posting is provided "AS IS" with no warranties,and confers no rights.
Subscribe at
http://support.microsoft.com/defaul...pam.asp&SD=msdn
-----------------------------------------------------------------------------------------------
Reply-To: "CMarsh" <cmarsh@aviacode.com>
From: "CMarsh" <cmarsh@aviacode.com>
Subject: Grouping in Mapper (xsl:for-each-group, Muenchian, Other) BizTalk 2002
Date: Thu, 25 Mar 2004 16:09:28 -0700
Lines: 117
BizTalk 2002, Win 2000
I am attempting to group using BizTalk mapper. I cannot find a built-in solution for doing this.
Couple of questions:
1. Can Muenchian Grouping be used? How?
2. Can the XSLT 2.0 directive xsl:for-each-group be used? How?
If none of the above:
3. Can a standard XSL file be used in a channel for mapping (one that was not created with the BizTalk metadata in it or by the BizTalk mapper)?
Consider:
<orderdata>
<orderitem orderid="001" itemid ="A001" />
<orderitem orderid="002" itemid ="B002" />
<orderitem orderid="002" itemid ="C003" />
</orderdata>
Maps to:
<orders>
<order id="001">
<item id="A001" />
</order>
<order id="002">
<item id="B002" />
<item id="C002" />
</order>
</orders>
Warm Regards,
Chris
cmarsh.biznews@@aviacode..com
|
|
|
|
|