topic Re: Reloading Qlikview Document with Section Access in QlikView

Reloading Qlikview Document with Section Access

Wed, 30 Mar 2016 12:44:56 GMT

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

Re: Reloading Qlikview Document with Section Access

swuehl — Wed, 30 Mar 2016 15:05:16 GMT

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

Re: Reloading Qlikview Document with Section Access

Wed, 30 Mar 2016 20:51:55 GMT

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.

Re: Reloading Qlikview Document with Section Access

swuehl — Wed, 30 Mar 2016 21:07:27 GMT

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.

Re: Reloading Qlikview Document with Section Access

Wed, 30 Mar 2016 23:49:13 GMT

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!

Re: Reloading Qlikview Document with Section Access

swuehl — Thu, 31 Mar 2016 09:35:37 GMT

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.

Re: Reloading Qlikview Document with Section Access

Anonymous — Thu, 31 Mar 2016 09:38:04 GMT

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;

Re: Reloading Qlikview Document with Section Access

Fri, 01 Apr 2016 14:51:43 GMT

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?