Testers should be able to get parameters for a test case from a csv file
MTM should allow parameters for a test case to be picked up from a csv file or an Excel file
This is the feature team’s backlog
I can copy and paste parameter values form Excel into a test case, however beyond a certain number of rows the data is not displayed.
If I run the tests I can see that it says 1 or 103 iterations.
Is there a limit on the amount of rows / iterateions that can be copy and pasted?
Andrew Halliday commented
I'd like to support what NJKotze has said. The CSV idea is more limited than a general data source concept or even just an excel/access database link that could be indirectly updated from multiple sources anyway (if it was too hard to implement connection to any generic data source).
This idea would help greatly with refdata testing or to improve quality of testing through a centrally managed test data database.
The Test team is working on some backlog prioritization and future efforts.
Based on your earlier feedback we were wondering if you could let us know what we should be doing more of/differently.
One of my coworkers has created a survey to facilitate this process: http://www.zoomerang.com/Survey/WEB22EBRY95XJ6
Charles (aka Chuck) Sterling
Yes indeed. We currently have over 800 test cases. Every 4 weeks our database change meaning that customer test data is different. The irony is now that the tester have to manually update about 600 test cases to reflect new customer reference data. Not very clever.
So my view of this suggestion will be to allow MTM parameters to point to a data source such as CSV, Excel or SQL(using a SQL script) so that when the data in those sources change the test cases does not have to get updated. This will allow the tester to run the SQL scripts that generate the data source files and test case parameters are "updated" dynamically.