Downloading file from external site

[Sivapriya_d]

Hi All,

I am trying to download a specific file from website. My requirement is to download the file from website and place it in Share folder.

Is it possible in QlikView? Can any one help me on this??

Thanks,

Siva

[andrey_krylov]

Hi, Sivapriya. I know exactly, that you can download a file via FTP using macro

Function FtpFile(vType, vWebSite, vUserName, vPassword, vLocalFolder, vRemoutFolder, vFileName)

  Dim oShell : Set oShell = CreateObject("Wscript.Shell")

  Dim vftp : vftp = "FTP.ftp"

  With CreateObject("Scripting.FileSystemObject")

   With .CreateTextfile(vftp, True)

     .WriteLine "open " & vWebSite

     .WriteLine "user " & vUserName

     .WriteLine  vPassword

     .WriteLine "binary"

     .WriteLine "lcd " & vLocalFolder

     .WriteLine "cd " & vRemouFolder

     .WriteLine vType & vFileName

     .WriteLine "Close"

     .WriteLine "Quit"

     .Close

   End With

   oShell.Run "ftp.exe -i -n -s:" & vftp, 0, True

   .DeleteFile vftp

  End With

  End Function

or download a webpage with macro as well.

set xmlhttp = CreateObject ("msxml2.xmlhttp.3.0")

xmlhttp.open "get", "YourURL" , false

xmlhttp.send

vText = xmlhttp.responseText