AD attribute in user account question

I have 2 questions

1.) We want to use the employeeID attribute in AD but you only see that when you look at the attribute editor. Is it possible to have it show up on the general tab?

2.) we need to import from excel an 4 digit + first character of first name to the employeeID AD attribute. I found a way to do part of this via powershell.

Import-CSV "C:\Scripts\Users.csv" |
  ForEach-Object{
     $user=([adsisearcher]"samaccountName=$($_.UserName)").FindOne().GetDirectoryENtry()
     $user.EmployeeID=$_.EmployeeID
     $User.CommitChanges()
}

But that does not take the first character of the first name and add it to the 4 digit code found in the cvs file. Is there a way to do that via powershell or do I have to do a vbscript?
iamuserAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ben HartCommented:
We also make sure of that specific attribute for the past 5 years but have still not found a way to see it easily.  You could obviously code something as an ADUC replacement but that's about it AFAIK.
0
iamuserAuthor Commented:
But is the field still usable if it's populated? My concern is whether another AD aware software can see the data in that attribute.
0
LearnctxEngineerCommented:
I have never had a need to do it before, but this article suggests they have a guide on making the attribute employeeID attribute available in ADUC: http://www.kreslavsky.com/2008/11/add-custom-field-to-aduc-employee-id.html.

If you want to replace the employee ID as the first letter of their given name with the number in the CSV then just do the following.

$user.EmployeeID=$user.givenName + $_.EmployeeID

Open in new window

This should do the trick.

Any software which can query AD should have no problems reading the employeeID attribute though. If it does...use other software because that is just terrible.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
iamuserAuthor Commented:
Great thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Active Directory

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.