Re: Zipped Files as a Data Source?

If the names of the files are fixed then u can write a batch command for copying and extracting the file, call the batch file in the qvd maker or run it through the scheduler and then load that file in Qlikview.

' Create FileSystemObject so we can use FolderExists and CreateFolder if necessary

Set objfso = CreateObject("Scripting.FileSystemObject")

' Create folder to receive files if it doesn' t already exist

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

' Use CopyHere to extract files

objshell.NameSpace(strFolderName).CopyHere

objshell.NameSpace(strFileName).ItemsSet

objfso = NothingSet objshell = NothingEnd Function

'Put your own zip file name and folder name inside the quotes in the next line

Unzip "C:\Test\Test.zip","C:\Test\Testing"

3

Edit the last line to substitute your own zip file name and folder name for the examples given inside the quotation marks. You can specify an existing folder or not. The script will create the folder if it doesn't already exist.

4

Click "File", "Save As" to open the Save As dialog window. Type "extractzip.vbs" (without the quotes) in the "File Name" box. Select "All Files (*.*)" from the "Save As Type" drop-down. Click the "Save" button to save the new VBS file.

Re: Zipped Files as a Data Source?

Btw. we have developed a component which can read zipped CSV files (e.g. from a FTP server) and it provides this as a web source via URL to QlikView.. So you would not need to do any batch processing, just read the data as from a web source.