Tab level security issue

[newhere2014]

I want to implement security on Tab level. I searched the forum and found an exmple here http://community.qlik.com/thread/38348

Actually, this method works well. But the issue is I want to use excel sheet to reload the Control table, instead of INLINE load, since we have many records to maintain.After the application is reloaded and distributed through PUBLISHER, I can not open this application from Access Point. Here is the  security code I used in this application.

It is urgent to solve this problem. I really appreciate your help.

1. With INLINE load, it works after Publisher

Section Access;

LOAD

    ACCESS,

    NTNAME

FROM

F:\...\Security.xls

(biff, embedded labels, table is Sheet4$);

Section Application;

Control :

LOAD * INLINE [

    NTNAME, Tab

    USER1, Y

    USER2,  

];

2. With excel sheet load, it failed to open a file after Publisher

Section Access;

LOAD

    ACCESS,

    NTNAME

FROM

F:\...\Security.xls

(biff, embedded labels, table is Sheet4$);

Section Application;

Control :

LOAD   NTNAME,

          Tab

FROM

F:\...\Security.xls

(biff, embedded labels, table is Sheet4$);

[newhere2014]

How to check the Publisher log?

[Jason_Michaelides]

In the QMC

[newhere2014]

Could you give me more detail how to  check log from QMC? Thanks

[newhere2014]

Problem solved. Thanks, Jason

[Jason_Michaelides]

What was the problem?

[newhere2014]

one of the NTNAME caused the problem, not sure why now. After being removed, it works.

[Jason_Michaelides]

Strict Exclusion maybe?  Anyway - glad you solved it. Please mark a correct answer to close the thread.

[newhere2014]

sure. BTW, could you tell me how to find publisher log? thanks

[Jason_Michaelides · Accepted solution]

In the QMC, goto Status > Tasks, then expand the tree to find your job and click "Show Task Details" on the top right. Then select Log.

Hope this helps,

Jason

[newhere2014]

oh, I see. Thank you very much!