Has anybody found a clean way of importing excel test scripts as test cases and designs. My coworker says Mercury has a macro for this, but we are using test manager. We have alot of existing test scripts in excel, so the manual way, by creating test cases and importing .csv files on the design tab is not looking very appealing. Thanks in advance,
it's quite easy to import Manual Test script from a txt or csv file....
you should know one thing first.... you have to save your manual test script as txt or csv file, and one file for each test case.
that means, if you composed all test case scripts in a csv file, then you have to separate all cases into several csv files.
secondly, the fields of manual test script...
after your clicking Design button at test case properties, then Design Editor will be opened. Have a look at what fields it has, yes, they are Type, Note and Description. And my point is you have to specify the information for these 3 fields at your txt or csv file.
Give you an example....
this is my CSV file opening by Text Editor...
Step,Note1,Start the application
VP,Note2,Whether the windows has been opened?
After you import a CSV with the format as above, Design Editor will ask you to set the corresponding field for each one it needs. After that, the CSV file should be able to import properly.
What I think he is asking and wht I am also wanting to know is "Is there a way to import an excel file of many individual testcases?".
In Excel we have 100s of testcases fully defined and delineated with title, description, steps, and validation points. Now we have this product and are told put all of the testcases in it. How can we do this without having to break out each and every testcase from each Excel file? The time to separate the cases alone will push the limits of our projected timeline. Checking them all, making sure the "step" and "validation" marks are present and then importing them via the OTS Rational process could drive any number of my testers to the limits of thier sanity.
In a nut shell --- HELP! --- . [img]images/icons/smile.gif[/img]