topic Re: Batch File Execution in QlikView

Batch File Execution

Mon, 21 Oct 2013 04:11:17 GMT

Dear All,

I want load an application through Batch file. I have written the batch file that run perfectly when my application doesn't contain password.

But where i work there is necessary that application must have password. So when my application is reloaded it gets failed because the application contain password.

So please help me out with the batch file code that contains password for application

Re: Batch File Execution

Mon, 21 Oct 2013 04:58:05 GMT

You can not pass username and password as parameter in Batch file.

instead of that you can use NTNAME field in section access (DOMAIN\USERNAME) and run that batch file on same windows user..

Karthik

Re: Batch File Execution

Mon, 21 Oct 2013 05:19:22 GMT

replace /l by /r in batch file like below.

"C:\Program Files\QlikView\Qv.exe" /r "D:\Batch file_qlikview\test.qvw"

Re: Batch File Execution

er_mohit — Mon, 21 Oct 2013 05:29:53 GMT

make a batch file and in that file on script mode write this section access here what m doing on the base of

plant wise

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, REDUCTION

ADMIN, Admin, pass1, *

USER, HO, pass1, 1

USER, KSP, pass1, 2

];

Section Application;

star is *;

Plant:

LOAD RowNo() as REDUCTION, * INLINE [

plantname

KSP

];

LOAD *

INLINE [

plantcode, plantname, id, price

101, HO, 1, 200

101, HO, 2, 300

101, HO, 3, 400

101, HO, 4, 500

102, KSP, 5, 600

102, KSP, 6, 700

102, KSP, 7, 800

];

hope it helps