Unable to import test cases from excel to PractiTest

Tests
1

Hi,

I am attaching the excel template where test cases reside. I tried importing by mapping excel column in PractiTest import screen. On clicking Import it shows following error:
We’re sorry but something went wrong.
We’ve been notified about this issue and we’ll take a look at it shortly. Use the Back button in your browser to return to your previous screen.
If you cannot go back to issues or tests view, then click on each of the links below:
Issues Default View
Tests Default View
TestSets Default View
Requirements Default View

Test case excel template

image.png1920×1030 84.8 KB

2

Hi Irfan,

Kindly note that the Author field should include the email addresses or the EXACT Display name of the desired user. The user needs to belong to the project.

Please revise the file and try to import it.

Thanks,
Christine

3

Hi Christine,

I tried importing test cases as per your suggestion by providing exact email address and display name but still I could not succeed in importing excel test cases into PratciTest. I am attaching the template for your reference.

Test Steps Template:

image.png1920×1030 92.5 KB

Could you please assist in this regard OR am I doing something wrong?

Your help will be highly appreciated.

Regards
Irfan

4

Hi Irfan,

Thanks for your reply.

What error message are you getting now? Have you checked the ‘Ignore first row’ checkbox when importing tests?

Thanks,
Christine

5

Hi Christine,

I have tried by checking and unchecking the Ignore first row check box. In both the cases I see following error:

image.png1920×1030 110 KB

Regards
Irfan

6

Let’s have a short session to review this.

Are you available at the moment?

7

Yes Christine, I am available now.

Regards
Irfan

8

Sending you a link to the session to your email address.

9

OK, will check the email.

10

Thanks a lot Christine for helping in resolving the importing of test case issue.

Following steps were carried out:
I was mapping excel and PractiTest columns wrongly.

Expected mapping is:
If you have excel with columns A, B, C, D, E, F, G, H,I, J with Testcase name, author, description, step name, step desc, step actual results, customer, module, test level, test type respectively, then while mapping in PractiTest provide actual column name.

If PractiTest has mandatory fields in the project under test case then add them to excel and provide the necessary values

If the excel has column A with test case name then in PractiTest provide A under Name field
If the excel has column C with test case description then in PractiTest provide C under Description field

Sample screenshot

image.png1920×1030 104 KB

Once again, thank you so much Christine for sorting out my importing of test cases issue.

Regards
Irfan

11

Thanks for your kind reply, Irfan :blush:

12

How do I import test cases into PractiTest?

There are 2 ways of importing tests and steps into PractiTest. You can import them together in one file, or you can choose to first import tests and then import the steps separately.