Mike If you don't want to use LDIFDE I would have thought the easiest method would be to write a small script to read the values from your CSV file and update the corresponding AD objects accordingly.
A good method for reading in from a CSV file is outlined here: http://www.tek-tips.com/faqs.cfm?spid=329&sfid=3323&newpid=329 and there are many good sources for examples of how to use ADSI to update objects in AD. Some of these are shown in the ADSI and Scripting section of the Links page at: http://www.activedir.org/links.htm Tony ---------- Original Message ---------------------------------- Wrom: IMQZUIVOTQNQEMSFDULHPQQWOYIYZUNNYCGPKYLEJG Reply-To: [EMAIL PROTECTED] Date: Thu, 22 Jan 2004 22:04:15 -0800 Thanks Russ, Looking at it now, looks nice. This (hopefully) was a one time thing so I doubt I'll be able to justify the expense but I see they have a trial version so I'll see if I can get it done with that. Thanks again, Mike. -----Original Message----- Wrom: DGVCJVTLBXFGGMEPYOQKEDOTWFAOBUZXUW [mailto:[EMAIL PROTECTED] On Behalf Of Rimmerman, Russ Sent: Thursday, January 22, 2004 4:59 PM To: '[EMAIL PROTECTED]' Subject: RE: [ActiveDir] Updating information in AD from a file. Quest Fastlane Migrator will do it. That's what we use to merge previously existed ADMT users. -----Original Message----- Wrom: LSZLKBRNVWWCUFPEGAUTFJMVRESKPNKMBI [mailto:[EMAIL PROTECTED] Behalf Of Mike Newell Sent: Thursday, January 22, 2004 6:52 PM To: [EMAIL PROTECTED] Subject: [ActiveDir] Updating information in AD from a file. Hey, Here's what I have. A few weeks ago everything was moved from a 2000 domain into a new 2003 domain in a new forest with ADMT. The Exchange server in the old domain was 5.5 and the mail was exmerged into a new Exchange 2003 server. Everything worked pretty much as expected except the old exchange server had a ton of data associated with the accounts (phone numbers, assistants, etc.) I have exported all that data into a csv file and I now need a way to merge that data into AD. I can change the headers in the file from the Exchange 5.5 names to reflect the attribute names in AD. I'm just not sure how to merge this type of data into AD for over 1000 users. Anyone know of a utility or a script I can use to merge the data from a file (preferably a csv file) into an existing user in AD? I looked at LDIFDE but it looks like I'd have to manually change the ldf file for each replacement and that's not what I'm looking for. The information changes for each user so changing the ldf file would be cumbersome (phone numbers, etc.) Any help is greatly appreciated. Thanks again, Mike Newell List info : http://www.activedir.org/mail_list.htm List FAQ : http://www.activedir.org/list_faq.htm List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ This e-mail is confidential, may contain proprietary information of the Cooper Cameron Corporation and its operating Divisions and may be confidential or privileged. This e-mail should be read, copied, disseminated and/or used only by the addressee. If you have received this message in error please delete it, together with any attachments, from your system. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ List info : http://www.activedir.org/mail_list.htm List FAQ : http://www.activedir.org/list_faq.htm List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/ List info : http://www.activedir.org/mail_list.htm List FAQ : http://www.activedir.org/list_faq.htm List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/ List info : http://www.activedir.org/mail_list.htm List FAQ : http://www.activedir.org/list_faq.htm List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/
