Multiple XML files... one output.

[querry]

Hi all, I hve a requirement wherein I have two XML files to be used as input to a XSLT transformation Style sheet. One of the XML files is used as a Template and te other is used as a data. As an example the below files can be used

template.xml

<?xml version="1.0" encoding="utf-8"?>
   <Table>
            <TR>
                   <TD/>
                   <TD/>
             </TR>
   </Table>

Values.xml

<?xml version="1.0" encoding="utf-8"?>
   <Value>Some text</Value>
   <Value>Some text2</Value>
 

I want to pass these two XML files to a XSLT and get a XML file as Below

actual.xml

<?xml version="1.0" encoding="utf-8"?>
<Table>
   <TR>
          <TD>some text</TD>
          <TD>some text2</TD>
   </TR>
</Table>

To make it more difficult I need to pull out the input files form a database.

I am using C# and VS2005.

Please help me with some example code.

Thanks and regards.

[jkmyoung]

Inside the xslt, use the document function to access the second xml file:

See http://www.w3schools.com/xsl/func_document.asp

Note, may also have to set the transformation to allow for the document function, as the processor will create a URIResolver in order to find the second document.

--
If necessary, you could create a parameter inside the xslt, and pass that to the document function.
<xsl:param name="template"/>
...
<xsl:apply-templates select="document($template)"/>

--
Could you explain more as to how the values and template mesh together? Do you replace each <td/> with a value?

Also note that the first file is not valid xml, as it has more than one root. Create a container element surrounding the 2 values.

[querry]

hi jkmyoung,

Thanks for your reply.

I read the article you referred me to. I understand that the document() Function needs a XML file to be present on the Disk. I am pulling out the XML files from the database I use the 'XPathDocument' which provides a fast, forward-only, in-memory representation of the XML document.

How do I work around this?? I mean I can't and I don't want to save the pulled up XML files to the disk. I other words I want them to be present in the memory and still be accessible to the XSLT style sheet.

Also note that the first file is not valid xml, as it has more than one root. Create a container element surrounding the 2 values.

Couldn't understand that though. I use it and it works fine in the VS2005. If you think its wrong please let me know what the correct form should look like.

If you are talknig about the Values.xml above. have just typed it in short. The actual file is much bigger.

Values.xml

<?xml version="1.0" encoding="utf-8"?>
<Values>
         <Value>Some text</Value>
         <Value>Some text2</Value>
</Values>

Could you explain more as to how the values and template mesh together? Do you replace each <td/> with a value?

I have typed <td/> as it is a empty element. Actually it is <td></td> and I want the value between the <value></value> tags to be placed in between the <td></td> tags. Some thing like this.

<td></td> + <value>Sone text</value> = <td>Some text</td>

Hope you understand.

Thanks again.

[querry]

Hi all,

After waiting for long I decided to modify the question.

I want to use the document() function of the xslt to pull up a particular value of a attribute form a external xml document and assign the value to a attribute in the document being transformed.

How can I do that??

XML Document Under Transformation:

<Tag1>
         <Tag2>
                <Tag3 val=""></Tag3>
         </Tag2>
</Tag1>

External XML Document:

<Values>
       <Value1 val="Some Value"></Value>
</Values> 

[jkmyoung]

Sorry, haven't been able to check these forums in awhile.

Using a standard copy xslt with modifications to replace val attribute:

<xsl:template match="*">
<xsl:copy>
  <xsl:apply-templates select="@*"/>
  <xsl:apply-templates"/>
</xsl:copy>
</xsl:template>
<xsl:template match="@val">
  <xsl:attribute name="val">
    <xsl:value-of select="document()/Values/Value1/@val"/>
  </xsl:attribute>
</xsl:template>
<xsl:template match="@*">
  <xsl:copy-of select="."/>
</xsl:template>

Or if you want to copy multiple values:

<xsl:template match="@val">
  <xsl:variable name="position" select="count(preceding::@val)"/>
  <xsl:attribute name="val">
    <xsl:value-of select="document()//@val[count(preceding::@val)=$position]"/>
  </xsl:attribute>
</xsl:template>
 

[querry]

Thanks a lot jkmyoung. This works perfectly. The second code snippet was what I was looking for.