How can I select objects (users, groups, and computers) in a migration project by importing a CSV Fi (NETIQKB4521)

  • 7704521
  • 02-Feb-2007
  • 04-Oct-2007

Resolution

fact
Migrating Computers - DMA

symptom
How can I select objects (users, groups, and computers) in a migration project by importing a CSV File?

fix

Domain Migration Administrator allows you to populate your projects from external sources by importing object information. You can export objects into a .csv file from an application, such as Configuration Assessor, or you can manually create a .csv file. Domain Migration Administrator supports some Configuration Assessor reports, such as the List of Users report.

The .csv file must be formatted as either ANSI or Unicode and the first row (header row) must contain the SAMAccountName keyword. The rest of the file lists one object SAM account name record per row. The text in your file may appear similar to the following example:

SAMAccountName

Administrator

TestUser01

TestUser02

Computer_name$

NOTE: To include computer accounts type in the name of the computer followed by a dollar sign '$'.

To import the CSV file, do the following:

  1. Select the project in the left pane of the main window.
  2. Right click and select 'Select objects using a CSV file' from the Action Menu.
  3. Select the .csv file that contains the objects you want to add to the project.
  4. Click OK.

NOTE: When you import objects from a .csv, the objects currently selected in the project will be overwritten.  If you intend to ADD users to a project without removing those that are already in the project, your import list should include the objects that have already been added to the project.  This will prevent the project's statistics of migrated objects from becoming corrupted.



note
For more information about 'Selecting Objects by Importing a CSV File', please see Chapter 5 in the DMA 7.1 User Guide.

Additional Information

Formerly known as NETIQKB4521