Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

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

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

1 Solution

Accepted Solutions
iktrayanov
Contributor III

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

try this

LOAD @1,

     @2,

     @3

FROM

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

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

5 Replies
Not applicable

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

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!

iktrayanov
Contributor III

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

try this

LOAD @1,

     @2,

     @3

FROM

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

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

iktrayanov
Contributor III

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

See attached.

jaimeaguilar
Valued Contributor II

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

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

Not applicable

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

Thanks a lot!!

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