Script to import test-cases from xls including Custom Field

[agarg2]

Hi,

I have written a perl script which reads the data from xls and import all the test-cases diretly into the TestLink MySQL DB (including keywords, custom fields) with categories. I have tested the script with various projects in my team and it is working fine.

I am using DBI and ParseExcel module to do this task.

Currently I am working on a small readme. Once finished I will post the script with readme and sample xls.

Regards,
Arun Garg

[Smittie]

While being able to manipulate custom field data via the XML structure already in place, a script that works with a spreadsheet might be a useful substitute. Does the script work in both directions? Can I export existing scripts to Excel?

Better still would be the ability to manipulate field for multiple test cases at once. A shift+click equivalent.

Smittie

[agarg2]

Hi,

Sorry for the delay is writing readme and sample xls file. Please find attached the XlsToTestLinkImport.rar which has the perl script and readme etc to import test-cases from xls (including custom fields, keywords etc).

Please let me know if you find any issues.

Regards,
Arun Garg

[agarg2]

I am not able to attach the script and working with TestLink team to resolve the issue I am facing. It may be something I am doing wrong.

Regards,
Arun Garg

[havlatm]

I apologize to Arun. Please download the script here:
http://www.teamst.org/_tlstore/XlsToTes ... Import.rar

[sandeepg]

Hi Arun,

I have test cases which has multiple rows for steps and expected result. Will it work? (As per demo excel sheet which has only single row test cases.)

-Sandeep

[agarg2]

Hi Sandeep,

Sorry, the script will not work properly in this case.

The script considers one row as a one test-case (if the data is correct) otherwise it will skip the row.

In your case, the script will consider first row which has all the data and import it. While it will skip the subsequent rows (which has only results and expected results) as the data is not sufficient for the script for these rows.

Regards,
Arun Garg

[gdeepak@aztecsoft.com]

I want to populate a TestSuite with the data from a XLS sheet,i want to add the data in the DB custom field and populate in the TL,i tried to add/insert the data in DB but when i tried to populate it with TL,its saying my search leads to no result ,can some body give me any solution

[agarg2]

I am not clear on what exactly you want to achieve? Please provide us more details or may be steps you are performing (with example) so that we can provide help, if possible.

Regards,
Arun Garg