CSVDE command

CSV Directory Exchange

Comma Separated Value Data Exchange

General Parameters
-i              Turn on Import Mode (The default is Export)
-f filename     Input or Output filename
-s servername   The server to bind to (Default to DC of computer's domain)
-v              Turn on Verbose Mode
-c FromDN ToDN  Replace occurences of FromDN to ToDN
-j path         Log File Location
-t port         Port Number (default = 389)
-u              Use Unicode format
-?              Help

Export Specific
-d RootDN       The root of the LDAP search (Default to Naming Context)
-r Filter       LDAP search filter (Default to "(objectClass=*)")
-p SearchScope  Search Scope (Base/OneLevel/Subtree)
-l list         List of attributes (comma separated) to look for in an
                LDAP search
-o list         List of attributes (comma separated) to omit from input.
-g              Disable Paged Search.
-m              Enable the SAM logic on export.
-n              Do not export binary values

-k              The import will go on ignoring 'Constraint Violation' and
                'Object Already Exists' errors

Credentials Establishment
Note that if no credentials is specified, CSVDE will bind as the currently logged on user, using SSPI.

-a UserDN [Password | *]            Simple authentication
-b UserName Domain [Password | *]   SSPI bind method

Example: Simple import of current domain
    csvde -i -f INPUT.CSV

Example: Simple export of current domain
    csvde -f OUTPUT.CSV

Example: Export of specific domain with credentials
    csvde -m -f OUTPUT.CSV
          -s SERVERNAME
          -d "cn=users,DC=DOMAINNAME,DC=Microsoft,DC=Com"
          -r "(objectClass=user)"
No log files were written.  In order to generate a log file, please specify the log file path via the -j option.

csvde -f test.csv (exporting all data from AD)
csvde -d "OU=MyOU,DC=domain,dc=local" -f test.csv (narrowing down the results, -d)
csvde -f test.scv -r objectClass=user (-r filters rows of unwanted data;users and computers)
csvde -f test.csv -r "(&(objectClass=user)(objectCategory=person)" (-r filters rows of unwanted data; users without computers)
csvde -d "OU=Directors,DC=domain,dc=local" -f test.csv -r "(&(objectClass=user)(objectCategory=person)" (exporting records of userc within OU called Directors)
csvde -d "OU=Directors,DC=domain,dc=local" -f test.csv -r "(&(objectClass=user)(objectCategory=person)" -l " givenName, sn, mail" (-l filters columns of unwanted data)

To detect of the property name - take a look at adsiedit.msc