Welcome
Developing
Learn how to develop schemas by using the Rational® ClearQuest® Designer.
Developing Schemas
You can develop or modify schemas with the Rational® ClearQuest® Designer.
Importing and exporting data
This topic describes how to import and export data between Rational® ClearQuest® databases, and how to import data into a Rational ClearQuest database from another defect tracking system.
Exporting data
You can export data from a Rational® ClearQuest® database.

IBM ClearQuest 10.0.9
Overview
Learn general information about the product.
Installing
Learn how to install the product.
Upgrading and migrating
Learn how to upgrade and migrate data for the product.
Administering
Learn how to administer the product.
Reporting
Learn how to generate reports for the product.
Developing
Learn how to develop schemas by using the Rational® ClearQuest® Designer.
- Developing Schemas
  You can develop or modify schemas with the Rational® ClearQuest® Designer.
  - Understanding the functions of the Rational® ClearQuest® schema developer
    This topic provides an overview of the tasks typically performed by a schema developer.
  - Overview of the Rational® ClearQuest® Designer interface
    The Rational® ClearQuest® Designer includes several different windows, or views, that you will use to perform your schema development tasks.
  - Rational® ClearQuest® schemas
    This topic explains the concept of a Rational® ClearQuest® schema.
  - Customizing a schema
    To modify how change requests are handled, you need to use the Designer to customize the records and fields of a schema.
  - Schemas and packages
    This topic explains the concept of using schemas and packages in Rational® ClearQuest®.
  - Packages and integrations
    This topic explains the concepts of Rational® ClearQuest® packages and integrations.
  - Test Management and Requests
    You can use the ClearQuest® TestManagement and Requests feature to create and track test plans and add approval processes to the record.
  - Working with Forms
    You must create a record form for each record type in your schema. You can also define a submit form for each record type.
  - Creating a security model
    This topic provides an overview of the process to create a security model.
  - Using hooks to customize your workflow
    This topic provides guidelines for using hooks to implement your workflow.
  - Record locking
    When multiple users attempt to simultaneously update a record, the database locking model ensures that the update from each user succeeds as a unit, but each update overwrites the previous update.
  - Customizing the Web
    The Designer provides many ways to customize the underlying schema and functionality that the Rational® ClearQuest® Web client accesses.
  - Rational® ClearQuest® email
    This topic provides a description of the supported Rational® ClearQuest® Web client email features.
  - Importing and exporting data
    This topic describes how to import and export data between Rational® ClearQuest® databases, and how to import data into a Rational ClearQuest database from another defect tracking system.
    - Overview of importing and exporting data
      Using the Import and Export wizards, you can move data such as records, history, and attachments from other change request systems and between Rational® ClearQuest® databases.
    - Adding and removing code page headers from exported files
      You can use the cpheader command to add and remove data code page header information to and from exported queries, charts, reports, report formats, and form files created by using the original Rational® ClearQuest® Web client Designer.
    - Starting the import process
      This topic explains the process for exporting and importing data in Rational® ClearQuest® Web client.
    - Testing the import process
      This topic provides an overview of the steps you should follow to test the import process.
    - Creating an import schema
      Before you can import data into a Rational® ClearQuest® database, you must create an import schema or modify an existing schema to support the data to be imported.
    - Creating a database for imported data
      Before importing data into a Rational® ClearQuest® database, you must create a user database to hold the imported data and associate this database with the import schema.
    - Creating a Rational® ClearQuest® import file
      If you are exporting data from an existing Rational® ClearQuest® database, you can use the Export feature to create the import file.
    - Configuring the Import Tool
      You can customize the behavior of the Import Tool with the Import Tool preference page.
    - Exporting data
      You can export data from a Rational® ClearQuest® database.
    - Importing data into Rational® ClearQuest®
      This topic provides an overview of the steps required to import data into Rational® ClearQuest® Web client.
Managing change and releases
Learn how to manage change and release in the product.
Integrating
You can integrate Rational® ClearQuest® with other software by adding packages to existing schema.
Extending product function
Learn how to extend the product.
Reference
Review reference information for the product.
Tutorials

Exporting data

You can export data from a Rational® ClearQuest® database.

About this task

To export data from a database-supported application other than Rational® ClearQuest®, you must use the database vendor tool. See Creating a Rational ClearQuest import file.

To export data from an existing Rational® ClearQuest® database, use the Export feature available in either the Rational® ClearQuest® Client. The Export wizard extracts data from a Rational® ClearQuest® database into a format optimized for the Import wizard.

To prevent data corruption, take care when exporting or importing data between databases that do not have the same data code page value. If imported data might corrupt the database, an error message is displayed. For more information, see the topics listed for exporting records and queries in the online help for the Rational® ClearQuest® Client.

Procedure

To export records from a database:

Start the Rational® ClearQuest® Client.
Run a query.
Click File > Export > Records.
In the Export wizard, select the data to export:
1. Select a record type to export.
2. Select Export all records or Export records based on an existing query.
3. Select a query (if applicable), and click Next.
Select the fields to include in the export file. Double-click or drag the fields to add them to the export file. Click Next
Select an export format. You can choose from ClearQuest® import, delimited text, and XML formats. Click Next.
Select an export directory and file name. You can also accept the default options.
Click Finish