Unable to import IN EXCEL the exported XML from testlink

Ask community to help.

Moderators: Amaradana, TurboPT, TL Developers

Unable to import IN EXCEL the exported XML from testlink

Postby 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
ananthnrk
TestLink user
 
Posts: 8
Joined: Mon Oct 25, 2010 8:29 pm

Re: Unable to import the exported XML from testlink

Postby Amaradana » Thu Nov 04, 2010 4:23 pm

Not enough details, need more info
Thanks,
TesterWorld
Http://amartester.blogspot.com
Amaradana
Member of TestLink Community
 
Posts: 398
Joined: Mon Feb 16, 2009 11:19 am

Re: Unable to import the exported XML from testlink

Postby 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[ <p><span style="line-height: 115%; font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; 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</span></p>
]]>
</summary>
- <preconditions>
- <![CDATA[
]]>
</preconditions>
- <execution_type>
- <![CDATA[ 1
]]>
</execution_type>
- <importance>
- <![CDATA[ 2
]]>
</importance>
- <steps>
- <step>
- <step_number>
- <![CDATA[ 1
]]>
</step_number>
- <actions>
- <![CDATA[ <p><span style="line-height: 115%; font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; 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 <b style="mso-bidi-font-weight: normal">Return</b> Tab.</span></p>
]]>
</actions>
- <expectedresults>
- <![CDATA[ <p><span style="line-height: 115%; font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; 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</span></p>
]]>
</expectedresults>
- <execution_type>
- <![CDATA[ 1
]]>
</execution_type>
</step>
- <step>
- <step_number>
- <![CDATA[ 2
]]>
</step_number>
- <actions>
- <![CDATA[ <p><span style="line-height: 115%; font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; 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 <b style="mso-bidi-font-weight: normal">Return Create</b> from left navigation panel.</span></p>
]]>
</actions>
- <expectedresults>
- <![CDATA[ <p class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none"><span style="color: black; mso-bidi-font-family: Calibri; mso-bidi-font-size: 10.0pt"><font size="3"><font face="Calibri">Return Authorization Create window is displayed<o:p></o:p></font></font></span></p>
<p class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none"><span style="color: black; mso-bidi-font-family: Calibri; mso-bidi-font-size: 10.0pt"><font size="3"><font face="Calibri">Customer Number and Customer name search boxes are displayed.<o:p></o:p></font></font></span></p>
<p><span style="line-height: 115%; font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; 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.</span></p>
]]>
</expectedresults>
- <execution_type>
- <![CDATA[ 1
]]>
</execution_type>
</step>
- <step>
- <step_number>
- <![CDATA[ 3
]]>
</step_number>
- <actions>
- <![CDATA[ <p><span style="line-height: 115%; font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; 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.</span></p>
]]>
</actions>
- <expectedresults>
- <![CDATA[ <p><span style="line-height: 115%; font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; 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</span></p>
]]>
</expectedresults>
- <execution_type>
- <![CDATA[ 1
]]>
</execution_type>
</step>
- <step>
- <step_number>
- <![CDATA[ 4
]]>
</step_number>
- <actions>
- <![CDATA[ <p><span style="line-height: 115%; font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; 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</span></p>
]]>
</actions>
- <expectedresults>
- <![CDATA[ <p class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none"><span style="mso-bidi-font-family: Calibri; mso-bidi-font-size: 10.0pt"><font size="3"><font face="Calibri">New RA XXXX successfully created for Customer <i>name xxxxx.</i><o:p></o:p></font></font></span></p>
<p class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none"><span style="mso-bidi-font-family: Calibri; mso-bidi-font-size: 10.0pt"><font size="3"><font face="Calibri">RA Type = Regular<o:p></o:p></font></font></span></p>
<p class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none"><span style="mso-bidi-font-family: Calibri; mso-bidi-font-size: 10.0pt"><font size="3"><font face="Calibri">Customer Category matches customer selected<o:p></o:p></font></font></span></p>
<p class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none"><span style="mso-bidi-font-family: Calibri; mso-bidi-font-size: 10.0pt"><font size="3"><font face="Calibri">Customer Name/Number matches customer selected<o:p></o:p></font></font></span></p>
<p class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none"><span style="mso-bidi-font-family: Calibri; mso-bidi-font-size: 10.0pt"><font size="3"><font face="Calibri">RA Status = NEW<o:p></o:p></font></font></span></p>
<p class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none"><span style="mso-bidi-font-family: Calibri; mso-bidi-font-size: 10.0pt"><font size="3"><font face="Calibri">Original RA ID - BLANK<o:p></o:p></font></font></span></p>
<p class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none"><span style="mso-bidi-font-family: Calibri; mso-bidi-font-size: 10.0pt"><font size="3"><font face="Calibri">Comments - blank<o:p></o:p></font></font></span></p>
<p class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none"><span style="mso-bidi-font-family: Calibri; mso-bidi-font-size: 10.0pt"><font size="3"><font face="Calibri">On Hold - No<o:p></o:p></font></font></span></p>
<p class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none"><span style="mso-bidi-font-family: Calibri; mso-bidi-font-size: 10.0pt"><font size="3"><font face="Calibri">Edit, Approve, Reject, Cancel buttons are enabled.<o:p></o:p></font></font></span></p>
<p class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none"><span style="mso-bidi-font-family: Calibri; mso-bidi-font-size: 10.0pt"><font size="3"><font face="Calibri">Sections appear:<o:p></o:p></font></font></span></p>
<p class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none"><span style="mso-bidi-font-family: Calibri; mso-bidi-font-size: 10.0pt"><font size="3"><font face="Calibri">RA Line Items<o:p></o:p></font></font></span></p>
<p class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none"><span style="mso-bidi-font-family: Calibri; mso-bidi-font-size: 10.0pt"><font size="3"><font face="Calibri">Hold and Exceptions<o:p></o:p></font></font></span></p>
<p class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none"><span style="mso-bidi-font-family: Calibri; mso-bidi-font-size: 10.0pt"><font size="3"><font face="Calibri">Finance Transaction History<o:p></o:p></font></font></span></p>
<p class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none"><span style="mso-bidi-font-family: Calibri; mso-bidi-font-size: 10.0pt"><font size="3"><font face="Calibri">Disposition Summary<o:p></o:p></font></font></span></p>
<p class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none"><span style="mso-bidi-font-family: Calibri; mso-bidi-font-size: 10.0pt"><font size="3"><font face="Calibri">Tabs:<o:p></o:p></font></font></span></p>
<p class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none"><span style="mso-bidi-font-family: Calibri; mso-bidi-font-size: 10.0pt"><font size="3"><font face="Calibri">General Details<o:p></o:p></font></font></span></p>
<p class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none"><span style="mso-bidi-font-family: Calibri; mso-bidi-font-size: 10.0pt"><font size="3"><font face="Calibri">Additional Details<o:p></o:p></font></font></span></p>
<p class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none"><span style="mso-bidi-font-family: Calibri; mso-bidi-font-size: 10.0pt"><font size="3"><font face="Calibri">RA Return Label Details<o:p></o:p></font></font></span></p>
<p class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none"><span style="mso-bidi-font-family: Calibri; mso-bidi-font-size: 10.0pt"><font size="3"><font face="Calibri">RA Set up Details<o:p></o:p></font></font></span></p>
<p><span style="line-height: 115%; font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; 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</span></p>
]]>
</expectedresults>
- <execution_type>
- <![CDATA[ 1
]]>
</execution_type>
</step>
- <step>
- <step_number>
- <![CDATA[ 5
]]>
</step_number>
- <actions>
- <![CDATA[ <p><span style="line-height: 115%; font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; 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</span></p>
]]>
</actions>
- <expectedresults>
- <![CDATA[ <p><span style="line-height: 115%; font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; 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.</span></p>
]]>
</expectedresults>
- <execution_type>
- <![CDATA[ 1
]]>
</execution_type>
</step>
- <step>
- <step_number>
- <![CDATA[ 6
]]>
</step_number>
- <actions>
- <![CDATA[ <p><span style="line-height: 115%; font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; 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</span></p>
]]>
</actions>
- <expectedresults>
- <![CDATA[
]]>
</expectedresults>
- <execution_type>
- <![CDATA[ 1
]]>
</execution_type>
</step>
- <step>
- <step_number>
- <![CDATA[ 7
]]>
</step_number>
- <actions>
- <![CDATA[ <p><span style="line-height: 115%; font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; 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</span></p>
]]>
</actions>
- <expectedresults>
- <![CDATA[
]]>
</expectedresults>
- <execution_type>
- <![CDATA[ 1
]]>
</execution_type>
</step>
</steps>
</testcase>
</testcases>
ananthnrk
TestLink user
 
Posts: 8
Joined: Mon Oct 25, 2010 8:29 pm

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

Postby fman » Thu Nov 04, 2010 5:26 pm

have you tried to load the file in a REAL XML editor ?
fman
Member of TestLink Community
 
Posts: 3063
Joined: Tue Nov 15, 2005 7:19 am

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

Postby 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"
ananthnrk
TestLink user
 
Posts: 8
Joined: Mon Oct 25, 2010 8:29 pm


Return to Installation and configuration



Who is online

Users browsing this forum: No registered users and 2 guests