Importing CSV to Populate AD Profile

I've started using a 3rd party program to streamline our email signatures, which pulls from the AD profile. I haven't always filled in the relevant information in the users' AD profiles and I was wondering if there was a way to export the profiles into Excel, fill out the needed items and then import it back into AD? That seems easier than going one by one through the profiles. Thanks!
itgolferAsked:
Who is Participating?
 
Adam BrownConnect With a Mentor Sr Solutions ArchitectCommented:
AD powershell makes it pretty easy to do, but it may require some finesse to get things added back, since it requires set-aduser, which doesn't give the option to modify all AD attributes.  https://www.adamfowlerit.com/2014/08/updating-active-directory-from-a-csv/ has a short guide.
https://support.software.dell.com/download-install-detail/5024645 has the ActiveRoles powershell console, which is much better at doing things, can let you export all AD attributes to a CSV, which can then be opened and modified in Excel. It's similar to AD Powershell, but gives more capabilities with the cmdlets it has.

Otherwise, http://www.techrepublic.com/blog/data-center/simplify-admin-tasks-by-exporting-active-directory-data-with-csvde/ CSVDE is a good solution for doing what you want.

LDIFDE is a more capable version of CSVDE: https://msdn.microsoft.com/en-us/library/bb727091.aspx
0
 
skullnobrainsConnect With a Mentor Commented:
any free ldap browser will be able to export/import to/from various formats. most handle csv. so does excel. that should be workable but remember that excel works as a table and an ad is more like a tree. in your case it should not be too cryptic, though since you should have a reasonable number of single-valued fields to deal with.

it is quite likely that working through the users using ldap queries such as "tell me which users have this field empty" would be simpler
0
 
itgolferAuthor Commented:
Thanks for the suggestions!
0
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.

All Courses

From novice to tech pro — start learning today.