Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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);
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!
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);
See attached.
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
Thanks a lot!!
I didn't know that it was possible to send the credentials this way. This helps me out!
we only have qliksense cloud... can you paste the load script code in here?