How to transfer userid and password to qvw in command line when reload

[#1]

Hi

I want to use command line to reload qvw files.

like: qv.exe /r abc.qvw

But my qvw has userid and password, How can I transfer userid and password to qvw in command line inorder to avoid manul input this information when relad.?

I reand read reference manual and try to add witch /nosecurity , but it don't work.

Could I ?

Thanks"::)

[erichshiino]

I really don't know if you can do it but can't you include NTUser on section access to allow the user running the task to open it without further inputs?

[#3]

Hi Erich

I want to reload it in server side without input userid and password manually.

But userid and password can be set in command line ...

[erichshiino]

You will probably use windows schedule, won't you?

So, there will be some 'user', even a system user' running this schedule. You can include it on the section access using NTName. Thus, QV Desktop will not ask user and password. It will just open.

[#5]

Erich Shiino wrote:
You will probably use windows schedule, won't you?
So, there will be some 'user', even a system user' running this schedule. You can include it on the section access using NTName. Thus, QV Desktop will not ask user and password. It will just open.
 <div></div>

As the reference manul says:

In the logon procedure, QlikView will first check SERIAL, NTNAME, NTDOMAINSID
and NTSID to see if this information is enough to grant the user access to the
document. If so, QlikView will open the document without prompting for User ID
and Password.

I think it can solve my problem. but I add a field named NTNAME. It don't work.

my access table is :

ACCESS	NTNAME	USERID	PASSWORD
Admin	?	ADMIN	admin
User	?	DEMO1	eco2010ta
User	?	DEMO2	eco2010ta
User	?	DEMO3	eco2010ta
User	?	DEMO4	eco2010ta
Admin	Frank-pc\Frank	test	test

My client os username is Frank-pc\Frank, I think I can open the document without input userid and pwd.But I still get a prompt to require user input.

[erichshiino]

On the last line you shouldn't use userid nor password.

Try blanks or *

Admin	Frank-pc\Frank

[#7]

I try

ACCESS	NTNAME	USERID
Admin	?	ADMIN
User	?	DEMO1
User	?	DEMO2
User	?	DEMO3
User	?	DEMO4
Admin	Frank-pc\Frank	*

or

ACCESS	NTNAME	USERID
Admin	?	ADMIN
User	?	DEMO1
User	?	DEMO2
User	?	DEMO3
User	?	DEMO4
Admin	Frank-pc\Frank	?

cant work... Erich, could you pls give me a example?

[erichshiino · Accepted solution]

The names must be upper case.

The app attached must open without password on your pc.

If it ask you something use ADMIN password: ADMIN

if it ask you the password, check the users on text boxes inside.

Hope it works now

[#9]

hi

It is ok,by the table:

ACCESS	NTNAME	USERID
Admin	*	ADMIN
User	*	DEMO1
User	*	DEMO2
User	*	DEMO3
User	*	DEMO4
Admin	Frank-pc\Frank	*

Thank you.

And I have another question about transfer userid and pwd in url. Could you pls help me about that question:)