Sample XML file given by Tools-R-Us
Moderators: Amaradana, TurboPT, TL Developers
Sample XML file given by Tools-R-Us
Does anybody know where to get this file?
i searched in vain for that stupid file then came across this method that works very good!
Excel to TestLink XML HOW TO:
1. You just need to create 1 or 2 testcases on using GUI.
2. Then export those testcases, the exported file is testcases.xml.
3. Open that .xml file with MS Excel.
4. When you open it, choose the option "Use the XML source task pane".
5. Then you will see the XML map in XML Source window.
6. Click and drag the elements to the excel sheet.
7. Eg. if you want name to be your first column, click and drag "name" element to 1A grid so that the column A will be "name" column.
After you try importing it
Excel to TestLink XML HOW TO:
1. You just need to create 1 or 2 testcases on using GUI.
2. Then export those testcases, the exported file is testcases.xml.
3. Open that .xml file with MS Excel.
4. When you open it, choose the option "Use the XML source task pane".
5. Then you will see the XML map in XML Source window.
6. Click and drag the elements to the excel sheet.
7. Eg. if you want name to be your first column, click and drag "name" element to 1A grid so that the column A will be "name" column.
After you try importing it
Issue with importing XML file into Excel Office 2007
I have exported a test case from TL 1.8.3 as an XML file. I have followed the instructions as noted in this post. All good so far.
But when I open the XML file in Excel 2007, all the tags etc are displayed as text in one cell.
For example, the test case Steps are displayed in one cell as:
<p>Step 1: <a href="http://xx.x.xx.xx/testlink/index.php">Logon to reporting server</a></p>
<p>Step 2: Select required report</p>
<p>Step 3: Select the year of interest</p>
<p>Step 4: Select the campus</p>
<p>Step 5: Run the report</p>
NB: I have tried the instructions, plus other permutations for opening the XML file in Excel 2007, but always the same result.
I have also copied the XML (for a test case) from the documentation (pdf), saved as XML file and imported into Excel. Same result as above.
Any suggestions as to what the issue could be?
Any help would be much appreciated.
But when I open the XML file in Excel 2007, all the tags etc are displayed as text in one cell.
For example, the test case Steps are displayed in one cell as:
<p>Step 1: <a href="http://xx.x.xx.xx/testlink/index.php">Logon to reporting server</a></p>
<p>Step 2: Select required report</p>
<p>Step 3: Select the year of interest</p>
<p>Step 4: Select the campus</p>
<p>Step 5: Run the report</p>
NB: I have tried the instructions, plus other permutations for opening the XML file in Excel 2007, but always the same result.
I have also copied the XML (for a test case) from the documentation (pdf), saved as XML file and imported into Excel. Same result as above.
Any suggestions as to what the issue could be?
Any help would be much appreciated.