Help requested: import a custom test cases excel to TL

Moderators: Amaradana, TurboPT, TL Developers

Help requested: import a custom test cases excel to TL

Postby ftide » Tue Apr 28, 2015 11:03 am

Hi,
I'm planning to implement TestLink into our Organization.
We have thousands of testcases, all written in Excel.
In our case, the test cases for each feature is written in a separate Excel workbook, (all test-cases are in one spreadsheet)
So, for feature1, we have testcases in a file called - feature1.xlsx, for feature2 - feature2.xlsx etc..

Our excel test cases sheet is a highly customized, with many additional headers than the standard format.
I am listing all the headers our test cases contain:

1. Test Case ID
2. Priority
3. Regression Test case (Yes/No)
4. Test Topology
5. Summary
6. Steps
7. Expected Results
8. Test Result
9. Test Build Version
10. Comments
11. Learnings
12. Automation Candidate [Yes/No]
13. Automated [Yes/No]
14. Automation Script Name

I would like to be able to import all of the test cases into Testlink seamlessly.
We are not tracking test cases to requirements, and test specification is also not currently in picture.

(These can be modified to start at the leftmost top corner of the excel file. No issue with that.)

If I understand rightly, to make this work:
a) some custom fields need to be created in Testlink to map to our sheet
b) our excel sheets need to be converted to XML to make the import into Testlink possible

It would be great if someone can point me in the right direction on how to make this work - as in what exact fields need to be added in Testlink..etc
How to create the right XML format for Testlink from our test cases sheets

I'm new to TestLink, and have little or no knowledge of XML at this time
Thanks in advance!
ftide
TestLink user
 
Posts: 4
Joined: Fri Apr 24, 2015 5:16 pm

Re: Help requested: import a custom test cases excel to TL

Postby gguenther » Fri May 22, 2015 7:15 pm

Here is what I recommend.

1. First of all the test specification is just grouping of your test cases so you will be using it, this is where you go to modify test cases, not where you execute them from.
2. Define any custom fields in testlink that your existing test procedures have and that are missing as built in fields in testlink then assign them.
3. Download this excel file created by Gowri on the following blog. http://testlink-import.blogspot.com/

https://docs.google.com/file/d/0BzBCa6US6n8TV0ZTLXlZa25vcUk/edit?usp=sharing

4. Modify the custom fields in the file and add your own making sure they match what you entered in testlink (I think the name has to match, I could be wrong though and it could be the label that has to match)
5. Start with one of your existing test cases. Copy it into the spreadsheet you just downloaded and arrange all the data properly including the custom fields.
6. Enable the developer tab in excel and run the macro in the worksheet to create xml files. It will create a test case and requirements xml file but you only need the test case if you don't have any requirements.
7. Open the xml file that was created (I suggest using notepad ++ as it will highlight any screwed up characters)
8. Skim through the xml file for any messed up characters, they will show up highlighted in orange as x92, x93, etc and fix these messed up characters.
9. Import the xml file using the import function in the test specification section of testlink
10. Once you have this working with one test case you can work on adding the rest of them to your spreadsheet. I would still recommend doing it in parts and not all at once to make it easier to find any issues with the import. When the import fails I don't think it gives you much information so it is up to you to figure it out.

I also saw this tool in the forums but I haven't had an opportunity to try it out yet.

http://forum.testlink.org/viewtopic.php?f=11&t=7221

Hope this helps!
gguenther
TestLink user
 
Posts: 2
Joined: Sat Apr 12, 2014 7:04 am

Re: Help requested: import a custom test cases excel to TL

Postby fman » Sat May 23, 2015 7:33 am

Thanks a lot for sharing your findings!, I've just twitted
fman
Member of TestLink Community
 
Posts: 3059
Joined: Tue Nov 15, 2005 7:19 am

Re: Help requested: import a custom test cases excel to TL

Postby MrBricodage » Sat May 23, 2015 8:53 am

File numbered 02 in the package provided here : https://github.com/MrBricodage/TestLink ... ExcelMacro should be able to generate the xml file, you have to copy your columns in the right order. Read carefully the documentation is in the same package to know the limitations.

You'll have to adapt project configuration as mentionned by gguenther in his post.
MrBricodage
TestLink user
 
Posts: 14
Joined: Fri Apr 27, 2012 7:57 pm

Re: Help requested: import a custom test cases excel to TL

Postby kbl163 » Mon Jun 29, 2015 7:38 am

MrBricodage,
Thanks for your contribution for our testlink fans.
I had used your generate tools for more than one year. But now, I encountered a issue after update testlink to 1.9.13. This issue description as below.
1.Export a test suite which test suite has more sub test suite;
2.Click "Import Test Cases from Testlink" in "02-ImportTestCasesIntoTestLink.xls" file;
3.Select step 1 exported xml file;
4. It will pop up a wrong prompt.
"Runtime Error '9'
Subscript out of range"
5. Click debug button
Cursor will stay " If (TestSuiteName(TShierarchy) <> "") Then "

Do you know this issue?
Thanks


MrBricodage wrote:File numbered 02 in the package provided here : https://github.com/MrBricodage/TestLink ... ExcelMacro should be able to generate the xml file, you have to copy your columns in the right order. Read carefully the documentation is in the same package to know the limitations.

You'll have to adapt project configuration as mentionned by gguenther in his post.
kbl163
TestLink user
 
Posts: 7
Joined: Sun Feb 08, 2015 11:33 am

Re: Help requested: import a custom test cases excel to TL

Postby aymen99 » Tue Mar 29, 2016 9:29 am

hello all,
i'm having the same issue i'm working on a on an undergraduate final year project work to get my software engineer degree and my project is about to import thousands of testcases to testlink.
Problem 1 : they re writtin in xls (each xls file contains dozens of spreadsheets and each sheet contains a test suite)
Problem 2 : they are customized (3 custom fields have to be added at least)
Is there a way to import all the testcases without modifying the Excel files?

Kind regards.
Aymen
aymen99
TestLink user
 
Posts: 3
Joined: Thu Mar 17, 2016 7:16 pm


Return to Import / Export



Who is online

Users browsing this forum: No registered users and 1 guest