Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 967
  • Last Modified:

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.

0
SandipDMehta
Asked:
SandipDMehta
  • 3
  • 2
1 Solution
 
CarlWarnerCommented:
You probably can't modify users security rights, which explains why that part of your import fails.

"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
0
 
mkbeanCommented:
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=nwtraders,DC=msft

DSADD also works very well with adding users to groups.


Hope this info helps

Brian
0
 
SandipDMehtaAuthor Commented:
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?
0
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 
mkbeanCommented:
Not sure I understand your question but you can use this for custom groups as well, you just have to know what the DN is for the group.

Brian
0
 
SandipDMehtaAuthor Commented:
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
0
 
mkbeanCommented:
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
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now