topic How to a .csv file load from a password protected internet location? in QlikView

How to a .csv file load from a password protected internet location?

Sun, 12 Jan 2014 19:05:13 GMT

Hi Qlik-community!

I need to load a bunch of .csv files that are located on an internet resource. I know I can load them with this simall peace of code:

Working load

LOAD id,
     test1,
     test2
FROM
[http://www.rpostma.com/qvtestt/qvtest.csv]
(txt, codepage is 1252, embedded labels, delimiter is ';', msq);

My question is, how I can load exactly this same test-file from a password-protected location.

Load that does NOT work

LOAD id,
     test1,
     test2
FROM
[http://www.rpostma.com/qvtest/qvtest.csv]
(txt, codepage is 1252, embedded labels, delimiter is ';', msq);

As visible in my test-code, I prepared a testfile in 2 different folders (qvtestt (working) and qvtest, not working).

When these below mentioned links are opened in a webbrowser, the 2nd (and NOT working) URL requires a password.

- http://www.rpostma.com/qvtestt/qvtest.csv

- http://www.rpostma.com/qvtest/qvtest.csv

My questions are these

- [Question 1]: Can the load-script be modified to include the username/password?

- [Question 2]: If not, what would be the best way to load these files into Qlikview (perhaps via a Macro? Or another approach? And in that case, could you give a working example for how it works?

The username / password for the password-protected url is:

- user name: qvtest

- password: qvtest

I'm curious about what's possible. Thanks in advance for your contributions!

Roberto

Re: How to a .csv file load from a password protected internet location?

Tue, 14 Jan 2014 15:40:49 GMT

Anyone?

Also if it is NOT possible in Qlikview, it is interesting for me to know. I however have the feeling that there is some way to fix this.

Relevant references or links are also very welcome!

Re: How to a .csv file load from a password protected internet location?

iktrayanov — Wed, 15 Jan 2014 21:30:49 GMT

try this

LOAD @1,

@2,

FROM

[http://qvtest:qvtest@www.rpostma.com/qvtest/qvtest.csv qvtest@www.rpostma.com/qvtest/qvtest.csv]

(txt, codepage is 1252, no labels, delimiter is ';', msq);

Re: Re: How to a .csv file load from a password protected internet location?

iktrayanov — Wed, 15 Jan 2014 21:34:28 GMT

See attached.

Re: How to a .csv file load from a password protected internet location?

jaimeaguilar — Wed, 15 Jan 2014 23:53:43 GMT

Hi,

sometime ago I wanted to extract information from a password protected URL: However, at that time I couldn't find a suitable answer. I thought the only way was to develop a custom connector.

I didn't know it was that easy,

thanks

regards

Re: How to a .csv file load from a password protected internet location?

Thu, 16 Jan 2014 15:49:10 GMT

Thanks a lot!!

I didn't know that it was possible to send the credentials this way. This helps me out!

Re: Re: How to a .csv file load from a password protected internet location?

mama25macs — Tue, 20 Oct 2020 12:43:35 GMT

we only have qliksense cloud... can you paste the load script code in here?