Downloading file from external site

Sivapriya_d — Tue, 11 Sep 2018 05:58:55 GMT

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

Re: Downloading file from external site

andrey_krylov — Tue, 11 Sep 2018 06:22:17 GMT

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