****
*
*
*
*







*
*
                                      
*
*
Windows Server



    

Csvde    

*
*

*
*

Csvde



Jan
08

Csvde

http://technet.microsoft.com/hi-in/library/cc771621(en-us,WS.10).aspx

Csvde

Applies To: Windows Server 2008

Csvde

Imports and exports data from Active Directory Lightweight Directory Services (AD LDS) using files that store data in the comma-separated value (CSV) format. You can also support batch operations based on the CSV file format standard.

Syntax

csvde [-i] [-f FileName] [-s ServerName] [-c String1 String2] [-v] [-j Path] [-t PortNumber] [-d BaseDN] [-r LDAPFilter] [-p Scope] [-l LDAPAttributeList] [-o LDAPAttributeList] [-g] [-m] [-n] [-k] [-a UserDistinguishedName Password] [-b UserName Domain Password]

Parameters

-i

Specifies the import mode. If the import mode is not specified, the default mode is export.

-f FileName

Identifies the import or export file name.

-s ServerName

Specifies the domain controller to perform the import or export operation.

-c String1 String2

Replaces all occurrences of String1 with String2. You generally use this when you importing from one domain to another and the distinguished name of the export domain (String1) must be replaced with the distinguished name of the import domain (String2).

-v

Sets verbose mode.

-j Path

Sets the log file location. The default is the current path.

-t PortNumber

Specifies a Lightweight Directory Access Protocol (LDAP) port number. The default LDAP port is 389. The global catalog port is 3268.

-d BaseDN

Sets the distinguished name of the search base for data export.

-r LDAPFilter

Creates an LDAP search filter for data export.

-p Scope

Sets the search scope. Search scope options are Base, OneLevel, or SubTree.

-l LDAPAttributeList

Sets the list of attributes to appear in the results of an export query. If this parameter is omitted, all attributes are returned.

-o LDAPAttributeList

Sets the list of attributes to be omitted from the results of an export query. You typically use this when you export objects from Active Directory Domain Services (AD DS) and then import them into another LDAP-compliant directory. If the attributes are not supported by another directory, you can omit the attributes from the result set using this option.

-g

Omits paged searches.

-m

Omits attributes that cannot be written, such as the ObjectGUID and objectSID attributes.

-n

Omits export of binary values.

-k

Ignores errors during the import operation, and continues processing. The following is a complete list of ignored errors:

·         Object already exists.

·         Constraint violation.

·         Attribute or value already exists.

-a UserDistinguishedName Password

Sets the command to run using the supplied UserDistinguishedName and Password. By default, the command runs using the credentials of the user who is currently logged on to the network.

-b UserName Domain Password

Sets the command to run as UserName Domain Password. By default, the command will run using the credentials of the user who is currently logged on to the network.

-?

Displays the command menu.

Remarks

  • Applications such as Microsoft Excel are capable of reading and saving data in the CSV format. In addition, Microsoft Exchange Server administration tools are also capable of importing and exporting data using the CSV format, as are many other non-Microsoft tools. 

    The CSV format consists of one or more lines of data, with each value separated by a comma. The first line (sometimes referred to as the header) of the CSV file must contain the names of each attribute in the same order as the data in any line following the first line. 

    Example:

    CN,FirstName,SurName,Description


    FirstUserLogonName,1stUserFirstName,1stUserSurName,Manager

    SecondUserLogonName,2ndUserFirstName,2ndUserSurName,
    President
  • You can use csvde -r to create an LDAP search filter for data export. For example, the following filter exports all users with a particular surname:

    csvde -r (and(objectClass=User)(sn=SurName))

Formatting legend

 

Format

Meaning

Italic

Information that you supply

Bold

Elements that you type exactly as shown

Ellipsis (...)

A parameter that can be repeated several times in a command line

Between brackets ([])

Optional items

Between braces ({}); choices separated by pipe (|). Example: {even|odd}

A set of choices from which you must choose only one

Courier font

Code or program output

Additional references

 

http://technet.microsoft.com/hi-in/library/cc771621(en-us,WS.10).aspx

 

How to use Csvde to import contacts and user objects into Active Directory

http://support.microsoft.com/kb/327620

KB Article ID: 327620

 

This step-by-step article describes how to use the Csvde.exe utility to create contacts and user accounts in Active Directory. You may have to use this method in some scenarios, for example, when administrators want to export custom recipients from Microsoft Exchange Server 5.5 and import them into Active Directory as Microsoft Windows contacts.

Csvde.exe is a Microsoft Windows 2000 command-line utility that is located in the SystemRoot\System32 folder after you install Windows 2000. Csvde.exe is similar to Ldifde.exe, but it extracts information in a comma-separated value (CSV) format. You can use Csvde to import and export Active Directory data that uses the comma-separated value format. Use a spreadsheet program such as Microsoft Excel to open this .csv file and view the header and value information. See Microsoft Excel Help for information about functions such as Concatenate that can simplify the process of building a .csv file.

Note Although Csvde is similar to Ldifde, Csvde has a significant limitation: it can only import and export Active Directory data by using a comma-separated format (.csv). Microsoft recommends that you use the Ldifde utility for Modify or Delete operations. Additionally, the distinguished name (also known as DN) of the item that you are trying to import must be in the first column of the .csv file or the import will not work. 

The source .csv file can come from an Exchange Server directory export. However, because of the difference in attribute mappings between the Exchange Server directory and Active Directory, you must make some modifications to the .csv file. For example, a directory export from Exchange Server has a column that is named "obj-class" that you must rename to "objectClass." You must also rename "Display Name" to "displayName."

For more information about attribute mappings, click the following article number to view the article in the Microsoft Knowledge Base:

281563 Exchange Server 5.5 to Exchange 2000 attribute mappings for the Migration Wizard

Use the following syntax to run the tool from a command prompt:

csvde -i -f c:\filename.csv

The minimum required attributes are listed in this article for each type of object that you may want to create, and sample .csv file headers are provided. Note that the minimum required attributes for one organization may not meet usage requirements for another organization. Use ADSI Edit or Ldp.exe to view the attributes for existing users and to verify the attributes that you may need or want for your scenario.



Warning
 If you use the ADSI Edit snap-in, the LDP utility, or any other LDAP version 3 client, and you incorrectly modify the attributes of Active Directory objects, you can cause serious problems. These problems may require you to reinstall Microsoft Windows 2000 Server, Microsoft Windows Server 2003, Microsoft Exchange 2000 Server, Microsoft Exchange Server 2003, or both Windows and Exchange. Microsoft cannot guarantee that problems that occur if you incorrectly modify Active Directory object attributes can be solved. Modify these attributes at your own risk. 


Windows 2000 contact with no e-mail address


The list in this section describes the minimum required attributes for a Windows 2000 contact with no e-mail address. You may require more attributes to fit your needs. For example, you can easily add the 
telephoneNumber attribute to the .csv file.

·         objectClass. This attribute specifies what type of object to create.

·         DN (distinguished name). This attribute specifies the distinguished name of the new user object.

·         displayName. The displayName attribute contains the display name of the object as it appears in the Global Address List and any other address lists that the object is a member of.

These required attributes must be column headers in your .csv file as shown in the following example.



objectClass

DN

displayName

contact

distinguished name of user object

Display Name



Note that distinguished name of user object in this table includes the display name of the object being created plus the distinguished name of the organizational unit (OU) where this object is to be created.

For example, to create a contact named MailDisabledContact in an organizational unit, the value would look similar to the following value:

cn=MailDisabledContact,OU=OU name,DC=Domainname,DC=com

This is also true for all other imports that are described in the rest of this article.



Windows 2000 user, no mailbox or e-mail address

The list in this section describes the minimum required attributes for a Windows 2000 user with no mailbox or e-mail address.

·         objectClass. The objectClass attribute specifies what type of object is created.

·         DN (distinguished name). This attribute specifies the distinguished name of the new user object.

·         displayName. The displayName attribute contains the display name of the object as it appears in the Global Address List and in any other address lists that the object is a member of.

·         sAMAccountName. This attribute maps to Pre Windows 2000 Logon Name in the user interface, and it is typically the same as the User logon name.

·         userAccountControl. Set the value of this attribute to 512.

These required attributes must be column headers in your .csv file as they appear in the following example.



objectClass

DN

displayName

sAMAccountName

userAccountControl

User

distinguished name of user object

NoMail User

NoMail User

66048




Troubleshooting

Generally, the Csvde utility gives clear indications of what is not acceptable in your .csv file. For example, you cannot use Csvde to duplicate certain attributes if those attributes already exist in Active Directory. If you try to do so, you receive the following message:

C:\WINNT\system32>csvde -i -f mailenabledcontactimport.csv
Connecting to "(null)"
Logging in as current user using SSPI
Importing directory from file "mailenabledcontactimport.csv"
Loading entries.
Add error on line 2: Already Exists
The server side error is "An attempt was made to add an object to the directory with a name that is already in use."
0 entries modified successfully.
An error has occurred in the program.

If a required attribute is missing from your .csv file, you receive the following message:

C:\csvde>csvde -i -f mailenableduserimport1.csv
Connecting to "(null)"
Logging in as current user using SSPI
Importing directory from file "mailenableduserimport1.csv"
Loading entries.
Add error on line 2: Constraint Violation The server side error is "A required attribute is missing."
0 entries modified successfully.
An error has occurred in the program.

Csvde does not log events to the Application event log. To troubleshoot Csvde you must view the command line output and use LDP or ADSI Edit to compare your file with the attributes of existing user objects. Do not modify objects in Active Directory without first testing the process extensively in a lab environment.

http://support.microsoft.com/kb/327620

 

XGEN: Exchange Server 5.5 to Exchange 2000 Attribute Mappings for the Migration Wizard

KB Article ID: 281563

http://support.microsoft.com/kb/281563

 

How to Use Csvde.exe to Import Contacts into Active Directory

KB Article ID: 300409

http://support.microsoft.com/kb/300409

 



No TrackBacks

TrackBack URL: http://www.skar.us/site/mt-tb.cgi/2904

Leave a comment








*
*

administrator
Author Bio          ★★★★★

Author Name:         administrator
Author Location:    India
Author Rank:          Writer
Author Status:        
The Green leave stands!!


*
*
*
*
****



*****



    Desktop
  • eBooks
  • Games
  • Softwares
  • Tools
  • Tweaks
  • Wallpapers
  • Warez
    PDA
  • Games
  • Tools
  • Wallpapers
    System Administration
  • dll Center
  • Scripts
  • Tools
  • .extensions database
  • Write-up
    more...
  • Download Database
  • Jobs
  • Lists
  • Polls
  • Glossary

01000011 01110010 01100001 01100011 01101011 01111010 01101000 01100001 01100011 01101011