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:
TweetAll 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.