Hello All,
As we know we can`t get full path of TC with in QC and to get it through QC SQL reports we have to create an extra userdefined field, even if it doesn`t get the path of old test cases.To over come all this issues I have prepared this add-in, using this add-in tool you can download all available test cases names & their full path in to an excel sheet.Please let me know if you have any deficulty in useing it.
Download Add-in
Quality Center TestCase Name & full Path download add-in
Example: if you want to download all TC and Full path in a QC project then just give "Subject" as a path, if you want to download TC`s from a specific path then give the path of the TC ("Subject\Folder1\Folder2").
Note: The folder should have at least one child folder in it.
Installing Add-in :
Pre-requisite: Before you use the QCTCdownload add-in, make sure that Microsoft
Excel and Quality Center Client are installed on your machine.
Unzip “QCAdd-in_APM.zip” and copy QCTCdownload.xla file to Microsoft office Start up location.
Microsoft Start up location
<drive>:\Program Files\Microsoft Office\Office\XLStart.
For example, location for Microsoft Excel 2007
<drive>:\Program Files\Microsoft Office\Office12\XLSTART
How it works:Add-in can only download following Quality Center fields in to Excel from given QC url and project:
Module Field Name Field Lable Description
Test Plan TS_NAME Test Name Test Case Name
Test Plan TS_SUBJECT TC Path Subject path of TC Instruction to download data from Quality Center:
In Excel, open the HP Quality Center Download wizard:
Excel 2003. Choose Tools > Import Data > HP Quality Center.
Excel 2007. Click the Add-ins tab and click the Import Data from HP Quality Center button.
The Quality Center Download Wizard opens
Type QC URL,Domain, Project and your user name, password.
And give subject path (Ex: Exp: Subject\Foldername).
Then Click on “Get Data” button.
You will get a confirmation message, Click on “OK”.
You can see data is pulled from Quality Center and prints in active excel sheet.
Wait till the “Download Completed” message is displayed.
Here is some good tips found in KM862096/KM450424, hope this will help you...
Steps need to be taken to improve the slow performance of Quality Center:
1. Compression
The Client Server compression mechanism that was originally developed for QC10.0 and QC 9.2 is applied. If working in a LAN environment, these improvements will probably not have a major effect. That said, improved performance will still be observed.
2. Using QCExplorer and a desktop installation
If QCExplorer is installed, then it will skip the file download phase and will improve login times.
3. Avoiding the use of a blank filter upon login to the Defects module
When the user enters the defects module, the system runs the last filter to retrieve the list of defects. If there is an empty filter, the returned list of defects can be very large. That is, the users should not logout with an empty filter. In these cases, a simple filter of "assigned to = " may improve login times.
4. Using the same machines for subsequent logins
Since QC client uses a local cache for all kinds of settings, subsequent log-ins from the same machine should be a lot faster than the first login from that machine.
5. Leaving QC Open
If QC is left running, the slow login is possibly avoided.Login performance is slow with Quality Center client startup
Cause
Network latency in the system environment
QC files are being checked by anti-virus software during cold startup of Internet Explorer
Version and signature checks are being performed on all QC files
Fix
Tips to make Quality Center client load faster:
Reduce network latency to less than 200 ms
Do not close IE window after logging out from QC
Put QC files in the exception list of the antivirus software
For example: Put all the files in the following folder and sub folders in the exception list of the antivirus software: C:\Program Files\Common Files\Mercury Interactive\Quality Center.
NOTE: QC must be at patch 10 or above to see the loading progress.
The Import and Export module primarily works in the background any time you transfer components between the SAP TAO Client and HP Quality Server. The user interface is useful for manual maintenance activities. You may want to transfer components to:
- Back up components on the HP Quality Server or on a hard drive.
- Transport components from one HP Quality Server project to another, or from one server to another
- Download components from HP Quality Center.
There is no limit to the number of components you can import or export.
Exporting Test Components
When you export a component from SAP TAO to the HP Quality Center, the component gets stored in the file that you designated in Connections.
To export components from the SAP TAO Client
1. In the SAP TAO navigation bar, click Import/Export.
2. Navigate to the directory in the SAP TAO directory.
3. Select the checkbox next to the transactions that you want to export to HP Quality Center.
4. Click Export to QC. The status bar indicates the export’s progress.
5. Check the designated folder on the HP Quality Center to make sure the Export succeeded.
Importing Test Components
When you import a component from the HP Quality Center, you can store the component in any location for
which you have permission.
To import components from the HP Quality Center
1. In the SAP TAO navigation bar, click Import/Export.
2. Navigate to the directory you want to import from on the HP Quality Center.
3. Click the box next to each of the components you want to transfer.
4. Click Import From QC.
5. A Browse For Folder popup opens. Browse to the folder where you want to store the components.
6. If you need to make a new folder:
a. In the Browse Window, browse to the folder or directory where you want to make a new folder.
b. Click Make New Folder. A new unnamed folder appears in the directory.
c. Enter a name for the new folder
7. Click OK.
8. Make sure that the new folder exists and that it contains the exported components.
