How to merge XML (with XSLT?)

[Victor (6)]

Hi, this might sound silly but I cannot figure out how to incorporate some XML of employees into some XML of a company to give new XML containing them all.

For example, this is the company now

<COMPANY>
<EMPLOYEE currentEmployee="true">
<NAME>Victor</NAME>
<AGE>37</AGE>
</EMPLOYEE>
</COMPANY>

And this is other XML that I want to add to the company

<EMPLOYEE currentEmployee="true">
<NAME>Thomas</NAME>
<AGE>39</AGE>
</EMPLOYEE>

<EMPLOYEE currentEmployee="false">
<NAME>Violeta</NAME>
<AGE>34</AGE>
</EMPLOYEE>

And the XML I want to generate is

<COMPANY>

<EMPLOYEE currentEmployee="true">
<NAME>Victor</NAME>
<AGE>37</AGE>
</EMPLOYEE>

<EMPLOYEE currentEmployee="true">
<NAME>Thomas</NAME>
<AGE>39</AGE>
</EMPLOYEE>

<EMPLOYEE currentEmployee="false">
<NAME>Violeta</NAME>
<AGE>34</AGE>
</EMPLOYEE>

</COMPANY>

I think I should be using XSLT but just cannot figure out the syntax. Could someone help me out with what the XSLT should look like for this example (if it is XSLT I should be using)?

Thank you again everyone for your help.
Regards
Victor

 

[Derek Harmon]

Hi, this might sound silly but I cannot figure out how to incorporate some XML of employees into some XML of a company to give new XML containing them all. : :
And this is other XML that I want to add to the company : :
<EMPLOYEE currentEmployee="true">
<NAME>Thomas</NAME>
<AGE>39</AGE>
</EMPLOYEE>

<EMPLOYEE currentEmployee="false">
<NAME>Violeta</NAME>
<AGE>34</AGE>
</EMPLOYEE>

Given each of these EMPLOYEE elements are in their own XML instance document,

- - - merger.xsl
<?xml version="1.0" ?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0"> <!-- Receives the file name of the document containing the employee to add.
-->
<xslaram name="employeeUrl" />

<!-- Your sample excludes an XML declaration, and is indented, so this tells the XSLT processor to emit the same way.
-->
<xslutput omit-xml-declaration="yes" indent="yes"/>

<!-- Copies verbatim any elements or attributes not explicitly matched by another template rule.
-->
<xsl:template match="@*|node">
<xsl:copy>
<xsl:apply-templates select="@*|node"/>
</xsl:copy>
</xsl:template>

<!-- Matches the source XML document's root node. This template rule re-emits the source XML but appends the document element of the XML instance document passed into the employeeUrl before emitting the closing COMPANY tag.
-->
<xsl:template match="/">
<COMPANY>
<xsl:apply-templates select="COMPANY/EMPLOYEE" />
<xsl:if test="$employeeUrl">
<xsl:apply-templates select="document($employeeUrl)/EMPLOYEE" /> </xsl:if> </COMPANY> </xsl:template>

</xsl:stylesheet>
- - -

On the other hand, if all of the EMPLOYEE elements are in one XML instance document, then they must be contained in a document element, i.e.,

<EMPLOYEES>
<EMPLOYEE> <!-- . . . --> </EMPLOYEE>
<EMPLOYEE> <!-- . . . --> </EMPLOYEE>
</EMPLOYEES>

because an XML instance document can have only one top-level document element. If this is the case, then the above XSLT transform requires a minor revision.

: :

I think I should be using XSLT but just cannot figure out the syntax. Could someone help me out with what the XSLT should look like for this example (if it is XSLT I should be using)?

Sure, see the above. It can be done in XSLT, but as always, there are 33 ways to skin an armadillo (if for some reason, you want to skin an armadillo).

If you want to see a solution written in VB.NET to a very similar problem, that does not involve any XSLT whatsoever, please see my reply in the following newsgroup thread (watch for line-wrap in the hyperlink),

http://groups.google.com/groups?selm=Ohfss2C#[email protected]&oe=UTF-8&output=gplain

Hope this has been of help,

Derek Harmon