Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How ti unzip Flat file(.CSV) from FTP server to Qlikview Server.

Hi Community,

I am fetching zip file from FTP server to Qlikview Server.

I have refer Qlikview Community link and i have written code in VBS script but it showing error

I have refer blow link -

Re: Zipped Files as a Data Source?

I have written below code in my VB file -

Function Unzip(strFileName,strFolderName)

Dim objshell

Dim objfso

Set objshell = CreateObject("Shell.Application")

Set objfso = CreateObject("Scripting.FileSystemObject")

If Not objfso.FolderExists(strFolderName) Then objfso.CreateFolder strFolderName

objshell.NameSpace(strFolderName).CopyHere

objshell.NameSpace(strFileName).Items

Set objfso = Nothing

Set objshell = Nothing

End Function

Unzip "D:\Ishwar Data\D\Ishwar\Qlikview\MY Pract\Data\Zip_Folder\Zip_Folder.zip","D:\Ishwar Data\D\Ishwar\Qlikview\MY Pract\Data\UnZip_Folder"

When i run this script it showing below error -

VBS script Error .jpg

How to resolve this issue?

Thanks in advance.

0 Replies