Hi Guys!
I have replaced Andy Bonsey here and as such I need to maintain his workflows. I have run into an issue with the XSLT Transform tool - which seems to glitch out when the character "é" is translated into "é".
Has anyone experienced this kind of think before? I have pinned it down to the XSLT Transform tool by adding loads of holds and stepping through the flow and im 99% sure its down to that element.
Any thoughts at all?
Thanks in advance!!
XSLT - special characters
-
- Member
- Posts: 94
- Joined: Fri Jul 08, 2011 10:31 am
- Location: The Netherlands
Re: XSLT - special characters
Hi
Sounds like an encoding issue.
Maybe you can play around with some different encoding-settings in the xslt or in de xml?
Robert
Sounds like an encoding issue.
Maybe you can play around with some different encoding-settings in the xslt or in de xml?
Code: Select all
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"/>
Re: XSLT - special characters
If the XML originates on a Windows machine you might need to encode the XSLT as iso-8859-1
Re: XSLT - special characters
I'm not too familiar with how these XML transforms work... I totally understand what you mean about encoding and i'm sure thats the case - but i'm not sure how to fix it! The first few lines of my xsl look like this:
What can I add in there to encode it in a different way?
EDIT: I have tried to add the header bits in as per Robert's suggestion but it didnt seem to do anything at all...
Thanks in advance!!
Code: Select all
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="text"/>
<xsl:template match="/"><xsl:text>"OrderID",
EDIT: I have tried to add the header bits in as per Robert's suggestion but it didnt seem to do anything at all...
Thanks in advance!!
Re: XSLT - special characters
It is the definition of the encoding of the input XML that is important. That is what tells the XSLT processor how to interpret the incoming XML.
The default is UTF-8, so that is what will be used when the declaration line is missing. But if it is not UTF-8 you will have to have a declaration line with the correct encoding. What that correct encoding is I cannot tell for sure, but as Jan suggested it might be iso-8859-1 in which case the declaration line has to be this:
Code: Select all
<?xml version="1.0" encoding="UTF-8"?>
Code: Select all
<?xml version="1.0" encoding="iso-8859-1"?>
Re: XSLT - special characters
Hi! Thanks for your reply!
I have tried a few different encodings but it doesnt seem to be making a difference - do you know if there is a way I can find out specifically what encoding I need to use?
Thanks in advance!
I have tried a few different encodings but it doesnt seem to be making a difference - do you know if there is a way I can find out specifically what encoding I need to use?
Thanks in advance!
Re: XSLT - special characters
I have been digging into this and it seems you can use Sublime text to show the current encoding of a file.
I have done this to the file in question - and it appears to be <?xml version="1.0" encoding="windows-1252"?>. I have replaced the other encoding line in the XSL - but it sends the job to the problem folder - "Message: Can't parse XSLT stylesheet 'C:/Users/switch/xxx'
Any ideas at all?!
Thanks!!
I have done this to the file in question - and it appears to be <?xml version="1.0" encoding="windows-1252"?>. I have replaced the other encoding line in the XSL - but it sends the job to the problem folder - "Message: Can't parse XSLT stylesheet 'C:/Users/switch/xxx'
Any ideas at all?!
Thanks!!
Re: XSLT - special characters
XML Transform is not a good tool, it is outdated. And it probably don't understand "windows-1252"
You should use Saxonica instead, it is up to date and can use XSLT 2.0 and 3.0. XML Transform only support XSLT 1.0
There is a free version of Saxonica that you download and then connect it to the Saxonica configurator.
You should use Saxonica instead, it is up to date and can use XSLT 2.0 and 3.0. XML Transform only support XSLT 1.0
There is a free version of Saxonica that you download and then connect it to the Saxonica configurator.
Re: XSLT - special characters
Yeah I think at this point I have all my encoding lined up as it should - its just outdated.
Thanks for the suggestion - I will take a look!
Thanks for the suggestion - I will take a look!