Importing test cases into Azure DevOps can be done using the built-in tools or extensions. Below are the common methods to import test cases efficiently:
1. Using the Excel Integration (Test Case Migrator)
Azure DevOps integrates with Excel to allow you to import test cases.
Steps:
- Install Azure DevOps Office Integration: Go to the Download Center and install the ‘Azure DevOps Office Integration’ add-on.
- Prepare Your Test Cases in Excel: Ensure the Excel file contains fields such as Title, Steps, Expected Results, Priority, and Assigned To.
- Connect to Azure DevOps: Open Excel and navigate to the Team tab in the ribbon. Click on New List and connect to your Azure DevOps project.
- Map Your Columns: Select the Test Case work item type and map the columns in Excel to the corresponding fields in Azure DevOps.
- Publish the Test Cases: Click Publish to upload the test cases to Azure DevOps.
2. Using the Azure DevOps REST API
If you need to automate or handle bulk imports programmatically, you can use the Azure DevOps REST API.
Steps:
- Authenticate: Use a Personal Access Token (PAT) to authenticate your API calls.
- Prepare the Data: Format your test cases in JSON according to Azure DevOps API specifications.
- Create Test Cases: Use the POST endpoint to create test cases. Provide the necessary fields like name, description, and action steps.
- Execute the API Call: Use tools such as Postman or Python scripts to perform the import.
3. Using Third-Party Tools
Several tools/extensions simplify importing test cases into Azure DevOps, such as:
- Test Case Migrator Plus: An extension that supports migrating test cases from Excel or other tools into Azure DevOps.
- Test Management Extension for Azure DevOps: Offers robust importing, reporting, and management features.
4. Using CSV Import via Test Plans (Preview Feature)
Azure DevOps has a CSV import feature for test cases, which may need enabling.
Steps:
- Enable the Feature: Go to Project Settings > Preview Features. Enable the Test Plans: Import test cases from CSV option.
- Prepare the CSV File: Use a simple structure with headers such as Test Case Title, Steps, and Expected Results.
- Import the CSV: Navigate to Test Plans in Azure DevOps. Select Import test cases and upload the CSV file.
How to import test cases from QA Touch into Azure DevOps?
To enhance the process of importing test cases from QA Touch into Azure DevOps, start by leveraging QA Touch’s custom export feature to ensure the exported test cases include all necessary fields such as Title, Steps, Expected Results, and custom attributes. Use Azure DevOps’ Excel Integration or CSV Import tools for uploading. For large-scale imports, consider automating the process by scripting with Azure DevOps REST API, ensuring consistent field mapping between QA Touch and Azure DevOps. Additionally, QA Touch’s integrations with Azure DevOps can simplify data synchronization, reducing manual effort and maintaining traceability between test management and development workflows.
