reload bat inpout log name

[wenkew186]

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.

[qlikpahadi07]

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'.

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

Let me know if you stuck some where.

Cheers!!!

[Bill_Britt]

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

[wenkew186]

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

[wenkew186]

Sir,

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

[#6]

check the Qlikview reference manual

[qlikpahadi07]

find the attachments

[wenkew186]

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 .........;

[qlikpahadi07]

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 .........;