6 Replies Latest reply: Jan 16, 2014 10:49 AM by Roberto Postma RSS

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

    Roberto Postma

      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