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

[Joris Gillis]

Hi,

Tempore 17:38:45, die Thursday 28 July 2005 AD, hinc in foro {comp.text.xml} scripsit Rolf Barbakken <no******@alexa ndria.cc>:

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

Where am I going wrong?

The error message sais it all: you're trying to access an element "c:v" but you didn't declare the namespace that goes with "c". Just add the correct "xmlns:c" attribute to an ancestor-or-self of the "xsl:value-of" element.

regards,
--
Joris Gillis (http://users.telenet.be/root-jg/me.html)
Vincit omnia simplicitas
Keep it simple

[Rolf Barbakken]

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

Hi,

Tempore 17:38:45, die Thursday 28 July 2005 AD, hinc in foro
{comp.text.xml} scripsit Rolf Barbakken <no******@alexa ndria.cc>:

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

Where am I going wrong?

The error message sais it all: you're trying to access an element "c:v"
but you didn't declare the namespace that goes with "c". Just add the
correct "xmlns:c" attribute to an ancestor-or-self of the "xsl:value-of"
element.

I thought so too, so I tried

xmlns:c="c:"

and

<xsl:for-each select="a:props tat/a:prop/f:professioncod e/c:v">
<xsl:value-of select="concat( ., ',')"/>
</xsl:for-each>

Is this right?

With this code I get even less than before (no professioncodes at all), but
no error.

--
_______________ __
Rolf @ Questus ans

[Joris Gillis]

Tempore 20:54:06, die Thursday 28 July 2005 AD, hinc in foro {comp.text.xml} scripsit Rolf Barbakken <no******@alexa ndria.cc>:

The error message sais it all: you're trying to access an element "c:v"
but you didn't declare the namespace that goes with "c". Just add the
correct "xmlns:c" attribute to an ancestor-or-self of the "xsl:value-of"
element.

I thought so too, so I tried

xmlns:c="c:"

Obviously, the namespace-uri (between the quotes) has to be the same as the one declared in the source XML; it is not dummy data. "c:" is a very unlikely uri...
regards,
--
Joris Gillis (http://users.telenet.be/root-jg/me.html)
Vincit omnia simplicitas
Keep it simple

[Rolf Barbakken]

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

Tempore 20:54:06, die Thursday 28 July 2005 AD, hinc in foro
{comp.text.xml} scripsit Rolf Barbakken <no******@alexa ndria.cc>:

The error message sais it all: you're trying to access an element "c:v"
but you didn't declare the namespace that goes with "c". Just add the
correct "xmlns:c" attribute to an ancestor-or-self of the "xsl:value-of"
element.

I thought so too, so I tried

xmlns:c="c:"

Obviously, the namespace-uri (between the quotes) has to be the same as
the one declared in the source XML; it is not dummy data. "c:" is a very
unlikely uri...

Well I've tried what looks like the correct namespace-uri:

xmlns:c="cln-ewa:standard:pr ofessioncode:"

and then:

<xsl:for-each select="a:props tat/a:prop/c:v">
<xsl:value-of select="concat( ., ',')"/>
</xsl:for-each>

But nothing comes out of it (no professioncode) . You can see the structure
in my xml in the OP.

--
_______________ __
Rolf @ Questus ans

[Joris Gillis]

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

xmlns:c="cln-ewa:standard:pr ofessioncode:"

and then:

<xsl:for-each select="a:props tat/a:prop/c:v">
<xsl:value-of select="concat( ., ',')"/>
</xsl:for-each>

But nothing comes out of it (no professioncode) .

That's pretty logical: there's no location step for 'professioncode '

INPUT XML:
<a:multistatu s
xmlns:a="DAV:"
xmlns:b="unknow n"
xmlns:c="cln-ewa:standard:pr ofessioncode:"
xmlns:d="urn:sc hemas:contacts: "
xmlns:e="cln-ewa:custom:"
xmlns:f="cln-ewa:standard:">
<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>
</a:multistatus>

XSLT:
<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:b="unknow n"
xmlns:c="cln-ewa:standard:pr ofessioncode:"
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/e:professioncod e/c:v">
<xsl:value-of select="concat( ., ',')" />
</xsl:for-each>
<xsl:text> </xsl:text>
</xsl:for-each>
</xsl:template>

</xsl:stylesheet>

OUTPUT :
1049306 byggtapetserarb eider,malerarbe ider,
I only just thought about this: Do you need all data of type 'multivalue strings' to be seperated by comma's? If so, it's better to use a template:

<xsl:styleshe et version="1.0"
xmlns:a="DAV:"
xmlns:b="unknow n"
xmlns:c="cln-ewa:standard:pr ofessioncode:"
xmlns:d="urn:sc hemas:contacts: "
xmlns:e="cln-ewa:custom:"
xmlns:f="cln-ewa:standard:"
xmlns:xsl="http ://www.w3.org/1999/XSL/Transform">
<xsl:output method="text"/>
<xsl:template

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:apply-templates select="a:props tat/a:prop/e:professioncod e"/>
<xsl:text> </xsl:text>
</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:stylesheet>

That will give you following output:
1049306 byggtapetserarb eider,malerarbe ider


regards,
--
Joris Gillis (http://users.telenet.be/root-jg/me.html)
Vincit omnia simplicitas
Keep it simple

[Rolf Barbakken]

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

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

xmlns:c="cln-ewa:standard:pr ofessioncode:"

and then:

<xsl:for-each select="a:props tat/a:prop/c:v">
<xsl:value-of select="concat( ., ',')"/>
</xsl:for-each>

But nothing comes out of it (no professioncode) . That's pretty logical: there's no location step for 'professioncode '

INPUT XML:
<a:multistatu s
xmlns:a="DAV:"
xmlns:b="unknow n"
xmlns:c="cln-ewa:standard:pr ofessioncode:"
xmlns:d="urn:sc hemas:contacts: "
xmlns:e="cln-ewa:custom:"
xmlns:f="cln-ewa:standard:">
<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>
</a:multistatus>

XSLT:
<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:b="unknow n"
xmlns:c="cln-ewa:standard:pr ofessioncode:"
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/e:professioncod e/c:v">
<xsl:value-of select="concat( ., ',')" />
</xsl:for-each>
<xsl:text> </xsl:text>
</xsl:for-each>
</xsl:template>

</xsl:stylesheet>

OUTPUT :
1049306 byggtapetserarb eider,malerarbe ider,

I get no professioncode with this code.
I only just thought about this: Do you need all data of type 'multivalue
strings' to be seperated by comma's? If so, it's better to use a template:

<xsl:styleshe et version="1.0"
xmlns:a="DAV:"
xmlns:b="unknow n"
xmlns:c="cln-ewa:standard:pr ofessioncode:"
xmlns:d="urn:sc hemas:contacts: "
xmlns:e="cln-ewa:custom:"
xmlns:f="cln-ewa:standard:"
xmlns:xsl="http ://www.w3.org/1999/XSL/Transform">
<xsl:output method="text"/>
<xsl:template

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:apply-templates select="a:props tat/a:prop/e:professioncod e"/>
<xsl:text> </xsl:text>
</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:stylesheet>

That will give you following output:
1049306 byggtapetserarb eider,malerarbe ider

This returns absolutely nothing. Not one single byte of data. But no error.

The entire xsl now looks like this:
<xsl:styleshe et version="1.0"
xmlns:a="DAV:"
xmlns:b="unknow n"
xmlns:c="cln-ewa:standard:pr ofessioncode:"
xmlns:d="urn:sc hemas:contacts: "
xmlns:e="cln-ewa:custom:"
xmlns:f="cln-ewa:standard:"
xmlns:xsl="http ://www.w3.org/1999/XSL/Transform">
<xsl:output method="text"/>
<xsl:template
match="/">
<xsl:for-each select="a:multi status/a:response">
<xsl:text></xsl:text>
<xsl:text> </xsl:text>
<xsl:text></xsl:text>
<xsl:text> </xsl:text>
<xsl:value-of select="a:props tat/a:prop/d:sn"/>
<xsl:text> </xsl:text>
<xsl:value-of select="transla te(a:propstat/a:prop/d:street,
' ', ' ')"/>
<xsl:text> </xsl:text>
<xsl:value-of select="transla te(a:propstat/a:prop/d:postalcode,
' ', '')"/>
<xsl:text> </xsl:text>
<xsl:value-of select="a:props tat/a:prop/d:l"/>
<xsl:text> </xsl:text>
<xsl:value-of select="a:props tat/a:prop/d:officetelepho nenumber"/>
<xsl:text> </xsl:text>
<xsl:value-of select="a:props tat/a:prop/d:telephoneNumb er"/>
<xsl:text> </xsl:text>
<xsl:value-of select="a:props tat/a:prop/d:mobile"/>
<xsl:text> </xsl:text>
<xsl:value-of select="a:props tat/a:prop/d:email1"/>
<xsl:text> </xsl:text>
<xsl:value-of select="a:props tat/a:prop/d:customerid"/>
<xsl:text> </xsl:text>
<xsl:value-of select="a:props tat/a:prop/f:contacturl"/>
<xsl:text> </xsl:text>
<xsl:value-of select="a:props tat/a:prop/d:facsimiletele phonenumber"/>
<xsl:text> </xsl:text>
<xsl:value-of select="a:props tat/a:prop/a:creationdate"/>
<xsl:text> </xsl:text>
<xsl:value-of select="a:props tat/a:prop/d:department"/>
<xsl:text> </xsl:text>
<xsl:text></xsl:text>
<xsl:text> </xsl:text>
<xsl:value-of select="a:props tat/a:prop/f:deleted"/>
<xsl:text> </xsl:text>
<xsl:value-of select="a:props tat/a:prop/f:maker"/>
<xsl:text> </xsl:text>
<xsl:value-of select="a:props tat/a:prop/f:work"/>
<xsl:text> </xsl:text>
<xsl:text></xsl:text>
<xsl:text> </xsl:text>
<xsl:value-of select="a:props tat/a:prop/f:ssn"/>
<xsl:text> </xsl:text>
<xsl:text></xsl:text>
<xsl:text> </xsl:text>
<xsl:value-of select="a:props tat/a:prop/f:visitadr"/>
<xsl:text> </xsl:text>
<xsl:value-of select="a:props tat/a:prop/d:businesshomep age"/>
<xsl:text> </xsl:text>
<xsl:value-of select="a:props tat/a:prop/e:agressoid"/>
<xsl:text> </xsl:text>
<xsl:value-of select="a:props tat/a:prop/e:agressoinitia ls"/>
<xsl:text> </xsl:text>
<xsl:value-of select="a:props tat/a:prop/d:homeState"/>
<xsl:text> </xsl:text>
<xsl:value-of select="a:props tat/a:prop/f:contactikon"/>
<xsl:text> </xsl:text>
<xsl:value-of select="a:props tat/a:prop/f:customergroup "/>
<xsl:text> </xsl:text>
<xsl:value-of select="a:props tat/a:prop/e:contactperson "/>
<xsl:text> </xsl:text>
<xsl:value-of select="a:props tat/a:prop/f:projects"/>
<xsl:text> </xsl:text>
<xsl:value-of select="a:props tat/a:prop/e:agressonew"/>
<xsl:text> </xsl:text>
<xsl:value-of select="a:props tat/a:prop/e:extagressoid"/>
<xsl:text> </xsl:text>
<xsl:value-of select="a:props tat/a:prop/e:foretn"/>
<xsl:text> </xsl:text>
<xsl:value-of select="a:props tat/a:prop/f:mycontact"/>
<xsl:text> </xsl:text>
<xsl:value-of select="a:props tat/a:prop/f:activeproject s"/>
<xsl:text> </xsl:text>
<xsl:value-of select="a:props tat/a:prop/f:contacted"/>
<xsl:text> </xsl:text>
<xsl:value-of select="a:props tat/a:prop/a:contentclass"/>
<xsl:text> </xsl:text>
<xsl:apply-templates select="a:props tat/a:prop/e:professioncod e"/>
<xsl:text> </xsl:text>
</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:stylesheet>

I really appreciate the help.

--
_______________ __
Rolf @ Questus ans

[Joris Gillis]

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

This returns absolutely nothing. Not one single byte of data. But no error.

I bet it's still a namespace issue.
Anyway, this conversation is leading nowhere. The XML sample in the OP was incomplete, I had to make to much assumptions.
Please provide the full XML (maybe a link to it?).

BTW, You don't need to copy everything I write litteraly;)
e.g. if I write xmlns:b="unknow n" that means I do not posses enough information to make write the proper namespace-uri. You should have corrected it.

I hope we can soon fix this...
regards,
--
Joris Gillis (http://users.telenet.be/root-jg/me.html)
Vincit omnia simplicitas
Keep it simple

[Rolf Barbakken]

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

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

This returns absolutely nothing. Not one single byte of data. But no
error.

I bet it's still a namespace issue.
Anyway, this conversation is leading nowhere. The XML sample in the OP was
incomplete, I had to make to much assumptions.
Please provide the full XML (maybe a link to it?).

I have sent you an email. Hope the address is correct.

--
_______________ __
Rolf @ Questus ans

[Joris Gillis]

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.

<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>

regards,
--
Joris Gillis (http://users.telenet.be/root-jg/me.html)
Vincit omnia simplicitas
Keep it simple