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$);

[Jason_Michaelides]

What's in your spreadsheet?  Just USER1 and USER2?

[newhere2014]

I have 60 users. This is just an example

[Jason_Michaelides]

But is the access level, ADMIN or USER in there?

[newhere2014]

yes. In the excel sheet I've other fields. I only pull information I need.

[Jason_Michaelides]

Why aren't you loading from the spreadhseet in the Section Access part of the script as well as in the Section Application part?

[newhere2014]

Yes, i did load all information from excel. I'll modify the above example.

[Jason_Michaelides]

Is it a CAsE issue with the spreadsheet data?

[newhere2014]

I've tried to make all value and field names UPPER case. The issue is why INLINE load works AFTER PUBLISHER, while Excel load does not.  Is it possible the problem is related to PUBLISHER?

[Jason_Michaelides]

Hence the reason I wanted to check the data being loaded from the spreadsheet was EXACTLY the same as the inline table.

Can publisher access the Excel file OK?  Anything in the logs?