Converting XML data

When exporting data from MIIS 2003, (for example, using a tool such as CSexport.exe), it is often preferable to convert the XML output to a format that is easier to present and read, for example, a comma-separated value file (.csv) format. XML data can be converted by use of XSL transforms, and the utility MSXSL.exe. MSXSL.exe, along with documentation and examples, can be downloaded from the Microsoft Web site. (http://www.microsoft.com/)

The following sample XSL transforms can be used as templates for your own customized transforms.

• This transform outputs XML to a CSV format:
  
  <?xml version="1.0" ?>
- <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml" indent="yes" encoding="ISO-8859-1" omit-xml-declaration="yes" />
- <xsl:template match="text()">
<xsl:copy-of select="." />
,
</xsl:template>
</xsl:stylesheet>

• This transform will select and display particular nodes:
  
  <?xml version="1.0" ?>
- <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
<xsl:output method="text" />
- <xsl:template match="cs-object">
<xsl:value-of select="normalize-space(@ cs-dn)" />
,
<xsl:value-of select="normalize-space(ma-name)" />
,
<xsl:value-of select="normalize-space(synchronized-hologram/entry/primary-objectclass)" />
,
</xsl:template>
</xsl:stylesheet>