Re: Importing requirements, test cases & defects in excel to HP QC (13800 Views)
Reply
Occasional Contributor
Rubal
Posts: 7
Registered: ‎02-21-2011
Message 1 of 9 (13,857 Views)
Accepted Solution

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.
Honored Contributor
Massimo De Rosa
Posts: 656
Registered: ‎03-02-2009
Message 2 of 9 (13,796 Views)

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.
Regular Advisor
SanjeevR
Posts: 113
Registered: ‎12-14-2010
Message 3 of 9 (13,800 Views)

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
Rubal
Posts: 7
Registered: ‎02-21-2011
Message 4 of 9 (13,793 Views)

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
Rubal
Posts: 7
Registered: ‎02-21-2011
Message 5 of 9 (13,793 Views)

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

Sanjeev,

Looks good. Let me check & revert. Thanks.
Honored Contributor
Massimo De Rosa
Posts: 656
Registered: ‎03-02-2009
Message 6 of 9 (13,793 Views)

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
Vladimir Skrbek
Posts: 2,093
Registered: ‎03-12-2008
Message 7 of 9 (13,793 Views)

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
Rubal
Posts: 7
Registered: ‎02-21-2011
Message 8 of 9 (13,793 Views)

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

Used excel add in with template shared by Rajeev. Thanks Guys. :)
Occasional Contributor
Rubal
Posts: 7
Registered: ‎02-21-2011
Message 9 of 9 (13,793 Views)

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

Thanks Sanjeev & Massimo
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.