0

This was imported into the "Test Version" (sn_test_management_test_version) table. I mapped the following fields:

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

Second Transform (Order 200)

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

  • Test Name → Test Version (Referenced value field name = "short_description". This ensures that the Test with the matching short description is found. Please ensure that each Test has a unique name).
  • Needs Verification → Needs Verification (the true/false value in the spreadsheet will check the box accordingly).
  • Test Step → Step
Upload tests and test sets from excel into test management 2.0
Working Code Edited question March 4, 2025