This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
steps_to_migrate_test_case_steps [2018/11/01 13:25] root created |
steps_to_migrate_test_case_steps [2018/11/01 15:39] (current) root |
||
|---|---|---|---|
| Line 2: | Line 2: | ||
| Migrating test cases is not an easy task, if you follow the steps below, you should be successful. Reference from: | Migrating test cases is not an easy task, if you follow the steps below, you should be successful. Reference from: | ||
| + | |||
| [[https:// | [[https:// | ||
| + | |||
| [[https:// | [[https:// | ||
| - | Step 1: Create filter on source for the project that you're exporting test cases for, name it as " | + | |
| + | Step 1: Create filter on source for the project that you're exporting test cases for, name it as " | ||
| Step 2: Open project and create single test cycle with all the test cases: | Step 2: Open project and create single test cycle with all the test cases: | ||
| - | a) Tests -> Plan Test Cycle | + | |
| - | b) Create Cycle (+ button) -> give it a name such as " | + | a) Tests -> Plan Test Cycle |
| - | c) Click the 3 dots button -> Add Tests | + | |
| - | d) Select "Via Search Filter" | + | b) Create Cycle (+ button) -> give it a name such as " |
| - | e) Verify that you have the right amount of test cases in your test cycle. | + | |
| + | c) Click the 3 dots button -> Add Tests | ||
| + | |||
| + | d) Select "Via Search Filter" | ||
| + | |||
| + | e) Verify that you have the right amount of test cases in your test cycle. | ||
| Step 3: Export test executions to CSV | Step 3: Export test executions to CSV | ||
| - | a) In the project, go to Tests -> Search Test Executions | + | |
| - | b) Perform a ZQL search as follows: cycleName = " | + | a) In the project, go to Tests -> Search Test Executions |
| - | c) Click Export (button) -> CSV | + | |
| - | d) Give short meaningful name (there is a character limit on sheet length, I recommend names no longer than 12 characters) ex. ABCExport.csv | + | b) Perform a ZQL search as follows: cycleName = " |
| + | |||
| + | c) Click Export (button) -> CSV | ||
| + | |||
| + | d) Give short meaningful name (there is a character limit on sheet length, I recommend names no longer than 12 characters) ex. ABCExport.csv | ||
| Step 4: Since Description does not come through, it has to be copied in manually, follow the steps below: | Step 4: Since Description does not come through, it has to be copied in manually, follow the steps below: | ||
| - | a) go to Issues -> Search for Issues | + | |
| - | b) load up the filter from Step 1 | + | a) go to Issues -> Search for Issues |
| - | c) Open the CSV file from Step 3 in Excel | + | |
| - | d) Create empty column in column E | + | b) load up the filter from Step 1 |
| - | e) Add the field name Description in first row of column E | + | |
| - | f) For each row of Issue Key (column C) type description from filter into the spreadsheet | + | c) Open the CSV file from Step 3 in Excel |
| - | g) For any fields that don't have anything, you need to put something, I recommend N-A | + | |
| + | d) Create empty column in column E | ||
| + | |||
| + | e) Add the field name Description in first row of column E | ||
| + | |||
| + | f) For each FIRST row of Issue Key (column C) type description from filter into the spreadsheet | ||
| + | |||
| + | g) For any fields that don't have anything, you need to put something, I recommend N-A | ||
| Step 5: Save the CSV file, then convert to XLS by going to File -> Save As -> Select Excel 97-2003 Workbook (*.xls) | Step 5: Save the CSV file, then convert to XLS by going to File -> Save As -> Select Excel 97-2003 Workbook (*.xls) | ||
| + | |||
| Step 6: Load up destination jira server project | Step 6: Load up destination jira server project | ||
| + | |||
| Step 7: Tests -> Importer (if you don't see Importer, you need to enable ZAPI API in Zephyr Plugin version 4.0 and above) | Step 7: Tests -> Importer (if you don't see Importer, you need to enable ZAPI API in Zephyr Plugin version 4.0 and above) | ||
| + | |||
| Step 8: Select the following for options: | Step 8: Select the following for options: | ||
| - | a) Project - Project name where you're importing to (ABC) | + | |
| - | b) Issue Type - Test | + | a) Project - Project name where you're importing to (ABC) |
| - | c) File Type for Upload - Excel | + | |
| - | d) Link type & Link - leave blank | + | b) Issue Type - Test |
| - | e) Discriminator - By Test Name Change | + | |
| - | f) Select file to Import - browse for the file you're importing (xls file) | + | c) File Type for Upload - Excel |
| + | |||
| + | d) Link type & Link - leave blank | ||
| + | |||
| + | e) Discriminator - By Test Name Change | ||
| + | |||
| + | f) Select file to Import - browse for the file you're importing (xls file) | ||
| Step 9: Once the file is selected, click the " | Step 9: Once the file is selected, click the " | ||
| + | |||
| Step 10: Map mandatory fields in order to get the test cases: | Step 10: Map mandatory fields in order to get the test cases: | ||
| - | a) Name - Test Summary | + | |
| - | b) Step - Step | + | a) Name - Test Summary |
| - | c) Result - Expected Result | + | |
| - | d) Testdata - Test Data | + | b) Step - Step |
| + | |||
| + | c) Result - Expected Result | ||
| + | |||
| + | d) Testdata - Test Data | ||
| Step 11: Optionally map additional fields as needed. Note for example " | Step 11: Optionally map additional fields as needed. Note for example " | ||
| - | a) Priority - Priority | + | |
| - | b) Component/s - Component/ | + | a) Priority - Priority |
| - | c) Comments - Comment | + | |
| - | d) Description - Description (from Step 4) | + | b) Component/s - Component/ |
| - | e) Fix Version/s - Version | + | |
| + | c) Comments - Comment | ||
| + | |||
| + | d) Description - Description (from Step 4) | ||
| + | |||
| + | e) Fix Version/s - Version | ||
| Step 12: Click " | Step 12: Click " | ||
| + | |||
| Step 13: Verify if all was successful, if not review the logs | Step 13: Verify if all was successful, if not review the logs | ||
| + | |||
| Step 14: Load up issue search, and find issues you just imported Issues -> Search for issues -> search using JQL: project = ABC and issuetype = Test | Step 14: Load up issue search, and find issues you just imported Issues -> Search for issues -> search using JQL: project = ABC and issuetype = Test | ||
| + | |||
| Step 15: Verify that all data was migrated properly - pick and choose certain criteria | Step 15: Verify that all data was migrated properly - pick and choose certain criteria | ||
| + | |||
| Step 16: Create Cycle (see above for steps) and add the test cases to that cycle | Step 16: Create Cycle (see above for steps) and add the test cases to that cycle | ||