Ad:

XML, XSLT and XPATH Discussion Thread
Marked Solved
Views: 2931

Sep 15th, 2009

XML to XML via XSL Transform Error...

Expand Post »

Here is a sample of the XML that I am starting with:

XML: any.xml

XML, XSLT and XPATH Syntax (Toggle Plain Text)
<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" href="any.xsl"?>
    <root>
	<device>
		<device_Info>
			<name>Name 1</name>
			<type>Type</type>
		</device_Info>
		<drive_Pair>
			<status>Ready</status>
			<Local>
				<l_name>10E5</l_name>
			</Local>
			<Remote>
				<l_name>0651</l_name>
			</Remote>
		</drive_Pair>
                #Can be 1 or many <drive_Pair>'s
		{<drive_Pair>
			...
		</drive_Pair>}
                # Can only be 1 Totals
		<Totals>
			<Local>
				<l1_invalid_mbs>0.0</l1_invalid_mbs>
				<l2_invalid_mbs>0.0</l2_invalid_mbs>
			</Local>
		</Totals>
	</device>
       #Can be 1 or many <device>'s
	{<device>
               ...
	</device>}
    </root>
<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" href="any.xsl"?>
    <root>
	<device>
		<device_Info>
			<name>Name 1</name>
			<type>Type</type>
		</device_Info>
		<drive_Pair>
			<status>Ready</status>
			<Local>
				<l_name>10E5</l_name>
			</Local>
			<Remote>
				<l_name>0651</l_name>
			</Remote>
		</drive_Pair>
                #Can be 1 or many <drive_Pair>'s
		{<drive_Pair>
			...
		</drive_Pair>}
                # Can only be 1 Totals
		<Totals>
			<Local>
				<l1_invalid_mbs>0.0</l1_invalid_mbs>
				<l2_invalid_mbs>0.0</l2_invalid_mbs>
			</Local>
		</Totals>
	</device>
       #Can be 1 or many <device>'s
	{<device>
               ...
	</device>}
    </root>

XSL: any.xsl

XML, XSLT and XPATH Syntax (Toggle Plain Text)
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
	<xsl:output method="xml" version="1.0" standalone="yes" cdata-section-elements="devices" indent="yes"/>
	<xsl:template match="/root/device">
		<xsl:element name="devices">
			<xsl:for-each select="device_Info">
				<device name="{name}" type="{type}"/>
			</xsl:for-each>
			<xsl:for-each select="drive_Pair">
				<drive_Pair status="{status}" local="{Local/l_name}" remote="{Remote/l_name}"/>
			</xsl:for-each>
			<xsl:for-each select="drive_Pair_Totals/Local">
				<Totals l1="{l1_invalid_mbs}" l2="{l2_invalid_mbs}"/>
			</xsl:for-each>
		</xsl:element>
	</xsl:template>
</xsl:stylesheet>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
	<xsl:output method="xml" version="1.0" standalone="yes" cdata-section-elements="devices" indent="yes"/>
	<xsl:template match="/root/device">
		<xsl:element name="devices">
			<xsl:for-each select="device_Info">
				<device name="{name}" type="{type}"/>
			</xsl:for-each>
			<xsl:for-each select="drive_Pair">
				<drive_Pair status="{status}" local="{Local/l_name}" remote="{Remote/l_name}"/>
			</xsl:for-each>
			<xsl:for-each select="drive_Pair_Totals/Local">
				<Totals l1="{l1_invalid_mbs}" l2="{l2_invalid_mbs}"/>
			</xsl:for-each>
		</xsl:element>
	</xsl:template>
</xsl:stylesheet>

The XML Result: temp.xml

XML, XSLT and XPATH Syntax (Toggle Plain Text)
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<devices>
	<device name="Name 1" type="backup"/>
	<drive_Pair status="same" local="1234" remote="1234"/>
	<drive_Pair status="same" local="4321" remote="4321"/>
	<Totals l1="0.0" l2="0.0"/>
</devices>
<devices>
	<device name="Name 2" type="Active"/>
	<drive_Pair status="different" local="3425" remote="3542"/>
	<drive_Pair status="different" local="0362" remote="9876"/>
        <drive_Pair status="same" local="8767" remote="8767"/>
	<Totals l1="0.0" l2="0.0"/>
</devices>
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<devices>
	<device name="Name 1" type="backup"/>
	<drive_Pair status="same" local="1234" remote="1234"/>
	<drive_Pair status="same" local="4321" remote="4321"/>
	<Totals l1="0.0" l2="0.0"/>
</devices>
<devices>
	<device name="Name 2" type="Active"/>
	<drive_Pair status="different" local="3425" remote="3542"/>
	<drive_Pair status="different" local="0362" remote="9876"/>
        <drive_Pair status="same" local="8767" remote="8767"/>
	<Totals l1="0.0" l2="0.0"/>
</devices>

The issue I am having is when I validate the output XML, temp.xml it comes back with an error that happens right here (line 8 of temp.xml):

XML, XSLT and XPATH Syntax (Toggle Plain Text)
	<Totals l1="0.0" l2="0.0"/>
</devices>
<devices>   #<--------- "Character 'D' is grammatically unexpected"
	<device name="Name 2" type="Active"/>
	<Totals l1="0.0" l2="0.0"/>
</devices>
<devices>   #<--------- "Character 'D' is grammatically unexpected"
	<device name="Name 2" type="Active"/>

It references that the reason for the error is because it expects '!' or '?'.... And I am at a loss on how to "fix" it.

Similar Threads

XML Bug Error. in XML, XSLT and XPATH
converting xml to xsl, formatting just right in XML, XSLT and XPATH
Refresh XML/XSL fails because XML page being updated in XML, XSLT and XPATH
ASP.NET - session objects Problem in ASP.NET
XML + XSL embedded into HTML in XML, XSLT and XPATH

sinnerFA

Reputation Points: 19

Solved Threads: 9

Junior Poster in Training

Offline

70 posts
since Sep 2009

Permalink

Sep 15th, 2009

Re: XML to XML via XSL Transform Error...

An XML document needs exactly one root element. So you should wrap your devices tags in another tag.
See: http://en.wikipedia.org/wiki/Root_element

pritaeas

Sponsor

Featured Poster

Reputation Points: 550

Solved Threads: 731

Bite my shiny metal ass!

Offline

4,177 posts
since Jul 2006

Permalink

Sep 15th, 2009

Re: XML to XML via XSL Transform Error...

XML, XSLT and XPATH Syntax (Toggle Plain Text)
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
	<xsl:output method="xml" version="1.0" standalone="yes" cdata-section-elements="devices" indent="yes"/>
	<xsl:template match="root">
		<devices>
			<xsl:apply-templates select="device"/>
		</devices>
	</xsl:template>
 
	<xsl:template match="device">
		<xsl:apply-templates select="device_Info"/>
		<xsl:apply-templates select="drive_Pair"/>
		<xsl:apply-templates select="Totals"/>
	</xsl:template>
 
 
	<xsl:template match="device_Info">
		<device name="{name}" type="{type}"/>
	</xsl:template>
	<xsl:template match="drive_Pair">
		<drive_Pair status="{status}" local="{Local/l_name}" remote="{Remote/l_name}"/>
	</xsl:template>
 
 
	<xsl:template match="Totals">
		<Totals l1="l1_invalid_mbs" l2="l2_invalid_mbs"/>
	</xsl:template>
</xsl:stylesheet>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
	<xsl:output method="xml" version="1.0" standalone="yes" cdata-section-elements="devices" indent="yes"/>
	<xsl:template match="root">
		<devices>
			<xsl:apply-templates select="device"/>
		</devices>
	</xsl:template>

	<xsl:template match="device">
		<xsl:apply-templates select="device_Info"/>
		<xsl:apply-templates select="drive_Pair"/>
		<xsl:apply-templates select="Totals"/>
	</xsl:template>


	<xsl:template match="device_Info">
		<device name="{name}" type="{type}"/>
	</xsl:template>
	<xsl:template match="drive_Pair">
		<drive_Pair status="{status}" local="{Local/l_name}" remote="{Remote/l_name}"/>
	</xsl:template>


	<xsl:template match="Totals">
		<Totals l1="l1_invalid_mbs" l2="l2_invalid_mbs"/>
	</xsl:template>
</xsl:stylesheet>

xml_looser

Reputation Points: 16

Solved Threads: 21

Junior Poster

Offline

178 posts
since Apr 2009

Permalink

Sep 15th, 2009

Re: XML to XML via XSL Transform Error...

Thanks for both replies, I had setup a rootElement earlier and It kept giving me another error... But thanks for pointing out the obvious and sending an example!

sinnerFA

Reputation Points: 19

Solved Threads: 9

Junior Poster in Training

Offline

70 posts
since Sep 2009

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in XML, XSLT and XPATH Forum Timeline: add xml declaration and namespace to xml output in sql

Next Thread in XML, XSLT and XPATH Forum Timeline: XSLT group size

DaniWeb Message

Cancel Changes

User Name
Password