Unable to import IN EXCEL the exported XML from testlink

ananthnrk · Post by **ananthnrk** » Thu Nov 04, 2010 3:13 pm

hi,

We have implemeted Testlink 1.9 and i have added test cases for one of the feature. I have exported those testcases from testlink in a xml format and try to import in MS-Excel 2007. Excel is not showing the testcases and it shows only the xml tags. Can you tell me how to fix this?

thanks,

~ Ananth

Amaradana · Post by **Amaradana** » Thu Nov 04, 2010 4:23 pm

Not enough details, need more info

ananthnrk · Post by **ananthnrk** » Thu Nov 04, 2010 4:52 pm

Here is the xml file exported from Testlink. When i imported this in Excel 2007, i was able to see the xml tags and not the test steps.

<?xml version="1.0" encoding="UTF-8" ?>
- <testcases>
- <testcase internalid="306" name="Create Regular RA by Customer Number">
- <node_order>
- <![CDATA[ 100
]]>
</node_order>
- <externalid>
- <![CDATA[ 4
]]>
</externalid>
- <version>
- <![CDATA[ 1
]]>
</version>
- <summary>
- <![CDATA[ <span style="line-height: 115%; font-family: "Calibri","sans-serif"; font-size: 11pt; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA">Creates RA Header and tests the retrieved value of Customer information
]]>
</summary>
- <preconditions>
- <![CDATA[
]]>
</preconditions>
- <execution_type>
- <![CDATA[ 1
]]>
</execution_type>
- <importance>
- <![CDATA[ 2
]]>
</importance>
- <steps>
- <step>
- <step_number>
- <![CDATA[ 1
]]>
</step_number>
- <actions>
- <![CDATA[ <span style="line-height: 115%; font-family: "Calibri","sans-serif"; color: black; font-size: 11pt; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: Calibri; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA; mso-bidi-font-size: 10.0pt">Go to Return Tab.
]]>
</actions>
- <expectedresults>
- <![CDATA[ <span style="line-height: 115%; font-family: "Calibri","sans-serif"; color: black; font-size: 11pt; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: Calibri; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA; mso-bidi-font-size: 10.0pt">Returns Authorization landing page is displayed
]]>
</expectedresults>
- <execution_type>
- <![CDATA[ 1
]]>
</execution_type>
</step>
- <step>
- <step_number>
- <![CDATA[ 2
]]>
</step_number>
- <actions>
- <![CDATA[ <span style="line-height: 115%; font-family: "Calibri","sans-serif"; color: black; font-size: 11pt; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: Calibri; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA; mso-bidi-font-size: 10.0pt">Select Return Create from left navigation panel.
]]>
</actions>
- <expectedresults>
- <![CDATA[ Return Authorization Create window is displayed<o:p></o:p>
Customer Number and Customer name search boxes are displayed.<o:p></o:p>
<span style="line-height: 115%; font-family: "Calibri","sans-serif"; color: black; font-size: 11pt; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: Calibri; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA; mso-bidi-font-size: 10.0pt">Next Button is enabled.
]]>
</expectedresults>
- <execution_type>
- <![CDATA[ 1
]]>
</execution_type>
</step>
- <step>
- <step_number>
- <![CDATA[ 3
]]>
</step_number>
- <actions>
- <![CDATA[ <span style="line-height: 115%; font-family: "Calibri","sans-serif"; color: black; font-size: 11pt; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: Calibri; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA; mso-bidi-font-size: 10.0pt">Enter a Customer No.
]]>
</actions>
- <expectedresults>
- <![CDATA[ <span style="line-height: 115%; font-family: "Calibri","sans-serif"; color: black; font-size: 11pt; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: Calibri; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA; mso-bidi-font-size: 10.0pt">Customer Number appears in the box
]]>
</expectedresults>
- <execution_type>
- <![CDATA[ 1
]]>
</execution_type>
</step>
- <step>
- <step_number>
- <![CDATA[ 4
]]>
</step_number>
- <actions>
- <![CDATA[ <span style="line-height: 115%; font-family: "Calibri","sans-serif"; color: black; font-size: 11pt; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: Calibri; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA; mso-bidi-font-size: 10.0pt">Click Next
]]>
</actions>
- <expectedresults>
- <![CDATA[ New RA XXXX successfully created for Customer name xxxxx.<o:p></o:p>
RA Type = Regular<o:p></o:p>
Customer Category matches customer selected<o:p></o:p>
Customer Name/Number matches customer selected<o:p></o:p>
RA Status = NEW<o:p></o:p>
Original RA ID - BLANK<o:p></o:p>
Comments - blank<o:p></o:p>
On Hold - No<o:p></o:p>
Edit, Approve, Reject, Cancel buttons are enabled.<o:p></o:p>
Sections appear:<o:p></o:p>
RA Line Items<o:p></o:p>
Hold and Exceptions<o:p></o:p>
Finance Transaction History<o:p></o:p>
Disposition Summary<o:p></o:p>
Tabs:<o:p></o:p>
General Details<o:p></o:p>
Additional Details<o:p></o:p>
RA Return Label Details<o:p></o:p>
RA Set up Details<o:p></o:p>
<span style="line-height: 115%; font-family: "Calibri","sans-serif"; font-size: 11pt; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: Calibri; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA; mso-bidi-font-size: 10.0pt">Audit Details
]]>
</expectedresults>
- <execution_type>
- <![CDATA[ 1
]]>
</execution_type>
</step>
- <step>
- <step_number>
- <![CDATA[ 5
]]>
</step_number>
- <actions>
- <![CDATA[ <span style="line-height: 115%; font-family: "Calibri","sans-serif"; color: black; font-size: 11pt; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: Calibri; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA; mso-bidi-font-size: 10.0pt">Click Additional Details Tab
]]>
</actions>
- <expectedresults>
- <![CDATA[ <span style="line-height: 115%; font-family: "Calibri","sans-serif"; color: black; font-size: 11pt; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: Calibri; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA; mso-bidi-font-size: 10.0pt">Verify Shipping and Billing Contacts Details are the same as the customer.
]]>
</expectedresults>
- <execution_type>
- <![CDATA[ 1
]]>
</execution_type>
</step>
- <step>
- <step_number>
- <![CDATA[ 6
]]>
</step_number>
- <actions>
- <![CDATA[ <span style="line-height: 115%; font-family: "Calibri","sans-serif"; color: black; font-size: 11pt; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: Calibri; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA; mso-bidi-font-size: 10.0pt">Record RA number for use in future test scripts
]]>
</actions>
- <expectedresults>
- <![CDATA[
]]>
</expectedresults>
- <execution_type>
- <![CDATA[ 1
]]>
</execution_type>
</step>
- <step>
- <step_number>
- <![CDATA[ 7
]]>
</step_number>
- <actions>
- <![CDATA[ <span style="line-height: 115%; font-family: "Calibri","sans-serif"; color: black; font-size: 11pt; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: Calibri; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA; mso-bidi-font-size: 10.0pt">End of Test Script
]]>
</actions>
- <expectedresults>
- <![CDATA[
]]>
</expectedresults>
- <execution_type>
- <![CDATA[ 1
]]>
</execution_type>
</step>
</steps>
</testcase>
</testcases>

Post by **fman** » Thu Nov 04, 2010 5:26 pm

have you tried to load the file in a REAL XML editor ?

ananthnrk · Post by **ananthnrk** » Thu Nov 04, 2010 5:55 pm

Yes. I have used XMLSpy to open the xml file. I was able to open the file but the grid tab shows "Unable to show schema:
C:\Word to XML\NEWtestcases.xml
XML Schema has to begin with a <schema> element in namespace 'http://www.w3.org/2001/XMLSchema'!
Error location: testcases"

TestLink

Unable to import IN EXCEL the exported XML from testlink

Unable to import IN EXCEL the exported XML from testlink

Re: Unable to import the exported XML from testlink

Re: Unable to import the exported XML from testlink

Re: Unable to import IN EXCEL the exported XML from testlink

Re: Unable to import IN EXCEL the exported XML from testlink