Problem to Import from xls

[dgonzalez]

Hi
How can i to import a test case from xls with "preconditions" ???

[Amaradana]

Please refer help files.

[pelletd]

Hello,
The problem with TestLink 1.9 Testcase import tool is that Name and Summary are imported fine, but not the Steps and Expected results column.
The workaround is to follow "2.9 Import Test Cases from Excel via XML" in document "http://172.20.22.84/testlink//docs/tl-file-formats.pdf" but adapting it for 1.9 as follows. Save this as testcase_template.xml. Then open with Excel as XML table, drag the bottom-right corner of the table to create the required number of rows according to the number of testcases in your testplan, and paste the columns from your .xls testplans and Save As XML. Then import into TestLink. As a trial, import this testcase_template.xml into TestLink to see which data ends up where.

testcase_template.xml:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<testcases xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<testcase name="ID1">
<summary>Summary</summary>
<preconditions>Provided (Pre-conditions)</preconditions>
<steps>
<step>
<step_number>1</step_number>
<actions>When (Trigger)</actions>
<expectedresults>Then (Expected results)</expectedresults>
</step>
</steps>
</testcase>
<testcase name="ID2">
<summary>Summary</summary>
<preconditions>Provided (Pre-conditions)</preconditions>
<steps>
<step>
<step_number>1</step_number>
<actions>When (Trigger)</actions>
<expectedresults>Then (Expected results)</expectedresults>
</step>
</steps>
</testcase>
</testcases>

Best regards,
:Danielle

[Matt]

Is this going to be fixed? Because all the documentation indicates that .xls is supported in 1.9 as per 1.8.

We are looking to upgrade to 1.9 from 1.8 and have been planning to do so for a while. We have been creating test cases using .xls spreadsheets following the convention required for TestLink imports (due to the nature of testing required we have been unable to move our whole operation into 1. and the removal of .xls support will be a big blow, requiring a fair amount of effort to work around

[asgzl]

I support Matt, import testcase from excel is very convenient and I believe it's needed for most of the users. Can this issue be treated with high prioirty and fixed in next 1.9.2.

[minimalromoy]

Here is the workaround::
http://mantis.testlink.org/view.php?id=4011