VSTS 2008 and ClearQuest Integration

Mon, 18 Feb 2008 21:07:45 Z

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

VSTS 2008 and ClearQuest Integration

Thu, 21 Feb 2008 23:45:31 Z

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

VSTS 2008 and ClearQuest Integration

Thu, 11 Sep 2008 12:39:36 Z

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

VSTS 2008 and ClearQuest Integration

Thu, 26 Feb 2009 15:50:24 Z

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
https://publib.boulder.ibm.com/infocenter/cqhelp/v7r1m0/topic/com.ibm.rational.clearquest.schema.ec.doc/topics/c_updat_exist_recs.htm

See also the general discussion on this subject http://www.roxolan.com/2009/02/clearquest-integration-with-team.html