topic Re: Creating directories in QlikView Script in QlikView

Creating directories in QlikView Script

chrisbrain — Fri, 22 Jul 2011 11:37:49 GMT

Is it possible to create directories in QlikView script?

I would like to store daily QVD dumps of data in a subfolder based on the year month and say, e.g.

2011\7\22\MyQvd.qvd

But I need to generate these folders on a daily basis.

Re: Creating directories in QlikView Script

Fri, 22 Jul 2011 12:48:34 GMT

i think it will work with a macro look here for synatx http://www.wisesoft.co.uk/scripts/vbscript_create_folder.aspx

Re: Creating directories in QlikView Script

chrisbrain — Fri, 22 Jul 2011 14:00:47 GMT

Thanks - I did think about macros but preferred to avoid it if possible - doesn't sound like it is though!

Re: Creating directories in QlikView Script

danielrozental — Fri, 22 Jul 2011 14:05:20 GMT

Chris, if you use the execute command you can ran any DOS command like mkdir.

execute mkdir directory

Re: Creating directories in QlikView Script

chrisbrain — Fri, 22 Jul 2011 15:22:42 GMT

Ah interesting!

OK so I am trying this:

execute mkdir c:\test;

But keep getting:

Script line error:

execute mkdir c:\test

The command works fine via a command prompt. Any ideas what I am missing?

Creating directories in QlikView Script

swuehl — Fri, 22 Jul 2011 15:28:23 GMT

mkdir is a command line command.

try

Execute cmd.exe /C mkdir c:\test

Stefan

Re: Creating directories in QlikView Script

martin59 — Fri, 22 Jul 2011 15:30:50 GMT

Hi,

You have to allow the macro override security in the document properties (security tab)

After that, you can also try something like that :

EXECUTE mspaint;

Hope that helps you

Martin

Re: Creating directories in QlikView Script

danielrozental — Fri, 22 Jul 2011 15:34:29 GMT

Sorry, right syntax should be

execute cmd.exe /c mkdir c:\test;

Creating directories in QlikView Script

chrisbrain — Sat, 23 Jul 2011 06:52:45 GMT

Thanks all!

Execute cmd.exe /C mkdir c:\test

Works.

Martin - I think the check box you show in your screen shot is only for code in the macro module (not load script) - I think the correct check box is the 'Can Execute Externam Programs' in the Settings tab of the load script.

Re: Creating directories in QlikView Script

Mon, 17 Mar 2014 16:09:35 GMT

Here is a syntax to create a new folder in the same location of the QVW :

EXECUTE cmd.exe /C mkdir QVD;

Thanks.

Re: Creating directories in QlikView Script

Mon, 17 Mar 2014 16:24:58 GMT

Of course, this syntaxe does not work exactly as it should be. If the drive is local, no problem. If the location is a network folder, it does not work anymore.

If i execute this command outside qlikview, it works. So an idea should be getting the path of the qvw, and build an instruction like :

EXECUTE cmd.exe /C mkdir variable\QVD;

with variable = Y:\folder\sub_folder\...\

De toute façon, ça sort du périmètre QlikView, ce sont des instructions windows.