Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
The problem is solved.
It required a * with the USERNAME and PASSWORD in the Excel file
Rey-man
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.
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
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.
The problem is solved.
It required a * with the USERNAME and PASSWORD in the Excel file
Rey-man