Quality Center Support and News
Showing results for 
Search instead for 
Do you mean 

Importing requirements, test cases & defects in excel to HP QC

SOLVED
Go to Solution
Occasional Contributor

Importing requirements, test cases & defects in excel to HP QC

Hi, we are trying to import requirements, test cases & defects already documented in excel into HP QC. Need assistance for the same. Thanks.
1 ACCEPTED SOLUTIONS
Highlighted
Regular Advisor

Re: Importing requirements, test cases & defects in excel to HP QC

Rubal,

Pls see the attachment.Its a template.Have got it from somewhere.Not tested.You can try it out.

8 REPLIES
Honored Contributor Honored Contributor

Re: Importing requirements, test cases & defects in excel to HP QC

Hi Rubal,

what do you need? i've never import defects but i think is similar to reqs and tests.

Let me know.

Ciao, Massimo.
Highlighted
Regular Advisor

Re: Importing requirements, test cases & defects in excel to HP QC

Rubal,

Pls see the attachment.Its a template.Have got it from somewhere.Not tested.You can try it out.

Occasional Contributor

Re: Importing requirements, test cases & defects in excel to HP QC

Hi Massimo,

We already have a lot of requirements & test cases on excel but since, we are implementing HP QC. We need to import those back into HP QC.

Anything on this front would be great. Thanks.
Occasional Contributor

Re: Importing requirements, test cases & defects in excel to HP QC

Sanjeev,

Looks good. Let me check & revert. Thanks.
Honored Contributor Honored Contributor

Re: Importing requirements, test cases & defects in excel to HP QC

Hi Rubal,

with the excel add-in you can export data from excel to QC.

Are you set everything on the client? Check that you can write into the folder:
c:\Programs\Microsoft Office\OFFICE11\XLSTART

then download the excel add-in on the client.



The add-in tool relations the columns of the excel within the QC fields. So firstable you need to know exactly which are the mandatory fields then you need to create a map (this is the 6th step of the export flow) to relate the excel columns with the QC fields.

to export datas you need to select all the datas, the area to be export in qc, for example you can select all the line(s).

then start the "Export to Quality Center..." tool and go on from each step of the flow... at the 6th step relate the columns with the QC fields and go on.

Let us know.

Ciao, Massimo.
Honored Contributor Honored Contributor

Re: Importing requirements, test cases & defects in excel to HP QC

Did you have a look to the QCMSExcelAddin.pdf which is installed with the Excel Addin? There is description of format of each type of entity that is possible to import to QC from excel. You can see there also the notes for attachments.
Occasional Contributor

Re: Importing requirements, test cases & defects in excel to HP QC

Used excel add in with template shared by Rajeev. Thanks Guys. :)
Occasional Contributor

Re: Importing requirements, test cases & defects in excel to HP QC

Thanks Sanjeev & Massimo