Reloading Qlikview Document with Section Access - Qlik Community

Report Inappropriate Content · ‎2016-03-30

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

swuehl · ‎2016-03-30

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

Report Inappropriate Content · ‎2016-03-30

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 · ‎2016-03-30

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.

Report Inappropriate Content · ‎2016-03-30

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 · ‎2016-03-31

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.