Trying to load two XML files using XSLT

talnw · Post by **talnw** » Thu Apr 04, 2019 5:28 pm

Hi,

Firstly I must say I'm not a great coder, but I'm here to learn.
The issue I have is I'm not sure how to load different XML files using XSL.

Current setup, after doing some reading.

XML File:

Code: Select all

<?xml version="1.0" encoding="UTF-8"?>

<?xml-stylesheet type="text/xsl" href="information.xsl"?>

<list>

<CL file="branches.xml"/>

<CL file="Services.xml"/>

</list>

The XSL file I have at the moment;

Code: Select all

<?xml version="1.0" encoding="UTF-8"?>

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:template match="/">



  <html>

  <body>

<!-- Branch Information -->

  <table border="0" cellpadding="5">

      <tr bgcolor="#9acd32">

        <th>Branch Letter</th>

        <th>Branch Name</th>

      </tr>

      <xsl:for-each select="node/branch">

	  <tr>

	  	<td><xsl:value-of select="branch_letter"/></td>

		<td><xsl:value-of select="branch_name"/></td>

      </tr>

      </xsl:for-each>

    </table>



<!-- Service Information -->

	<table border="0" cellpadding="5">

      <tr bgcolor="#9acd32">

        <th>Branch</th>

        <th>Port</th>

		<th>Debug</th>

        <th>Target / IP Address</th>

		<th>Assignment / User</th>

      </tr>

      <xsl:for-each select="/node/service">

	  <tr>

	  	<td><xsl:value-of select="branch"/></td>

		<td><xsl:value-of select="port"/></td>

        	<td><xsl:value-of select="debug"/></td>

        	<td><xsl:value-of select="target"/></td>

        	<td><xsl:value-of select="command"/></td>

         </tr>

      </xsl:for-each>

    </table>

  </body>

  </html>

</xsl:template>

</xsl:stylesheet>

If I just use the one xml file, for instance branch.xml below, it loads all the information, using the XSL file.

Code: Select all

<?xml version="1.0" encoding="UTF-8"?>

<?xml-stylesheet type="text/xsl" href="Classic_branches.xsl"?>

<node>

Server-Node

<branch>

<branch_letter>B</branch_letter>

<branch_name>Branch Name</branch_name>

<cli_mas>Branch File 1</cli_mas>

<cli_mas_size>0.30MB</cli_mas_size>

<pol_mas>Branch File 2</pol_mas>

<pol_mas_size>0.35MB</pol_mas_size>

<his_mas>Branch File 3</his_mas>

<his_mas_size>0.35MB</his_mas_size>

<ris_mas>Branch File 4</ris_mas>

<ris_mas_size>0.35MB</ris_mas_size>

<sta_mas>Branch File 5</sta_mas>

<sta_mas_size>25.41MB</sta_mas_size>

</branch>

</node>

So using the XSL file, I want to know how I get can it to read / load the below XML file;

Code: Select all

<?xml version="1.0" encoding="UTF-8"?>

<?xml-stylesheet type="text/xsl" href="Classic_branches.xsl"?>

<node>

Server Node

<service>

<branch>A</branch>

<port>port 1</port>

<debug>N</debug>

<target>xxx.xxx.xxx.xxx</target>

<command>comand_file | user_name</command>

</service>

<service>

<branch>B</branch>

<port>Port 2</port>

<debug>N</debug>

<target>aaa.aaa.aaa.aaa</target>

<command>command_file | user_name</command>

</service>

I'm hoping someone can point me in the right direction, but in the mean time I'll be on www3 schools website, amongst other material I'm finding / reading on the next. Thanks!