Is there any way to update Actual results in Quality Center from an Excel?
Software Quality Assurance, Software testing, Quality assurance, Microsoft Excel, HP Quality Center, Quality assurance testing
Is there any way to update Actual results in Quality Center from an Excel?
ASKED:
Oct 22, 2008 6:32 AM GMT
UPDATED:
December 27, 2008 10:27:09 PM GMT
RELATED QUESTIONS
- Macro code for QC to Excel?
- Creating a view from an external database
- Automated export/import between Microsoft Outlook 2003 and Microsoft Excel 2003
- Excel 2000 cannot open .ods file
- How do I merge an Exchange mailbox with a group calendar account?
- Are Oracle direct queries straightforward?
- Generating Excel spread sheets from Sequel on the iseries
- job scheduler email notification
- how to limit data access on AS400 through ODBC, client access or Sequel viewpoint product
- Funds committments interface to SAP PS & CO project
Answer Wiki:
There is an easy way which may not do everything you want and a harder way which can do everything.
1. The easy way: There should be a set of Excel Macros included with your release of QC for importing and exporting to the TD part of QC.
2. The hard way: you should be able to get the API for test cycles and write a vba macro to run the API.
3. The really hard way: Acquire enough access rights to walk the schema and write a odb routine in a vba macro to talk directly to the underlying database (probably MS SQL server on small enterprises, and Oracle on large ones). You want to update entries in the CYCLES table. (Not sure of the exact name because I am not currently working with TD/QC but have done so in the recent past.
4. You can, with some care, automate the TD interface using Mercury automation tools like WinRunner or QTP (and probably with other tools of an equivalent nature like silk). You could then use your spreadsheet as input to a datadriven WinRunner Script. WinRunner will not ordinarily record GUI map objects for TestDirector, so you may need to explicitly code these (The objects do show up in the spy).
1. The easy way: There should be a set of Excel Macros included with your release of QC for importing and exporting to the TD part of QC.
2. The hard way: you should be able to get the API for test cycles and write a vba macro to run the API.
3. The really hard way: Acquire enough access rights to walk the schema and write a odb routine in a vba macro to talk directly to the underlying database (probably MS SQL server on small enterprises, and Oracle on large ones). You want to update entries in the CYCLES table. (Not sure of the exact name because I am not currently working with TD/QC but have done so in the recent past.
4. You can, with some care, automate the TD interface using Mercury automation tools like WinRunner or QTP (and probably with other tools of an equivalent nature like silk). You could then use your spreadsheet as input to a datadriven WinRunner Script. WinRunner will not ordinarily record GUI map objects for TestDirector, so you may need to explicitly code these (The objects do show up in the spy).
30 pts.
To see other answers submitted to the Answer Wiki View Answer History.
