Vbscript To Export Test Cases From Qc To Excel

11.08.2019

Export Test Cases From Qc To Excel Using Vbscript
Vbscript To Export Test Cases From Qc To Excel Online
Vbscript To Export Test Cases From Qc To Excel

HP Quality Center is a web-based system for requirements, test, and defect management.

se-uql#toggleEditor'>

Hi guys i would like to know how do we export all test cases in test plan tab of quality center in word at a time. Anyways, i would like to differ that we cannot export all test cases at once in excel. Hers is how to do it - if you see the site admin tool in qc, you can see the qc db structure. I want to get all the open defects and the linked test cases in HP ALM (sql), below is the query i am using but the issue is that I am getting duplicate values for the Bug_id and the TS_Name. Sql alm hp-quality. I need an automation script to export HP QC defects to Excel using batch script or vb script. HP ALM - Import Test Cases From Excel - HP ALM Import Test Cases From Excel - HP ALM / QC Online Training Online Training - HP ALM / QC Online Training online video training for beginners to teach basic to advanced concepts covering Overview, HP ALM / QC Online Training, Site Admin, HP ALM Domain, Project, Users, User Interface, Releases.

0answers

Can't upload more than one test case into HP ALM

My problem is that the current code only uploads one Test case and I have no way of adding more than one since the number of test steps are dynamic (see attached image), hence I wouldn't know in which ..

Pᴇʜ

31.3k6 gold badges30 silver badges56 bronze badges

1answer

Quality Center Microsoft Excel Add-in Error

I work on Mercury Quality Center 8.2 Build 3406 Entreprise Edition.In order to write tests within Excel for Test Director, I installed the Excel Add-In. When I try to export the Excel file to ..

Community♦

2answers

Exception in thread “main” com4j.ExecutionException: com4j.ComException: 80040154 CoCreateInstance failed : Class not registered : .com4j.cpp

I am getting the following error when tried to log a defect in QC. Error is as follows:Exception in thread 'main' com4j.ExecutionException: com4j.ComException: 80040154 CoCreateInstance failed : ..

Community♦

12answers

High quality alternatives to HP (Mercury) Quality Center? [closed]

I'm looking for a more developer friendly alternative to HP (Mercury) Quality Center. I'm interested to find out what other tools developers & testers are using out there to manage their ..

Glorfindel

17.3k11 gold badges53 silver badges75 bronze badges

0answers

How to integrate HP Quality center's query builder with external programs like Python/VBscript?

I need to integrate 'HP Quality center' query builder tool with external programs like python or vbscript , So I can run multiple custom queries from the code and generate reports to on an excel sheet ..

1answer

com4j works in eclipse but not working in jar

I wrote a tool (using spring boot) to get the details from HP QC v10. I'm using com4j API for this. Program works fine in eclipse but throws following Exception when I'm running code through jar (..

1answer

Can we integrate protractor test with ALM (Quality center)

Is there a way to integrate protractor test with HP ALM(Application lifecycle management). Purpose is to save the execution results in Quality center.Is there a plug-in available for this?

2answers

Integrating Selenium with HP ALM

We have a requirement to understand if Selenium could be integrated with HP ALM. The requirement is to execute the Selenium scripts from ALM and to update back the results in ALM. From the research ..

0answers

How to run automate scripts in ALM from UFT where scrips were created using data driven framewrk?

I have to run automation scripts from ALM. I have created scripts in UFT using date driven framework. I have testcase and data in datasheet. How can I import that datasheet in ALM and run those ..

1answer

Propagating ALM parameters between called sub tests

In HP ALM/QC, given : a Template Test T1 with a parameter P1 a Template Test T2 with a parameter P2 Can I make T1 call T2 with the value of P1 inserted into P2? In T1 I tried to call T2 and pass '..

TheBlastOne

3,3693 gold badges33 silver badges65 bronze badges

2answers

HP ALM Quality center - How to register or add a vbscript externally instead of using workflow script editor

I need to perform some tasks related to workflow customization.Currrently, I am using the Workflow Script Editor to add a vbscript.Can the same thing be achieved without logging in to HP ALM and ..

1answer

TFS - HPQC Bi-Directional Integration

Can bug in TFS be integrated with defects in HP ALM in a two-way manner? If yes, how will it work?

2answers

Synchronize defects and requirements between TFS and HP QC

We use TFS 2010 for (development and requirements) and HP Quality Center for Testing and defects. We currently use Juvander TFS Bug Synchronizer for synchronizing defects and requirements between TFS ..

1answer

Can we write for loop in HPQC/ALM Query builder

I am using HPQC/ALM version 11.00 and I want to write an sql statement that retrieve the number of step that passed, failed, blocked, etc.. for each run id.I tried to write a for loop, but query ..

APC

125k17 gold badges126 silver badges235 bronze badges

5answers

Tracking History in HP QC(Quality Center)

Is there a way to tracking a bug's history in QC? What I am trying to get is how many bugs are being reopened over a release and how many times it got reopened. From the QC, I can only see the 'status'..

2answers

HP ALM REST API Get Requirements Coverage

Is there any way to get the requirement coverage matrix from a specific domain/project/requirements/id ?As I read from the REST API Help you can only get the number of covering items [test] but not ..

EstevaoLuis

1,2566 gold badges22 silver badges31 bronze badges

1answer

I can't openning a session in ALM 12.5x

I'am new in ALM. I just read some guides from REST API and try to repeat this. But I face up to the situation. In my last request I have 401 return (User not authenticated). What am I doing wrong?..

2answers

I need to import issues from HP Quality Center to JIRA

I was using HP Quality Center previously to log the issues. But now I am using JIRA for almost 5 projects. Its data is so important to us. How can I move all the issues from QC to JIRA? I found this ..

1answer

How to get everything present in clipboard using VBA code?

As of now, I am able to retrieve only text content from clipboard using Data OBJECT despite clipboard having html ,pictures & tables.How to retrieve everything present in clipboard as-is like ..

Community♦

1answer

HP- ALM Installation error - QAIAD.dll has no digital signature or the publisher is untrusted

I have installed HP ALM 11.52 on windows server 2008 r2 for learning purpose. I have used sql sever 2008 and iis 7. I have installed and configured the ALM successfully to use on local machine. Now i ..

1answer

Executing the test cases in alm from Excel by Test ID

I am trying to execute the test cases in QC ALM through an Excel macro. I am able to access the tests in testlist, but I am not able to find the particular test case I need to execute by its ID..

Community♦

4answers

Connecting to Quality Center v11 using COM4J

I am trying to connect to HP Quality Center V11 using Java code and com4j but i keep getting following error. Can someone please take a look at the error?When I use the URL in my browser and log-in ..

1answer

ALM Rest API (C#) : Creation of Test Set

I have successfully managed to sign-in/authenticate with my ALM instance using the Rest API, but I am now confused on what I should be doing to create a new test set.private string CreateTestSetURL =..

Marco smdm

7661 gold badge11 silver badges21 bronze badges

Export Test Cases From Qc To Excel Using Vbscript

1answer

HP ALM script to copy tests

Here is my question: Is it possible to change the copy paste especially in test plan using workflow script ?I need to make a script to copy and paste tests from one folder to another but the amount ..

Marco smdm

7661 gold badge11 silver badges21 bronze badges

2answers

Using VB interfaces in VB script

I work on workflow scripts of HPQC, and wanted to port some VB code given in the examples to VB script. I am not able to get the interfaces working in VB script.VB Code: Dim iscp As ..

2answers

Connecting to HPQC from 64bit JAVA

While trying to cennect HPQC from a 64bit machine(having 64bit JAVA, and ECLIPSE), I am getting the below mentioned exception:Exception in thread 'main' com4j.ExecutionException: com4j.ComException: ..

2answers

How can i move a test run from one test set to another in Quality Center?

In Quality Center, I want to move a test run with Passed/Failed status from one test set to another, copying its run history as well.Please help, how can i do that.

1answer

How can I integrate QC and Perforce

How can I integrate perforce and HP Quality Center? I would like to link perforce job and HP QC defect, and more important, we want to see perforce changelist in QC.

Brad Larson♦

163k44 gold badges369 silver badges546 bronze badges

1answer

Replacing portion of a URL in HPE UFT / VBscript

So I am trying to get a script to work that will obtain the current URL of the open tab, replace a portion of the URL, and enter in/navigate to the new URL which has the replaced text. I'm ..

Potatoツ

7,9432 gold badges12 silver badges34 bronze badges

4answers

How to add an attachment to a test set in ALM OTA via c#?

I run the following code but nothing shows up in ALM:AttachmentFactory attachmentFactory = (AttachmentFactory)tsTest.Attachments;TDAPIOLELib.Attachment attachment = (TDAPIOLELib.Attachment)..

Paul Roub

33.2k8 gold badges62 silver badges76 bronze badges

1answer

Quality Center administration via REST API

I'm currently working with the HP Quality Center REST API which works pretty good for creating and reading entities.But I'd like to perform some administrative tasks that way. Is it possible to add ..

3answers

How to upload IMAGE as run attachment in QC with HP ALM REST API

I have searched for days and trying to solve the problem by myself, unsuccessfully.I found that is possible to attach files to QC Run (using Python or Ruby) with something like this (send it in a ..

1answer

ALM Rest API : site-session returns 'The remote server returned an error: (400) Bad Request.'

I am getting '(400) Bad Request.' when I try complete authenticate against an ALM REST API, the first part (authentication) is successful) and I get the LWSSO_COOKIE_KEY, but site-session always fails ..

0answers

SQL returning duplicate values in the Query

I am trying to get the linked test cases associated to a defect. The Problem arises when i run the query, i am getting duplicate values even when there is a 'DISTINCT' clause to the query.Select ..

1answer

HPQC - RecordSet Not Displaying All Data

I am using HP (Microfocus) Quality Center 12.5 and designed a button using the toolbar in Workflow.The following code pulls the first value from the RecordSet but not all values. How do I pull all ..

Sohel

3671 gold badge5 silver badges22 bronze badges

2answers

QC : How to Find a test in QC by test case id using OTA API in C#

I am using OTA API in C#.How can I find a test in QC, if I am having test case ID. (Find Test by Test Case Id)Test may present under any folder in Test Plan.(i.e Under SUbject).

2answers

HP ALM - download a resource under a specific folder in the Test Resource module

We are using ALM 12. We have multiple folders in our Test Resources module, and some of the resources stored in these folders have the same name as in other folders. I am able to download a resource ..

1answer

Connection to HP ALM with macro using proxy

I am using TDApiOle80.TDConnection within my vba code to connect to HP ALM. But when i try to connect to HP ALM remotely i need to use proxy. Is there a way/method by which we can use proxy inside vba ..

Community♦

1answer

How to use 'Export to HP ALM' Addin for Excel using Macro or VbScript

I am trying to find a way to automate uploading manual testcases in excel to ALM. I have been using the 'Export to HP ALM' Addin. However, This process is manual as you need to select the range and ..

1answer

How to download HTML Report from HP ALM Performance Center 11.0 using rest API

I want to download HTML default report for a test run from Performance Center storage (using Rest API). Actually I need just summary.html file.I was using the following steps in PC 11.5: Request ..

ROMANIA_engineer

37k20 gold badges164 silver badges153 bronze badges

1answer

.net - How to get the test cases present in a test set using HP ALM 12.5

Below query is used to get the test cases present in a test set.But the response returns all the test cases present in the project irrespective of the test set id passed in the query. https://..

-1

1answer

How to export Defects from HP QC to Excel using windows batch script?

Can someone tell me how to export Defects from HP QC to an Excel sheet using batch script?I need an automation script to export HP QC defects to Excel using batch script or vb script.Thanks in ..

Marco smdm

7661 gold badge11 silver badges21 bronze badges

2answers

QC ALM REST API using java

Can any one help me on QC ALM REST API's.What are all the things we need to configure to work on this?I have access to QC 10. Can i use same QC 10 url to connect using ALM REST API's

1answer

Update HP QC Defect comment using API

Can anyone help me as my HP QC Update comment API is returning http_code: 401 which is 'user not authenticated'. But I am sending the request after login only.The flow is as below: I hit qcbin/api/..

Marco smdm

7661 gold badge11 silver badges21 bronze badges

2answers

Adding testcase results to Quality Center Run from a outside Python Script

I want to try to add all the step details - Expected, Actual, Status, etc. to a QC Run for a testcase of a TestSet from a Python Script living outside the Quality Center. I have come till here (..

-1

1answer

HPQC ALM - How to make TC_PLAN_SCHEDULING_DATE Read Only

I am trying to make 'Planned Exec Date' field read only inTest Lab --> Execution Grid. In Test Lab Module script --> TesSetTests_FieldCanChange Sub, I have added the following code: ..

Sohel

3671 gold badge5 silver badges22 bronze badges

2answers

Unable to remove folder with GIT repo via command in VBScript

I am using Quality Center to execute tests in Windows 8.The VBScript file creates a temporary (timestamped) workspace/folder to clone the git repository and execute the test.When I try to remove ..

koxta

2301 gold badge3 silver badges17 bronze badges

1answer

QC REST API : Unsupported Media Type

We use HP Quality Center and we upgrade 11.5x to 12.21 and i use the API to create a ticket. Connexion and ticket creation are ok, but attachement of file is not.I got {'Id':'qccore.general-error','..

1answer

How to change call test parameters in ALM?

I have created a test Templates it has just one step and I have used 3 parameters A,B,C. I have to run this script for 10 cases and every time A and B will remain the same but C will Change.One ..

Marco smdm

7661 gold badge11 silver badges21 bronze badges

0answers

Calling custom fields form Defect Table in HP ALM using C#

I am currently working on a C# code to export a Bug Report form HP ALM using OTA.I am successfully able to fetch the System Fields but am not understanding the way to fetch the User Defined fields..

153050per page

HP Quality Center is a web-based system for requirements, test, and defect management.

se-uql#toggleEditor'>

0answers

Can't upload more than one test case into HP ALM

0answers

How to integrate HP Quality center's query builder with external programs like Python/VBscript?

1answer

com4j works in eclipse but not working in jar

I wrote a tool (using spring boot) to get the details from HP QC v10. I'm using com4j API for this. Program works fine in eclipse but throws following Exception when I'm running code through jar (..

1answer

Can we integrate protractor test with ALM (Quality center)

Is there a way to integrate protractor test with HP ALM(Application lifecycle management). Purpose is to save the execution results in Quality center.Is there a plug-in available for this?

Bharath Kumar S

6261 gold badge4 silver badges21 bronze badges

0answers

How to run automate scripts in ALM from UFT where scrips were created using data driven framewrk?

I have to run automation scripts from ALM. I have created scripts in UFT using date driven framework. I have testcase and data in datasheet. How can I import that datasheet in ALM and run those ..

1answer

TFS - HPQC Bi-Directional Integration

Can bug in TFS be integrated with defects in HP ALM in a two-way manner? If yes, how will it work?

1answer

Can we write for loop in HPQC/ALM Query builder

I am using HPQC/ALM version 11.00 and I want to write an sql statement that retrieve the number of step that passed, failed, blocked, etc.. for each run id.I tried to write a for loop, but query ..

1answer

Propagating ALM parameters between called sub tests

In HP ALM/QC, given : a Template Test T1 with a parameter P1 a Template Test T2 with a parameter P2 Can I make T1 call T2 with the value of P1 inserted into P2? In T1 I tried to call T2 and pass '..

Wenneguen

1,0781 gold badge8 silver badges17 bronze badges

1answer

I can't openning a session in ALM 12.5x

I'am new in ALM. I just read some guides from REST API and try to repeat this. But I face up to the situation. In my last request I have 401 return (User not authenticated). What am I doing wrong?..

1answer

How to get everything present in clipboard using VBA code?

As of now, I am able to retrieve only text content from clipboard using Data OBJECT despite clipboard having html ,pictures & tables.How to retrieve everything present in clipboard as-is like ..

Srihari

1,1363 gold badges21 silver badges33 bronze badges

1answer

HP ALM script to copy tests

1answer

Replacing portion of a URL in HPE UFT / VBscript

So I am trying to get a script to work that will obtain the current URL of the open tab, replace a portion of the URL, and enter in/navigate to the new URL which has the replaced text. I'm ..

1answer