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 |