Problem with test-case import via excel add-in

[Legacy User]

Hi there!

This is my first time trying to import test-cases via excel add-in, and here is what i experienced, and what prevents me from importing the test-case.

1. So i downloaded the template for TC import, filled in the needed fields, others were left blank, and here is the error i got when validating the .csv:

            ReadOnlyAttribute Attribute 'Last Verdict' in column U is ReadOnly and cannot be imported!
            ReadOnlyAttribute Attribute 'Last Build' in column V is ReadOnly and cannot be imported!
            ReadOnlyAttribute Attribute 'Last Run' in column W is ReadOnly and cannot be imported!

      I tried leaving those fields blank, populating them, deleting them, etc. but nothing would help. That's weird.

 

      2. Apart from those fields, the system keeps telling me that columns' headers up to "X" column cannot be null.           Considering the original template has only columns up to "W", the question is - what should i put in that column??           Whatever i put, the system finds a new problem - "incorrect header"! What's wrong with it?

 

      3. I cannot edit the schema for upload... Yes, i am a regular user, i have no admin rights, but it is not said anywhere that non-admin cannot edit the schema fields when importing.

 

      4. Have no idea and found no materials on how to import STEPS. I can import using "simple import", but each new line is a new test case. That's not what i want, i'd love to have one file as a test case, having several lines as test steps. All the links around "help", "support" and "community" areas are either broken or not found. All the videos are for oldest versions of the app. How can i import test steps?

 

      5. Try to import from the excel add-in using the import template - you'll see a bunch of errors on validation step, is the template out-of-date?

[davse04]

Hi Evgenii,

 

 

The templates are only to use with the Basic Import from the application. To understand how to build your Excel sheet for each Item type, from the Choose Import Pop-up, click the Schema button. This should help with questions 1,2,4, and 5. For question 3, if you are referring to the schema from the button, that is only to show how to build your sheet and it is not editable. Here is a screenshot of the Choose Import Pop-up.

 

 

Here is a screenshot of the Test Case Step Schema:

 

Let me know if that helps.

 

-Sean Davis