Using the ClearQuest Import Wizard to import records

You can use the ClearQuest Import Wizard to import records from a ClearQuest user database into a project area. The imported records are stored as work items in the Jazz™ Team Server repository. The new work items are not synchronized with the ClearQuest records upon which they are based.

Before you begin

Rational® ClearQuest® must be installed on the computer where the Rational Team Concert™ Eclipse client is installed. You must have at least a Contributor Client Access License (CAL) to run the wizard to create work items. If creating work items involves creating categories, iterations, or releases, then you need a Developer CAL. You must be assigned adequate process permissions. If the import operation will create Jazz user accounts, you must be a member of the JazzAdmins group.

About this task

Note: Each time that you run the ClearQuest Import Wizard against a set of records, it creates work items for those records, even if you have previously run it against the same records. To avoid duplicate work items, be sure to run the wizard against a record only once.

For fields that contain time values, the ClearQuest Import Wizard supports both the 24-hour format (HH:mm) and am/pm (HH:mm a) format. For example, both 13:36 and 1:36 pm are acceptable. The table below lists the supported date formats.

Table 1. Date formats supported by ClearQuest Import Wizard
Date format Example
M/dd/yyyy 9/13/2009
M/dd/yy 9/13/09
MMM d, yyyy Sep 13, 2009
MMMM d, yyyy September 13, 2009
dd MMMM yyyy 13 September 2009
dd-MMM-yy 13-Sep-09
yyyy-M-dd 2009-09-13
dd/mm/yyyy 13/09/2009
dd.mm.yyyy 13.09.2009
To import ClearQuest records:

Procedure

  1. In the Rational Team Concert Eclipse client, click File > Import. Expand Team and select ClearQuest Records. Click Next.
  2. The first time through, select Connect to ClearQuest.
  3. Select the schema repository for the ClearQuest user database that contains the records you want to import. Enter a user name and password for the wizard to use to login to the ClearQuest user database. Select the user database.
  4. In the Select a Query section, click Browse and navigate to a query in the Personal Queries or Public Queries folder that selects the records that you want to import.
  5. In the Options section, select Save as XML data. Click Browse and navigate to a directory where you want to store the zip file that contains the results of the query. Enter a name for the zip file.
  6. Click Finish to create the zip file.
  7. Open the ClearQuest Import Wizard.
  8. In the Source Location section, select Zip file. Click Browse and navigate to the zip file that you created previously.
  9. In the Options section, select Import to Project Area and select a project area.
  10. In the Custom Data Mapping section, click Save Default As, and specify the name of a file that contains the information that maps ClearQuest record fields to work item attributes and attribute types. The wizard creates a sample mapping file, which you customize.
  11. Open the mapping file and modify it to map the ClearQuest record fields to work item attributes and attribute types. Save the modified mapping file.
  12. Before you import the records into your production Jazz Team Server repository, verify that the mapping file works as desired against a test repository. Open the ClearQuest Import Wizard. Select Zip file. Click Browse and navigate to the zip file that you created previously. Select Import to Project Area, and select a test project area. In the Custom Data Mapping section, click Browse and navigate to the mapping file. Click Finish. Examine the results of the import operation. If necessary, make corrections to the mapping file.
  13. When you are ready to import records into the production repository, open the ClearQuest Import Wizard. Select Connect to ClearQuest. Complete the fields in the ClearQuest Connection Info section. Select Import to Project Area, and select the production project area. In the Custom Data Mapping section, select the mapping file. Click Finish.

Feedback

Did this help? You can provide feedback at Jazz.net (registration required): Comment in the forums or submit a bug