Transform boolean and enumerated XML data

ovjrao · May 23rd, 2012, 05:27 PM

Hello,

I'm new to XSLT and would appreciate help transforming the below XML data that I'm trying to convert to CSV format. The first 2 fields are converting fine, however dynamicFlag and SelMode are returning blanks.

XML:

<CDR>
<DRTA>
<callType>11</callType>
<callTime>1108251352422</callTime>
<dynamicFlag><true/></dynamicFlag>
<SelMode><servingLinkSupplied/></SelMode>
</DRTA>
</CDR>

XSL:
<?xml version='1.0'?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
<xsl:output method="text"/>
<xsl:strip-space elements = "CDR"/>
<xsl:template match="/CDR/DRTA">"<xsl:value-of select="normalize-space(/CDR/DRTA/callType)"/>","<xsl:value-of select="normalize-space(/CDR/DRTA/callTime)"/>","<xsl:value-of select="normalize-space(/CDR/DRTA/dynamicFlag)"/>","<xsl:value-of select="normalize-space(/CDR/DRTA/SelMode)"/>"
</xsl:template>
</xsl:stylesheet>

mhkay · May 23rd, 2012, 05:44 PM

You haven't said what you want to output for these two elements. You're currently trying to output the string value, which is empty. If you want to output the name of the contained element, use

Code:

<xsl:value-of select="name(/CDR/DRTA/dynamicFlag/*)"/>

ovjrao · May 23rd, 2012, 05:53 PM

Hi Michael,

Thank you for your response. I'd like the output to be

"11","1108251352422","true","servingLinkSuppli ed"

or

"11","1108251352422","1","1" (if I can somehow transform "true" and "servingLinkSupplied" to 1)

Much Thanks again,
-Vijay

samjudson · May 24th, 2012, 10:25 AM

If you are in a template matching against /CDR/DRTA then you don't need the /CDR/DRTA in from of every value of instruction (in fact if you had more than one DRTA element this would produce something I am sure you wouldnt want).

Also, if you want to transform a particular element into something else then use a apply-templates rather than a value-of and have other templates to handle the transformation.

Code:

<xsl:template match="/CDR/DRTA">"<xsl:value-of select="normalize-space(callType)"/>","<xsl:value-of select="normalize-space(callTime)"/>","<xsl:apply-template select="dynamicFlag"/>","<xsl:apply-template select="SelMode"/>"
</xsl:template>

<xsl:template match="dynamicFlag/true">1</xsl:template>
<xsl:template match="dynamicFlag/false">0</xsl:template>
<xsl:template match="SelMode/servingLinkSupplied">1</xsl:template>

ovjrao · May 24th, 2012, 05:15 PM

Sam,

Thanks for your response. I tried your suggestion for the first boolean field and received the below error

SystemId Unknown; Line #-1; Column #-1; XSLT Error (javax.xml.transform.TransformerConfigurationExcep tion): javax.xml.transform.TransformerException: javax.xml.transform.TransformerException: xsl:apply-template is not allowed in this position in the stylesheet!

Code:

<?xml version='1.0'?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
<xsl:output method="text"/>
<xsl:strip-space elements = "CDR"/>
<xsl:template match="/CDR/DRTA">"<xsl:value-of select="normalize-space(callType)"/>","<xsl:value-of select="normalize-space(callTime)"/>","<xsl:>","<xsl:apply-template select="dynamicFlag"/>",)"/>","<xsl:value-of select="normalize-space(SelMode)"/>"
</xsl:template>

<xsl:template match="dynamicFlag/true">1</xsl:template>
<xsl:template match="dynamicFlag/false">0</xsl:template>
</xsl:stylesheet>

mhkay · May 24th, 2012, 06:50 PM

Typo: it's xsl:apply-templates.

We put typos in our answers deliberately, it forces people to pore over the code and try to understand it, which helps them learn the language and reduces the number of questions they ask in the future. Sometimes.

ovjrao · May 25th, 2012, 12:06 AM

That worked like a charm. Thank you very much.

One more question - is there a way to convert sets of data that are missing a parent node but otherwise XML compliant? I had to go through some hoops to create an entirely new file just to add a parent node (to use XSLT) but was curious if there is a better way to process the below XML example without an enclosing parent node.

Code:

<CDR>
   <TagA1>
      <TagB>
         <TagC>
         </TagC>
      </TagB>
  </TagA1>
</CDR>

<CDR>
   <TagA2>
      <TagB>
         <TagD>
         </TagD>
      </TagB>
  </TagA2>
</CDR>

Thank you again.
Vijay

mhkay · May 25th, 2012, 04:01 AM

It's best to post a new question on a new thread.

The way that most people tackle XML with multiple top level elements is to treat it as an external parsed entity, and copy it into a wrapper document like this example of mine:

Code:

<!DOCTYPE orders [
<!ENTITY e SYSTEM "orderlog.xml">
]>
<?xml-stylesheet href="report.xsl" type="text/xsl"?>
<orders>&e;</orders>

The wrapper document can then be presented to the parser.

ovjrao · June 19th, 2012, 02:07 PM

why does the below xsl code returns duplicate records when converting to csv ?

The number of output records matches with number of XML blocks but the csv values are duplicate (from the first xml block).

Code:

<?xml version='1.0'?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
<xsl:output method="text"/>
<xsl:strip-space elements = "CDR"/>
<xsl:template match="/CDR/DRTA">"<xsl:value-of select="normalize-space(callType)"/>","<xsl:value-of select="normalize-space(callTime)"/>","<xsl:>","<xsl:apply-templates select="dynamicFlag"/>",)"/>","<xsl:value-of select="normalize-space(SelMode)"/>"
</xsl:template>

<xsl:template match="dynamicFlag/true">1</xsl:template>
<xsl:template match="dynamicFlag/false">0</xsl:template>
</xsl:stylesheet>

ovjrao · June 19th, 2012, 03:39 PM

I was able to figure it out myself. Much Thanks.