|
Home > Archive > BizTalk Server General > May 2006 > Mapping more than 100 messages to one message
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 |
Mapping more than 100 messages to one message
|
|
| Murugan 2006-05-16, 1:14 pm |
| Hi all,
i have problem in Mapping. In the Source of the Map, i cann't able add the
more than 100 message. Is it limitation of the BTS map? If able to map the
more than 100 message to one message, please share the idea
Thanks
Murugan A
| |
| Leonid Ganeline 2006-05-16, 1:14 pm |
| Separate the whole process to 2 or more stages. 100(by 50) --> to 2 --> to 1
I'm sure there should be the semantic grouping of these schemas.
--
Regards,
Leonid Ganeline
BizTalk Solution Developer
===================================
BizTalk Blog -- http://geekswithblogs.net/leonidganeline
"Murugan" <Murugan@discussions.microsoft.com> wrote in message
news:901B142A-2FD6-4CA3-8A21-E63866061196@microsoft.com...
> Hi all,
>
> i have problem in Mapping. In the Source of the Map, i cann't able add
> the
> more than 100 message. Is it limitation of the BTS map? If able to map the
> more than 100 message to one message, please share the idea
>
> Thanks
>
> Murugan A
| |
| Murugan 2006-05-17, 7:14 am |
| Thanks for immediate reply,
I will try with your suggestion.
"Leonid Ganeline" wrote:
> Separate the whole process to 2 or more stages. 100(by 50) --> to 2 --> to 1
> I'm sure there should be the semantic grouping of these schemas.
>
> --
> Regards,
>
> Leonid Ganeline
> BizTalk Solution Developer
> ===================================
> BizTalk Blog -- http://geekswithblogs.net/leonidganeline
>
> "Murugan" <Murugan@discussions.microsoft.com> wrote in message
> news:901B142A-2FD6-4CA3-8A21-E63866061196@microsoft.com...
>
>
>
| |
| Murugan 2006-05-17, 7:14 am |
| Hi Leonid Ganeline,
It is another problem to map the two related schemas to one schema.
Let us consider,
xml data1 :
<College Id="1" Name="1st College"/>
xml data2 Multiple data under one college)
<Student Id="101" Name ="Anand" Mark="90" CollegeId="1"/>
<Student Id="102" Name ="Britto" Mark="70" CollegeId="1"/>
<Student Id="103" Name ="John" Mark="72" CollegeId="1"/>
I have mapped to above two xml data to one . ie, its displayed as
<College Id="1" Name="1st College">
<Student Id="101" Name ="Anand" Mark="90" CollegeId="1"/>
<Student Id="102" Name ="Britto" Mark="70" CollegeId="1"/>
<Student Id="103" Name ="John" Mark="72" CollegeId="1"/>
</College>
But i cannt able to do this, If you have any idea please explain this
Thanks
Murugan A
"Murugan" wrote:
[vbcol=seagreen]
> Thanks for immediate reply,
>
> I will try with your suggestion.
>
>
> "Leonid Ganeline" wrote:
>
| |
| Rajesh 2006-05-17, 1:14 pm |
| Muru,
Are you trying to take input from 100 elements and map to one? I didn't
understand your problem. There is no limitation on BTS map.
RajP
"Murugan" wrote:
[vbcol=seagreen]
> Hi Leonid Ganeline,
>
> It is another problem to map the two related schemas to one schema.
>
> Let us consider,
> xml data1 :
>
> <College Id="1" Name="1st College"/>
>
> xml data2Multiple data under one college)
>
> <Student Id="101" Name ="Anand" Mark="90" CollegeId="1"/>
> <Student Id="102" Name ="Britto" Mark="70" CollegeId="1"/>
> <Student Id="103" Name ="John" Mark="72" CollegeId="1"/>
>
>
> I have mapped to above two xml data to one . ie, its displayed as
>
> <College Id="1" Name="1st College">
> <Student Id="101" Name ="Anand" Mark="90" CollegeId="1"/>
> <Student Id="102" Name ="Britto" Mark="70" CollegeId="1"/>
> <Student Id="103" Name ="John" Mark="72" CollegeId="1"/>
> </College>
>
> But i cannt able to do this, If you have any idea please explain this
>
> Thanks
>
> Murugan A
>
>
>
> "Murugan" wrote:
>
| |
| Murugan 2006-05-18, 7:18 am |
| Hi Rajesh,
In Source side of the BTS Map has provide the only 100 messages thro
transform shape in Orchestration. I solve that problem using more than one
map it has divdide to multiple.
It was another problem, I have a two messages, one is like
Inbound1:
-----------
<College Id="1" Name="1st College"/>
<College Id="2" Name="2nd College"/>
and another one is
Inbound2:
-----------
<Student Id="101" Name ="Anand" Mark="90" CollegeId="1"/>
<Student Id="102" Name ="Britto" Mark="70" CollegeId="1"/>
<Student Id="103" Name ="John" Mark="72" CollegeId="1"/>
<Student Id="201" Name ="Arun" Mark="90" CollegeId="2"/>
<Student Id="202" Name ="Bosh" Mark="70" CollegeId="2"/>
<Student Id="203" Name ="David" Mark="72" CollegeId="2"/>
I need Combined message like below
Outbound:
------------
<College Id="1" Name="1st College">
<Student Id="101" Name ="Anand" Mark="90" CollegeId="1"/>
<Student Id="102" Name ="Britto" Mark="70" CollegeId="1"/>
<Student Id="103" Name ="John" Mark="72" CollegeId="1"/>
</College>
<College Id="2" Name="2nd College">
<Student Id="201" Name ="Arun" Mark="90" CollegeId="2"/>
<Student Id="202" Name ="Bosh" Mark="70" CollegeId="2"/>
<Student Id="203" Name ="David" Mark="72" CollegeId="2"/>
</College>
after mapping two messages.
How to map these two message to one message, if you have an idea share with
me.
I hope the above scenario, its clear to understand you.
Thanks
Murugan A
"Rajesh" wrote:
[vbcol=seagreen]
> Muru,
> Are you trying to take input from 100 elements and map to one? I didn't
> understand your problem. There is no limitation on BTS map.
>
> RajP
>
> "Murugan" wrote:
>
| |
| Greg Forsythe 2006-05-22, 7:14 am |
| Here is a custom Xslt that will group student records by college:
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:msxsl="urn:schemas-microsoft-com:xslt"
xmlns:var="http://schemas.microsoft.com/BizTalk/2003/var"
exclude-result-prefixes="msxsl var" version="1.0">
<xsl:output omit-xml-declaration="yes" version="1.0" method="xml" />
<xsl:key name="collegekey" match="/root/Student" use="@CollegeId"/>
<xsl:template match="/">
<xsl:apply-templates select="/root" />
</xsl:template>
<xsl:template match="/root">
<root>
<xsl:for-each select="Student">
<xsl:variable name="group" select="key('collegekey', @CollegeId)"/>
<xsl:if test="generate-id($group[1]) = generate-id()">
<College>
<xsl:variable name="var:Id" select="@CollegeId"/>
<xsl:attribute name="Id">
<xsl:value-of select="$var:Id"/>
</xsl:attribute>
<xsl:attribute name="name">
<xsl:value-of select="/root/College[@Id = $var:Id]/@Name"/>
</xsl:attribute>
<xsl:for-each select="$group">
<Student>
<xsl:attribute name="Id">
<xsl:value-of select="@Id" />
</xsl:attribute>
<xsl:attribute name="Name">
<xsl:value-of select="@Name" />
</xsl:attribute>
<xsl:attribute name="Mark">
<xsl:value-of select="@Mark" />
</xsl:attribute>
<xsl:attribute name="CollegeId">
<xsl:value-of select="@CollegeId" />
</xsl:attribute>
</Student>
</xsl:for-each>
</College>
</xsl:if>
</xsl:for-each>
</root>
</xsl:template>
</xsl:stylesheet>
Input Xml:
<root>
<College Id="1" Name="1st College"/>
<College Id="2" Name="2nd College"/>
<Student Id="101" Name ="Anand" Mark="90" CollegeId="1"/>
<Student Id="102" Name ="Britto" Mark="70" CollegeId="1"/>
<Student Id="103" Name ="John" Mark="72" CollegeId="1"/>
<Student Id="201" Name ="Arun" Mark="90" CollegeId="2"/>
<Student Id="202" Name ="Bosh" Mark="70" CollegeId="2"/>
<Student Id="203" Name ="David" Mark="72" CollegeId="2"/>
</root>
Output Xml
<root>
<College Id="1" name="1st College">
<Student Id="101" Name="Anand" Mark="90" CollegeId="1" />
<Student Id="102" Name="Britto" Mark="70" CollegeId="1" />
<Student Id="103" Name="John" Mark="72" CollegeId="1" />
</College>
<College Id="2" name="2nd College">
<Student Id="201" Name="Arun" Mark="90" CollegeId="2" />
<Student Id="202" Name="Bosh" Mark="70" CollegeId="2" />
<Student Id="203" Name="David" Mark="72" CollegeId="2" />
</College>
</root>
Greg
"Murugan" <Murugan@discussions.microsoft.com> wrote in message
news:644B0753-8E2D-4614-A7A2-66C53CB79EF8@microsoft.com...[vbcol=seagreen]
> Hi Rajesh,
>
> In Source side of the BTS Map has provide the only 100 messages thro
> transform shape in Orchestration. I solve that problem using more than one
> map it has divdide to multiple.
>
> It was another problem, I have a two messages, one is like
>
> Inbound1:
> -----------
> <College Id="1" Name="1st College"/>
> <College Id="2" Name="2nd College"/>
>
> and another one is
>
> Inbound2:
> -----------
> <Student Id="101" Name ="Anand" Mark="90" CollegeId="1"/>
> <Student Id="102" Name ="Britto" Mark="70" CollegeId="1"/>
> <Student Id="103" Name ="John" Mark="72" CollegeId="1"/>
>
> <Student Id="201" Name ="Arun" Mark="90" CollegeId="2"/>
> <Student Id="202" Name ="Bosh" Mark="70" CollegeId="2"/>
> <Student Id="203" Name ="David" Mark="72" CollegeId="2"/>
>
>
> I need Combined message like below
>
> Outbound:
> ------------
>
> <College Id="1" Name="1st College">
> <Student Id="101" Name ="Anand" Mark="90" CollegeId="1"/>
> <Student Id="102" Name ="Britto" Mark="70" CollegeId="1"/>
> <Student Id="103" Name ="John" Mark="72" CollegeId="1"/>
> </College>
> <College Id="2" Name="2nd College">
> <Student Id="201" Name ="Arun" Mark="90" CollegeId="2"/>
> <Student Id="202" Name ="Bosh" Mark="70" CollegeId="2"/>
> <Student Id="203" Name ="David" Mark="72" CollegeId="2"/>
> </College>
>
> after mapping two messages.
>
> How to map these two message to one message, if you have an idea share
> with
> me.
>
> I hope the above scenario, its clear to understand you.
>
> Thanks
> Murugan A
>
>
>
>
>
>
>
>
>
> "Rajesh" wrote:
>
| |
| Murugan 2006-05-22, 7:14 am |
| HI Greg Forsythe,
Thanks for your response
Murugan A
"Greg Forsythe" wrote:
> Here is a custom Xslt that will group student records by college:
>
> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
> xmlns:msxsl="urn:schemas-microsoft-com:xslt"
> xmlns:var="http://schemas.microsoft.com/BizTalk/2003/var"
> exclude-result-prefixes="msxsl var" version="1.0">
> <xsl:output omit-xml-declaration="yes" version="1.0" method="xml" />
> <xsl:key name="collegekey" match="/root/Student" use="@CollegeId"/>
> <xsl:template match="/">
> <xsl:apply-templates select="/root" />
> </xsl:template>
> <xsl:template match="/root">
> <root>
> <xsl:for-each select="Student">
> <xsl:variable name="group" select="key('collegekey', @CollegeId)"/>
> <xsl:if test="generate-id($group[1]) = generate-id()">
> <College>
> <xsl:variable name="var:Id" select="@CollegeId"/>
> <xsl:attribute name="Id">
> <xsl:value-of select="$var:Id"/>
> </xsl:attribute>
> <xsl:attribute name="name">
> <xsl:value-of select="/root/College[@Id = $var:Id]/@Name"/>
> </xsl:attribute>
> <xsl:for-each select="$group">
> <Student>
> <xsl:attribute name="Id">
> <xsl:value-of select="@Id" />
> </xsl:attribute>
> <xsl:attribute name="Name">
> <xsl:value-of select="@Name" />
> </xsl:attribute>
> <xsl:attribute name="Mark">
> <xsl:value-of select="@Mark" />
> </xsl:attribute>
> <xsl:attribute name="CollegeId">
> <xsl:value-of select="@CollegeId" />
> </xsl:attribute>
> </Student>
> </xsl:for-each>
> </College>
> </xsl:if>
> </xsl:for-each>
> </root>
> </xsl:template>
> </xsl:stylesheet>
>
> Input Xml:
> <root>
> <College Id="1" Name="1st College"/>
> <College Id="2" Name="2nd College"/>
> <Student Id="101" Name ="Anand" Mark="90" CollegeId="1"/>
> <Student Id="102" Name ="Britto" Mark="70" CollegeId="1"/>
> <Student Id="103" Name ="John" Mark="72" CollegeId="1"/>
> <Student Id="201" Name ="Arun" Mark="90" CollegeId="2"/>
> <Student Id="202" Name ="Bosh" Mark="70" CollegeId="2"/>
> <Student Id="203" Name ="David" Mark="72" CollegeId="2"/>
> </root>
>
> Output Xml
> <root>
> <College Id="1" name="1st College">
> <Student Id="101" Name="Anand" Mark="90" CollegeId="1" />
> <Student Id="102" Name="Britto" Mark="70" CollegeId="1" />
> <Student Id="103" Name="John" Mark="72" CollegeId="1" />
> </College>
> <College Id="2" name="2nd College">
> <Student Id="201" Name="Arun" Mark="90" CollegeId="2" />
> <Student Id="202" Name="Bosh" Mark="70" CollegeId="2" />
> <Student Id="203" Name="David" Mark="72" CollegeId="2" />
> </College>
> </root>
>
> Greg
>
>
> "Murugan" <Murugan@discussions.microsoft.com> wrote in message
> news:644B0753-8E2D-4614-A7A2-66C53CB79EF8@microsoft.com...
>
>
>
| |
| Murugan 2006-05-23, 1:15 pm |
| Hi Greg Forsythe,
In Biztalk , how to implement this, ie.) how to add this schema in the
project.
Thanks
Murugan A
"Greg Forsythe" wrote:
> Here is a custom Xslt that will group student records by college:
>
> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
> xmlns:msxsl="urn:schemas-microsoft-com:xslt"
> xmlns:var="http://schemas.microsoft.com/BizTalk/2003/var"
> exclude-result-prefixes="msxsl var" version="1.0">
> <xsl:output omit-xml-declaration="yes" version="1.0" method="xml" />
> <xsl:key name="collegekey" match="/root/Student" use="@CollegeId"/>
> <xsl:template match="/">
> <xsl:apply-templates select="/root" />
> </xsl:template>
> <xsl:template match="/root">
> <root>
> <xsl:for-each select="Student">
> <xsl:variable name="group" select="key('collegekey', @CollegeId)"/>
> <xsl:if test="generate-id($group[1]) = generate-id()">
> <College>
> <xsl:variable name="var:Id" select="@CollegeId"/>
> <xsl:attribute name="Id">
> <xsl:value-of select="$var:Id"/>
> </xsl:attribute>
> <xsl:attribute name="name">
> <xsl:value-of select="/root/College[@Id = $var:Id]/@Name"/>
> </xsl:attribute>
> <xsl:for-each select="$group">
> <Student>
> <xsl:attribute name="Id">
> <xsl:value-of select="@Id" />
> </xsl:attribute>
> <xsl:attribute name="Name">
> <xsl:value-of select="@Name" />
> </xsl:attribute>
> <xsl:attribute name="Mark">
> <xsl:value-of select="@Mark" />
> </xsl:attribute>
> <xsl:attribute name="CollegeId">
> <xsl:value-of select="@CollegeId" />
> </xsl:attribute>
> </Student>
> </xsl:for-each>
> </College>
> </xsl:if>
> </xsl:for-each>
> </root>
> </xsl:template>
> </xsl:stylesheet>
>
> Input Xml:
> <root>
> <College Id="1" Name="1st College"/>
> <College Id="2" Name="2nd College"/>
> <Student Id="101" Name ="Anand" Mark="90" CollegeId="1"/>
> <Student Id="102" Name ="Britto" Mark="70" CollegeId="1"/>
> <Student Id="103" Name ="John" Mark="72" CollegeId="1"/>
> <Student Id="201" Name ="Arun" Mark="90" CollegeId="2"/>
> <Student Id="202" Name ="Bosh" Mark="70" CollegeId="2"/>
> <Student Id="203" Name ="David" Mark="72" CollegeId="2"/>
> </root>
>
> Output Xml
> <root>
> <College Id="1" name="1st College">
> <Student Id="101" Name="Anand" Mark="90" CollegeId="1" />
> <Student Id="102" Name="Britto" Mark="70" CollegeId="1" />
> <Student Id="103" Name="John" Mark="72" CollegeId="1" />
> </College>
> <College Id="2" name="2nd College">
> <Student Id="201" Name="Arun" Mark="90" CollegeId="2" />
> <Student Id="202" Name="Bosh" Mark="70" CollegeId="2" />
> <Student Id="203" Name="David" Mark="72" CollegeId="2" />
> </College>
> </root>
>
> Greg
>
>
> "Murugan" <Murugan@discussions.microsoft.com> wrote in message
> news:644B0753-8E2D-4614-A7A2-66C53CB79EF8@microsoft.com...
>
>
>
| |
| Greg Forsythe 2006-05-23, 1:15 pm |
| Create a file in the project directory e.g. "CustomMap.xslt" and paste the
xslt code.
Add your file to your project (not really necessary but helps with source
control)
Create a map, select source schema, and destination schema.
Click on centre grid of map.
Go to Properties Window and select Custom Xslt ellipsis and select your file
You can then use Test Map.
Greg
"Murugan" <Murugan@discussions.microsoft.com> wrote in message
news:9510777D-B39E-4DCD-ACAF-D9B39F3A4F07@microsoft.com...[vbcol=seagreen]
> Hi Greg Forsythe,
>
> In Biztalk , how to implement this, ie.) how to add this schema in the
> project.
>
> Thanks
> Murugan A
>
> "Greg Forsythe" wrote:
>
| |
| Murugan 2006-05-24, 1:14 pm |
|
HI Greg Forsythe,
Thanks for immediate reply and soln.,
i have implemented to this code with your direction. It gives the error
message as "Output validation error: The root element is missing."
And the following message was show in the output xml file in _mapdata folder
*----------------------------------------------------------------------*
The XML page cannot be displayed
Cannot view XML input using style sheet. Please correct the error and then
click the Refresh button, or try again later.
----------------------------------------------------------------------
XML document must have a top level element. Error processing resource
'file:///C:/Documents and Settings/biztalk/Local Sett...
--------------------------------------------------------------------------------
If you have any solution, please send.
Thanks
Murugan A
"Greg Forsythe" wrote:
> Create a file in the project directory e.g. "CustomMap.xslt" and paste the
> xslt code.
> Add your file to your project (not really necessary but helps with source
> control)
> Create a map, select source schema, and destination schema.
> Click on centre grid of map.
> Go to Properties Window and select Custom Xslt ellipsis and select your file
>
> You can then use Test Map.
>
> Greg
>
>
> "Murugan" <Murugan@discussions.microsoft.com> wrote in message
> news:9510777D-B39E-4DCD-ACAF-D9B39F3A4F07@microsoft.com...
>
>
>
| |
| Greg Forsythe 2006-05-24, 7:15 pm |
| The map is a generic example, it will need to be modified to match your
actual schemas.
Any chance of sending me your schemas and example messages?
Greg
"Murugan" <Murugan@discussions.microsoft.com> wrote in message
news:A14B8FF2-758A-49BF-87B1-353E63C62D5F@microsoft.com...[vbcol=seagreen]
>
> HI Greg Forsythe,
>
> Thanks for immediate reply and soln.,
>
> i have implemented to this code with your direction. It gives the error
> message as "Output validation error: The root element is missing."
>
> And the following message was show in the output xml file in _mapdata
> folder
>
> *----------------------------------------------------------------------*
>
> The XML page cannot be displayed
> Cannot view XML input using style sheet. Please correct the error and then
> click the Refresh button, or try again later.
> ----------------------------------------------------------------------
> XML document must have a top level element. Error processing resource
> 'file:///C:/Documents and Settings/biztalk/Local Sett...
> --------------------------------------------------------------------------------
>
> If you have any solution, please send.
>
> Thanks
>
> Murugan A
>
>
>
> "Greg Forsythe" wrote:
>
| |
| Murugan 2006-05-25, 7:14 am |
| Hi Greg Forsythe,
Thanks for reply,
i cann't able to detect the error, because i don't have knowledge in Xslt.
I give the Inbound and Outbound schemas.
Let us consider the inbound and outbound scemas as shown below
Inbound Schema:
<?xml version="1.0" encoding="utf-16" ?>
<xs:schema xmlns="http://examLoop3.Schema1"
xmlns:b="http://schemas.microsoft.com/BizTalk/2003"
targetNamespace="http://examLoop3.Schema1"
xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:element name="root">
<xs:complexType>
<xs:sequence>
<xs:element name="College">
<xs:complexType>
<xs:attribute name="Id" type="xs:string" />
<xs:attribute name="Name" type="xs:string" />
</xs:complexType>
</xs:element>
<xs:element name="Student">
<xs:complexType>
<xs:attribute name="Id" type="xs:string" />
<xs:attribute name="Name" type="xs:string" />
<xs:attribute name="Mark" type="xs:string" />
<xs:attribute name="CollegeId" type="xs:string" />
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>
Outbound Schema:
<?xml version="1.0" encoding="utf-16" ?>
<xs:schema xmlns="http://examLoop3.Schema2"
xmlns:b="http://schemas.microsoft.com/BizTalk/2003"
targetNamespace="http://examLoop3.Schema2"
xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:element name="root">
<xs:complexType>
<xs:sequence>
<xs:element name="College">
<xs:complexType>
<xs:sequence>
<xs:element name="Student">
<xs:complexType>
<xs:attribute name="Id" type="xs:string" />
<xs:attribute name="Name" type="xs:string" />
<xs:attribute name="Mark" type="xs:string" />
<xs:attribute name="CollegeId" type="xs:string" />
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="Id" type="xs:string" />
<xs:attribute name="name" type="xs:string" />
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>
If you have find the mistake one it, please indicate.
Murugan
| |
| Greg Forsythe 2006-05-25, 7:14 am |
| You needed to add the namespaces to the map - see below
Without the source namespace the Xslt is unable to find any of the Xml nodes
in the source document so there is no output.
Greg
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:msxsl="urn:schemas-microsoft-com:xslt"
xmlns:var="http://schemas.microsoft.com/BizTalk/2003/var"
exclude-result-prefixes="msxsl var" version="1.0"
xmlns:s0="http://examLoop3.Schema1"
xmlns:ns0="http://examLoop3.Schema2">
<xsl:output omit-xml-declaration="yes" version="1.0" method="xml" />
<xsl:key name="collegekey" match="/s0:root/Student" use="@CollegeId"/>
<xsl:template match="/">
<xsl:apply-templates select="/s0:root" />
</xsl:template>
<xsl:template match="/s0:root">
<ns0:root>
<xsl:for-each select="Student">
<xsl:variable name="group" select="key('collegekey', @CollegeId)"/>
<xsl:if test="generate-id($group[1]) = generate-id()">
<College>
<xsl:variable name="var:Id" select="@CollegeId"/>
<xsl:attribute name="Id">
<xsl:value-of select="$var:Id"/>
</xsl:attribute>
<xsl:attribute name="name">
<xsl:value-of select="/root/College[@Id = $var:Id]/@Name"/>
</xsl:attribute>
<xsl:for-each select="$group">
<Student>
<xsl:attribute name="Id">
<xsl:value-of select="@Id" />
</xsl:attribute>
<xsl:attribute name="Name">
<xsl:value-of select="@Name" />
</xsl:attribute>
<xsl:attribute name="Mark">
<xsl:value-of select="@Mark" />
</xsl:attribute>
<xsl:attribute name="CollegeId">
<xsl:value-of select="@CollegeId" />
</xsl:attribute>
</Student>
</xsl:for-each>
</College>
</xsl:if>
</xsl:for-each>
</ns0:root>
</xsl:template>
</xsl:stylesheet>
"Murugan" <Murugan@discussions.microsoft.com> wrote in message
news:707926BC-73A2-4798-A1C4-1CCA950A9AC1@microsoft.com...
> Hi Greg Forsythe,
>
> Thanks for reply,
>
> i cann't able to detect the error, because i don't have knowledge in
> Xslt.
> I give the Inbound and Outbound schemas.
>
> Let us consider the inbound and outbound scemas as shown below
>
> Inbound Schema:
>
> <?xml version="1.0" encoding="utf-16" ?>
> <xs:schema xmlns="http://examLoop3.Schema1"
> xmlns:b="http://schemas.microsoft.com/BizTalk/2003"
> targetNamespace="http://examLoop3.Schema1"
> xmlns:xs="http://www.w3.org/2001/XMLSchema">
> <xs:element name="root">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="College">
> <xs:complexType>
> <xs:attribute name="Id" type="xs:string" />
> <xs:attribute name="Name" type="xs:string" />
> </xs:complexType>
> </xs:element>
> <xs:element name="Student">
> <xs:complexType>
> <xs:attribute name="Id" type="xs:string" />
> <xs:attribute name="Name" type="xs:string" />
> <xs:attribute name="Mark" type="xs:string" />
> <xs:attribute name="CollegeId" type="xs:string" />
> </xs:complexType>
> </xs:element>
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> </xs:schema>
>
>
> Outbound Schema:
>
> <?xml version="1.0" encoding="utf-16" ?>
> <xs:schema xmlns="http://examLoop3.Schema2"
> xmlns:b="http://schemas.microsoft.com/BizTalk/2003"
> targetNamespace="http://examLoop3.Schema2"
> xmlns:xs="http://www.w3.org/2001/XMLSchema">
> <xs:element name="root">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="College">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="Student">
> <xs:complexType>
> <xs:attribute name="Id" type="xs:string" />
> <xs:attribute name="Name" type="xs:string" />
> <xs:attribute name="Mark" type="xs:string" />
> <xs:attribute name="CollegeId" type="xs:string" />
> </xs:complexType>
> </xs:element>
> </xs:sequence>
> <xs:attribute name="Id" type="xs:string" />
> <xs:attribute name="name" type="xs:string" />
> </xs:complexType>
> </xs:element>
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> </xs:schema>
>
>
> If you have find the mistake one it, please indicate.
>
> Murugan
| |
| Murugan 2006-05-25, 7:14 am |
| Hi Greg Forsythe,
Thanks for immediate solution,
Great , i got the correct schema. Thanks.
I want to explore the xslt, therefore if you have any reference about the
xslt , please guid.
Thanks
Murugan
|
|
|
|
|