locked
Populate MOSS list with Active Directory data? RRS feed

  • Question

  • Edit: I've been thinking this over, and I'd like to simplify/rephrase the question: I have a list with a Name column, type is Person or Group (People Picker). Users input through the input form. When a user is selected via People Picker, I'd like the list to automatically populate two other columns (Office Location, Division) in the list with data from AD.

    Again, much thanks.

    -------------------------

    Original text:

    First off, apologies if this isn't the right forum, I couldn't find one that seemed more appropriate. I'm using MOSS. No Enterprise, no InfoPath. I'm having users add data to the list using the newform.aspx input form.

    The gist is that I have some fields with People Pickers, and I want to pull the information on the AD user filling out the form, as well as the users selected from People Picker within the form.

    I have created a custom list with several columns. The ones in bold are those I'd like to keep as-is, those Italicised I'd like to automatically fill in with AD data, Underlined ones I'd like to delete:

    1. Your name (currently single line text box, though I'd like to replace this with the user's login credentials)
    2. Your Office (currently dropdown, I'd like to replace with automatically filled in data from AD based on question 1)
    3. Your Division  (currently dropdown, I'd like to replace with automatically filled in data from AD based on question 1)
    4. Your Manager's Name (People Picker)
    5. Coworker's Name (People Picker)
    6. Coworker's Title (currently text box, but I'd like replace with with automatically filled in data from AD based on question 5)
    7. Additional Information (multi-line plaintext box)

    Much thanks!

     



    • Edited by scogordo Monday, October 10, 2011 2:52 PM
    Thursday, October 6, 2011 8:07 PM

All replies

  • Hi Scogordo,

    You would have to replace the pre-defined columns with custom columns. Or create a new content type with the appropriate columsn included as part of the type.

    Here is an article on planning content sources which brances off into many directions including custom templates and an explination of content types. If you are running workflows and such on the list (or will be in the future) you will want a custom content type if you plan on having these custom columns named the same as default columns.

     

    http://technet.microsoft.com/en-us/library/cc262735(office.12).aspx

     

    Hope this helps!

    Rick

    Thursday, October 6, 2011 11:13 PM
  • Thanks Rick Andring,

    Already created the Custom List with the custom columns (Your Name, Your Office, etc.), and associated it with Types, eg:

      Column                              Type                          Required
      Your Manager's Name     Person or Group       check
      Coworker's Name            Person or Group       check

    Planning on using workflows down the road to trigger an email when new submissions are added. The email will be based on #4's (Your Manager's Name) data: it will send the manager an email, which will be read from AD.

    I'm not sure I see the benefit of creating a new Content Type in this context, as this form is not likely to be reused in other areas of the site. I'm more interested in mining the data from AD to present the selected user's Office, Division, email address, etc to the person viewing the form results.

    Monday, October 10, 2011 1:59 PM