Import / export file formats
Contents
1. lt xml versionz 1 0 encoding UTF 8 standalone yes gt lt fesicases gt testcase name ACC 1 1 gt lt summary gt Whether the user can view Accounts List View as a default view under Accounts screen lt summary gt lt steps gt Pre condition A valid user has logged in the application Navigate to Accounts screen by clicking on the Accounts screen tab lt steps gt lt expectedresults gt On navigating to Accounts screen the following view should be displayed My Accounts List view By default this view should be displayed All Accounts List view lt expectedresults gt a testcases testcase name ACC 1 2 gt summary gt Whether the user can view Accounts List View as a default view under Accounts screen lt summary gt lt steps gt Pre condition A valid user has logged in the application Navigate to Accounts screen by clicking on the Accounts screen tab lt steps gt lt expectedresults gt On navigating to Accounts screen the following view should be displayed My Accounts List view By default this view should be displayed All Accounts List view lt expectedresults gt z testcase lt testcases gt Importing XML file into TestLink Step 1 Login in to TestLink gt Select your project in dropdown list Step 2 Click on Specification gt Create New Suite gt Select Suite gt Click on Import Test Cases TRUST Manager Test Management 140663 Role2. CDATA 184 externalid lt summary gt lt CDATA gt lt summary gt lt steps gt lt CDATA gt lt steps gt lt expectedresults gt lt CDATA gt lt expectedresults gt lt requirements gt lt requirement gt req spec title gt lt CDATA RSPEC 001 gt lt req spec title gt doc id CDATA ENG 0002 doc id title CDATA Main Deflector gt lt title gt lt requirement gt lt requirement gt lt req spec title gt lt CDATA RSPEC 001 gt lt req spec title gt lt doc_id gt lt CDATA DOC 009 gt lt doc_id gt lt title gt lt CDATA James Bond gt lt title gt lt requirement gt lt requirements gt lt testcase gt lt testcases gt 2 4 All Test Cases tn test suite Eth Handheld devices 2 gi 74 10 G shock gr 76 Gamma Ray Storm lt xml version 1 0 encoding UTF 8 gt lt testcases gt lt testcase name 10 G shock gt lt summary gt lt CDATA gt lt summary gt lt steps gt lt CDATA gt lt steps gt lt expectedresults gt lt CDATA gt lt expectedresults gt lt testcase gt lt testcase name Gamma Ray Storm gt lt summary gt lt CDATA gt lt summary gt lt steps gt lt CDATA gt lt steps gt lt expectedresults gt lt CDATA gt lt expectedresults gt lt testcase gt lt testcases gt Test cases in XLS format Every row must have four columns Column Contents number 1
3. Import export file formats TestLink version 1 9 Author Francisco Mancardi Version 1 0 Status Updated for TL 1 9 2004 2010 TestLink Community Permission is granted to copy distribute and or modify this document under the terms of the GNU Free Documentation License Version 1 2 published by the Free Software Foundation with no Invariant Sections no Front Cover Texts and no Back Cover Texts The license is available in GNU Free Documentation License homepage Revision History Description Date Author 0 1 Initial document 20070728 Francisco Mancardi 0 2 Added XLS format for test cases Code contributed by 20071101 Francisco Mancardi lightbulb Added XML format for results 0 3 Notes about internal and external ID 20080911 Francisco Mancardi New tag supported for results on TL 1 8 0 4 Test Case XML added support for custom fields 20090106 Francisco Mancardi 0 5 Test Case XML added support for link requirements 20090207 Francisco Mancardi 0 6 Updated Format for version 1 9 20100227 Francisco Mancardi 1 0 Updated documentation layout corrected license 04 03 10 Martin Havlat merged information from User manual docbook support etc 1 Introduction TestLink is web based Test Management tool This manual describes a format of files for import and export data See the User manual and Installation manual for more information about tool The latest documentation is
4. Test case XLS X Keywords import is NOT supported Keyword CSV XML X X All test project s keywords Requirement CSV XML X X Requirement CSV DOORS X DocBook Results XML X Platforms XML X X New on 1 9 Custom Fields XML X X New on 1 9 Table 1 Items that can be exported imported Limitation Attached files and custom fields are not imported exported Table format CSV is not directly supported in some cases You should convert it into XML before import See below for more Definition for Internal and Documentation Identifiers e Every object has its internal ID this ID is value of ID column in database table e Test cases and requirements are special case because they have internal and document ID e Every time you see keyword ID in xml format it indicates INTERNAL ID 2 1 All Test Project User can import or export Test Project including Description of the project Test Specification and Keywords The next two pictures show tree menu with data and the same data as XML file Warning You can rich a server memory limit for larger amount of Test cases 1 CF except Test cases lt xml version 1 0 encoding UTF 8 gt lt testsuite name gt EH Enterprise Space Ship 5 lt details gt lt CDATA gt lt details gt Se Communications 3 lt testsuite name Communications Ea Handheld devices 2 lt details gt lt CDATA lt p gt Communication Systems of all types lt p gt Eo uc P 7 T P 74 10 G shock
5. valid regexp gt lt CDATA gt lt valid regexp gt length min gt lt CDATA 0 gt lt length_ min length max gt lt CDATA 0 gt lt length_max gt lt show_on_design gt lt CDATA 1 gt lt show_on_design gt enable on design gt lt CDATA 1 gt lt enable on design show on execution CDATA 1 show on execution enable on execution CDATA 0 enable on execution show on testplan design CDATA 0 show on testplan design enable on testplan design CDATA 0 enable on testplan design node type id CDATA 3 node type id custom field lt custom field gt lt name gt lt CDATA CF_LIST gt lt name gt lt label gt lt CDATA List Type CF gt lt label gt lt type gt lt CDATA 6 gt lt type gt possible values gt lt CDATA Deep Purple Yes Queen possible values gt default value gt lt CDATA gt lt default value valid regexp gt lt CDATA gt lt valid regexp gt length min gt lt CDATA 0 gt lt length min length max gt lt CDATA 0 gt lt length_max gt show on design CDATA 1 show on design enable on design CDATA 1 enable on design show on execution CDATA 0 show on execution enable on execution gt lt CDATA 0 gt lt enable on execution show on testplan design CDATA 0 show on testplan design enable on testplan design CDAT
6. Test case name 2 summary 3 steps 4 Expected results First row will be skipped because is supposed it contains column descriptions Example Name Summary Steps Expected results Engine fast start up Start up on 5 second Too fast write steps Kind nothing Engine emergency stop Engine stop due to panic button 1 Unlock panic button 2 Press panic button 3 Press confirm Engine must stop right now Etc Etc Etc Etc 2 5 Import Export Keywords reale Keyword Moon racks csv v Moon rocks keyword notes Hotes Klynzon Klyngon keyword notes Illustration 1 Keywords frame includes buttons for import and export Example of CSV Keyword Notes Klyngon Klyngon keyword notes Moon rocks Moon rocks keyword notes Example of XML with keywords lt xml version 1 0 encoding UTF 8 gt lt keywords gt lt keyword name Klyngon gt notes CDATA Klyngon keyword notes lt notes gt lt keyword gt lt keyword name Moon rocks gt notes lt CDATA Moon rocks keyword notes gt notes lt keyword gt lt keywords gt 2 6 Import Export Software Requirements 10 List of requirements Xl ly CSV DOC ID Title am Scope A ENG 0001 Terrestrial Propulsor ENG 0002 Main Deflector Main deflector bla bla bla CSV file includes Identifier of document title description Exam
7. summary gt lt CDATA lt p gt This procedure must be done once a week with this safety device disabled p ol li X45HH li li YY89 000 JI li ol lt summary gt lt steps gt lt CDATA lt p gt Preset bias to 0 lt p gt lt p gt Enable lt strong gt long range lt strong gt communications control lt p gt lt p gt Simulate black hole interference lt p gt gt lt steps gt lt expectedresults gt lt CDATA lt table width 200 cellspacing 1 cellpadding 1 border 1 gt lt caption gt Main Results lt caption gt lt tbody gt lt Ur gt lt Ud gt Spin value lt Ld gt lt td gt 9 9 lt td gt lt tr gt lt tr gt lt td gt Opposite Angle lt td gt lt td gt 18 rad lt td gt lt tr gt lt tro lt td gt enbsp lt td gt lt td gt enbsp lt td gt lt tr gt lt tbody gt lt table gt gt lt expectedresults gt lt keywords gt lt keyword name Moon rocks gt lt notes gt lt CDATA Moon rocks keyword notes gt lt notes gt lt keyword gt lt keywords gt lt testcase gt lt testcases gt Example XML Test Case with custom fields lt xml version 1 0 encoding UTF 8 gt lt testcases gt lt testcase name Black Hawk test gt lt summary gt lt CDATA lt p gt This procedure must be done once a week with this safety device disabled lt p gt ol li X45HH li li YY89 000 JI li ol 7 lt summary gt lt ste
8. A 0 enable on testplan design node type id gt lt CDATA 3 gt lt node_ type id custom field custom fields 18
9. New Solaris gt lt notes gt lt platform gt lt platform gt lt name gt lt CDATA Solaris 8 gt lt name gt lt notes gt lt CDATA gt lt notes gt lt platform gt lt platform gt lt name gt lt CDATA Solaris 9 gt lt name gt lt notes gt lt CDATA gt lt notes gt lt platform gt lt platform gt lt name gt lt CDATA Windows 2008 name lt notes gt lt CDATA notes lt platform gt lt platform gt lt name gt lt CDATA Windows 7 gt lt name gt lt notes gt lt CDATA New MS OS notes lt platform gt lt platforms gt 17 2 11 Custom Fields Definition of custom field can be both in imported and exported since TL 1 9 Custom fields Name Label Type Enable on Display on Enable on Enable on Available for test specification test execution test execution test plan design CF_LIST List Type CF list 7 Test Case CF_STRING String CF string Q Q Test Case NS Illustration 2 Custom field management window with Import and Export actions Example of definition file lt xml version 1 0 encoding ISO 8859 1 gt custom fields custom field gt lt name gt lt CDATA CF STRING gt lt name gt lt label gt lt CDATA String CF gt lt label gt lt type gt lt CDATA 0 gt lt type gt possible values gt lt CDATA gt lt possible values default value gt lt CDATA gt lt default value
10. admin Test Project role admin Home KR Site Test Management Defect Tracking Trus Home Specification Execute Results User Administration Personal Test Case ID Logout eo Havigator Test Specification Test Suite Customer Navigation Filter amp Settings Test Suite Edit Delete Move Copy J Reorder children Export Test Suite Update tree after every operation Update tree New Test Suite Import Test Suite E Pfizer Ace IQ 1323 f zer Ace IQ Create Test Case s Import Test Case s Export Test Case s nam Customer 319 suai oie Went ay Blak b ELS sport est t 11 1 emm au Jee Fem m Step 3 Browse for the XML file submit it and you are done with the Importing 2 10 Platforms Platforms can be both imported and exported The feature is available from TL 1 9 16 Platform Management 3 amp Platform Description Ah AC 15 Solans 10 Mew Solaris Solaris 8 Solars 59 Windows 2008 Windows 7 Mew ANS OS Example of data lt xml version 1 0 encoding UTFP 8 platforms platform name CDATA MAC OS name lt notes gt lt CDATA gt lt notes gt lt platform gt lt platform gt lt name gt lt CDATA Solaris 10 gt lt name gt lt notes gt lt CDATA
11. available on web http www teamst org Feel free to use our forum if you have questions that the manual doesn t answer Table of Contents 1 Introduction 2 Import and Export data 2 1 Export Import Test Project 2 Import Export Test suite 2 3 Just one Test Case 2 4 All Test Cases in test suite 2 5 Import Export Keywords 2 6 Import Export Software Requirements 2 7 Results import 2 8 Import Test Cases from Excel via XML 2 9 Platforms 2 10 Custom Fields Herer NANNDWOUODUNA LW 2 Import and Export data TestLink supports several ways to share data See the next table for overview In addition you can consider to use TestLink API to deliver supported data There is amount of file examples in directory testlink docs file examples Troubleshooting No answer for import action Check size of imported file There are limits in TestLink configuration and web server settings Check if DOM module is loaded for your web server Item File format Import Export Notes Test project XML X X All test suites and test cases You can choose if export also assigned keywords Test suite XML X X Test suite details All test cases and child test suites and test cases You can choose if export assigned keywords Test case XML X X Two types of exports can be done Just one test case All test cases in test suite Custom Fields and Requirements assigned are exported Keywords export is optional
12. entry gt e lt row gt lt tbody gt tgroup lt informaltable gt 11 lt sect3 gt TestLink uses such element as data for just one requirement This element is defined via constant DOCBOOK_REQUIREMENT check the code i e lt sect3 gt is default but could be modified Each requirement content is maintain the following way title receive text in tag lt title gt req doc id parse title for the first two words and add counter You can modify regular expression directly in code Default is a zA Z 0 9 description parse following elements after title para lt orderedlist gt lt informaltable gt etc DocBook elements are modified to HTML tags Unknown ones are ommited Warning the original code could be modified to fit your structure of DocBook Check requirement inc php function importReqDataFromDocBook fileName and related constants Warning generated REQ DOC ID is danger for the case of update Because it s generated from file content without relation to existing testlink data 2 8 Results import Results import is supported from TL 1 7 Example 1 Results in XML format using internal ID lt xml version 1 0 encoding UTF 8 gt lt results gt lt testcase id 100 gt lt ID internal DB id gt lt result gt p lt result gt lt notes gt functionality works great lt notes gt lt testcase gt lt testcase id 200 gt lt result gt f lt result gt lt note
13. me Propulsion Systems gt lt details gt lt CDATA gt lt details gt lt testsuite name Main engine lt details gt lt CDATA gt lt details gt lt testcase name Emergency stop gt lt summary gt lt CDATA gt lt summary gt lt steps gt lt CDATA gt lt steps gt lt expectedresults gt lt CDATA gt lt expectedresults gt lt testcase gt lt testsuite gt lt testsuite gt lt testsuite gt 2 2 Import Export Test suite XML Example Test Suite without keywords lt xml version 1 0 encoding UTF 8 gt Handheld devices 2 lt testsuite name Hand held devices gt lt details gt lt CDATA gt lt details gt yF 74 10 G shock testcase name 10 G shock gt 76 Gamma Ray Storm lt summary gt lt CDATA gt lt summary gt lt steps gt lt CDATA gt lt steps gt lt expectedresults gt lt CDATA gt lt expectedresults gt lt testcase gt lt testcase name Gamma Ray Storm gt R lt summary gt lt CDATA gt lt summary gt lt steps gt lt CDATA gt lt steps gt lt expectedresults gt lt CDATA gt lt expectedresults gt lt testcase gt testsuite XML format example Test Suite with keywords lt xml version 1 0 encoding UTF 8 gt lt testsuite name Hand held devices gt lt details gt lt CDATA gt lt details gt lt testcase name 10 G shock gt lt summary gt lt CDATA gt lt
14. ple of CSV file ENG O001 Terrestrial Propulsor ENG 0002 Main Deflector lt p gt Main deflector bla bla bla lt p gt Example of XML file lt xml version 1 0 encoding UTF 8 gt lt requirements gt lt requirement gt lt docid gt lt CDATA ENG 0001 gt lt docid gt title CDATA Terrestrial Propulsor gt lt title gt lt description gt lt CDATA gt lt description gt lt requirement gt lt requirement gt lt docid gt lt CDATA ENG 0002 gt lt docid gt lt title gt lt CDATA Main Deflector gt lt title gt lt description gt lt CDATA lt p gt Maindeflector bla bla bla lt p gt gt lt description gt lt requirement gt lt requirements gt 2 7 Import rich text format requirements via DocBook There is limited support of import for documents in such formats as is MSWord or openoffice You can export original document as DocBook tested with openoffice2 and 3 Choose import button for your SRS in TestLink Select type DocBook The exported file is XML Basic element for default settings could be the next lt sect3 gt lt title gt Title lt title gt lt para gt Description lt para gt lt orderedlist gt lt listitem gt Item lt listitem gt lt orderedlist gt lt informaltable gt lt tgroup gt lt thead gt lt row gt 52 lt entry gt lt entry gt i lt row gt lt thead gt lt tbody gt lt row gt lt entry gt lt
15. ps gt lt CDATA lt p gt Preset bias to 0 lt p gt lt p gt Enable lt strong gt long range lt strong gt communications control lt p gt lt p gt Simulate black hole interference lt p gt gt lt steps gt lt expectedresults gt lt CDATA lt table width 200 cellspacing 1 cellpadding 1 border 1 gt lt caption gt Main Results lt caption gt lt tbody gt tr td Spin value lt td gt lt td gt 9 9 lt td gt lt tr gt lt tr gt lt td gt Opposite Angle lt td gt lt td gt 18 rad lt td gt lt tr gt lt tr gt lt td gt amp nbsp lt td gt lt td gt amp nbsp lt td gt lt tr gt lt tbody gt lt table gt gt lt expectedresults gt lt custom fields gt lt custom field gt lt name gt lt CDATA CF_SKILLS NEEDED gt lt name gt lt value gt lt CDATA QA Engineer gt lt value gt custom field custom field lt name gt lt CDATA CF ESTIMATED EXEC TIME gt lt name gt lt value gt lt CDATA 12 gt lt value gt lt custom_field gt lt y custom fields lt testcase gt lt testcases gt Example XML Test Case with requirements lt xml version 1 0 encoding UTF 8 gt lt testcases gt lt testcase internalid 12644 name High speed gt node order CDATA 0 node order externalid CDATA 182 externalid lt summary gt lt CDATA gt lt summary gt lt steps gt lt CDATA gt lt steps gt lt expectedresult
16. rough menu bar Data gt XML gt Import amp select the sample XML file It creates appropriate structure in Excel Ed Microsoft Excel Book1 BH File Edit View Insert Format Tools P Window Filter Help Text to Columns Import Export AML Source ML Expansion Packs kl hal Step 4 Then we will get dialog box asking Where do you want to put the data 13 14 x Where do you want to put Ehe data B XML list in existing worksheet Cancel 8j 9 C XML list in new worksheet Properties Step 5 Choose option one XML list in existing worksheet with first cell A 1 Step 6 You will be able to see following columns name summary steps amp expected results expectedresults user has logged inthe On navigating to Accounts application screen the following view should be displayed Navigate ta Accounts My Accounts List view By screen by clicking an default this view should be the Accounts screen display ed ACC 1 1 Whether the user can view Ztah All Accounts List view be loaded I Click on the It should display all the following Accounts screen applets ACC 1 2 Whether the required applet ii Check for applets Step 7 Copy your data into this file accordingly amp save the file in XML Data xml format Step 8 Check your XML file for correctness by opening with the help of internet explorer 15
17. s gt lt CDATA gt lt expectedresults gt lt requirements gt lt requirement gt req spec title gt lt CDATA RSPEC 001 gt lt req spec title gt doc id CDATA ENG 0002 doc id title CDATA Main Deflector gt lt title gt lt requirement gt lt requirement gt req spec title CDATA RSPEC 001 req spec title gt amp doc 1d gt lt CDATA DOC 009 5 7doc 1d title CDATA James Bond title lt requirement gt lt requirements gt lt testcase gt lt testcase internalid 12646 name Half speed stop gt node order CDATA 0 node order lt externalid gt lt CDATA 183 gt lt externalid gt lt summary gt lt CDATA gt lt summary gt lt steps gt lt CDATA gt lt steps gt lt expectedresults gt lt CDATA gt lt expectedresults gt lt requirements gt lt requirement gt req spec title gt lt CDATA RSPEC 001 gt lt req spec title gt doc id CDATA ENG 0002 doc id title CDATA Main Deflector title lt requirement gt lt requirement gt req spec title gt lt CDATA RSPEC 001 gt lt req spec title gt lt doc_id gt lt CDATA DOC 009 gt lt doc_id gt 8 title CDATA James Bond gt lt title gt lt requirement gt lt requirements gt lt testcase gt lt testcase internalid 12648 name Jump start gt node order CDATA 0 node order externalid
18. s gt this case failed due to error lt notes gt lt testcase gt lt testcase id 150 gt result b result lt notes gt this test case is blocked lt notes gt lt testcase gt lt results gt Example 2 Results in XML format using external ID lt xml version 1 0 encoding UTF 8 gt lt Comment gt lt results gt lt testcase external id POb L 2 lt if not present logged user will be used gt lt tester gt u0113 lt tester gt lt tester LOGIN Name gt lt if not present now will be used gt lt timestamp gt 2008 09 08 14 00 00 lt timestamp gt lt result gt p lt result gt lt notes gt functionality works great lt notes gt lt testcase gt UestCase exrernal 1d POL 17 gt Slc ANOTHER EXE Tof SAME Test Case gt lt result gt f lt result gt lt notes gt functionality works great KIMI lt notes gt lt testcase gt 2 Format supported on TL 1 8 beta 3 and UP 12 lt testcase external id 1256 gt lt Using INTERNAL ID gt lt result gt f lt result gt lt notes gt Using INTERNAL ID as link lt notes gt lt testcase gt lt results gt You can import several multiple execution results using a single XML file 2 9 Import Test Cases from Excel via XML Creating XML file to import in TestLink Step 1 Export one or more dummy Test Cases from TestLink into a XML file Step 2 Open new blank spread sheet document file Step 3 Navigate th
19. summary gt lt steps gt lt CDATA gt lt steps gt lt expectedresults gt lt CDATA gt lt expectedresults gt lt keywords gt lt keyword name Klyngon gt lt notes gt lt CDATA Klyngon keyword notes gt lt notes gt lt keyword gt lt keywords gt lt testcase gt lt testcase name Gamma Ray Storm lt summary gt lt CDATA gt lt summary gt lt steps gt lt CDATA gt lt steps gt lt expectedresults gt lt CDATA gt lt expectedresults gt lt keywords gt lt keyword name Klyngon gt lt notes gt lt CDATA Klyngon keyword notes gt lt notes gt lt keyword gt lt keyword name Moon rocks gt lt notes gt lt CDATA Moon rocks keyword notes gt lt notes gt lt keyword gt lt keywords gt lt testcase gt lt testsuite gt 2 3 Just one Test Case ID 78 Test Case Black hole test Version 1 Summary This procedure must be done once a week with this safety device disabled 1 A45HH 2 YY89 D00 J 5teps Expected Results Main Results Preset bias to Spin value 9 9 Enable long range communications control lo TOU ENS Ipposite Angle 18 rad Simulate black hole interference Keywords Moon rocks Created on 27 07 2007 15 16 52 by admin Last modified on 27 07 2007 16 16 33 by admin Example of XML file Test case with keyword lt xml version 1 0 encoding UTF 8 gt lt testcases gt lt testcase name Black hole test gt lt
20. testsulte name Hand held devices E 4 76 Gamma Ray Storm edetalls ei lCcDATAI I detatis ER Subspace channels 1 lt testcase name 10 G shock gt oF 78 Black hole test lt summary gt lt CDATA gt lt summary gt Ea Holodeck 1 lt steps gt lt CDATA gt lt steps gt expectedresults gF 70 Light settings CDATA gt lt expectedresults gt Ead Propulsion Systems 1 lt testcase gt ak Main engine 1 lt testcase name Gamma Ray Storm gt gF 72 Emergency stop lt summary gt lt CDATA gt lt summary gt lt steps gt lt CDATA gt lt steps gt lt expectedresults gt lt CDATA gt lt expectedresults gt lt testcase gt lt testsuite gt lt testsuite name Subspace channels gt lt details gt lt CDATA lt p gt Only basic subspace features lt p gt gt lt details gt lt testcase name Black hole test gt lt summary gt lt CDATA gt lt summary gt lt steps gt lt CDATA gt lt steps gt lt expectedresults gt lt CDATA gt lt expectedresults gt lt testcase gt lt testsuite gt lt testsuite gt lt testsuite name Holodeck gt lt details gt lt CDATA gt lt details gt lt testcase name Light settings gt lt summary gt lt CDATA gt lt summary gt lt steps gt lt CDATA gt lt steps gt lt expectedresults gt lt CDATA gt lt expectedresults gt lt testcase gt lt testsuite gt lt testsuite na
Download Pdf Manuals
Related Search