Skip to content

Bulk Import of Test Cases from Excel/CSV #173

Description

@DevashishSalgaonkar

Objective: To streamline the onboarding and migration process for QA teams by enabling the bulk import of test cases from Excel or CSV files into the Azure DevOps MCP server.

Background: QA teams often manage test cases in Excel or CSV formats. A native import tool would simplify the process of importing these test cases into the MCP server, enhancing efficiency and reducing manual effort 1.

Proposal: Functionality: Leverage the existing create_test_case tool to handle the bulk creation of test cases from CSV files using the MCP server.

Parameters:
file_path: Path to the Excel or CSV file
format: File format (csv or xlsx)
mapping_template: Optional JSON/YAML column-to-field mapping
validate_only: Preview import without committing
import_mode: create, update, or merge
suite_id: Optional test suite to associate cases
shared_steps_support: Enable linking shared steps by ID
custom_fields: Support for tags, iteration path, etc.

Additional Considerations: Include CRUD operations for configurations and parameters as part of the test plans tool. Provide an intermediate verbose step before the actual creation of test cases to prevent the creation of unnecessary data. Evaluate technical limitations such as the maximum number of test cases to be created and the size of the input file.

Metadata

Metadata

Labels

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions