Query Regarding TEST LINK

[Santosh Chandrashekhar Sheelvant]

Dear All,

Can Anybody let me know, How to EXPORT the Test cases to an EXCEL / .CSV file.

We are using the Test Link 1.7.3 Version.

And currently the export is permitted only in XML format... but we are also looking for a mechanism where in we can export the Test Suites to .XLS or .CSV file format.

Awaiting your help in this regard

--
Regards-

Santosh C Sheelvant

[praveen kumar]

Open the Xml file in the excel. excel supports of converting xls file
to xml and viceversa

[chsrre]

Hi all,

I am also facing the same problem.
i have converted excel to xml by using a conversion tool.
The xml file is generated and i uploaded it into testlink
Testlink throws an error saying that "Wrong testcase in the file".
Can i know clearly the format for writing the testcases so that i
convert it into correct XML format.
Please help me ASAP coz i have been strucked up with this problem

> > Santosh C Sheelvant- Hide quoted text -
>
> - Show quoted text -

[noelob]

If you need to be sure of the XML format, why not create a test case
and export it in XML. This should show you the format the Testlink
expects

Regards,
Noel

[chsrre]

Hi Noel,

Thanks a lot for your reply.

I have got the XML format but the problem here is we are preparing
the testcases in excel format.

After that i am converting the excel to a CSV file,and converting this
CSV into XML using tool(gives the format which Testlink accpets)

When i am trying to upload it to the TestLink Steps and Expected
results are not displayed properly.

Can u suggest me any other way of uploading testcases through excel or
csv or else how can we solve this issue.

> > > - Show quoted text -- Hide quoted text -

[Cynthia Sadler]

I don't know if this will help you. But perhaps you could save your excel file to CSV, and then use this Ruby script I wrote to convert to the XML format. It is in the user contributions area of the TestLink CVS repository on sourceforge:
http://testlink.cvs.sourceforge.net/viewvc/testlink/testlink/third_party/user_contribution/convert_csv_to_testlink.rb?view=markup

I also blogged about it here:
http://geekythoughtbubbles.blogspot.com/2008/11/importing-tests-from-csv-into-testlink.html

Kind regards,
Cynthia

--
http://agirlwalksintoablog.blogspot.com
http://geekythoughtbubbles.blogspot.com
http://www.myspace.com/thesaxidentals

[sraVanthi reddy]

Hi Cynthia,

 

Thanks for your quick response.

 

Can u give me more clarity on running this script??? Let me brief you up what all i have done to RUN this script(given by you!) :

 

1) i have downloaded "ruby.exe", one - click installer for Windows - XP.

2) Once done i have run this given script from IE browser, but on doing so error 's are thrown in the shell prompt.I am not able capture those errors !

3) Please help me to run this script by helping me out in How to suppply CSV file ? Where does the converted XML file gets saved? How to run this script, if not browser any alternative way !!

 

Please provide solution ASAP as i am stuck with this for last 2 weeks !!!

 

Thanks and regards,

Chintham

[Cynthia Sadler]

Hi,

The script is not run from the browser, but from the command line (or DOS prompt). So, assuming you have ruby in your PATH environment variable, go to the directory where you have your CSV file and run:

ruby convert_csv_to_testlink.rb infile.csv outfile.xml

where infile.csv is your test cases exported to CSV format and outfile.xml is what you want the new file to be named. The script expects four fields in each row: name, summary, steps, expected results. If your first field starts with the literal "name", it assumes it to be header row and it will skip that row. Hope that helps.

Kind regards,
Cynthia