VSTS 2008 and ClearQuest Integration
For VS and TFS 2008, I'm trying to figure out if we can keep using ClearQuest for our
Work Ticket system but use the other feature of VSTS such as source control.
I've found articles stating that there is integration, but my question is how much?
A plug-in in VS allows access to ClearQuest Work Tickets, but is there source control
integration as well? When you do a CheckIn in VS, can Work Tickets in CQ be linked
in some way and updated? Is there a document somewhere of the integration functionality?
We're currently using VS & TFS 2005 but are upgrading to 2008. Would staying with
2005 change any of this?
Thanks,
Todd
Answers
- Todd,
I think this question might be better suited for the Rational forums. But then I see you already have:
http://www.ibm.com/developerworks/forums/thread.jspa?messageID=14049527&tstart=0
There are some tools out there for migration:
http://msdn2.microsoft.com/en-us/teamsystem/bb840033.aspx
But I think you may end up having to write some code against both APIs to do it.
Hope this helps,
Steve - www.platinumbay.com
All Replies
- Todd,
I think this question might be better suited for the Rational forums. But then I see you already have:
http://www.ibm.com/developerworks/forums/thread.jspa?messageID=14049527&tstart=0
There are some tools out there for migration:
http://msdn2.microsoft.com/en-us/teamsystem/bb840033.aspx
But I think you may end up having to write some code against both APIs to do it.
Hope this helps,
Steve - www.platinumbay.com Any news in this matter?
I'm interested in a two-way integration between TFS and ClearQuest. Or a way to update CQ-items with status-information from TFS...
Thanks,
Roy Lofthus
- Proposed As Answer byaustrweg Thursday, February 26, 2009 3:22 PM
- In terms of two-way integration, there may be some custom integrations done per customer basis, but I have not seen public domain automated solutions.
Here are some gruesome manual steps to update the CQ records with the status changes from TFS:- Open TFS WIT query of interest in Excel. Save the results that should be updated in CQ as a CSV file.
- Open the CSV file and change the column headers to match the import record field names in CQ. For detailed instructions see https://publib.boulder.ibm.com/infocenter/cqhelp/v7r1m0/index.jsp?topic=/com.ibm.rational.clearquest.schema.ec.doc/topics/c_importing_data_into_cq.htm and https://publib.boulder.ibm.com/infocenter/cqhelp/v7r1m0/topic/com.ibm.rational.clearquest.schema.ec.doc/topics/c_fmt_rectyp_impfile.htm. Be warned: you may also have to manually manipulate field values themselves, to "map" what exists in TFS to the values defined in CQ.
- Run the ClearQuest Import utility. Make sure to specify that existing records are being updated as opposed to creating the new ones. See details at
https://publib.boulder.ibm.com/infocenter/cqhelp/v7r1m0/topic/com.ibm.rational.clearquest.schema.ec.doc/topics/t_imp_recs_into_cq.htm
See also the general discussion on this subject http://www.roxolan.com/2009/02/clearquest-integration-with-team.html
https://publib.boulder.ibm.com/infocenter/cqhelp/v7r1m0/topic/com.ibm.rational.clearquest.schema.ec.doc/topics/c_updat_exist_recs.htm
- Open TFS WIT query of interest in Excel. Save the results that should be updated in CQ as a CSV file.
