Csvde batch import domain user data

Netsh

Interface

Ipv4

Set address "local area connection" static ip mask gateway

Set dnsserver "local area connection" static ip primary

Netdom computername % hostname %/add: newcomputername

Netdom computername % hostname %/makeprimary: newcomputername

Netdom computername % hostname %/remove: oldcomputername

Dcpromo/unattend/balabala

Dcpromo /? : Promotion/demotion

Csvde/d LDAP path/f exportfilepath/j logfilepath/l comma separated attribute/

Csvde/I/k/f exportfilepath/j logfilepath

DN

ObjectClass

Sn

GivenName

Displayname

Description

SAMAccountName

UserPrincipalName

Physicaldeliveryofficename

L

St

Co

Postalcode

Mobile

User fields that cannot be imported

The following fields are protected system fields and cannot be modified through an LDIFDE import .:

· BadPasswordTime:

· BadPwdCount:

· LastLogoff:

· LastLogon:

· LogonCount:

· MemberOf

· ObjectGUID:

· ObjectSid:

· PrimaryGroupID:

· PwdLastSet:

· SAMAccountType:

Raw HR excel Data

650) this. width = 650; "title =" clip_image002 "style =" border-top: 0px; border-right: 0px; border-bottom: 0px; border-left: 0px; display: inline "border =" 0 "alt =" clip_image002 "src =" http://www.bkjia.com/uploads/allimg/131228/0436312223-0.gif "" 668 "height =" 268 "/>

Use the left/right/lower/concatenate function to process the required data and convert it to a csv file.

The yellow part needs to be manually modified (ou naming rules and hr department naming rules are incorrect. You can use lookup to extract them. This is not done here). The green part of general data remains unchanged, the purple part is automatically crawled by the formula.

650) this. width = 650; "title =" clip_image004 "style =" border-top: 0px; border-right: 0px; border-bottom: 0px; border-left: 0px; display: inline "border =" 0 "alt =" clip_image004 "src =" http://www.bkjia.com/uploads/allimg/131228/0436312P2-1.gif "" 714 "height =" 166 "/>

The csvde cannot import the password. The account used for this operation is disabled.