topic Web file wizard does not accept Unicode characters in QlikView

Web file wizard does not accept Unicode characters

francescopuppin — Tue, 15 Jan 2013 16:32:09 GMT

Hi,

if I put this string in the Web file wizard

http://maps.google.com/maps/geo?q=Krakow&output=xml&oe=utf8&sensor=false&key=XXYYZZ

it will give me a nice and clean output.

But if I put this string, the wizard tells me "invalid character" and fails, because of the ó character.

http://maps.google.com/maps/geo?q=Kraków&output=xml&oe=utf8&sensor=false&key=XXY

But, funny thing: if you click on the socond link from here, google does actually accept it and resolve it! So, it is a problem of the wizard.

I would gladly replace the ó with o, but I have a loop with thousands of cities from the world, with too many characters to replace (óo,íi,łl,źz,żz,ýy,áa,ęe,îi,ěe,ée, etc..)

Can anyone tell me how to configure the wizard to accept Unicode characters, or any other way to solve the problem?

Thanks

Re: Web file wizard does not accept Unicode characters

Gysbert_Wassenaar — Tue, 15 Jan 2013 19:00:22 GMT

I had IE8 which showed the same error when I opened your second url. Then I upgraded to IE9 and the error is gone in both IE9 itself and in Qlikview. So, try upgrading to IE9 if you can.

It would be very nice if Qlikview allowed us to choose which browser (engine) to use, but it seems we're stuck with microsofts no-standards-supported-here browser..

edit:

Ah, I see what happened. I copied the url instead of the text of the url. When I copied the url it was properly encoded:

http://maps.google.com/maps/geo?q=Krak%C3%B3w&output=xml&oe=utf8&sensor=false

As far as I know the standard for url's does not allow non-ascii characters in urls. See here also.

So, try encoding the url properly if it isn't already.

Re: Web file wizard does not accept Unicode characters

francescopuppin — Mon, 21 Jan 2013 01:38:28 GMT

Hi Gysbert,

the browser does not give me any error. As I wrote above, if you click on the link with the ó character, google resolves it with perfectly.

The problem is in Qlikview: the wizard of Qlikview does not accept Unicode characters, and it gives an error message even before sending the request to the browser. Any idea how to solve this?

Thanks

Re: Web file wizard does not accept Unicode characters

francescopuppin — Thu, 24 Jan 2013 17:00:38 GMT

Hi,

but where do I find the proper encoding?

I mean, how do I know that ó corresponds to %C3%B3?

I have 4200 locations to search on Google, and each of them potentially contains one or more forbidden characters... Is there a mapping table somewhere?

And I repeat, again... despite the fact that the ó character is forbidden for the URL, the URL works fine!

If you copy this string and paste it into your browser, it works OK!

So, the question is: if it's OK as a URL for the brwser, why it is not ok for the Qlikview wizard?

http://maps.google.com/maps/geo?q=Kraków&output=xml&oe=utf8&sensor=false&key=XXY