Please Read: Significant Update Planned, Migrating Forum Software This Month

See more
See less

Mdoifying users

  • Filter
  • Time
  • Show
Clear All
new posts

  • Mdoifying users

    Hi guys, I'm new to scripting and have been challenged with getting some information into AD from our HR system via excell.

    The problem I have is that the HR system does not have the AD user names, only an Employee ID.

    I have added a few Employee IDs into a test AD environment, but have absolutely no idea how to proceed.

    Any help is greatly apreciated


  • #2
    Re: Mdoifying users

    thats rough, because you will need a logon name to create the accounts, or you will be calling joe blow user 654785.

    it would be easier to create the user accounts then import the employee IDs to the existing accounts.

    i had to do the same, and basically used an LDIFDE export to a .csv, then added the user IDs to the corresponding names, then re-imported the attributes.

    that doesnt help you much, though, does it?

    its easier to beg forgiveness than ask permission.
    Give karma where karma is due...


    • #3
      Re: Mdoifying users

      Use a vbscript to Search in AD for userobjects where employeeID <> ""
      - create an array (or VBScript Dictionary Object) employeeID, DN

      Read the data from the excel sheet;
      From each row get the employee ID an go through the dictionary that you had created before (loop within a loop).

      At every match, bind to the userobject using the DN, and do what you was planning to do.


      This posting is provided "AS IS" with no warranties, and confers no rights.


      ** Remember to give credit where credit's due **
      and leave Reputation Points for meaningful posts