Importing test cases from Excel to 1.9.1

Moderators: Amaradana, TurboPT, TL Developers

Importing test cases from Excel to 1.9.1

Postby georgeeager » Tue May 10, 2011 2:06 pm

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 :D
Hope that helps to anyone.
georgeeager
TestLink user
 
Posts: 1
Joined: Tue May 10, 2011 1:50 pm

Re: Importing test cases from Excel to 1.9.1

Postby bashibashouks » Wed May 11, 2011 12:07 am

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
bashibashouks
TestLink user
 
Posts: 1
Joined: Tue May 10, 2011 11:52 pm

Re: Importing test cases from Excel to 1.9.1

Postby istream » Tue May 17, 2011 11:54 pm

istream
Advanced user
 
Posts: 59
Joined: Wed Mar 31, 2010 10:28 pm

Re: Importing test cases from Excel to 1.9.1

Postby todnih » Sat Jul 23, 2011 9:32 am

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
Hello I'm todnih :)
todnih
TestLink user
 
Posts: 2
Joined: Sat Jul 23, 2011 9:08 am

Re: Importing test cases from Excel to 1.9.1

Postby fman » Sat Jul 23, 2011 10:44 am

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
fman
Member of TestLink Community
 
Posts: 3063
Joined: Tue Nov 15, 2005 7:19 am

Re: Importing test cases from Excel to 1.9.1

Postby avleaf » Thu Jul 28, 2011 1:27 am

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
avleaf
TestLink user
 
Posts: 2
Joined: Wed Jul 27, 2011 7:18 pm

Re: Importing test cases from Excel to 1.9.1

Postby aerodarius » Mon Nov 19, 2012 4:28 pm

Here is a program that you can use to convert test cases in XLSto XML: https://sourceforge.net/projects/xlstoxml/ :)
aerodarius
TestLink user
 
Posts: 2
Joined: Mon Nov 19, 2012 3:58 pm

Re: Importing test cases from Excel to 1.9.1

Postby Greco » Thu Nov 22, 2012 8:38 am

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)
Greco
TestLink user
 
Posts: 5
Joined: Mon Nov 19, 2012 3:59 pm


Return to Import / Export



Who is online

Users browsing this forum: No registered users and 1 guest