Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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$);
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
What's in your spreadsheet? Just USER1 and USER2?
I have 60 users. This is just an example
But is the access level, ADMIN or USER in there?
yes. In the excel sheet I've other fields. I only pull information I need.
Why aren't you loading from the spreadhseet in the Section Access part of the script as well as in the Section Application part?
Yes, i did load all information from excel. I'll modify the above example.
Is it a CAsE issue with the spreadsheet data?
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?
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?