hey David, if you care to send it off-list, I may have a few minutes to see if one of the scripts I have could be converted and made useful to you. I would suggest that you consider doing this via script vs. converting to ldf then importing. ldf would work, but for repetitive things and for making sure you have it right, script is much easier. For example, if you know that you want to do this for every mail-enabled object that exists in the GAL, you could iterate through via a LDAP query, and for each, read the displayname, and then convert it to proper case (likely using http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbenlr98/html/vafctstrconv.asp) It could be a couple of days before I get back to you though.
Al On 12/13/05, CHIANESE, DAVID <[EMAIL PROTECTED]> wrote: > They are all caps and I want them proper case. Or actually management wants > them that way. :) > > We have this: > On 12/13/05, CHIANESE, DAVID <[EMAIL PROTECTED]> wrote: > > We want this: > On 12/13/05, Chianese, David <[EMAIL PROTECTED]> wrote: > ________________________________ > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Phil Renouf > Sent: Tuesday, December 13, 2005 2:02 PM > To: [email protected] > Subject: Re: [ActiveDir] csv to ldf converter > > > How are your Display names formatted? Are they say: Firstname Lastname, or > Lastname, Firstname? Are the first name and last name fields in the users > populated and do they have the correct case? > > If so then AD Modify should fix that as you can tell it to build the Display > Name from the Firstname and Lastname fields. > > If not then this won't help and I'll go back to what I was doing...actually > either way I'll go back to what I was doing ;) > > Phil > > > On 12/13/05, CHIANESE, DAVID <[EMAIL PROTECTED]> wrote: > > > > I just found that admodify.net cannot do what I want either. Basically if > you look at my display name in e-mail here, it is all caps.. so... In a > csvde directory export of all users and using a well known excel function > (=proper(A1)) I am able to give proper case to each field I want to change. > So I have that part done, all DN, SN, CN and other capitalized fields have > been reworked to proper case fields. The trouble I am having is converting > the .csv file to .ldf so I can then modify these attributes in the directory > using ldifde. > > > > If anyone would like to look at my current spreadsheet that does this > conversion (well it used to anyway), I would be happy to send a copy off > list. Scripting in Excel/VB is not my forte. > > > > > > Regards, > > > > > > Dave > > > > ________________________________ > From: [EMAIL PROTECTED] [mailto: > [EMAIL PROTECTED] On Behalf Of Brian > Desmond > > Sent: Tuesday, December 13, 2005 1:10 PM > > To: [email protected] > > Subject: RE: [ActiveDir] csv to ldf converter > > > > > > > > > > > > You could just use csvde to do the import/export if that's what you're > trying to do…. > > > > > > > > > > Thanks, > > Brian Desmond > > > > [EMAIL PROTECTED] > > > > > > > > c - 312.731.3132 > > > > > > > > > > > > ________________________________ > > > > > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > CHIANESE, DAVID > > Sent: Tuesday, December 13, 2005 1:05 PM > > To: [email protected] > > Subject: [ActiveDir] csv to ldf converter > > > > > > > > Would anybody have a handy csv to ldif macro for excel 2003? The one I > have no longer functions. Even a .csv file to .ldf file conversion tool > would help. TIA! > > > > > > > > Regards, > > > > Dave > >
