Exporting data

You can export data from a HCL Compass database.

About this task

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

To export data from an existing HCL Compass database, use the Export feature available in either the HCL Compass Client. The Export wizard extracts data from a HCL Compass 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 HCL Compass Client.

Procedure

To export records from a database:
  1. Start the Rational® ClearQuest® Client.
  2. Run a query.
  3. Click File > Export > Records.
  4. 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.
  5. Select the fields to include in the export file. Double-click or drag the fields to add them to the export file. Click Next
  6. Select an export format. You can choose from Compass import, delimited text, and XML formats. Click Next.
  7. Select an export directory and file name. You can also accept the default options.
  8. Click Finish