Rational Clearquest Import Tool
On my current project, I found myself exporting my team's list of activities from to excel over and over again. This made me look at what offers in terms of an API. Luckily enough, there was an API available, however whatever documentation that google threw at me, was pants.I created an excel VBA macro to connect to clearquest and pull whatever data I wanted. Another useful use of the API is wto create some kind of integration tool thing between and clearquest. I haven't had time to do this though.You can download the excel workbook which contains my vba macro from.
You need access to a clearquest database and have the clearquest client installed for this to work.Here's an explanation of the code which is contained in the 'ThisWorkbook' object if you open the Visual Basic editor ( Tools Macro Visual Basic Editor).I would recommend that you have the open while you're going through this.The first thing to do is to import the module clearquest.bas from C:Program FilesRationalClearquest or wherever cq is installed. This module contains a whole load of useful contstants that you may need later on.Next open ToolsReferences and look in the Available references list and make sure 'ClearQuestOLEServer' is selected.Now for some code. You need to create a Session object to connect to clearquest. AnonymousBeg your help, I want to connect to the database schema of CQ, the name of database schema is: testschema, the use name is: test,the database on the another computer, the ip address is: 192.168.0.3，when i run my code(italic), VBA run fail.
Rational Clearquest Import Tool Download
My code:-Dim CQObject as objectDim varCQDbs as variantCQObject = CreateObject('CLEARQUEST.SESSION')For Each varCQDbs In CQObject.GetAccessibleDatabases('192.168.0.3testschema', test, ').Next-How can i connect to ClearQuest Database on another computer, thanks.
Clearquest Cqweb
ClearQuest ComponentsAs outlined in the ClearQuest manuals (see Introducing Rational ClearQuest, IBM Rational Software), ClearQuest consists of several components that work in a client-server environment. Table 4-1 describes these components.