topic Re: directory in QlikView

Re: directory

alexandros17 — Wed, 23 Sep 2015 08:37:44 GMT

take a look to "Execute"

Re: directory

Wed, 23 Sep 2015 08:56:17 GMT

Execute is working good for files..folders I tried below... not working

EXECUTE cmd /C rmdir/s C:\Documents\*.* ;

Re: directory

Wed, 23 Sep 2015 14:28:58 GMT

hi all,

any suggestion here?

Re: directory

giakoum — Wed, 23 Sep 2015 14:32:33 GMT

try this :

EXECUTE cmd /C "rmdir/s C:\Documents\"

Re: directory

giakoum — Wed, 23 Sep 2015 14:34:05 GMT

/Q	Quiet mode, do not ask if ok to remove a directory tree with /S.

Re: directory

jonas_rezende — Wed, 23 Sep 2015 14:39:54 GMT

Hi, benny1409.

Make the following steps below:

Create a folder in your directory of name TESTCOMMUNITY.
Create a bat_Test.bat file name and place within it the following command and save file in c:\
cd\
c:
rd TESTCOMMUNITY
In Script area Qlikview, insert EXECUTE cmd.exe /C C:\bat_Test.bat;
Click Ok;
Click in Menu Settings->User Preferences...
In Security tab, mark Script (Allow Database Write and Execute Statements)
Click Ok;
Reload qvw;

After test successfull, transfer for your app *.qvw.

Anyway, the file was attached.

Hope this helps!

Re: directory

Wed, 23 Sep 2015 15:07:52 GMT

hi ioannis /Jonas

delete works good

Is their a similar way to move from one folder to another 12122013.xls where all xls files are there within this folder. so the whole folder needs to be moved

for ex: I want to move a folder called

C:/23092015 folder To D:/

so everyday a new folder comes I need to move to 😧 as back up

for ex 23092015

24092015

25092015

Re: directory

jonas_rezende — Wed, 23 Sep 2015 16:35:41 GMT

Hi, benny1409.

Utilize the same principle. Make one bat file with statement for move xls. Ex.:

cd\

c:\

cd TESTCOMMUNITY

move *.xls c:\<directory desired>

Not forget of execute in Qlikview, before command EXECUTE delete.

Re: directory

Thu, 24 Sep 2015 06:15:44 GMT

hi Jonas,

how can I give a UNC path in the directory for ex: \\servername\..... etc

Re: directory

Thu, 24 Sep 2015 06:44:13 GMT

hi all,

my current scenario is .. I need to move a specific folder with the folder name

for ex 12122015....

in a month I may receive this folder in any of the dates

11122015 or 10122015 or 23122015 keeping dec as example

so I tried the below making a variable for date as todays date.. it works good. but as the folders dates are not the same ..in everymonth you may receive this folder on any of the dates .so today does not work ..so in a month if today is 24th I may get the folder dated 09202015

EXECUTE cmd /C move C:\Data\$(Date).in D:\processed;

Re: directory

jonas_rezende — Thu, 24 Sep 2015 12:05:44 GMT

Hi, benny1409.

I believe that the simple form, will be Map Network drive, on machine with Qlikview Desktop installed.

In bat file, you utilize the unit mapping and the final path. Ex.: F:\archive\qlik.

Re: directory

Thu, 24 Sep 2015 12:32:18 GMT

hi Jonas,

maping is good. but how could I move .in folder specified with dates.

11122015 or 10122015 or 23122015 keeping dec as example

if I put *.in .in the move command .it does not work

Re: directory

jonas_rezende — Thu, 24 Sep 2015 16:37:21 GMT

Hi, benny1409.

The command cmd require the extension .exe. Ex.: EXECUTE cmd.exe /C move C:\Data\$(Date).in D:\processed;

Note: verify if variable Date is been initialized with value. Including, equal the name of the folder.