topic Re: Loading Data from web page in QlikView

Loading Data from web page

mambi — Thu, 09 Mar 2017 10:07:00 GMT

Hello everyone,

I'm using QV11 desktop and I'm trying to load data from a simple web page (Table) : List of countries by motor vehicle production - Wikipedia‌

but i got this error : Internet error 12157

i assume it's an error related to the https

any one have an idea on how to solve this problem ?

Thanks

Re: Loading Data from web page

avinashelite — Thu, 09 Mar 2017 12:48:17 GMT

it not the error related to QV check this

How to resolve internet errors 12157/12057/12045?

Re: Loading Data from web page

mambi — Thu, 09 Mar 2017 13:11:35 GMT

but when I try with an other site without https it's works

Re: Loading Data from web page

avinashelite — Thu, 09 Mar 2017 14:08:53 GMT

It depends on the site security features ...did you tried as per the above article ? did the issue got resolved ?

Re: Loading Data from web page

mambi — Thu, 09 Mar 2017 14:36:53 GMT

I haven't found a real solution in this article

Re: Loading Data from web page

adamdavi3s — Thu, 09 Mar 2017 14:43:02 GMT

This runs absolutely fine for me which suggests it must be something to do with your network I guess:

LOAD Rank,

Country,

"2015 [2]",

"2014 [3]",

"2013 [4]",

"2012 [5]",

"2011 [6][7]",

"2010 [7][8]",

"2005 [9]",

"2000 [10][11]",

"1995 [11][12]",

"1990 [13][14][15]",

"1980 [13][14][15][16]",

"1970 [13][14][15][16]",

"1960 [13][14][15][16]",

"1950 [13][14]",

"Peak production [13][14][11][17][12][15]",

"Peak year [13][14][11][17][12][15]"

FROM

[https://en.wikipedia.org/wiki/List_of_countries_by_motor_vehicle_production]

(html, codepage is 1252, embedded labels, table is @1);

Re: Loading Data from web page

mambi — Thu, 09 Mar 2017 14:54:41 GMT

if I use your script I got this error :

Re: Loading Data from web page

adamdavi3s — Thu, 09 Mar 2017 14:57:34 GMT

loading locally or loading from the server?

where ever you're loading from, can you access that page in I.E.?

Re: Loading Data from web page

mambi — Thu, 09 Mar 2017 15:09:40 GMT

I'm loading locally,

your are right I can't access this page from IE

Re: Loading Data from web page

adamdavi3s — Thu, 09 Mar 2017 15:13:24 GMT

I suspected that would be the case, its some network issue then I am afraid

Re: Loading Data from web page

mambi — Thu, 09 Mar 2017 15:20:20 GMT

I'm chekcking with our IT manager

Re: Loading Data from web page

avinashelite — Thu, 09 Mar 2017 15:22:17 GMT

Ok , if you have got the answers mark the helpful and correct answers and close this thread