Exporting
csvde -f c:\csvde-export.csv -s lon-dc1 -p subtree -r "(&(objectCategory=person)(objectClass=User)(givenname=*))" -l "cn,givenName,objectClass,samAccountName"

 

Connecting to "lon-dc1"
Logging in as current user using SSPI
Exporting directory to file c:\csvde-export.csv
Searching for entries...
Writing out entries
..
Export Completed. Post-processing in progress...
1 entries exported
The command has completed successfully

DN,objectClass,cn,givenName,sAMAccountName
"CN=Joe Bloggs,OU=London,DC=contoso,DC=com",user,Joe Bloggs,Joe,joebloggs

 

 

Importing
DN,objectClass,cn,givenName,sAMAccountName
"CN=Bob Smith,OU=London,DC=contoso,DC=com",user,Bob Smith,Bob,bobsmith

csvde -i -f c:\csvde-import.csv

Connecting to "(null)"
Logging in as current user using SSPI
Importing directory from file "csvde-import.csv"
Loading entries..
1 entry modified successfully.
The command has completed successfully

 

 

 

 

CSV Directory 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


Import
======
-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
          -b USERNAME DOMAINNAME *
          -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.

 

 

 

 

Share this blog post on social media:

Social Links

Disclaimer

All advice, installation/configuration how to guides, troubleshooting and other information on this website are provided as-is with no warranty or guarantee. Whilst the information provided is correct to the best of my knowledge, I am not reponsible for any issues that may arise using this information, and you do so at your own risk. As always before performing anything; check, double check, test and always ensure you have a backup.

Copyright ©2008-2021 Andy Barnes - Please do not copy any content including images without prior consent!

Designed and Hosted by Andy Barnes