topic Create new folder in script in QlikView

Create new folder in script

Thu, 10 Nov 2011 11:51:45 GMT

Hello,

I need to create a new folder in the script to store my QVD-files.

Can anybody help me?

Create new folder in script

Thu, 10 Nov 2011 12:35:17 GMT

Hello,

as far as I understand you try this to create a new directory within a load-script before storing some qvd-files into it:

EXECUTE cmd.exe /C mkdir C:\mydir

HtH

Roland

Re: Create new folder in script

Alexander_Thor — Thu, 10 Nov 2011 13:02:39 GMT

Or you could create a macro that you call from your loadscript.

Macro-code below.

Function CreateFolder(Path, Name) 
Dim objFSO, Folder
Set FSO = CreateObject("Scripting.FileSystemObject")
Set Folder = FSO.CreateFolder(Path & "\" & Name)
Set FSO = Nothing
Set Folder = Nothing
End Function

Then call this function from your loadscript with,

LET Execute = CreateFolder('C:\Temp', 'New');

Please make sure that you allow system access in your macro.

I know Publisher has had a bit of problems executing macros upon reloads, bit it is worth a try
Make sure the user running publisher has file system access and you might need to enable that the server are allowed to execute unsafe macros.