SSDN - XSL to ''normalise" an xml structure

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9

richard potts

Subject: XSL to ''normalise" an xml structure
Author: richard potts
Date: 07 Oct 2004 06:41 AM

Hi everyone,

I'm hoping someone can help me with XSL to transform from a 'non-normalised' xml structure to a 'normalised' xml structure.

E.g. for the element <PIDHex> 2A23 <PIDHex> there are two 'records' in the non normalised xml (but there maybe more than two in other cases).
And I want to extract the common elements to form a single 'record' for <PIDHex> 2A23 <PIDHex> and add any non unique information in a new 'sub tag' called <Bytes>

I include example data files for you to understand.

I'd like to implement this purely in XSL if possible. (I'm using msxml 4)

If it helps the structure could possibly be changed to <PID id ="2A23"service="IO" type="BitMapped" use="Production"> so you only need to look at attributes instead of 'sub-tag values.

Any clues/or suggestions would be much appreciated, as I'm new to xsl

Thanks in advance

Non-Normalised xml

<Generic_Part_II>
<Extract>
<ExtractSourceFileName>P2_59 Blank.xls</ExtractSourceFileName>
<ExtractDate>06 Oct 2004 14:59:31</ExtractDate>
</Extract>
<PIDs>

<PID service="IO" type="BitMapped" use="Production">
<PIDPin>1</PIDPin>
<PIDHex>2A23</PIDHex>
<PIDRange>Vehicle Manufacturer Specific</PIDRange>
<PIDDescription>Spare Wheel Unit Tire Sensor Status</PIDDescription>
<PIDParamNumber>0</PIDParamNumber>
<PIDSize>32</PIDSize>
<PIDBMByte>2</PIDBMByte>
<PIDBMBit>0</PIDBMBit>
<PIDBMBitSequence>16</PIDBMBitSequence>
<PIDBMBitDescription>Tire Temperature Out of Specification</PIDBMBitDescription>
<PIDBMIO>I/P</PIDBMIO>
<PIDBMZero>No (False)</PIDBMZero>
<PIDBMOne>Yes (True)</PIDBMOne>
<PIDDefaultLower>R</PIDDefaultLower>
<PIDExtendedLower>R/W</PIDExtendedLower>
<PIDExtendedUpper>W</PIDExtendedUpper>
<PIDComments>comm</PIDComments>
<ECUApplicablity>
<ECUVariant>1</ECUVariant>
<ECUVariant>2</ECUVariant>
</ECUApplicablity>
</PID>
<PID service="IO" type="BitMapped" use="Production">
<PIDPin>2</PIDPin>
<PIDHex>2A23</PIDHex>
<PIDRange>Vehicle Manufacturer Specific</PIDRange>
<PIDDescription>Spare Wheel Unit Tire Sensor Status</PIDDescription>
<PIDParamNumber>0</PIDParamNumber>
<PIDSize>32</PIDSize>
<PIDBMByte>3</PIDBMByte>
<PIDBMBit>0</PIDBMBit>
<PIDBMBitSequence>8</PIDBMBitSequence>
<PIDBMBitDescription>Tire Pressure Out Of Specification</PIDBMBitDescription>
<PIDBMIO>O/P</PIDBMIO>
<PIDBMZero>No (False)</PIDBMZero>
<PIDBMOne>Yes (True)</PIDBMOne>
<PIDDefaultLower>W</PIDDefaultLower>
<PIDExtendedLower/>
<PIDExtendedUpper/>
<PIDComments/>
<ECUApplicablity/>
</PID>
<PID service="IO" type="SED" use="Production">
<PIDPin>1</PIDPin>
<PIDHex>2A17</PIDHex>
<PIDRange>Vehicle Manufacturer Specific</PIDRange>
<PIDDescription>Rear Left Tire Sensor Wheel Unit Operation Mode</PIDDescription>
<PIDParamNumber>0</PIDParamNumber>
<PIDSize>8</PIDSize>
<PIDSEDValue>01</PIDSEDValue>
<PIDSEDStateDesciption>Driving mode DP driving fast</PIDSEDStateDesciption>
<PIDDefaultLower>R</PIDDefaultLower>
<PIDExtendedLower>R/W</PIDExtendedLower>
<PIDExtendedUpper>W</PIDExtendedUpper>
<PIDComments>comm</PIDComments>
<ECUApplicablity>
<ECUVariant>1</ECUVariant>
<ECUVariant>1</ECUVariant>
</ECUApplicablity>
</PID>
<PID service="IO" type="SED" use="Production">
<PIDPin/>
<PIDHex>2A17</PIDHex>
<PIDRange>Vehicle Manufacturer Specific</PIDRange>
<PIDDescription>Rear Left Tire Sensor Wheel Unit Operation Mode</PIDDescription>
<PIDParamNumber>0</PIDParamNumber>
<PIDSize>8</PIDSize>
<PIDSEDValue>05</PIDSEDValue>
<PIDSEDStateDesciption>ICT test (HW interrupt) & LF</PIDSEDStateDesciption>
<PIDDefaultLower>R</PIDDefaultLower>
<PIDExtendedLower>R/W</PIDExtendedLower>
<PIDExtendedUpper>R</PIDExtendedUpper>
<PIDComments><>"'AA&&</PIDComments>
<ECUApplicablity/>
</PID>
<PID service="IO" type="SED" use="Production">
<PIDPin/>
<PIDHex>2A18</PIDHex>
<PIDRange>Vehicle Manufacturer Specific</PIDRange>
<PIDDescription>Spare Wheel Unit Tire Pressure Status</PIDDescription>
<PIDParamNumber>0</PIDParamNumber>
<PIDSize>8</PIDSize>
<PIDSEDValue>03</PIDSEDValue>
<PIDSEDStateDesciption>Test mode & 135kPa<P<350kPa
& DP parking slow</PIDSEDStateDesciption>
<PIDDefaultLower>W</PIDDefaultLower>
<PIDExtendedLower>W</PIDExtendedLower>
<PIDExtendedUpper>W</PIDExtendedUpper>
<PIDComments/>
<ECUApplicablity/>
</PID>
</PIDs>
</Generic_Part_II>

Normalised - xml
<?xml version="1.0"?>
<ASL>
<PIDs>
<PID service="RW" type="BitMapped" use="Production">
<PIDHex>2A23</PIDHex>
<PIDRange>Vehicle Manufacturer Specific</PIDRange>
<PIDDescription>Spare Wheel Unit Tire Sensor Status</PIDDescription>
<PIDParamNumber>0</PIDParamNumber>
<PIDSize>32</PIDSize>
<Bytes>
<Byte>
<PIDPin>1</PIDPin>
<PIDBMByte>2</PIDBMByte>
<PIDBMBit>0</PIDBMBit>
<PIDBMBitSequence>16</PIDBMBitSequence>
<PIDBMBitDescription>Tire Temperature Out of Specification</PIDBMBitDescription>
<PIDBMIO>I/P</PIDBMIO>
<PIDBMZero>No (False)</PIDBMZero>
<PIDBMOne>Yes (True)</PIDBMOne>
<PIDDefaultLower>R</PIDDefaultLower>
<PIDExtendedLower>R/W</PIDExtendedLower>
<PIDExtendedUpper>W</PIDExtendedUpper>
<PIDProgramLower>N/A</PIDProgramLower>
<PIDProgramUpper>R</PIDProgramUpper>
<PIDComments>comm</PIDComments>
<ECUApplicablity>
<ECUVariant>1</ECUVariant>
<ECUVariant>2</ECUVariant>
</ECUApplicablity>
</Byte>
<Byte>
<PIDPin>2</PIDPin>
<PIDBMByte>3</PIDBMByte>
<PIDBMBit>0</PIDBMBit>
<PIDBMBitSequence>8</PIDBMBitSequence>
<PIDBMBitDescription>Tire Temperature Out of Specification</PIDBMBitDescription>
<PIDBMIO>O/P</PIDBMIO>
<PIDBMZero>No (False)</PIDBMZero>
<PIDBMOne>Yes (True)</PIDBMOne>
<PIDDefaultLower>W</PIDDefaultLower>
<PIDExtendedLower></PIDExtendedLower>
<PIDExtendedUpper></PIDExtendedUpper>
<PIDProgramLower></PIDProgramLower>
<PIDProgramUpper></PIDProgramUpper>
<PIDComments></PIDComments>
<ECUApplicablity></ECUApplicablity>
</Byte>
</Bytes>
</PID>
</PIDs>
</ASL>

Ivan Pedruzzi

Subject: XSL to ''normalise
Author: Ivan Pedruzzi
Date: 11 Oct 2004 12:40 AM

Hi Richard,

The following stylesheet should solve your problem

<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml" indent="yes"/>
<xsl:key name="PID" match="Generic_Part_II/PIDs/PID" use="concat(@service, @type)"/>
<xsl:key name="PID_children" match="Generic_Part_II/PIDs/PID/*" use="concat(../@service, ../@type, name(.), .)"/>

<xsl:template match="/">

<ASL>
<PIDs>

<xsl:apply-templates select="Generic_Part_II/PIDs/PID[ generate-id() = generate-id(key('PID', concat(@service, @type))[1])]"/>
</PIDs>
</ASL>
</xsl:template>

<xsl:template match="PID">
<xsl:copy>
<xsl:copy-of select="@*"/>


<xsl:for-each select="*[count(key('PID_children', concat(../@service, ../@type, name(.), . ))) > 1]">
<xsl:copy-of select="."/>
</xsl:for-each>

<Bytes>
<xsl:for-each select="key('PID', concat(@service, @type))">
<byte>
<xsl:for-each select="*[count(key('PID_children', concat(../@service, ../@type, name(.), . ))) = 1]">
<xsl:copy-of select="."/>
</xsl:for-each>
</byte>
</xsl:for-each>
</Bytes>
</xsl:copy>
</xsl:template>
</xsl:stylesheet>

richard potts

Subject: XSL to ''normalise
Author: richard potts
Date: 12 Oct 2004 06:05 AM

Thanks for your help - it's been useful

Topic Page 1 2 3 4 5 6 7 8 9

Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!

Go to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.