1.9 Data Migration from ClearQuest
You can skip this step if your trial goal is to demonstrate JIRA's agile project management capabilities which makes a migration of historic or current ClearQuest content unnecessary.
However in most other cases, you might want to demonstrate a JIRA pilot instance that contains real business data from your ClearQuest system. To achieve this, you have three main options:
Manually create issues in JIRA
For a manual population step, you can leverage the same steps as for the CSV importer but replace the actual CSV import procedure with a manual issue creation run.
When tackling more than 20-30 issues to be created, it is also possible to create a data collection sheet with a spreadsheet application. You can then export that collection sheet to CSV which you can then import using the CSV importer. The best way to perform this, is to create a couple of issues in JIRA first, export them to Excel and then add more rows using the existing field values. This way, you could minimize problems during the importing procedure.
Import via CSV
Alternatively, you are also able to export the records from your ClearQuest instance and import the resulting data dump using the CSV Importer Add-on in JIRA. The Importer Wizard lets you map each source field with the respective standard and custom fields in JIRA. Additionally, the wizard lets you map value pairs as well which enables you to translate versions, issue types and other standard fields as well.
To ensure a smooth transition, we would recommend the following migration process:
- Export the range of records in ClearQuest into a CSV file
- Analyze the CSV file in Excel and mark for every field
- Whether you desire to maintain it in JIRA
- The matching field in JIRA
- The type of field and allowed values
- If it is a controlled list field such as component or version, lay out all possible values of that field. You can do that easily in Excel by making a pivot table of that column and display all possible values and their occurrences. Mark which of these possible values should exist in JIRA and plan respective versions, components or values in custom fields.
- Create the project in JIRA and create fields and custom fields as required by your reviewed CSV export
- Once you can confirm that all fields and possible values (such as versions, components and statuses) exist in the JIRA project, you can commence with the CSV import.
For more details, please see the CSV importer documentation
JIRA importers for ClearQuest by our Experts
After performing dozens of ClearQuest to JIRA migrations, a number of our Experts have developed tools to automize the specific process to move content between these two system. Please see the migration section of the Add-On Chapter.
Customized migration scripts
In case of a heavy customization and integration of your ClearQuest instance, as well as a very large issue base (>100,000 records), a more customized migration might be an option. Such a path would involve jelly scripts that would directly access the JIRA API and write directly to the database. Scenarios could be the desire to preserve application links, attachments, changset links or respective change histories to 3rd party systems. We would only recommend going forward with this option together with an Expert.