How to import ClearQuest records with history and links
Hi
We are currently migrating from CQ to RTC, and met an issue with importing records with history and/or links to related records. In these cases, a straight forward query made in the CQ query editor, for returning all required fields for import, results in a complex query with several JOINs, ultimately returning "duplicate" CQ records - one line/record for each combination of history and links.
Clearly, this is not desireable for importing into RTC, where you want unique records with their history from CQ intact, as well as links to related work items.
Is there a way to create a CQ query that returns the history and links in another format that can be managed as desired during import? Or another "recipe" for handling this challenge?
Any help deeply appreciated :)
Kind regards,
Trond
We are currently migrating from CQ to RTC, and met an issue with importing records with history and/or links to related records. In these cases, a straight forward query made in the CQ query editor, for returning all required fields for import, results in a complex query with several JOINs, ultimately returning "duplicate" CQ records - one line/record for each combination of history and links.
Clearly, this is not desireable for importing into RTC, where you want unique records with their history from CQ intact, as well as links to related work items.
Is there a way to create a CQ query that returns the history and links in another format that can be managed as desired during import? Or another "recipe" for handling this challenge?
Any help deeply appreciated :)
Kind regards,
Trond
2 answers
What I did was write a perl script which went through each defect, and went through each of the history records and serialized them into a human readable text string. I then added thatas a note to the record.
I did this before I did the export into RTC.
Not perfect, but good enough.
I did this before I did the export into RTC.
Not perfect, but good enough.
Hi
We are currently migrating from CQ to RTC, and met an issue with importing records with history and/or links to related records. In these cases, a straight forward query made in the CQ query editor, for returning all required fields for import, results in a complex query with several JOINs, ultimately returning "duplicate" CQ records - one line/record for each combination of history and links.
Clearly, this is not desireable for importing into RTC, where you want unique records with their history from CQ intact, as well as links to related work items.
Is there a way to create a CQ query that returns the history and links in another format that can be managed as desired during import? Or another "recipe" for handling this challenge?
Any help deeply appreciated :)
Kind regards,
Trond
