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:
HR的excel原始数据
用left/right/lower/concatenate函数处理成需要的数据，转换为csv文件
***部分需要手动修改一下(ou命名规则和hr部门命名规则不对，可以用lookup提取，这里没做）；绿色部分通用数据，基本是固定不变，不需要修改的；紫色部分是公式自动抓取的
csvde无法导入密码，这样做进去的账号是disabled的
