SandipDMehta
asked on
CSV File Headers
Hi Experts
I have created a csv file and i can succesfully bulk import users into active directory using the csv file and csvde however the user password is always set to blank (no password) even though i have in the header the field password and havew specfied a password. also i have tried to use the memberOf field to add security groups to users and when i ry to import witht the memberOf field the import fails.
I have created a csv file and i can succesfully bulk import users into active directory using the csv file and csvde however the user password is always set to blank (no password) even though i have in the header the field password and havew specfied a password. also i have tried to use the memberOf field to add security groups to users and when i ry to import witht the memberOf field the import fails.
CSVDE does not allow you to import passwords. :-( If you want to import accounts and have it use passwords you could try to use DSADD but it may require more work.
When you do the memberOF value make sure you put in the DN of the group IE: CN=Guests,CN=Builtin,DC=nw
DSADD also works very well with adding users to groups.
Hope this info helps
Brian
When you do the memberOF value make sure you put in the DN of the group IE: CN=Guests,CN=Builtin,DC=nw
DSADD also works very well with adding users to groups.
Hope this info helps
Brian
ASKER
hi brian
what if the security groups is not one of the builtin groups and its one that has been created e.g AllTeachers and also the CN=guests is that where the security group is in or is that where the destination container of the imported user?
what if the security groups is not one of the builtin groups and its one that has been created e.g AllTeachers and also the CN=guests is that where the security group is in or is that where the destination container of the imported user?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
sorry Brian
one last question. would you know the header fields for the following:
Live Communications
a) SIP URI
b) Home Server
Exchange 2003 Server
Under the exchange genral tab in active directory and in delivery restrictions:
a) Accept message only from
one last question. would you know the header fields for the following:
Live Communications
a) SIP URI
b) Home Server
Exchange 2003 Server
Under the exchange genral tab in active directory and in delivery restrictions:
a) Accept message only from
SandipDMehta,
I don't have Live Communications or Exchange 2003 installed on a server to see but if you look in the Schema snap-in you should be able to see the actual name of the attribute.
Brian
I don't have Live Communications or Exchange 2003 installed on a server to see but if you look in the Schema snap-in you should be able to see the actual name of the attribute.
Brian
"Another utility called Csvde.exe performs the same export functions as the Ldifde.exe utility, but uses a comma-separated file format. Import operations with this utility are “add” only; it does not offer the ability to modify or delete objects. The comma-separated value (CSV) file format is supported by applications such as Microsoft Excel."
Step-by-Step Guide to Active Directory Bulk Import and Export
http://www.microsoft.com/technet/prodtechnol/windowsserver2003/technologies/directory/activedirectory/stepbystep/adbulk.mspx
How to use Csvde to import contacts and user objects into Active Directory
http://support.microsoft.com/default.aspx?scid=kb;en-us;327620