Register now or log in to join your professional community.
Comma Separated Value Data Exchange is a command line utility that allows you to import and export, but not to modify or delete, entries into or from a Lightweight Directory Access Protocol (LDAP) repository, such as Active Directory Application Mode (ADAM), Active Directory Lightweight Directory Services (AD LDS), Active Directory, or Active Directory Domain Services (AD DS).
CSVDE is a command-line tool that is built into Windows Server 2008
It is available only if AD DS or Active Directory Lightweight Directory Services (AD LDS) server role installed
It is commonly used for importing of contact and user object in the active directory
CSVDE - Comma Separated Value for Directory Exchange is the command line tools which is available in windows server if you have ADDS or AD LDS, its allow you to exchange the data in CSV format.
csvde -f c:\\ad_data.txt
For more switches, type csvde /?
Csvde is a command line tool that exports or imports AD objects to or from a Comma-separated values ( .csv) file
Here are a few types of servers, among a great number of other possibilities:
An application server is a program in a computer in a distributed network that provides the business logic for an application program.
A proxy server is software that acts as an intermediary between an endpoint device, such as a computer, and another server from which a user or client is requesting a service.
A mail server is an application that receives incoming e-mail from local users (people within the same domain) and remote senders and forwards outgoing e-mail for delivery.
A virtual server is a program running on a shared server that is configured in such a way that it seems to each user that they have complete control of a server.
A blade server is a server chassis housing multiple thin, modular electronic circuit boards, known as server blades. Each blade is a server in its own right, often dedicated to a single application.
A file server is a computer responsible for the central storage and management of data files so that other computers on the same network can access them.
A policy server is a security component of a policy-based network that provides authorization services and facilitates tracking and control of files.
CSVDE is command-line tool that is built into Windows Server 2003, 2003 R2, 2008, 2008 R2 and Server 2012. It is tool to import and export data from Active Dreictory Domian services. (AD DS) using files that store data in the comma-separated value.
We use syntax: Csvde [-i] [-f <filename>] [-s <serverName>] [-c <string1> <string2> [-v] [-j <Path>] [-t <portnumebr>] [-d <BaseDN>] [-r <LDAPFilter>] [-p <Scope] [-l <LDAPAttributeList>] [-o <LDAPAttributeList>] [-g] [-m] [-n] [-k] [-a <UserDistinguishedName> {<Password> | *}] [-b <UserName> <Domain> {<Password> | *}]
csvde command doesn't use for import username and password because it doesn't send over an encrypted channel. It also doesn't support SSL (Secure sockets layers) or encrypted LDAP.
CSVDE = csv data exchange. It is a command line utility that allows o import and export, but not to modify or delete, entries into or from a Lightweight Directory Access Protocol (LDAP).
CSCDE Means:
CSVDE is the type of program that you learn for a specific task and then forget about. Therefore, what you need are a few tried and tested examples to get started. The classic job for CSVDE is to import user accounts into a Windows domain. While I often use CSVDE to create users on my test network, my main use for CSVDE is to research LDAP names. What I do is a quick export of Active Directory into a .csv file. I then open that .csv export file with Excel and study the LDAP fields in the first row of the spreadsheet.
Comma - Delimit data with a comma, not tab. CSV is an ideal format for Excel.
Separated - Split a string of data, so that each property fits into an LDAP column.
Value - We focus on the values, rather than properties.
Data - Again concentrate on the data, and don't worry about the objects.
Exchange - Move data from the spreadsheet into Active Directory (or vica versa).
Works?
Think of CSVDE as the engine that drives data into or out of Active Directory. This CSVDE engine has two directions, export and import. The data consists of Active Directory accounts in CSV format. Excel, or a similar spreadsheet, is marvelous at dropping the comma-separated data into columns. To actually export from Active Directory, all you need is CSVDE -f filename.csv. As export is the default mode, there is no -e switch, so just issue CSVDE, the -f switch and a suitable name.
The knack of reading the data is to launch Excel, find the export file and open it as a spreadsheet. Fortunately, Excel has a built-in csv converter, each row in Excel holds one user's properties and each column represents one LDAP field. As we will see, only a few fields are compulsory. Most columns are optional and can remain blank if you wish.
Whenever you transfer data in the other direction, from the file into Active Directory, you must actively switch CSVDE into import mode. This is why you need the extra the -i parameter. For example CSVDE -i -f filename.csv.
Csvde is a command-line tool that is built into Windows Server 2008 in the %windir%/system32 folder. It is available if you have the AD DS or Active Directory Lightweight Directory Services (AD LDS) server role installed. To use csvde, you must run the csvdecommand from an elevated command prompt. To open an elevated command prompt, click Start, right-click Command Prompt, and then click Run as administrator.
