Creating XSLT for combined data of XML

EDN Admin

EDN Admin

Well-known member
Joined
Aug 7, 2010
Messages
12,794
Location
In the Machine
Hi,
I had posted question about Creating XSLT for Group Data as below :
http://social.msdn.microsoft.com/Forums/en-US/xmlandnetfx/thread/a6952b50-c1ff-4079-a662-2eb83699a438 http://social.msdn.microsoft.com/Forums/en-US/xmlandnetfx/thread/a6952b50-c1ff-4079-a662-2eb83699a438
That got resolved perfectly.
Going forward, I had to combine two xml into one single xml variable.
Now my question is, How can I get the data into my XSLT for the another part of the xml??
Here is my XML till now :

<div style="color:black; background-color:white
<pre><span style="color:blue <<span style="color:#a31515 my<span style="color:blue :<span style="color:#a31515 data <span style="color:red ItemCount<span style="color:blue =<span style="color:black "<span style="color:blue 5<span style="color:black "<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 z<span style="color:blue :<span style="color:#a31515 row <span style="color:red GroupName<span style="color:blue =<span style="color:black "<span style="color:blue Manager"User="User1<span style="color:black " <span style="color:blue />
<span style="color:blue <<span style="color:#a31515 z<span style="color:blue :<span style="color:#a31515 row <span style="color:red GroupName<span style="color:blue =<span style="color:black "<span style="color:blue Developer"User="User2<span style="color:black " <span style="color:blue />
<span style="color:blue <<span style="color:#a31515 z<span style="color:blue :<span style="color:#a31515 row <span style="color:red GroupName<span style="color:blue =<span style="color:black "<span style="color:blue Manager"User="User3<span style="color:black " <span style="color:blue />
<span style="color:blue <<span style="color:#a31515 z<span style="color:blue :<span style="color:#a31515 row <span style="color:red GroupName<span style="color:blue =<span style="color:black "<span style="color:blue CEO"User="User4<span style="color:black " <span style="color:blue />
<span style="color:blue <<span style="color:#a31515 z<span style="color:blue :<span style="color:#a31515 row <span style="color:red GroupName<span style="color:blue =<span style="color:black "<span style="color:blue CEO"User="User5<span style="color:black " <span style="color:blue />
<span style="color:blue </<span style="color:#a31515 my<span style="color:blue :<span style="color:#a31515 data<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Users<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 User <span style="color:red Name <span style="color:blue = <span style="color:black "<span style="color:blue User1<span style="color:black " <span style="color:red ImageName <span style="color:blue = <span style="color:black "<span style="color:blue MainUser/UserPic1<span style="color:black " <span style="color:red Email <span style="color:blue = <span style="color:black "<span style="color:blue User.1@company.com<span style="color:black " <span style="color:blue />
<span style="color:blue <<span style="color:#a31515 User <span style="color:red Name <span style="color:blue = <span style="color:black "<span style="color:blue User2<span style="color:black " <span style="color:red ImageName <span style="color:blue = <span style="color:black "<span style="color:blue NonMainUser/UserPic2<span style="color:black " <span style="color:red Email <span style="color:blue = <span style="color:black "<span style="color:blue User.2@company.com<span style="color:black " <span style="color:blue />
<span style="color:blue <<span style="color:#a31515 User <span style="color:red Name <span style="color:blue = <span style="color:black "<span style="color:blue User3<span style="color:black " <span style="color:red ImageName <span style="color:blue = <span style="color:black "<span style="color:blue MainUser/UserPic3<span style="color:black " <span style="color:red Email <span style="color:blue = <span style="color:black "<span style="color:blue User.3@company.com<span style="color:black " <span style="color:blue />
<span style="color:blue <<span style="color:#a31515 User <span style="color:red Name <span style="color:blue = <span style="color:black "<span style="color:blue User4<span style="color:black " <span style="color:red ImageName <span style="color:blue = <span style="color:black "<span style="color:blue NonMainUser/UserPic4<span style="color:black " <span style="color:red Email <span style="color:blue = <span style="color:black "<span style="color:blue User.4@company.com<span style="color:black " <span style="color:blue />
<span style="color:blue <<span style="color:#a31515 User <span style="color:red Name <span style="color:blue = <span style="color:black "<span style="color:blue User5<span style="color:black " <span style="color:red ImageName <span style="color:blue = <span style="color:black "<span style="color:blue MainUser/UserPic1<span style="color:black " <span style="color:red Email <span style="color:blue = <span style="color:black "<span style="color:blue User.5@company.com<span style="color:black " <span style="color:blue />
<span style="color:blue </<span style="color:#a31515 Users<span style="color:blue >
[/code]

<br/>
Here is my XSLT till now :


<div style="color:black; background-color:white
<pre><span style="color:blue <?<span style="color:#a31515 xml <span style="color:red version<span style="color:blue =<span style="color:black "<span style="color:blue 1.0<span style="color:black " <span style="color:red encoding<span style="color:blue =<span style="color:black "<span style="color:blue utf-8<span style="color:black "<span style="color:blue ?>
<span style="color:blue <<span style="color:#a31515 xsl<span style="color:blue :<span style="color:#a31515 stylesheet <span style="color:red version<span style="color:blue =<span style="color:black "<span style="color:blue 1.0<span style="color:black "
<span style="color:red xmlns:xsl<span style="color:blue =<span style="color:black "<span style="color:blue http://www.w3.org/1999/XSL/Transform<span style="color:black "
<span style="color:red xmlns:my<span style="color:blue =<span style="color:black "<span style="color:blue urn:schemas-microsoft-com:rowset<span style="color:black " <span style="color:red xmlns:z<span style="color:blue =<span style="color:black "<span style="color:blue #RowsetSchema<span style="color:black "<span style="color:blue >

<span style="color:blue <<span style="color:#a31515 xsl<span style="color:blue :<span style="color:#a31515 output <span style="color:red method<span style="color:blue =<span style="color:black "<span style="color:blue html<span style="color:black " <span style="color:red indent<span style="color:blue =<span style="color:black "<span style="color:blue yes<span style="color:black " <span style="color:blue />
<span style="color:blue <<span style="color:#a31515 xsl<span style="color:blue :<span style="color:#a31515 param <span style="color:red name<span style="color:blue =<span style="color:black "<span style="color:blue groups<span style="color:black " <span style="color:red select<span style="color:blue =<span style="color:black "<span style="color:blue //my:data//z:row[not(@GroupName=preceding-sibling::z:row/@GroupName)]<span style="color:black " <span style="color:blue />

<span style="color:blue <<span style="color:#a31515 xsl<span style="color:blue :<span style="color:#a31515 template <span style="color:red match<span style="color:blue =<span style="color:black "<span style="color:blue /<span style="color:black "<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 html<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 body<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 xsl<span style="color:blue :<span style="color:#a31515 for-each <span style="color:red select<span style="color:blue =<span style="color:black "<span style="color:blue $groups<span style="color:black "<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 xsl<span style="color:blue :<span style="color:#a31515 sort <span style="color:red select<span style="color:blue =<span style="color:black "<span style="color:blue @User<span style="color:black " <span style="color:red order<span style="color:blue =<span style="color:black "<span style="color:blue ascending<span style="color:black " <span style="color:blue />
<span style="color:blue <<span style="color:#a31515 xsl<span style="color:blue :<span style="color:#a31515 variable <span style="color:red name<span style="color:blue =<span style="color:black "<span style="color:blue group<span style="color:black " <span style="color:red select<span style="color:blue =<span style="color:black "<span style="color:blue @GroupName<span style="color:black " <span style="color:blue />
<span style="color:blue <<span style="color:#a31515 div <span style="color:red class<span style="color:blue =<span style="color:black "<span style="color:blue my_contactdata<span style="color:black " <span style="color:red id<span style="color:blue =<span style="color:black "<span style="color:blue 074a0fb0-e68c-4699-a22f-7366efd63f58<span style="color:black "<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 div <span style="color:red class<span style="color:blue =<span style="color:black "<span style="color:blue my_contactdata_group<span style="color:black "<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 div <span style="color:red class<span style="color:blue =<span style="color:black "<span style="color:blue group<span style="color:black "<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 div <span style="color:red class<span style="color:blue =<span style="color:black "<span style="color:blue name<span style="color:black "<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 h3<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 xsl<span style="color:blue :<span style="color:#a31515 apply-templates <span style="color:red select<span style="color:blue =<span style="color:black "<span style="color:blue @GroupName<span style="color:black " <span style="color:blue />
<span style="color:blue </<span style="color:#a31515 h3<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 div<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 div <span style="color:red class<span style="color:blue =<span style="color:black "<span style="color:blue my_contactdata_person<span style="color:black "<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 div <span style="color:red class<span style="color:blue =<span style="color:black "<span style="color:blue my_contactdata_basic<span style="color:black "<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 table <span style="color:red cellpadding<span style="color:blue =<span style="color:black "<span style="color:blue 0<span style="color:black " <span style="color:red cellspacing<span style="color:blue =<span style="color:black "<span style="color:blue 0<span style="color:black " <span style="color:red border<span style="color:blue =<span style="color:black "<span style="color:blue 0<span style="color:black "<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 tbody<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 tr<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 tr<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 td <span style="color:red class<span style="color:blue =<span style="color:black "<span style="color:blue my_contactdata_person_name<span style="color:black "<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 div <span style="color:red class<span style="color:blue =<span style="color:black "<span style="color:blue items<span style="color:black "<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 xsl<span style="color:blue :<span style="color:#a31515 for-each <span style="color:red select<span style="color:blue =<span style="color:black "<span style="color:blue //my:data/z:row[@GroupName=$group]<span style="color:black "<span style="color:blue >

<span style="color:blue <<span style="color:#a31515 div <span style="color:red class<span style="color:blue =<span style="color:black "<span style="color:blue item<span style="color:black "<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 span<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 img <span style="color:red border<span style="color:blue =<span style="color:black "<span style="color:blue 0<span style="color:black " <span style="color:red height<span style="color:blue =<span style="color:black "<span style="color:blue 12<span style="color:black " <span style="color:red src<span style="color:blue =<span style="color:black "<span style="color:blue /_layouts/images/imnhdr.gif<span style="color:black " <span style="color:red onload<span style="color:blue =<span style="color:black "<span style="color:blue IMNRC(FirstName.LastName@Company.com)<span style="color:black " <span style="color:red ShowOfflinePawn<span style="color:blue =<span style="color:black "<span style="color:blue 1<span style="color:black " <span style="color:red alt<span style="color:blue =<span style="color:black "<span style="color:blue <span style="color:black " <span style="color:red id<span style="color:blue =<span style="color:black "<span style="color:blue user_presence_icon<span style="color:black " <span style="color:blue />
<span style="color:blue </<span style="color:#a31515 span<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 xsl<span style="color:blue :<span style="color:#a31515 apply-templates <span style="color:red select<span style="color:blue =<span style="color:black "<span style="color:blue @User<span style="color:black " <span style="color:blue />
<span style="color:blue </<span style="color:#a31515 div<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 xsl<span style="color:blue :<span style="color:#a31515 for-each<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 div<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 td<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 tr<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 tr<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 tbody<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 table<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 div<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 div <span style="color:red class<span style="color:blue =<span style="color:black "<span style="color:blue my_contactdata_details<span style="color:black " <span style="color:red style<span style="color:blue =<span style="color:black "<span style="color:blue display: none;<span style="color:black "<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 table <span style="color:red cellpadding<span style="color:blue =<span style="color:black "<span style="color:blue 3<span style="color:black " <span style="color:red cellspacing<span style="color:blue =<span style="color:black "<span style="color:blue 0<span style="color:black " <span style="color:red border<span style="color:blue =<span style="color:black "<span style="color:blue 0<span style="color:black "<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 tbody<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 tr<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 td <span style="color:red align<span style="color:blue =<span style="color:black "<span style="color:blue left<span style="color:black " <span style="color:red valign<span style="color:blue =<span style="color:black "<span style="color:blue top<span style="color:black " <span style="color:red class<span style="color:blue =<span style="color:black "<span style="color:blue my_contactdata_details_photo<span style="color:black "<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 Image <span style="color:red runat<span style="color:blue =<span style="color:black "<span style="color:blue server<span style="color:black " <span style="color:red ImageUrl<span style="color:blue =<span style="color:black "<span style="color:blue http://www.something.com/WhichUser_WhichPic.png" AlternateText="<span style="color:black " <span style="color:blue />
<span style="color:blue </<span style="color:#a31515 td<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 td <span style="color:red align<span style="color:blue =<span style="color:black "<span style="color:blue left<span style="color:black " <span style="color:red valign<span style="color:blue =<span style="color:black "<span style="color:blue top<span style="color:black " <span style="color:red class<span style="color:blue =<span style="color:black "<span style="color:blue my_contactdata_details_info<span style="color:black "<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 div <span style="color:red class<span style="color:blue =<span style="color:black "<span style="color:blue my_contactdata_details_info_title<span style="color:black "<span style="color:blue >Designation<span style="color:blue </<span style="color:#a31515 div<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 div <span style="color:red class<span style="color:blue =<span style="color:black "<span style="color:blue my_contactdata_details_info_email<span style="color:black "<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 a <span style="color:red href<span style="color:blue =<span style="color:black "<span style="color:blue mailto:FirstName.LastName@Company.com<span style="color:black "<span style="color:blue >FirstName.LastName@Company.com<span style="color:blue </<span style="color:#a31515 a<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 div<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 div <span style="color:red class<span style="color:blue =<span style="color:black "<span style="color:blue my_contactdata_details_info_status<span style="color:black "<span style="color:blue >Last Status<span style="color:blue </<span style="color:#a31515 div<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 td<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 tr<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 tbody<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 table<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 div<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 div<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 div<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 div<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 div<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 xsl<span style="color:blue :<span style="color:#a31515 for-each<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 body<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 html<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 xsl<span style="color:blue :<span style="color:#a31515 template<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 xsl<span style="color:blue :<span style="color:#a31515 stylesheet<span style="color:blue >
[/code]


<br/>
My Questions:
1. How can I replace <strong style="white-space:pre FirstName.LastName@Company.com <strong style="white-space:pre
with the email id of current user from XML data in
<span style="white-space:pre 1.1 onload="IMNRC(<strong style="white-space:pre FirstName.LastName@Company.com )" function
<span style="white-space:pre 1.2 mailto:<strong style="white-space:pre FirstName.LastName@Company.com <strong style="white-space:pre FirstName.LastName@Company.com
2. How can replace the value of WhichUser and
WhichPic with current users value?

The XML node User contains the value of <strong style="white-space:pre FirstName.LastName@Company.com, WhichUser
and WhichPic.
Please help!!
Thanks
<
https://twitter.com/#!/NaimishPandya @NaimishPandya |
mailto:pandya.naimish@hotmail.com Email | http://www.linkedin.com/in/naimishpandya
LinkedIn | http://naimishpandya.wordpress.com/ My Blog <br/>
<br/>

View the full article
 
Back
Top