February 10, 2010
TestTrack Excel Add-in Toolbar
Developed against TestTrack Pro 2010 and Excel 2007
This tools allows the user to view the defect list from within Excel. Selected records in the list window can be imported into a new worksheet in the Excel workbook.
How it worksThe TestTrack Excel Add-in Toolbar is a way to access TestTrack Pro from Excel. After installting the Add-in toolbar, a TestTrack toolbar will become available in Excel.
The ToolbarThe toolbar consists of three buttons
Defect List ButtonUse this button to retrieve the list of defects in TestTrack Pro. This button will not be enabled unless you have already connected to TestTrack Pro.
Connect to TestTrack ButtonUse this button to bring up a login window. Enter the appropriate information to log in to TestTrack. This button will be disabled when you are connected.
Disconnect from TestTrack ButtonUse this button to terminate your TestTrack session. This button will be disabled if you are disconnected from TestTrack.
Login WindowUse the Login Window to connect to TestTrack and establish a connection.
Defect List WindowThe defect list window displays defects returned by the selected filter.
Column ConfigurationThe defect list window will contain three columns by default:
Configuration FileWhen the connection information on the login window is saved, it is saved to a configuration file called "TTConfig.xml". This file gets saved to the "current directory", which by default is the directory where the Excel executable is located. The file may also contain information about columns to display in the defect list window. Following is a sample config file that is saving all connection information (including password) and also has three extra columns configured.
<?xml version="1.0"?> <ROOT> <ServerAddress>http://localhost/scripts/ttsoapcgi.exe</ServerAddress> <Project>TestTrack ALM</Project> <TTUserName>Administrator</TTUserName> <TTPassword>password</TTPassword> <SaveConnection>True</SaveConnection> <SavePassword>True</SavePassword> <Column>Currently Assigned To</Column> <Column>Product</Column> <Column>Component</Column> </ROOT>