problem with xsl for multivalue strings

[Rolf Barbakken]

I have an xml with records like this one:

<a:response>
<a:href>http://server/public/sol/comp/1049306.eml</a:href>
<a:propstat>
<a:status>HTT P/1.1 200 OK</a:status>
<a:prop>
<d:customerid>1 049306</d:customerid>
<e:professionco de b:dt="mv.string ">
<c:v>byggtapets erarbeider</c:v>
<c:v>malerarbei der</c:v>
</e:professioncod e>
</a:prop>
</a:propstat>
</a:response>

I want to display this tab-separated and have this xsl:
<?xml version="1.0"?>
<xsl:styleshe et version="1.0"
xmlns:xsl="http ://www.w3.org/1999/XSL/Transform">
<xsl:output method="text"/>
<xsl:template
xmlns:a="DAV:"
xmlns:d="urn:sc hemas:contacts: "
xmlns:e="cln-ewa:custom:"
xmlns:f="cln-ewa:standard:"
match="/">
<xsl:for-each select="a:multi status/a:response">
<xsl:value-of select="a:props tat/a:prop/d:customerid"/>
<xsl:text> </xsl:text>
<xsl:for-each select="a:props tat/a:prop/f:professioncod e/c:v">
<xsl:value-of select="concat( ., ',')" />
</xsl:for-each>
<xsl:text> </xsl:text>
</xsl:for-each>
</xsl:template>
</xsl:stylesheet>

I have no problem getting the customerid, but without a "for-each" the
professioncode always comes out as a single string with no separation like
this:

byggtapetserarb eidermalerarbei der,

With the "for-each" I get this error:
msxml4.dll: Reference to undeclared namespace prefix: 'c'.

Where am I going wrong?

--
_______________ __
Rolf @ Questus ans

[Rolf Barbakken]

"Joris Gillis" <ro**@pandora.b e> wrote in message
news:op******** *******@news.pa ndora.be...

Tempore 22:04:55, die Friday 29 July 2005 AD, hinc in foro {comp.text.xml}
scripsit Rolf Barbakken <no******@alexa ndria.cc>:

Here's the sylesheet, it does not look very neat, but at least it works.

How did you test it?

I get nothing out of this xsl-file. The XML fills up nicely, but when I do a

objXMLDOM.trans formNode(objXSL DOM)

the result is nothing.

The XSL:
<xsl:styleshe et xmlns:xsl="http ://www.w3.org/1999/XSL/Transform"
version="1.0"
xmlns:b="urn:uu id:c2f41010-65b3-11d1-a29f-00aa00c14882/"
xmlns:f="cln-ewa:custom:"
xmlns:c="xml:"
xmlns:g="urn:sc hemas-microsoft-com:office:offi ce"
xmlns:e="cln-ewa:standard:"
xmlns:d="urn:sc hemas:contacts: "
xmlns:a="DAV:">
<xsl:output method="text"/>
<xsl:template
match="/">
<xsl:for-each select="a:multi status/a:response">
<xsl:for-each select="(a:prop stat/a:prop)[1]">
<xsl:text></xsl:text>
<xsl:text> </xsl:text>
<xsl:text></xsl:text>
<xsl:text> </xsl:text>
<xsl:apply-templates select="d:sn"/>
<xsl:text> </xsl:text>
<xsl:apply-templates select="d:stree t"/>
<xsl:text> </xsl:text>
<xsl:apply-templates select="d:posta lcode"/>
<xsl:text> </xsl:text>
<xsl:apply-templates select="d:l"/>
<xsl:text> </xsl:text>
<xsl:apply-templates select="d:offic etelephonenumbe r"/>
<xsl:text> </xsl:text>
<xsl:apply-templates select="d:telep honeNumber"/>
<xsl:text> </xsl:text>
<xsl:apply-templates select="d:mobil e"/>
<xsl:text> </xsl:text>
<xsl:apply-templates select="d:email 1"/>
<xsl:text> </xsl:text>
<xsl:apply-templates select="d:custo merid"/>
<xsl:text> </xsl:text>
<xsl:apply-templates select="f:conta cturl"/>
<xsl:text> </xsl:text>
<xsl:apply-templates select="d:facsi miletelephonenu mber"/>
<xsl:text> </xsl:text>
<xsl:apply-templates select="a:creat iondate"/>
<xsl:text> </xsl:text>
<xsl:apply-templates select="d:depar tment"/>
<xsl:text> </xsl:text>
<xsl:text></xsl:text>
<xsl:text> </xsl:text>
<xsl:apply-templates select="f:delet ed"/>
<xsl:text> </xsl:text>
<xsl:apply-templates select="f:maker "/>
<xsl:text> </xsl:text>
<xsl:apply-templates select="f:work"/>
<xsl:text> </xsl:text>
<xsl:text></xsl:text>
<xsl:text> </xsl:text>
<xsl:apply-templates select="f:ssn"/>
<xsl:text> </xsl:text>
<xsl:text></xsl:text>
<xsl:text> </xsl:text>
<xsl:apply-templates select="f:visit adr"/>
<xsl:text> </xsl:text>
<xsl:apply-templates select="d:busin esshomepage"/>
<xsl:text> </xsl:text>
<xsl:apply-templates select="e:agres soid"/>
<xsl:text> </xsl:text>
<xsl:apply-templates select="e:agres soinitials"/>
<xsl:text> </xsl:text>
<xsl:apply-templates select="d:homeS tate"/>
<xsl:text> </xsl:text>
<xsl:apply-templates select="f:conta ctikon"/>
<xsl:text> </xsl:text>
<xsl:apply-templates select="f:custo mergroup"/>
<xsl:text> </xsl:text>
<xsl:apply-templates select="e:conta ctperson"/>
<xsl:text> </xsl:text>
<xsl:apply-templates select="f:proje cts"/>
<xsl:text> </xsl:text>
<xsl:apply-templates select="e:agres sonew"/>
<xsl:text> </xsl:text>
<xsl:apply-templates select="e:extag ressoid"/>
<xsl:text> </xsl:text>
<xsl:apply-templates select="e:foret n"/>
<xsl:text> </xsl:text>
<xsl:apply-templates select="f:mycon tact"/>
<xsl:text> </xsl:text>
<xsl:apply-templates select="f:activ eprojects"/>
<xsl:text> </xsl:text>
<xsl:apply-templates select="f:conta cted"/>
<xsl:text> </xsl:text>
<xsl:apply-templates select="a:conte ntclass"/>
<xsl:text> </xsl:text>
<xsl:apply-templates select="e:profe ssioncode"/>
<xsl:text> </xsl:text>
</xsl:for-each>
</xsl:for-each>
</xsl:template>
<xsl:template match="*[@b:dt='mv.strin g']/*[position() !=last()]">
<xsl:value-of select="." /><xsl:text>,</xsl:text>
</xsl:template>
<xsl:template match="d:street ">
<xsl:value-of select="transla te(., ' ', ' ')" />
</xsl:template>
<xsl:template match="d:postal code">
<xsl:value-of select="transla te(., ' ', '')" />
</xsl:template>
</xsl:stylesheet>
--
_______________ __
Rolf @ Questus ans

[Joris Gillis]

This one's nicer:
<xsl:styleshe et xmlns:xsl="http ://www.w3.org/1999/XSL/Transform"
version="1.0"
xmlns:b="urn:uu id:c2f41010-65b3-11d1-a29f-00aa00c14882/"
xmlns:f="cln-ewa:custom:"
xmlns:c="xml:"
xmlns:g="urn:sc hemas-microsoft-com:office:offi ce"
xmlns:e="cln-ewa:standard:"
xmlns:d="urn:sc hemas:contacts: "
xmlns:a="DAV:">
<xsl:output method="text"/>

<xsl:variable name="field">
<xsl:text> d:sn d:street d:postalcode d:l d:officetelepho nenumber d:telephoneNumb er d:mobile d:email1 d:customerid f:contacturl d:facsimiletele phonenumber a:creationdate d:department f:deleted f:maker f:work f:ssn f:visitadr d:businesshomep age e:agressoid e:agressoinitia ls d:homeState f:contactikon f:customergroup e:contactperson f:projects e:agressonew e:extagressoid e:foretn f:mycontact f:activeproject s f:contacted a:contentclass e:professioncod e</xsl:text>
</xsl:variable>

<xsl:template match="/">
<xsl:for-each select="a:multi status/a:response">
<xsl:for-each select="(a:prop stat/a:prop)[1]">
<xsl:call-template name="fieldCrea tor"/>
<xsl:text> </xsl:text>
</xsl:for-each>
</xsl:for-each>
</xsl:template>

<xsl:template name="fieldCrea tor">
<xsl:param name="fields" select="concat( $field,' ')"/>
<xsl:apply-templates select="*[name()=substrin g-before($fields, ' ')]"/>
<xsl:if test="substring-after($fields,' ')">
<xsl:text> </xsl:text>
<xsl:call-template name="fieldCrea tor">
<xsl:with-param name="fields" select="substri ng-after($fields,' ')"/>
</xsl:call-template>
</xsl:if>
</xsl:template>

<xsl:template match="*[@b:dt='mv.strin g']/*[position() !=last()]">
<xsl:value-of select="." /><xsl:text>,</xsl:text>
</xsl:template>

<xsl:template match="d:street ">
<xsl:value-of select="transla te(., ' ', ' ')" />
</xsl:template>

<xsl:template match="d:postal code">
<xsl:value-of select="transla te(., ' ', '')" />
</xsl:template>

</xsl:stylesheet>

P.S. Watch out for wrapping. The data of <xsl:variable name="field"/> should all be on 1 line.
--
Joris Gillis (http://users.telenet.be/root-jg/me.html)
Vincit omnia simplicitas
Keep it simple