XML XLS related error. using java to parse from xlm to xlm ( rss )

[Sindre Knutsen]

Hey im using a java application to convert a xml form into another xml using xls as the converter. This is the error i get "

ERROR: 'Invalid byte 2 of 3-byte UTF-8 sequence.'
FATAL ERROR: 'Could not compile stylesheet'
The following error occured: Could not compile stylesheet

"


http://pastebin.no/5498 xml http://pastebin.no/5499 xls
here is a link to the xml and xsl. the java application has been tested with other xml/xsl files which is much more simple and it worked. can someone help me?


Thanks

[ May 05, 2008: Message edited by: Sindre Knutsen ]
[ May 05, 2008: Message edited by: Sindre Knutsen ]

[Ben Souther]

"Sindre xtra",
Please check your private messages regarding an important administrative matter.
-Ben

[Paul Clapham]

Your stylesheet doesn't declare any encoding, so it must be encoded in either UTF-8 or UTF-16. For European languages, UTF-8 is more typical. So first of all, is it really encoded in UTF-8?

If so, are you passing the stylesheet to the transformer in such a way that the correct encoding is applied? Bad things to do include using a Reader which uses your system's default encoding (which isn't UTF-8).

[Sindre Knutsen]

i added <?xml version="1.0" encoding="UTF-8"?> to the stylesheet and now im getting this error. Shouldn�t this list Aust-agder?

ERROR: 'Syntax error in 'normalize-space(weatherdata/forecast/text/location name)'.'
FATAL ERROR: 'Could not compile stylesheet'
The following error occured: Could not compile stylesheet

[Paul Clapham]

It's like the error message says, there's a syntax error in that XPath expression. In particular there's a space in the middle of "locationname" which should not be there. XML element names cannot have spaces in them.

[Paul Clapham]

Originally posted by Paul Clapham:
It's like the error message says, there's a syntax error in that XPath expression. In particular there's a space in the middle of "locationname" which should not be there. XML element names cannot have spaces in them.

Edit: looking at your XML, it appears you want the value of the "name" attribute of the "location" element. The XPath way to say that is "location/@name".

In future would you post your code in this forum? It's inconvenient for people to follow links, which is why I didn't understand your question at first. And data in the forum is permanent, whereas data posted elsewhere may not be.