Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
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