Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Security from Excel

Hi all,

we have a security list in excel which contains the names from users who have access.

If we try to load the excelfile in the Section Access, it loads. But when we try out the security, it prompts and asks for a user id (its NT security)

If we do the same values in a inline table, it works perfect.

Also, if we put the values from the inline table to an excel export file and load that exportfile to the section access it works perfectly.

My question is: what are the settings in an excel document for section access? is it the fieldproperties we have to adjust or is it something else?

In the excelfile we use the following fields:

ACCESS, USERID, PASSWORD, NTNAME, NTDOMAINSID, PROFILE_1, NTSID, PROFILE_2

the PROFILEs are the accessiblilty for data redundancy.

Does anybody know the answer?

Thanks in advance

Rey-man

1 Solution

Accepted Solutions
Not applicable
Author

The problem is solved.

It required a * with the USERNAME and PASSWORD in the Excel file

Rey-man

View solution in original post

4 Replies
Bjorn_Wedbratt
Former Employee
Former Employee

Hi Rey-man,

Shouldn't be any differences. I load SA from xls all the time. The only thing I can think of is that you don't have strict CAPITAL letters in you xls. Remember that both fieldnames (NTNAME etc) and field value (USER1, USER2 etc) should be in capital letters. As a good practice always format your fields with the upper() function, like

Load upper(NTNAME) as NTNAME,

upper(PROFILE_1) as PROFILE_1)

and so on.

Not applicable
Author

Hi Bjorn,

thanks for your reply.

I forgot to mention that we put the Upper() statement in our xls

The fieldnames are indeed NTNAME (capitalized).

So its really strange that it doesn't work.

Rey-man

Bjorn_Wedbratt
Former Employee
Former Employee

If possible, can you post an example xls-spreadsheet? This must simply be a small typo somewhere, because as I said, there's nothing special related to reading SA info from xls.

Not applicable
Author

The problem is solved.

It required a * with the USERNAME and PASSWORD in the Excel file

Rey-man