topic check if directory exists in QlikView

check if directory exists

Thu, 23 Jul 2009 15:43:08 GMT

Hi all,

is there a way to check if a directory exists? and if it doens't exist create the directory?

thanks in advance 🙂

Rey-man

check if directory exists

Thu, 23 Jul 2009 15:58:50 GMT

Try this:

sub createFolder

newfolder = "E:\QVApplications\QVTest\newone"
set fso = CreateObject("Scripting.FileSystemObject")
If Not fso.FolderExists(newfolder) Then
Set newfolder = fso.CreateFolder(newfolder)
End If

end sub

Regards,

Gordon

check if directory exists

Thu, 23 Jul 2009 16:16:06 GMT

Hi Gordon,

its not working the way it want it i guess. This looks like a macro. I want it in the load script.

I fill in the tablename and description manually. Based on the name, it should create the directory. (see LET vDir)


LET vDir = 'D:\QlikView Storage\Private Data\Source Documents\Data\SAP ECC\$(vNaam)\';

SET fso = CreateObject("Scripting.FileSystemObject")
IF NOT fso.FolderExists('$(vDir)') THEN
 SET newfolder = fso.CreateFolder('$(vDir)')

 '$(vNaam)':
 LOAD
 *

 ;
 SQL SELECT *
 FROM $(vNaam)
 ;

 //STORE $(vNaam) INTO ../Data/SAP ECC/New/$(vDesc)$(vQVD_ECC_version)$(vVersionNumber)$(vWeek)$(Year).qvd;
 STORE $(vNaam) INTO $(vDir)$(vNaam)_$(vDesc)$(vQVD_ECC_version)$(vVersionNumber)$(vWeek)$(Year).qvd;
 DROP TABLE $(vNaam);

End If

Hope its clear what im trying to say.

Regards,

Rey-man

check if directory exists

Thu, 23 Jul 2009 19:01:06 GMT

You can create the function in your macro and execute the function during the script reload

LET CreateFolder = CreateFolder();

//Where CreateFolder is the macro function

This way the macro will be launched only during reload of application

Rgds,

Sébastien

check if directory exists

Mon, 27 Jul 2009 16:02:58 GMT

Hi Sébastien,

i don't want to use a macro if its not necessary.

Is there a way to avoid this? or is it the only option?

Rgds,

Rey-man

check if directory exists

Tue, 28 Jul 2009 16:51:43 GMT

I don't think about another way...

check if directory exists

disqr_rm — Tue, 28 Jul 2009 21:55:31 GMT

Here is another option for you.

Use this is your QV script:

Let vTime = FileTime('C:\Test');

In abopve line "Test" is a directory in "C" drive. If vTime is empty, directory doesn't exists. 🙂

I was surprised to see that this file function works on directories as well, atleast on my machine. Please validate if it works on your machine as well.

check if directory exists

Tue, 28 Jul 2009 22:47:44 GMT

Hi Rakesh,

I tested it, but of course, if the directory doesn't exists, the variable vTime neither exists.

So how can I create an if function then, cause the compiler returns an error in the script. Its says IF '' = '' then ...

Regards

Rey-man

check if directory exists

disqr_rm — Tue, 28 Jul 2009 22:55:50 GMT

How about this one?

if FileTime('C:\Test') > 0 then
Set vDirExists = 'Yes';
else
Set vDirExists = 'No';
end if

check if directory exists

Wed, 29 Jul 2009 13:18:28 GMT

Now the only part remains the creation of this directory itself.

Greetz

Rey-man

Re: check if directory exists

arpita — Fri, 26 Mar 2021 15:21:29 GMT

any idea of creating a dynamic year and month folder

Re: check if directory exists

x6oTsUCYKP5PcLxRUGLH — Wed, 29 Nov 2023 09:11:51 GMT

Hey, versuche es doch mit dem Einbinden eines Powershell Skripts mit der Übergabe des gewünschten Verzeichnisses.