import test suite from excel to testlink:how to append data?

typing82 · Post by **typing82** » Mon Jan 07, 2008 1:02 am

Hi guys,

I manage to create a xml schema which enable the data from excel to be imported by testlink. however i got some problem that if I import the same xml data again, testlink will create another test suite with the same name of the previous test suite.
how I can write a code to check if the xml data ready for import contains testsuite that exist in the testlink, it will append the data into the same testsuite, not create a new test suite.
if not, what should be done to avoid duplicated test suite problem??
thx a lot. hope to see someone could provide solution.

sujaldalia · Post by **sujaldalia** » Tue Jan 08, 2008 7:35 pm

Hi,
Do you mind sharing how you created xml schema which enabled the data from excel to be imported to testlink? I have test cases in excel but just not sure how to get started with import process.

Thanks,
Sujal

typing82 · Post by **typing82** » Thu Jan 10, 2008 1:33 am

sujaldalia wrote:Hi,
Do you mind sharing how you created xml schema which enabled the data from excel to be imported to testlink? I have test cases in excel but just not sure how to get started with import process.

Thanks,
Sujal

I have replied your PM.

agarg2 · Post by **agarg2** » Tue Jan 15, 2008 4:25 pm

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 readme and once finished I will post the script with readme and sample xls.

Regards,
Arun Garg

import test suite from excel to testlink:how to append data?

import test suite from excel to testlink:how to append data?

Script to import test-cases from xls