Hi,
The following code works:
SECTION ACCESS;
LOAD * INLINE [
ACCESS, NTNAME, NTDOMAINSID
ADMIN, domain\user1, S-1-5-21-4212263732-3897499842-2088291733
ADMIN, domain\user2, S-1-5-21-4212263732-3897499842-2088291733
];
SECTION APPLICATION;
If i try to read section access list from Excel using the following code - won't work:
LET vDocument = 'TEST';
//Location of User_Accss file
LET vExcelDirectory = 'C:\QlikView\QVWorkspace\User Access';
DIRECTORY '$(vExcelDirectory)';
//Domain ID
LET vNTDOMAINID = 'S-1-5-21-4212263732-3897499842-2088291733';
tmpSectionAccess:
CrossTable(Document, Authorized, 3)
LOAD NTNAME ,
ACCESS,
'$(vNTDOMAINID)' AS NTDOMAINSID,
Aanvragen,
app1,
app2,
app3,
app4,
app5
FROM
[User Access.xlsx]
(ooxml, embedded labels, table is Blad1)
;
SECTION ACCESS;
LOAD
ACCESS,
NTNAME
RESIDENT tmpSectionAccess
WHERE Document = '$(vDocument)';
SECTION APPLICATION;
DROP TABLE tmpSectionAccess;
Trying to executed to task in the server generates the following error:
The task "TEST.qvw" failed. Part of the log file follows:
10-7-2012 14:26:42 Error Document open call failed. The document might require username and password.
10-7-2012 14:26:42 Error The document failed to open. Bad Username and password is the most likely cause of this problem.
10-7-2012 14:26:42 Error Document could not be opened
10-7-2012 14:26:42 Error The task "TEST.qvw" failed. Exception: QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors |
domain\user1 is a domain admin account which runs the QDS service.
Any idea's? It's kinda driving me crazy...
