Testlink导入测试用例xml格式转换器

  • q6_793974
    了解作者
  • 938KB
    文件大小
  • rar
    文件格式
  • 0
    收藏次数
  • VIP专享
    资源类型
  • 0
    下载次数
  • 2022-04-05 09:52
    上传日期
本工具可以将excel格式的测试用例转换为xml格式, 用于testlink中测试用例的导入
EX-Converter_1_2_1_rel+AllDocuments.rar
  • EX-Converter_Test_Suite_Templates-0_0_2.xlsx
    333.9KB
  • EX-Converter_Test_Cases_Templates-0_0_2.xlsx
    248.3KB
  • Quick Tutorial of EX-Converter.docx
    355.3KB
  • EX-Converter_1_2_1_rel.exe
    58KB
内容介绍
<html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta charset="utf-8"> <meta name="generator" content="pdf2htmlEX"> <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> <link rel="stylesheet" href="https://static.pudn.com/base/css/base.min.css"> <link rel="stylesheet" href="https://static.pudn.com/base/css/fancy.min.css"> <link rel="stylesheet" href="https://static.pudn.com/prod/directory_preview_static/626e1e6815314c70c38f864e/raw.css"> <script src="https://static.pudn.com/base/js/compatibility.min.js"></script> <script src="https://static.pudn.com/base/js/pdf2htmlEX.min.js"></script> <script> try{ pdf2htmlEX.defaultViewer = new pdf2htmlEX.Viewer({}); }catch(e){} </script> <title></title> </head> <body> <div id="sidebar" style="display: none"> <div id="outline"> </div> </div> <div id="pf1" class="pf w0 h0" data-page-no="1"><div class="pc pc1 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://static.pudn.com/prod/directory_preview_static/626e1e6815314c70c38f864e/bg1.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 x1 h3 y2 ff1 fs0 fc0 sc0 ls0 ws0">Quick T<span class="_ _0"></span>utorial of EX<span class="_ _0"></span>-<span class="_ _1"></span>Con<span class="_ _2"></span>vert<span class="_ _2"></span>er v1.2.1</div><div class="t m0 x1 h4 y3 ff2 fs1 fc1 sc0 ls0 ws0">Author: Jack Zhang (sf<span class="_ _2"></span>.jackzhang@gmail.c<span class="_ _2"></span>om)</div><div class="t m0 x1 h4 y4 ff2 fs1 fc1 sc0 ls0 ws0">Date: 15</div><div class="t m0 x2 h5 y5 ff2 fs2 fc1 sc0 ls0 ws0">th</div><div class="t m0 x3 h4 y4 ff2 fs1 fc1 sc0 ls0 ws0"> Feb, 2013</div><div class="t m0 x1 h4 y6 ff2 fs1 fc1 sc0 ls0 ws0">V<span class="_ _2"></span>ersion: 1.0</div><div class="t m0 x1 h6 y7 ff3 fs3 fc0 sc0 ls0 ws0">--------------------------------------------------------<span class="_ _1"></span>------------------------------------------------------------------------</div><div class="t m0 x1 h6 y8 ff3 fs3 fc0 sc0 ls0 ws0">When<span class="_ _1"></span> <span class="_ _1"></span>using<span class="_ _1"></span> <span class="_ _3"></span>this<span class="_ _1"></span> <span class="_ _1"></span>tool,<span class="_ _1"></span> <span class="_ _1"></span>it<span class="_ _1"></span> <span class="_ _1"></span>means<span class="_ _3"></span> <span class="_ _1"></span>that <span class="_ _3"></span>you <span class="_ _1"></span>want<span class="_ _1"></span> <span class="_ _1"></span>ot<span class="_ _3"></span> <span class="_ _1"></span>con<span class="_ _2"></span>vert<span class="_ _1"></span> <span class="_ _1"></span>your<span class="_ _1"></span> <span class="_ _1"></span>exis&#58903;ng <span class="_ _1"></span>test<span class="_ _1"></span> <span class="_ _1"></span>speci&#58905;ca&#58903;ons<span class="_ _1"></span> <span class="_ _1"></span>wri&#58906;en</div><div class="t m0 x1 h6 y9 ff3 fs3 fc0 sc0 ls0 ws0">in<span class="_ _3"></span> <span class="_ _3"></span>Ex<span class="_ _2"></span>cel<span class="_ _3"></span> <span class="_ _3"></span>sheets<span class="_ _1"></span> <span class="_ _3"></span>to<span class="_ _3"></span> <span class="_ _3"></span>XML<span class="_ _1"></span> <span class="_ _3"></span>&#58905;les.<span class="_ _3"></span> <span class="_ _3"></span>Then<span class="_ _3"></span> <span class="_ _3"></span>you<span class="_ _1"></span> <span class="_ _3"></span>could<span class="_ _1"></span> <span class="_ _4"></span>import<span class="_ _1"></span> <span class="_ _3"></span>them<span class="_ _3"></span> <span class="_ _3"></span>to<span class="_ _1"></span> <span class="_ _4"></span>T<span class="_ _0"></span>estLink&#8217;<span class="_ _2"></span>s<span class="_ _1"></span> <span class="_ _3"></span>&#8220;<span class="_ _1"></span>T<span class="_ _5"></span>est<span class="_ _1"></span> <span class="_ _3"></span>Speci&#58905;ca&#58903;on&#8221;<span class="_ _1"></span> <span class="_ _3"></span>tree</div><div class="t m0 x1 h6 ya ff3 fs3 fc0 sc0 ls0 ws0">folde<span class="_ _2"></span>rs.</div><div class="t m0 x1 h6 yb ff3 fs3 fc0 sc0 ls0 ws0">Bef<span class="_ _2"></span>ore con<span class="_ _2"></span>ver&#58903;ng, you should note tha<span class="_ _2"></span>t:</div><div class="t m0 x1 h6 yc ff3 fs3 fc0 sc0 ls0 ws0">1.<span class="_ _6"> </span>T<span class="_ _0"></span>estLink<span class="_ _7"> </span> <span class="_ _4"></span>1.<span class="_ _1"></span>9.x<span class="_ _4"></span> <span class="_ _7"> </span>supports<span class="_ _7"></span> <span class="_ _4"></span>impor&#58903;ng<span class="_ _7"></span> <span class="_ _4"></span>your<span class="_ _7"></span> <span class="_ _4"></span>test<span class="_ _4"></span> <span class="_ _7"> </span>speci&#58905;ca&#58903;ons<span class="_ _4"></span> <span class="_ _7"> </span>with<span class="_ _4"></span> <span class="_ _7"> </span>the<span class="_ _7"></span> <span class="_ _4"></span>format<span class="_ _4"></span> <span class="_ _7"> </span>of<span class="_ _4"></span> <span class="_ _7"> </span>both<span class="_ _4"></span> <span class="_ _7"> </span>&#8220;test</div><div class="t m0 x4 h6 yd ff3 fs3 fc0 sc0 ls0 ws0">suite&#8221; and &#8220;tes<span class="_ _2"></span>t cases&#8221;<span class="_ _0"></span>. And all those should be in XML &#58905;les.</div><div class="t m0 x1 h6 ye ff3 fs3 fc0 sc0 ls0 ws0">2.<span class="_ _6"> </span>T<span class="_ _0"></span>estLink limits the Max. &#58905;le size f<span class="_ _2"></span>or impor&#58903;ng to be 400KB. </div><div class="t m0 x1 h6 yf ff3 fs3 fc0 sc0 ls0 ws0">3.<span class="_ _6"> </span>EX<span class="_ _2"></span>-Conv<span class="_ _2"></span>erter 1.2.1 supports:</div><div class="t m0 x4 h6 y10 ff3 fs3 fc0 sc0 ls0 ws0">a)<span class="_ _8"> </span>Conv<span class="_ _2"></span>er&#58903;ng with both &#8220;test suite<span class="_ _2"></span>&#8221; (up to 2 levels) and &#8220;tes<span class="_ _2"></span>t cases&#8221;;</div><div class="t m0 x4 h6 y11 ff3 fs3 fc0 sc0 ls0 ws0">b)<span class="_ _9"> </span>De&#58905;ning<span class="_ _a"> </span> <span class="_ _a"> </span>(mapping)<span class="_ _a"> </span> <span class="_ _a"> </span>of<span class="_ _b"> </span> <span class="_ _a"> </span>&#8220;Level-1-suite&#8221;<span class="_ _0"></span>,<span class="_ _a"> </span> <span class="_ _a"> </span>&#8220;Level-2-suite&#8221;<span class="_ _0"></span>,<span class="_ _a"> </span> <span class="_ _a"> </span>&#8220;Name&#8221;<span class="_ _5"></span>,<span class="_ _a"> </span> <span class="_ _a"> </span>&#8220;Importance&#8221;<span class="_ _0"></span>,</div><div class="t m0 x5 h6 y12 ff3 fs3 fc0 sc0 ls0 ws0">&#8220;Summary<span class="_ _1"></span>&#8221;<span class="_ _0"></span>, &#8220;Precondi&#58903;ons&#8221;<span class="_ _0"></span>, &#8220;<span class="_ _5"></span>Ac&#58903;ons&#8221; and &#8220;Expected Results.<span class="_ _0"></span>&#8221;</div><div class="t m0 x4 h6 y13 ff3 fs3 fc0 sc0 ls0 ws0">c)<span class="_ _c"> </span>A<span class="_ _4"></span> <span class="_ _3"></span>sigle<span class="_ _4"></span> <span class="_ _3"></span>test<span class="_ _3"></span> <span class="_ _4"></span>case<span class="_ _4"></span> <span class="_ _3"></span>that<span class="_ _4"></span> <span class="_ _4"></span>has<span class="_ _3"></span> <span class="_ _4"></span>mul&#58903;ple<span class="_ _3"></span> <span class="_ _4"></span>steps<span class="_ _3"></span> <span class="_ _4"></span>de&#58905;ned<span class="_ _3"></span> <span class="_ _4"></span>in<span class="_ _3"></span> <span class="_ _4"></span>separat<span class="_ _2"></span>ed<span class="_ _4"></span> <span class="_ _3"></span>Excel<span class="_ _3"></span> <span class="_ _4"></span>sheet<span class="_ _4"></span> <span class="_ _3"></span>cells.<span class="_ _4"></span> <span class="_ _4"></span>Step</div><div class="t m0 x5 h6 y14 ff3 fs3 fc0 sc0 ls0 ws0">numbers will be assigned automa<span class="_ _2"></span>&#58903;cally<span class="_ _5"></span>.</div><div class="t m0 x1 h6 y15 ff3 fs3 fc0 sc0 ls0 ws0">4.<span class="_ _6"> </span>EX<span class="_ _2"></span>-Conv<span class="_ _2"></span>erter 1.2.1 curren<span class="_ _2"></span>tly DO NOT support:</div><div class="t m0 x4 h6 y16 ff3 fs3 fc0 sc0 ls0 ws0">a)<span class="_ _8"> </span>De&#58905;ning<span class="_ _3"></span> <span class="_ _4"></span>of<span class="_ _3"></span> <span class="_ _4"></span>test<span class="_ _1"></span> <span class="_ _4"></span>suite&#8217;<span class="_ _5"></span>s<span class="_ _4"></span> <span class="_ _3"></span>&#8220;Node<span class="_ _4"></span> <span class="_ _3"></span>Order<span class="_ _1"></span>&#8221;<span class="_ _4"></span> <span class="_ _3"></span>and<span class="_ _4"></span> <span class="_ _3"></span>&#8220;Details&#8221;<span class="_ _0"></span>.<span class="_ _4"></span> <span class="_ _3"></span>But<span class="_ _4"></span> <span class="_ _4"></span>these<span class="_ _3"></span> <span class="_ _4"></span>&#58905;elds<span class="_ _3"></span> <span class="_ _4"></span>will<span class="_ _3"></span> <span class="_ _4"></span>be<span class="_ _3"></span> <span class="_ _4"></span>assigned</div><div class="t m0 x5 h6 y17 ff3 fs3 fc0 sc0 ls0 ws0">with a def<span class="_ _2"></span>ault value by T<span class="_ _0"></span>estLink during impor&#58903;ng.</div><div class="t m0 x4 h6 y18 ff3 fs3 fc0 sc0 ls0 ws0">b)<span class="_ _9"> </span>De&#58905;ning<span class="_ _4"></span> <span class="_ _4"></span>of<span class="_ _4"></span> <span class="_ _4"></span>test<span class="_ _3"></span> <span class="_ _4"></span>case&#8217;<span class="_ _2"></span>s<span class="_ _3"></span> <span class="_ _4"></span>&#8220;Internal<span class="_ _4"></span> <span class="_ _4"></span>ID&#8221;<span class="_ _0"></span>,<span class="_ _4"></span> <span class="_ _4"></span>&#8220;N<span class="_ _1"></span>ode<span class="_ _4"></span> <span class="_ _4"></span>Order<span class="_ _1"></span>&#8221;<span class="_ _0"></span>,<span class="_ _4"></span> <span class="_ _4"></span>&#8220;Ex<span class="_ _1"></span>ternal<span class="_ _4"></span> <span class="_ _3"></span>ID&#8221;<span class="_ _7"></span> <span class="_ _3"></span>and<span class="_ _7"></span> <span class="_ _3"></span>&#8220;<span class="_ _1"></span>V<span class="_ _2"></span>ersion&#8221;<span class="_ _0"></span>.<span class="_ _4"></span> <span class="_ _4"></span>But</div><div class="t m0 x5 h6 y19 ff3 fs3 fc0 sc0 ls0 ws0">these &#58905;elds will be assigned with a defa<span class="_ _2"></span>ult value by T<span class="_ _0"></span>estLink during impor&#58903;ng </div><div class="t m0 x4 h6 y1a ff3 fs3 fc0 sc0 ls0 ws0">c)<span class="_ _c"> </span>De&#58905;ning<span class="_ _1"></span> <span class="_ _3"></span>of<span class="_ _3"></span> <span class="_ _3"></span>test<span class="_ _1"></span> <span class="_ _3"></span>cases&#8217;<span class="_ _5"></span>s<span class="_ _3"></span> <span class="_ _1"></span>&#8220;Execu&#58903;on<span class="_ _1"></span> <span class="_ _3"></span>T<span class="_ _2"></span>ype&#8221;<span class="_ _0"></span>,<span class="_ _3"></span> <span class="_ _1"></span>the<span class="_ _3"></span> <span class="_ _3"></span>conve<span class="_ _2"></span>rter<span class="_ _3"></span> <span class="_ _1"></span>will<span class="_ _3"></span> <span class="_ _3"></span>alwa<span class="_ _2"></span>ys<span class="_ _3"></span> <span class="_ _1"></span>assign<span class="_ _3"></span> <span class="_ _3"></span>this<span class="_ _3"></span> <span class="_ _3"></span>&#58905;eld<span class="_ _1"></span> <span class="_ _3"></span>as</div><div class="t m0 x5 h6 y1b ff3 fs3 fc0 sc0 ls0 ws0">&#8220;Manul&#8221;<span class="_ _0"></span>.</div><div class="t m0 x1 h6 y1c ff3 fs3 fc0 sc0 ls0 ws0">Steps<span class="_ _3"></span> <span class="_ _3"></span>below<span class="_ _3"></span> <span class="_ _3"></span>shown<span class="_ _3"></span> <span class="_ _3"></span>a<span class="_ _4"></span> <span class="_ _3"></span>regular<span class="_ _1"></span> <span class="_ _4"></span>process<span class="_ _1"></span> <span class="_ _4"></span>fo<span class="_ _2"></span>r<span class="_ _3"></span> <span class="_ _3"></span>doing<span class="_ _3"></span> <span class="_ _4"></span>this,<span class="_ _3"></span> <span class="_ _3"></span>as<span class="_ _3"></span> <span class="_ _4"></span>ex<span class="_ _2"></span>ample,<span class="_ _3"></span> <span class="_ _3"></span>conve<span class="_ _2"></span>r&#58903;ng<span class="_ _3"></span> <span class="_ _3"></span>with<span class="_ _4"></span> <span class="_ _3"></span>a<span class="_ _3"></span> <span class="_ _3"></span>2-level<span class="_ _3"></span> <span class="_ _3"></span>test</div><div class="t m0 x1 h6 y1d ff3 fs3 fc0 sc0 ls0 ws0">suite in an Ex<span class="_ _2"></span>cel sheet (whereas con<span class="_ _2"></span>ver&#58903;ng with tes<span class="_ _2"></span>t cases would be only simpler).</div><div class="t m0 x1 h6 y1e ff3 fs3 fc0 sc0 ls0 ws0">1.<span class="_ _6"> </span>Launch<span class="_"> </span> <span class="_"> </span>EX<span class="_ _2"></span>-Convert<span class="_ _2"></span>er<span class="_"> </span> <span class="_"> </span>and<span class="_"> </span> <span class="_ _d"> </span>select<span class="_"> </span> <span class="_"> </span>&#8220;Source<span class="_"> </span> <span class="_"> </span>Exc<span class="_ _2"></span>el<span class="_"> </span> <span class="_"> </span>File&#8221;<span class="_ _5"></span>,<span class="_"> </span> <span class="_"> </span>poin&#58903;ng<span class="_"> </span> <span class="_"> </span>to<span class="_"> </span> <span class="_ _e"> </span> <span class="_"> </span>your<span class="_"> </span> <span class="_"> </span>&#58905;le<span class="_"> </span> <span class="_"> </span>:<span class="_"> </span> <span class="_"> </span>&#8220;EX-</div><div class="t m0 x4 h6 y1f ff3 fs3 fc0 sc0 ls0 ws0">Conv<span class="_ _2"></span>erter_T<span class="_ _0"></span>est_Suite_T<span class="_ _0"></span>emplates-0_0_2.xlsx&#8221;<span class="_ _1"></span> (the standa<span class="_ _2"></span>rd templat<span class="_ _2"></span>e).</div><div class="t m0 x1 h6 y20 ff3 fs3 fc0 sc0 ls0 ws0">2.<span class="_ _6"> </span>Select<span class="_ _e"> </span> <span class="_ _e"> </span>&#8220;<span class="_ _2"></span>Des&#58903;na&#58903;on<span class="_ _e"> </span> <span class="_ _f"> </span>XML<span class="_ _f"> </span> <span class="_ _e"> </span>File&#8221;<span class="_ _e"> </span> <span class="_ _f"> </span>(or<span class="_ _e"> </span> <span class="_ _f"> </span>c<span class="_ _1"></span>rea<span class="_ _2"></span>te<span class="_ _f"> </span> <span class="_ _e"> </span>new),<span class="_ _e"> </span> <span class="_ _f"> </span>e.<span class="_ _1"></span>g.<span class="_ _f"> </span> <span class="_ _e"> </span>with<span class="_ _e"> </span> <span class="_ _f"> </span>the<span class="_ _e"> </span> <span class="_ _e"> </span>name<span class="_ _f"> </span> <span class="_ _e"> </span>of</div><div class="t m0 x4 h6 y21 ff3 fs3 fc0 sc0 ls0 ws0">&#8220;Sample_T<span class="_ _0"></span>est_Suite.xml&#8221;<span class="_ _0"></span>.</div><div class="t m0 x1 h6 y22 ff3 fs3 fc0 sc0 ls0 ws0">3.<span class="_ _6"> </span>Click on &#8220;<span class="_ _1"></span>T<span class="_ _5"></span>est Suite&#8221; in &#8220;<span class="_ _1"></span>T<span class="_ _5"></span>emplate T<span class="_ _5"></span>ype&#8221; and check with<span class="_ _1"></span> &#8220;Enable Level 2 Fo<span class="_ _2"></span>lder<span class="_ _1"></span>&#8221;<span class="_ _5"></span>.</div><div class="t m0 x1 h6 y23 ff3 fs3 fc0 sc0 ls0 ws0">4.<span class="_ _6"> </span>Enter &#8220;1&#8221; in<span class="_ _2"></span>to &#8220;<span class="_ _5"></span>Ac&#58903;ve Sheet&#8221;<span class="_ _5"></span>, since sheet in use is the &#58905;r<span class="_ _2"></span>st one of the Excel &#58905;le.</div><div class="t m0 x1 h6 y24 ff3 fs3 fc0 sc0 ls0 ws0">5.<span class="_ _6"> </span>Map<span class="_ _1"></span> <span class="_ _3"></span>other<span class="_ _1"></span> <span class="_ _3"></span>&#58905;elds<span class="_ _3"></span> <span class="_ _1"></span>corresponding<span class="_ _1"></span> <span class="_ _3"></span>to<span class="_ _1"></span> <span class="_ _3"></span>your<span class="_ _1"></span> <span class="_ _3"></span>source<span class="_ _1"></span> <span class="_ _1"></span>Excel<span class="_ _1"></span> <span class="_ _3"></span>sheet.<span class="_ _1"></span> <span class="_ _3"></span>E.<span class="_ _1"></span>g.<span class="_ _1"></span> <span class="_ _3"></span>ent<span class="_ _2"></span>er<span class="_ _3"></span> <span class="_ _1"></span>&#8220;16&#8221;<span class="_ _3"></span> <span class="_ _3"></span>to<span class="_ _1"></span> <span class="_ _3"></span>&#8220;Start<span class="_ _1"></span> <span class="_ _3"></span>R<span class="_ _2"></span>ow<span class="_ _1"></span>&#8221;<span class="_ _0"></span>,</div><div class="t m0 x4 h6 y25 ff3 fs3 fc0 sc0 ls0 ws0">enter <span class="_ _1"></span>&#8220;<span class="_ _2"></span>d&#8221; <span class="_ _1"></span>or<span class="_ _1"></span> <span class="_ _1"></span>&#8220;4&#8221;<span class="_ _1"></span> <span class="_ _1"></span>to<span class="_ _1"></span> &#8220;Name&#8221;<span class="_ _5"></span>.<span class="_ _1"></span> <span class="_ _3"></span> Screentshots <span class="_ _3"></span>below <span class="_ _1"></span>shown<span class="_ _1"></span> <span class="_ _1"></span>a<span class="_ _1"></span> <span class="_ _1"></span>fully<span class="_ _1"></span> <span class="_ _1"></span>mapped<span class="_ _1"></span> <span class="_ _1"></span>result <span class="_ _1"></span>of<span class="_ _1"></span> <span class="_ _1"></span>the<span class="_ _1"></span> <span class="_ _1"></span>source</div><div class="t m0 x4 h6 y26 ff3 fs3 fc0 sc0 ls0 ws0">sheet:</div><div class="t m0 x4 h4 y27 ff2 fs1 fc0 sc0 ls0 ws0">Source sheet:</div></div></div><div class="pi" data-data='{"ctm":[1.611850,0.000000,0.000000,1.611850,0.000000,0.000000]}'></div></div> </body> </html>
评论
    相关推荐