Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Reloading Qlikview Document with Section Access

Hi - I am trying to setup a task to refresh my qlikview document each night.  The document currently has section access on it (login and password required).

Normally, for documents without section access, I just create a Scheduled Task with Windows to run a batch file that looks like this:

"C:\Program Files\QlikView\Qv.exe" /r \\mktxindfs\data_grp1\Data\eric.qvw

However, this only works for documents without section access.  With section access, the document prompts for a login and password.  Is there a way around this?

Thanks,

Eric

7 Replies
swuehl
MVP
MVP

Add a user to the section access table that uses SERIAL to authenticate.

Not applicable
Author

but i would need to know every user's serial number to enable this right?

i have 10 people who use my document, all with different access.

swuehl
MVP
MVP

No, the SERIAL is for the computer you are performing the reload.

Or are you reloading on each user's PC separately per batch?

This user needs to have access to all data (ADMIN user).

After the reload is done, you can distribute the QVW to your users, they'll use their current users listed in the current section access table to access the app.

Note that these users then probably shouldn't open the QVW on the PC that does the reload, since then the user with the SERIAL will apply.

Not applicable
Author

Ah I see.  I am reloading on my PC (I am the admin).  Then other users login with read-only access on their own desktop. 

This is the top half of my section access statement now:

Section Access;

LOAD * INLINE [

    ACCESS, USERID,PASSWORD

    ADMIN, ADMIN,MORROW

    USER, MARKETS,MARKETS

    USER, FLOW,FLOW

    USER, SUPER,SUPER

    USER, TRADING,TRADING

    USER, SALES,SALES

];

Section Application;

So I should have this instead?

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, SERIAL

    ADMIN, ADMIN, MORROW, 1234-4567-8910

    USER, MARKETS,MARKETS

    USER, FLOW,FLOW

    USER, SUPER,SUPER

    USER, TRADING,TRADING

    USER, SALES,SALES

];

Section Application;

Thank you!

swuehl
MVP
MVP

Basically, yes.

You might need to test if you need to leave USERID & Password empty or use a star symbol for the ADMIN, and maybe create a second line to allow access on a different computer, like

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, SERIAL

    ADMIN, *, *, 1234-4567-8910

    ADMIN,ADMIN,MORROW,*

Similar for the users, you may need to use the star symbol to allow access on all computer (or it may work with just leaving the field empty:

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, SERIAL

    ADMIN, *, *, 1234-4567-8910

    ADMIN,ADMIN,MORROW,*

    USER, MARKETS,MARKETS, *

    USER, FLOW,FLOW,*

    USER, SUPER,SUPER,*

    USER, TRADING,TRADING,*

    USER, SALES,SALES,*

];

I can't test it right now, but that's the basic idea.

Instead of SERIAL etc., you can also try NTSID to automatically check for the logged in user, or similar.

See also

Introduction to Section Access

Anonymous
Not applicable
Author

Section Access;

LOAD * INLINE [

    ACCESS, USERID,PASSWORD

    ADMIN, ADMIN,MORROW

    USER, MARKETS,MARKETS

    USER, FLOW,FLOW

    USER, SUPER,SUPER

    USER, TRADING,TRADING

    USER, SALES,SALES

];

Section Application;

Not applicable
Author

I tried both and still both prompted me for a login/pw...

ACCESS, USERID, PASSWORD, SERIAL

    ADMIN, *, *, 1234-4567-8910

    ADMIN,ADMIN,MORROW,*

    USER, MARKETS,MARKETS, *

    USER, FLOW,FLOW,*

ACCESS, USERID, PASSWORD, SERIAL

    ADMIN, *, *, 1234-4567-8910

    USER, MARKETS,MARKETS, *

    USER, FLOW,FLOW,*

did you have success?