I want to set up a batch file to run QV automatically and then transfer stored txt file D:\QMC.txt to zip file. After that sent to server.
The bat file below works:
"c:\program files\qlikview\qv.exe" /r -vPaticipantCodeType=AMC "d:\Export\TestExport.qvw"
set MyFilename="D:\QMC.zip"
"c:\program files\winrar\rar.exe" a %MyFilename% "D:\QMC.txt"
echo servername>ftp.txt
echo password>>ftp.txt
echo binary>>ftp.txt
echo cd XX>>ftp.txt
echo put %MyFilename%>>ftp.txt
echo quit>>ftp.txt
ftp -s:"ftp.txt" ncexx.com
del %MyFilename%
del ftp.txt
set MyFilename=
Now the problem is QMC.txt is just a test file name. The really file name is dynamic, getting from variables from QV. I don't know how to get variable values to bat script to create a dynamic file name.
For example the stored txt file from QV is $(vDate)$(vSequenceNo).txt The vDate and vSequenceNo are variables in QlikView script.
How can I get the variable values from QlikView? I have tried $(vDate)$(vSequenceNo) and %vDate%%vSequenceNo% and they didn't work.
set MyFilename="D:\$(vDate)$(vSequenceNo).zip"
"c:\program files\winrar\rar.exe" a %MyFilename% "D:\$(vDate)$(vSequenceNo).txt" (Not work)
set MyFilename="D:\ %vDate%%vSequenceNo%zip"
"c:\program files\winrar\rar.exe" a %MyFilename% " D:\%vDate%%vSequenceNo%txt" (Not work)
Can anyone help me please? Thanks!
