Really? I just exported a CSV with ADFIND and when opening with Excel the fields are empty. Or are you referring to it when opening it in a text editor?
I know years ago I used to "wash" an export because it was saved in Unicode (IIRC I was batch exporting Registry stuff) and I needed it to be ASCII, so in batch I had Notepad open the file and then the batch would "Save As..." and flip the format to ASCII, perhaps the same thing can be done here? A little clunky, but perhaps someone knows a cleaner method... Additionally, checking out my ADFIND output I see a couple dozen users (out of 200+) without a UPN. Would this affect many things by not having this? SharePoint? Exchange? Anything? I guess I'm asking: When is UPN used? Dave Lum - Systems Engineer [EMAIL PROTECTED] - (971)-222-1025 "When you step on the brakes your life is in your foot's hands" -----Original Message----- From: Kurt Buff [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 05, 2008 7:12 PM To: NT System Admin Issues Subject: Re: ADMod question Yep - new version of admod is better. Still gonna take some work, though, from what I can see in the docs. Have to prefix each field with the correct identifier. That's definitely going to be interesting. On a side note, the newest version of adfind still is stupid about populating blank fields with garbage. Sigh. Kurt On Feb 5, 2008 5:00 PM, Michael B. Smith <[EMAIL PROTECTED]> wrote: > Admod -csv? > > I took a quick look at it...it appears to be doable. > > Regards, > > Michael B. Smith > MCSE/Exchange MVP > http://TheEssentialExchange.com > > > > -----Original Message----- > From: Kurt Buff [mailto:[EMAIL PROTECTED] > Sent: Tuesday, February 05, 2008 7:44 PM > To: NT System Admin Issues > Subject: ADMod question > > As you might have guessed from the ADFind question a few minutes ago, > I've extracted our user accounts from AD - I gave them a somewhat > cleaned up version, and asked them to verify things like phone > numbers, job titles, managers, etc. > > Now I have a csv file that looks like the following: > > displayName","dn","givenName","sn","description","title","department","d epar > tmentNumber","employeeNumber","company","streetAddress","l","st","postal Code > ","physicalDeliveryOfficeName","co","telephoneNumber","mobile","mail","m gr", > "t > > "Kurt Buff","CN=Kurt > Buff,OU=US,OU=MycompanyUsers,DC=mycompany,DC=com","Kurt","Buff","","Lead > Network Administrator","Information > Technology","6011","1095","Mucompany"," Inc.","PO Box > 9xxxx","Redmond","WA","98xxx","US","US","463","","[EMAIL PROTECTED]"," Mark > Manager","CN=Mark > Manager","OU=US","OU=MycompanyUsers","DC=mycompany","DC=com" > > > and want to import the cleaned up data. > > I'm looking at the docs for ADMod.exe, and don't see how I can do this. > > Does anyone have a pointer on this, or have a better way to do it? > > Kurt > > ~ Upgrade to Next Generation Antispam/Antivirus with Ninja! ~ > ~ <http://www.sunbelt-software.com/SunbeltMessagingNinja.cfm> ~ > > > ~ Upgrade to Next Generation Antispam/Antivirus with Ninja! ~ > ~ <http://www.sunbelt-software.com/SunbeltMessagingNinja.cfm> ~ > ~ Upgrade to Next Generation Antispam/Antivirus with Ninja! ~ ~ <http://www.sunbelt-software.com/SunbeltMessagingNinja.cfm> ~ ~ Upgrade to Next Generation Antispam/Antivirus with Ninja! ~ ~ <http://www.sunbelt-software.com/SunbeltMessagingNinja.cfm> ~
