As current testcase import methord has many restrictions, like only support xml, only can support one test step, etc.
I use python3+xlrd model to write a new script, which can export the content in excel to xml, and then you can import that into testlink
The script support
- main testcase attributes: name, summary, preconditions, actions and expected results.
- multiple steps, (max 5 steps)
- multiple lines in one excel cell (also will displayed as multiple lines in testlink)
The main restriction of the script
- only support testcase, not test suite
- don't support blank cell interval. That is, if you have action1, then name, summary, pre-condition must be filled in.
- not suppport requirement mapping
- if action exist, then corresponding expected result must exist, and vice versa.
As attachment is not supported in the forum, anyone who has interest in the script can reply you mail address, and I will send it to you.
As a tester, I must say I don't good at coding (actually it's the first script I made in the 5 years), so the script surely has much space to be improved. Any improvement is welcome.
[SOLVED] - new testcase import template and script
Moderators: Amaradana, TurboPT, TL Developers
Re: new testcase import template and script
open issue on mantis and attach code
Re: new testcase import template and script
see issue http://mantis.testlink.org/view.php?id=3949 and http://mantis.testlink.org/view.php?id=4011 to resolve your problem.
Another post that will also help. Read it completely.
http://www.teamst.org/forum/viewtopic.p ... 8&start=15
Another post that will also help. Read it completely.
http://www.teamst.org/forum/viewtopic.p ... 8&start=15