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...