I suggest you ...

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

199 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Shankar SathiamurthiShankar Sathiamurthi shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    4 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Anonymous commented  ·   ·  Flag as inappropriate

        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 HallidayAndrew Halliday commented  ·   ·  Flag as inappropriate

        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.

      • Visual Studio teamAdminVisual Studio team (Product Team, Microsoft) commented  ·   ·  Flag as inappropriate

        Hello NJKotze,
        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

        Thanks,
        Charles (aka Chuck) Sterling

      • NJKotzeNJKotze commented  ·   ·  Flag as inappropriate

        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.

      Feedback and Knowledge Base