topic Re: Help to create Folder named today date and store current QVW in QlikView

Help to create Folder named today date and store current QVW

Thu, 26 Jun 2014 09:17:02 GMT

Hello everyone,

I want to create a folder which name must be today() like 26/06/2014,and it contains the QVW file which is created or updated on today().

and again when I Reload the application tomorrow it will create a new folder with name 27/06/2014 and store the updated QVW file.

How is this possible,if anyone has idea please share with me.

Thank you in advance.

Re: Help to create Folder named today date and store current QVW

Gysbert_Wassenaar — Thu, 26 Jun 2014 09:23:17 GMT

You'll have to use some sort of batch script. Perhaps something like this (untested):

@echo off
For /f "tokens=2-4 delims=/ " %%a in ('date /t') do (set mydate=%%c-%%a-%%b)
set mydir="%mydate%"
mkdir %mydir%
"c:\program files\qlikview\qv.exe" /r "MyDoc.qvw"
copy "MyDoc.qvw" %mydir%

Re: Help to create Folder named today date and store current QVW

Thu, 26 Jun 2014 09:30:43 GMT

and how would I run this batch file,is there any macro code to run this batch file?

Re: Help to create Folder named today date and store current QVW

Gysbert_Wassenaar — Thu, 26 Jun 2014 09:35:31 GMT

Put a line like the one below in the script of the qlikview document:

execute cmd.exe /c "c:\myfolder\mybatchscript.bat"

Re: Help to create Folder named today date and store current QVW

Thu, 26 Jun 2014 16:31:26 GMT

I found the solution which works fine. thank you Gysbert for your help..

this is the batch file coding,

@echo off

set yy=%date:~-4%

set mm=%date:~-7,2%

set dd=%date:~-10,2%

set MYDATE=%dd%-%mm%-%yy%

md %MYDATE%

"c:\program files\qlikview\qv.exe" "C:\Users\Administrator\Desktop\qlikview\my\Sample apps\button.qvw"

copy "C:\Users\Administrator\Desktop\qlikview\my\Sample apps\button.qvw" %MYDATE%

pause

Re: Help to create Folder named today date and store current QVW

vignesh_s — Mon, 12 Feb 2018 12:19:24 GMT

how to obtain date formate "mm" as "mmm"