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