Absent Member.. NamanBatra Absent Member..
Absent Member..
9423 views

Upload Manual TestCases from an excel to ALM-QC 11?

Hi,

 

I am pretty new to VBA,

 

I need some help  in making an excel macro which uploads Manual test cases from an excel 2007 to ALM-QC11 test plan.

 

We can't use the excel add-in as the number of test cases are pretty high and wish to automate the task + a lot of formatting is required in the excel sheets (which again is being done in the macro code itself).

 

So far, I have formatted the excel sheets in the required format and been able to successfully able to connect to QC in the required domain/project.

 

What do I do next and how to go about it?

 

Thanks,

Naman

0 Likes
6 Replies
Absent Member.. Trudy Claspill Absent Member..
Absent Member..

Re: Upload Manual TestCases from an excel to ALM-QC 11?

The basic steps would be
1. Determine the folder you want to put a test case in.
2. Find the folder or create the folder if it doesn't exist.
3. Add the test case
4. Add the test case steps.

There are many examples of this in the OTA API documentation. The programming language used is Visual Basic rather than VBA, but it is still pretty close.

You may also find this thread helpful.
http://h30499.www3.hp.com/t5/Quality-Center-Support-and-News/adding-a-test-case-using-OTA/m-p/4273269#M9608

After you've started working out the code, come back with more specific questions.

Of course, you can always ask for somebody to give you the complete code. I don't know if anybody will do that, though. Personally, I like the challenge of trying to figure it out and the process of learning something new.
[If this post solves or helps solve your issue, mark the thread as solved and give KUDOS to the author for their assistance.]

(Opinions expressed in my postings are mine alone, and do not reflect the opinions of my employer.No warranties express or implied for any solution/suggestion posted.)
Absent Member.. NamanBatra Absent Member..
Absent Member..

Re: Upload Manual TestCases from an excel to ALM-QC 11?

Thanks Trudy,

 

 

0 Likes
Nandi
Visitor.

Re: Upload Manual TestCases from an excel to ALM-QC 11?

Hi Naman,

Are you able to upload multiple test cases from excel to ALM ?

If yes, can you please share the code

0 Likes
Highlighted
Knowledge Partner
Knowledge Partner

Re: Upload Manual TestCases from an excel to ALM-QC 11?

Nandi,
Tool is available for this purpose.
Use excel addin tool for this activity.
https://marketplace.microfocus.com/appdelivery/content/microsoft-excel-add
Regards,
Srihari
Nandi
Visitor.

Re: Upload Manual TestCases from an excel to ALM-QC 11?

Srihari,

I am trying to develop a macro for uploading multiple test cases from excel to ALM because I don't wanna spend time in mapping the fields.

Can you please help me with the code ?

I am able to upload single test case but need help for uploading multiple test cases.

Your help will be appreciable

Thanks in Advance.

0 Likes
Knowledge Partner
Knowledge Partner

Re: Upload Manual TestCases from an excel to ALM-QC 11?

Hi Nandi,

Mapping fields takes very less time and effort.

Moreover, you can save the mapping file once it is created for first time and use it for further imports.

Still if you want to write the code on your own note that you have to consider writing all other data validations such as test name should not be > 120 characters etc, you can refer OTA API reference and excel import tool code as your starting point.

Regards,
Srihari
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.