Alternative Quality Center Reporting and Data Extraction
Download
Report
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