4 Replies Latest reply: May 12, 2009 9:30 AM by rey-man RSS

    Security from Excel

    rey-man

      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

        • Security from Excel
          Björn 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.