Security from Excel

[#1]

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

[Bjorn_Wedbratt]

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.

[#3]

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]

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.

[#5 · Accepted solution]

The problem is solved.

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

Rey-man