topic Re: reload bat inpout log name in QlikView

reload bat inpout log name

wenkew186 — Mon, 26 Jan 2026 18:19:17 GMT

Hi all,

how can i reload a regional access rights's qvw automantic by bat file. don't need input logid and logname.

thanks,

kevin.

Re: reload bat inpout log name

Peter_Cammaert — Tue, 21 Jan 2014 08:17:07 GMT

There is an example of how to reload a QVW from the command line in this discussion Reload from web access (first reply). Put that in a .BAT file and if needed, schedule it to run at an appropriate time with Windows Task Scheduler.

Best

Peter

Re: reload bat inpout log name

wenkew186 — Tue, 21 Jan 2014 08:31:26 GMT

thank you sir,

i means my QVW have set a section access. but if i reload by bat script ,it will have a winodw for need i input logID and password, i don't want input it. if have some mehord?

thanks.

Re: Re: reload bat inpout log name

wenkew186 — Tue, 21 Jan 2014 08:35:45 GMT

please check the picture.

Re: reload bat inpout log name

Peter_Cammaert — Tue, 21 Jan 2014 11:29:14 GMT

Sorry.

QlikView security and Section Access cannot be circumvented, except by providing correct user credentials that allow you to reload a document.

You must have Role=ADMIN for this, or the document security setting "Allow User Reload" must be enabled for this to work.

Also, as of now there aren't any command line switches that allow you to pass username and password on the command line.

Good luck,

Peter

Re: reload bat inpout log name

Bill_Britt — Tue, 21 Jan 2014 11:46:11 GMT

Hi,

Check the server reference manual for QlikView Batch. This will give you more options than qv.exe does.

Bill

Re: reload bat inpout log name

wenkew186 — Wed, 22 Jan 2014 05:33:22 GMT

thanks sir,

oh, no command. it maybe impossible.

but Reload setting in QVS just allow one time everyday, if i have to reload twice in one day and it is must automantic, how to operation?

Re: reload bat inpout log name

wenkew186 — Wed, 22 Jan 2014 05:37:45 GMT

thank you sir,

server reference manual maybe don't mentioned about reload QVW by bat. and i have a qvw must relaod automantic twice one day . i don't know how to solve.

Re: reload bat inpout log name

qlikpahadi07 — Wed, 22 Jan 2014 06:19:49 GMT

Hi,

here is what you need

you have section access just add the Domain user which you used to login the machine with NTNAME and Admin role and run the batch file.

example

NTNAME	ACCESS
qvadmin_dev	ADMIN

this will not ask you for Username or password as it will first check the 1st level of security which is NTNAME.

Cheers!!!!

Re: reload bat inpout log name

wenkew186 — Wed, 22 Jan 2014 08:27:54 GMT

Sir,

your means if is add the server machine name to section access of qv script ? i don't understand well. Can you give me a sample? thank y ou very much!

Re: Re: reload bat inpout log name

qlikpahadi07 — Wed, 22 Jan 2014 08:43:45 GMT

Hi,

sure with pleasure but as it will be NTNAME you need to be careful for following points:

First you can check your NTNAME :

Create a Demo Application and in text box type 'OSUser()' you will see the NTNAME like mine is 'Rohit-PC\Rohit'.

Download the Zip file and extract it.
Open the attached excel and add your NTNAME (as suggested above) with role ADMIN.
Open the attached Qlikview App
1. Reload
2. Save
3. Close and reopen
If you are able to open the file means Section Access is working fine.
Now do the editing part in the Batch file for "QVWPath" and run it manually.
This time it will reload and will not ask for any USERNAME/Password.

Let me know if you stuck some where.

Cheers!!!

Re: reload bat inpout log name

Bill_Britt — Wed, 22 Jan 2014 13:15:11 GMT

Not Bat but batch. In the version 11.20 SR5 english manual it starts on page 59. This uses the Distribution service to reload and you can put that account into section access.

Bill

Re: reload bat inpout log name

wenkew186 — Thu, 23 Jan 2014 01:35:06 GMT

do you have the mannual, sir? i don't find it. can you share it? thank you very much.

Re: Re: reload bat inpout log name

wenkew186 — Thu, 23 Jan 2014 03:25:32 GMT

Sir,

sorry, what's the 'zip file'? i don't have recevied.

Re: reload bat inpout log name

Thu, 23 Jan 2014 03:41:37 GMT

check the Qlikview reference manual

Re: Re: Re: reload bat inpout log name

qlikpahadi07 — Thu, 23 Jan 2014 04:46:30 GMT

find the attachments

Re: Re: Re: reload bat inpout log name

wenkew186 — Thu, 23 Jan 2014 06:46:56 GMT

thank you sir,

i get it and test is successful.

but i have a problem, in my QVW, there have more than the 2 felid in the section access script.e.g.

Section Access;

LOAD

NTNAME,ACCESS,USERID,PASSWORD,AERA

FROM ........;

(because i need limit data access right by AERA. )

and then, open the QVW is need userid and password. so in my issue: the inital section acces is exist. when i open or use bat reload it need userid and password. and now i want don't need userid and password when use bat reload it.

inital section access script:

LOAD

ACCESS,USERID,PASSWORD,AERA

FROM .........;

Re: reload bat inpout log name

qlikpahadi07 — Fri, 24 Jan 2014 10:41:53 GMT

hi,

you don't need to use both... either you can use NTNAME or USERID/PASSWORD.

for your query NTNAME is enough and with my personal experience I suggest you must use NTNAME only as it is more secure.

so now your Script will be like this :

inital section access script:

LOAD

ACCESS, NTNAME, AERA

FROM .........;

and this will work smooth when you run your batch file with the USER who have ADMIN ACCESS in above script.

eg:

LOAD

ACCESS, NTNAME, AERA

Admin, Qvadmin, <India>

FROM .........;