Importing Test Cases from Excel

The release related discussions, plans and questions.
Locked
ratan_pahwa
TestLink user
Posts: 1
Joined: Mon Dec 22, 2008 11:32 am

Importing Test Cases from Excel

Post by ratan_pahwa »

I am trying to import test cases to Test link 1.7 from MS Excel. The problem is that the test cases have multiple steps, and each step is mentioned in a different row. See example below
--------------------------------------------------------------------------------------
Test Case Steps Actual Result Expected Result
TP_1 1 Login Login page should displayed

2 UserName UserName should be entered

3 Password Password should be entered

4 Submit clicking on submit button

while import the testcases these steps are imported/mapped as a single test case to the test link.I need these steps to import in a single test casei.e., under TP_1 .Please provide the solution if anyone knows.Thanks in advance
bhagwatn
TestLink user
Posts: 6
Joined: Thu May 15, 2008 6:31 am

Post by bhagwatn »

Ratan,
One row must have one test case, you will need to rearrange them yourself.

In Steps column, you enter multiple lines using ALT+ENTER technique. so, you go to each call paste your line (without newline) and press ALT+ENTER, this keeps the control in the same cell and lets you enter multi-line data in a single cell.

If you know Perl and you have your data in text format then, one can do this via Perl's Text::CSV module, else do all this manually.
Locked