Importing test cases from Excel to 1.9.1

[georgeeager]

Hi guys,

I'd like to share my experience on the subject.
I used to work with Testlink 1.6 to 1.8 and always had no trouble using XLS->XML->Testlink import.

But after upgrading to 1.9.1 I found a surprise. The good old import-to-Excel-put-data-and-export-XML-back didn't work since the steps feature emerged!
The problem was that Excel 2010 didn't handle that XML mapping well.

I tried many different ways but still didn't succeed. The new Import-From_Excel feature really did the import of headers and summaries but didn't care about steps and results. The task was to upload a large amount of old cases to run regression.

So, the best choice for me so far was to use good old TL 1.8 format and upload all the cases to TL 1.8... And then when it was done - I did migrate to 1.9
Hope that helps to anyone.

[bashibashouks]

Thanks georgeeager.

I am evaluating TestLink for a client and I ran into the same issue. Since I don't have the luxury of importing testcases into 1.8 and then upgrading, does anyone have another workaround?

Thanks
Bashibashouks

[istream]

Please check this http://www.teamst.org/forum/viewtopic.p ... 6d82505e57 out.

[todnih]

Hello Guys,

I also have that problem, I think that version 1.6 and version 1.8 is really good handling those XLS - XML for testlink import. I think Test link developers is now working on that. I like what you did, you use Test Link version 1.8 and then after the import has finish you switched in the other version. I will look forward on that, Thanks for sharing your experience.

Regards,

todnih

[fman]

we are not working on direct XLS import, due to N level nature of test spec structure.
We will support XML format
On each tl 1.9.x distrubution there is an utility that allow you to use excel and then generate XML

[avleaf]

Take a look at my Plaintext to TestLink XML converter. It's an initial release, but might help.

We found we were taking too much time entering test cases into Test Link.

https://github.com/avleaf/Test-Outline- ... -Converter

[aerodarius]

Here is a program that you can use to convert test cases in XLSto XML: https://sourceforge.net/projects/xlstoxml/

[Greco]

The workaround I use was to customize an exported XML testcase, and edit it with and XML editor like Stylus Studio in grid view, you can also omit the CDATA fields for simplicity, here is a example.

Also I would suggest an improvement, it would be perfect if you can import many .xml at the same time, with multi-selection on the file explorer, I will open this suggestion in Mantis (as I think is its place)