Access Security and XML File

[#1]

Hello,

I have a problem with the Session Access in Qlikview :

I have many reports (8 in total) and each of them have User Access different.

I want to use a XML file to write their rights.

<?xml version="1.0" encoding="UTF-8"?>
<Security>
 <Users App="Payment Report">
 <User Access="ADMIN" UserId="" Password="" NTName="ADMIN03\Qlikview Administrators "/>
 <User Access="ADMIN" NTName="*" UserId="ADMIN" Password="ADMIN" />
 </Users>
</Security>

And I use in my QVW script:

Section Access;

LOAD Access as ACCESS,
 UserId as USERID,
 Password as PASSWORD,
 NTName as NTNAME
FROM [$(pathSecu)QV_Security.xml] (XmlSimple, Table is [Security/Users/User]);

Section Application;

My problem is that my NT Account is not recognised by Qlikview when a Open my file after the reload.

I don't understand why but when I used the Access Users Helper in the Edit Script and i add manually my Account like this:

Section Access;
LOAD * INLINE [
 ACCESS, USERID, PASSWORD, NTNAME
 ADMIN, , , ADMIN03\Qlikview Administrators
];
Section Application;

I succeed to open my file.

Can you help me to understand the difference please and resolve my problem ?[:'(]

Kind Regards,

Bruno

[#2]

Hello,

Anyone have a suggestion please??

[#3]

Hello,

Anybody have a suggestion for this problem please?? Is very Crucial for my report.

Thanks

[suniljain]

Please Try This Code.

Section Access;
LOAD Trim(Access) as ACCESS,
Trim(UserId) as USERID,
Trim(Password) as PASSWORD,
Trim(NTName) as NTNAME
FROM [$(pathSecu)QV_Security.xml] (XmlSimple, Table is [Security/Users/User]);

Regards

Sunil.

[#5]

It's not works 😞

Again th same message : Please enter your login 😞

[jonathandienst]

Bruno

You may need an asterisk in the blank fields for your NT account in the XML file.

UserId="*" Password="*"

Jonathan

[#7]

It don't change anything 😞

[Anonymous]

When loading Section Access fields, you must always use upper():
upper(UserId) as USERID
upper(Pwassword) as PASSWORD
...

[#9]

It's Works 🙂 ^^ Thank you very much for your help ^^

Can you explain me why this function is important please? 🙂

[Anonymous]

Hmm, I can never answer the "why" questions...
This is how it works. Section Access requires field names and field values in upper case. If you use load inline, it will be in upper case as you enter it, but if you load from any data source, you have to convert it using upper() function. Even if you think that the values are in upper case in data source - it may be not reliable.
If you use fields for data reduction in Section Access and Sectio appliaction - the "upper rule" must be used in both places.