Failed to import test cases from Excel to QC 11.00.3

Hi ,

 

We want to import test cases from Excel to QC, while continuously get following error:

____________________________________________________________________________

Row: 1, Column: A1 - Field 'Subject': Value is required.

Row: 1, Column: B1 - Field 'Test Name': Value is required.

Row: 1, Column: G1 - Field 'Test Technique': Value is required.

Row: 1, Column: H1 - Field 'Test Title': Value is required.

 

Scan Report - 4 errors.

---------------------------------------------------------------------------------------------------------------------------

 

Screen shot see attached.

 

Other information:

1, Excel version: 2007

2, QC version: 11.00.3

3, Has installed HP-ALM-MSExcelAddin.exe for QC 11.0

 

I have tried many times and also searched some solution, while none of them succeeds. Could you help me?

Parents Reply
  • 1. Try to check the data inside of cells. If there are write exact text "Subject..." (I mean to check if there are not some not allowed chars) and so on.

     

    2. Try first export one test to excel so you will see the data.

     

    3. Try to create new blank excel, put one row with simple data and import, like:

     

    Subject  Test Name

    Subject  TestA

     

    and so on.

     

    4. Try to import test to a blank QC project without mandatory user fields like Test Title ...

Children