Skip Navigation LinksHome Page > Forums > SpiraTest Forums > SpiraTest Issues & Questi... > Folder Structure while up...

Folder Structure while uploading test cases from Excel addin

Wednesday, February 17, 2016

excel

import

Praveen460004p

Hi.

I'm new to SpiraTest & I'm trying to upload test cases using the Microsoft excel Add in. Can anyone explain me how to create folders,sub-folders & place test cases inside sub-folders (using excel addin) ?

I've tried selecting the type as 'folder' in test cases sheet, but indent isn't happening properly.

Eg for the folder structure:

Folder 1

Sub-Folder 1.1

Test Case 1.1.1

Sub Folder 1.2

Test Case 1.2.1

Folder 2

5 Replies

Wednesday, February 17, 2016

rajuarelli

re: Praveen460004p Wednesday, February 17, 2016

Praveen,

You cannot directly upload your sub folders using excel add in. Instead of that you can try the below one.

Enter the folder & Sub folder names in each row and for that select the Type as Folder .

Once you export them into spira,indent them as per your need.

Thursday, February 18, 2016

Praveen460004p

re: rajuarelli Wednesday, February 17, 2016

Thanks for the response Raju,

I have a problem in indent as well. Suppose I create child folder first(Sub-Folder 1.1)& then create parent folder (Folder 1), I'm not able to indent child folder inside parent folder, only the reverse is possible (as the child appears first in the list).

Tuesday, February 23, 2016

Praveen460004p

re: Praveen460004p Thursday, February 18, 2016

I think I found a way. Folder can be inserted anywhere in the middle, After inserting the folder below the cases, we can indent the cases.

Monday, April 17, 2017

htaylor

re: rajuarelli Wednesday, February 17, 2016

Was " directly upload your sub folders using excel add in" fixed in v5? I would like to export test cases from Excel to SpiraTest and maintain the folder structure. I would like to add test cases to an existing folder. The folders already exist in SpiraTest, first screenshot. In Excel, I have specified the folder structure, second screenshot. When I export from Excel, SpiraTest creates new folders named "20 - Assessments" / "100 - Adult Integrated" / TC. I have compared all names in NotePad. They are identical. Please tell me what is wrong with the Excel folder structure, lines 3, 4 and 5. Thank you

Monday, April 17, 2017

htaylor

re: htaylor Monday, April 17, 2017

We figured it out. If the folder already exists then we need to specify the Test #, column A.

What is the easiest way to determine the Test #/ID? I cannot find anywhere it is listed. We found it by exporting.

Thank you

Spira Helps You Deliver Quality Software, Faster and With Lower Risk

And if you have any questions, please email or call us at +1 (202) 558-6885

Statistics

Started: Wednesday, February 17, 2016
Last Reply: Monday, April 17, 2017
Replies: 5
Views: 3245

Folder Structure while uploading test cases from Excel addin

Spira Helps You Deliver Quality Software, Faster and With Lower Risk

Edit Thread

Edit Message

Search Results