All geek questions in one place

What's the best way to export error tracking data from an HP hosted quality center?

This question may be too specific for the product, but I would like to know if someone is exporting error data from the HP Quality Center.

HP Quality Center (QC) has an old COM API, but I prefer to use a web service or even a screen scraper to export data to an Excel spreadsheet.

In any case, what's the best way to export error tracking data from an HP hosted quality center?

+4
source share
4 answers

You can use this QC API code to modify errors / requirements.

TDAPIOLELib.TDConnection connection = new TDAPIOLELib.TDConnection(); connection.InitConnectionEx("http://SERVER:8080/qcbin"); connection.Login("USERNAME", "PASSWORD"); connection.Connect("QCDOMAIN", "QCPROJECT"); TDAPIOLELib.BugFactory bugFactory = connection.BugFactory as TDAPIOLELib.BugFactory; TDAPIOLELib.List bugList = bugFactory.NewList(""); foreach (TDAPIOLELib.Bug bug in bugList) { // View / Modify the properties // bug.ID, bug.Name, etc. // Save them when done // bug.Post(); }
+6
source

Personally, I like the COM API, and I use it to create Word and Excel reports. I did some experiments with VS2005, and the results are encouraging.

If you do not want to go along this route, I have a few suggestions.

  • If you use charting options (Analysis> Graphs). Each chart has a tab called a data grid that allows you to export data to Excel and a bunch of other data formats.
  • If you are an administrator or are friendly with your administrator, you can reset the entire database to access and then import into Excel. Of course, you lose all your relationships with tables, but it's better than nothing. It is also a really good way to learn db schema.
+1
source

Unfortunately, QC has not yet disclosed any web services. I think the easiest way is to access the database directly. The data you are looking for is in the project diagram in the BUG table.

QC also has an excel add-in, which you might want to try, but mainly for adding defects from excel to QC.

+1
source

If manual export is possible for you (i.e., not using the program), the next path will be the easiest way to export these defects.

In QC 9.2 (possibly present in earlier versions), Defects has an Export/All menu that exports defects in your defect grid to an Excel worksheet.

Exported fields are those that are shown in the defect grid, which can be configured using the "Select Columns" button (looks like a green grid).

0
source

Source: https://habr.com/ru/post/1276790/

More articles:


All Articles