Page 1 of 1

exporting TSuites&TCases in a xml file from excel

PostPosted: Tue Apr 07, 2009 7:46 am
by ploinquer
First of all: this is no testlink problem, but my fighting with excel!

I try to open one of these sample xml files provided with testlink to get a sample file as a basis to specify my own testsuites and testcases (to get a valid schema):

open Excel: DATA - XML - IMPORT - file selection (C:\Programme\xampp\htdocs\testlink180\docs\file_examples\testsuite-100-testcases.xml):
- the following message occurs:
"the xml source has no relationship to the schema. excel will create a schema, that is based on the xml data. (but execl can open the data)"

Before changing the file I try to export it again:
data - XML - Export, the following message occurs:
- xml data cannot be exported and stored.
the xml links within this spreadsheet cannot be exported."

The same problem occurs, when I try to export a xml file from testlink, try to open it in execel and try to store it from excel without any changes.

Importing a predefined xml file from
"C:\Programme\xampp\htdocs\testlink180\docs\file_examples" works fine!!!

So I think it must be my excel settings.

Is anyone familiar with these little problems?

PostPosted: Tue Apr 07, 2009 7:59 am
by Amaradana
Please don't spam by posting multiple opsts related to same topic.

First : Please read the installation and user manual and other pdfs preent in the docs folder of your installed testlink folder. If you dont get the iinformation then post with the data and your query.

Second: Please search in the forum if you get any errors, if that is not availble, then post it with relavant steps and data providing.

Thanks,
Amardeep Maradana.

PostPosted: Tue Apr 07, 2009 8:27 am
by ploinquer
I have read all the docs, but there is no hint to the described problems.
Testlink inside seems to be good, but the documentation for new users is not going into that detail, they need. specially the documentation of the integration like data exchange with excel seem sto be very poor, what a pitty.

PostPosted: Tue Apr 07, 2009 8:33 am
by Amaradana
ploinquer wrote:I have read all the docs, but there is no hint to the described problems.
Testlink inside seems to be good, but the documentation for new users is not going into that detail, they need. specially the documentation of the integration like data exchange with excel seem sto be very poor, what a pitty.


I Have no idea, what your saying, you can make suggestion, But to be fact iam also a new user just one month or so, i learnt everything by reading docs, and not only me but many of the people do here by using docs, if you dont think that the docs are not so useful, make a suggestion on what particular aspect you want to be clear. We will see if we can implement that. As far as my understanding docs are fine.

Importing exisitng data into TestLink DB

PostPosted: Tue Apr 14, 2009 10:08 am
by karan
Gone thru this topic and also tried to import test data(TestSuites containing Test Cases) into TestLink.
As per the documentation of TestLink1.8.1, TestLink supports the xls for import only for TestCases. If you want to import the TestSuites+TestCases then you have to use the xml format. Now the problem is when you have your testdata in xls how do you generate the xml which contains all your test data. if you try to to use excel, First you would import the xml source ( source From TestLink docs) into xls. During this process, excel will create a schema based on the xml source. Then when you save the sheet as xml, excel will not allow because it doesnot support - List of lists, Denormalized data etc.
So the point is you can't use excel to modify the existing test data and store it in xml format which would otherwise been easier to do.
Suggestions on how to import the exisiting test data(TestSuites with TestCases) into TestlLink DB are sought for.

Re: Importing exisitng data into TestLink DB

PostPosted: Tue Apr 14, 2009 1:21 pm
by ploinquer
so, the problem seems to be the solution:
you have to import suites ans cases separatly.
- create a xml file to import all suites, import them
- create a xls file for each suite with testcases you would like to import: testsuite name will be the filename, each file conatins the columns testcase name, steps, expectes results, ...)
- insert alle testcases
- activate the appropriate testsuite in TL
- import alls related testcases
- repeat for another testsuite

Thanx for solving my problem.
I don't know why, but I always used the testsuite/testcase example to verify the import.