Transcript Alternative Quality Center Reporting and Data Extraction

Don Smith
[email protected]
Tech4Test.com




Excel Reports
HTML App using OTA
C# using OTA
And any other tool or language that can access
a Dynamic Link Library (DLL)


HP User’s Guide (12 pages)
SQL



Retrieve data from almost any table or test asset
Database Reference (quality_center_db.chm)
Excel Visual Basic for Applications (VBA)

Format data via VBA (PivotTables, Charts, etc.)




Filtering by Test Plan Path
Filtering by Test Lab Path
Filtering by Release/Cycle
Filtering by Other Fields

Filter by
Test Set
 ReleaseName
 ReleaseCycle
 TestSetFolderPath


Other Fields


Test Set Fields can be added into the select and
where clauses
Test Case Fields
can be added
but require the
addition of the
‘Test’ table to the
from clause and
an additional
statement to the
where clause




We have the data…how do we format it?
What does the user of the report want?
What is important to highlight?
How are we going to highlight it?




Excel VBA – Excel Macros
Create PivotTables, Charts, etc.
Create Custom Tables
Summarize, Manipulate and Format Data



Post-processing = Excel VBA/Macros
Default gives you the “Range”
Tip: Use the “Microsoft Visual Basic for
Applications” editor in Excel to create your
Post-Processing code

On the PTSumm worksheet “PivotTable”

Reporting by type of tests and application

Reporting by Iterations

What is an HTML Application?


Single file with HTML and Scripting included
As per Microsoft, HTAs are full-fledged
applications. HTAs pack all the power of
Internet Explorer—its object model,
performance, rendering power and protocol
support—without enforcing the strict security
model and user interface of the browser.
http://msdn.microsoft.com/enus/library/ms536496(VS.85).aspx

GUI for connecting to QC

Test Plan view of folders and test cases





Sqaforums.com
Forums.itrc.hp.com
Msdn.com
ConnectedTesting.com
Other random code searches…


Live Demo
Questions
Utilities available for download at Tech4Test.com
Don Smith
[email protected]
Tech4Test.com