Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register 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