Import Test Cases into Zephyr Scale and keeping original test case number

Hi,

<shudder> 🙂

I'm afraid there's no perfect solution for the approach you're taking.  I'm sure there are good reasons why you're having to work in this way, but IMO it's not great.  You're missing out on some great features for testers and test managers, and you're missing out on the power of Jira and Scale combined.  But if that's not an option...

... as you've discovered, you can't update test cases via an import into Scale - it just creates new test cases.  You should however be able to update test results into Scale using the API, but you'll need some (or someone with) technical experience using an API to be able to make that work, and I expect there will be a fair bit of transformation between your spreadsheets and Scale, particularly if your testers are sharing test cases - that, I imagine, would be very hard to manage.

That is disappointing, and short-sighted, and a lot of other words I could use 🙂

Something that might help is to use a custom field or use the label field to record the original test case ID.  And then going forward use that label or custom field as your ID reference.  Your workflow would then look like this:

Export test cases

Sent to testers

Testers update/you update

Add a new field to your Scale import template for label or a custom field that you've created

Transfer updated test case data to import sheet (remembering to transfer the test case ID)

Move test case ID into label or custom field

Upload data into Scale

Archive old test cases

In the Test Case screen view, add a column for Labels (or the new custom field you created)

Sort by that new column you just added, et voila!

I think that should work.  Let me know if it does.

By the way, this approach will work while you are developing the test cases, but it might not work when it comes to test execution, assuming you want to keep test results: each time you import and archive a test case, you are also archiving the test results.

I will give that a try. Thank you so much.

Hi,

My situation is a bit different but it results in the same problem.

We are in the process of testing the migration of Zephyr Scale to a new server. As we are testing, we have found some errors with the user mapping that are forcing us to delete all the Test Cases and import them again. This is causing the new test to create the Test Cases with different numbers. How can we preserver the exact number that were originally used? This will also be important when we add all the Test Cycles and Plans associated to these Test Cases as they are referencing the key.

We have access to the database if we need to run some SQL and we are using the REST API to transfer the Test Cycles and Plans.

As you have access to the DB you might be able to reset the seed of the Test Case ID for a project, but if you're unsure I guess your only option is SmartBear support.

In terms of what you could do in the UI to preserve the original ID, there aren't many options available and I can only think of the suggestion I made above, placing the ID into a custom field or label.