Upload tests and test sets from excel into test management 2.0

[Nick Goding1]

Hello,

We're using Test Management 2.0 but already created all of our tests and associated steps into excel. Is there any way to upload these directly into ServiceNow from an excel template? Thanks.

[SusanWinKY]

Hi Nick, we're also looking into this. Have you made any progress on it that you'd be willing to share?

[Michael Brown6]

I was able to figure this out.  I do not have an update set, but I will try to explain how I did it. 

I created a spreadsheet with the following columns. 

• Test Name  (text) 
• Test Step (text)
• Needs Verification (true/false)
• Owner (email address)

e.g.

Test Name   |   Step      |   Needs Verification   |  Owner

Test 1           |   Step 1   |   true                           |  joe@aol.com

Test 1           |   Step 2   |   true                           |  joe@aol.com

Test 2           |   Step 1   |   true                           |  joe@aol.com

Test 2           |   Step 2   |   true                           |  joe@aol.com

This should result in 2 Test with 2 steps each.

I created a Data Source to import the spreadsheet.  I then created 2 Transform Maps

First Transform (Order 100)

This imported into the "Test Version" (sn_test_management_test_version) table.  I mapped

• Test Name --> Short Description (on Test Version table)
• Owner --> Owner (used the "email" address as the Referenced value field name)

Second Transform (Order 200)

I mapped the following to the "Test Step" (sn_test_management_step) table.

• Test Name --> Test Version (Referenced value field name = "short_description".  This finds the Test with the same short description.  You will need to ensure that each overall Test has a unique name).
• Needs Verification --> Needs Verification (the true/false in the spreadsheet will check the box or not.
• Test Step --> Step

With this method, I was able to import Tests, with Steps.  Hopefully this helps.