Support

Expand all | Collapse all

How to import and export the tag fields along with test cases

  • 1.  How to import and export the tag fields along with test cases

    Posted 04-04-2017 06:43
    Hi,
        I have test cases which I want to import through excel along with the "tag" field. And later on I want to export to excel with the "tag" fields. I am able to view the "tags " and filter the test cases but not able to import and export with the "tags" field. I do not see the "tags" option in the "All fields" when I click on the "cog" for the test case.  Please help on this one or if there is an existing solution it would be of great help. 

    Thanks,
    -R

    ------------------------------
    Rajanikant Kolaki
    Verifone
    KS
    ------------------------------


  • 2.  RE: How to import and export the tag fields along with test cases

    Posted 04-06-2017 04:11
    If any help on this would be great. We need on this a bit urgently. Please help.

    Thanks,

    ------------------------------
    Rajanikant Kolaki
    Verifone
    KS
    ------------------------------



  • 3.  RE: How to import and export the tag fields along with test cases

    Posted 04-06-2017 08:27
    Hi Rajanikant,
    Sorry for the delay. Unfortunately I do not have good news for you; there is not a way to import or export tags via Excel. This data is not an actual field—it's metadata—so the list view will not display it and it cannot be exported.

    The only way to get this info out via an export would be to consider a custom BIRT or Velocity report.


    ------------------------------
    Kristina King
    Jama Software
    ------------------------------



  • 4.  RE: How to import and export the tag fields along with test cases

    Posted 04-10-2017 23:23
    Thank you Kristina for reply. We will try the option you mentioned and check if it suits our needs.
    Thank you. Have a good day ahead.
    -Rajanikant

    ------------------------------
    Rajanikant Kolaki
    Verifone
    KS
    ------------------------------



  • 5.  RE: How to import and export the tag fields along with test cases

    Posted 04-13-2017 11:04
    For excel export try this as contect sensitve velocity report:

    <?xml version="1.0"?>
    <ss:Workbook xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet">
    <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
    <Title>Excel Export for Roundtrip</Title>
    <Subject>Excel Export for Roundtrip</Subject>
    <Author>Harald HOTZ-BEHOFSITS</Author>
    <LastAuthor>HOTZ-BEHOFSITS Harald</LastAuthor>
    <Company>Frequentis AG</Company>
    <Version>14.00</Version>
    </DocumentProperties>
    <ss:Worksheet ss:Name="Sheet1">
    <ss:Table>
    <ss:Row>
    <ss:Cell><ss:Data ss:Type="String">ID</ss:Data></ss:Cell>
    <ss:Cell><ss:Data ss:Type="String">Short Name</ss:Data></ss:Cell>
    <ss:Cell><ss:Data ss:Type="String">Status</ss:Data></ss:Cell>
    <ss:Cell><ss:Data ss:Type="String">Release</ss:Data></ss:Cell>
    <ss:Cell><ss:Data ss:Type="String">Description</ss:Data></ss:Cell>
    <ss:Cell><ss:Data ss:Type="String">Up</ss:Data></ss:Cell>
    <ss:Cell><ss:Data ss:Type="String">Down</ss:Data></ss:Cell>
    <ss:Cell><ss:Data ss:Type="String">Tags</ss:Data></ss:Cell>
    <ss:Cell><ss:Data ss:Type="String">Comments</ss:Data></ss:Cell>
    </ss:Row>
    ##
    #set($rlshpDao = $applicationContext.getBean("relationshipDao"))
    #set($tagDao = $applicationContext.getBean("tagDao"))
    #set($documentDao = $applicationContext.getBean("documentDao"))
    #set($commentDao = $applicationContext.getBean("commentDao"))
    #foreach($vDoc in $documentList)
    #if($vDoc.document.documentType.display != "Folder" &&
    $vDoc.document.documentType.display != "Set")
    <ss:Row>
    <ss:Cell><ss:Data ss:Type="String">$vDoc.document.documentKey</ss:Data></ss:Cell>
    <ss:Cell><ss:Data ss:Type="String">$vDoc.document.name</ss:Data></ss:Cell>
    <ss:Cell><ss:Data ss:Type="String">$vDoc.document.status.name</ss:Data></ss:Cell>
    <ss:Cell><ss:Data ss:Type="String">$vDoc.document.release.name</ss:Data></ss:Cell>
    <ss:Cell><ss:Data ss:Type="String">$vDoc.document.description</ss:Data></ss:Cell>
    #set($rlshp = $rlshpDao.getRelationshipsForDocument($vDoc.document.id,false))
    #set ($up="")
    #if($rlshp.size() != 0)
    #set ($started = 0)
    #foreach ($r in $rlshp)
    #if ($started==1)
    #set ($up=$up+",")
    #end
    #set ($up=$up+"$r.fromDocument.documentKey")
    #set ($started = 1)
    #end
    #end
    #if ($up)
    <ss:Cell><ss:Data ss:Type="String">$up</ss:Data></ss:Cell>
    #else
    <ss:Cell><ss:Data ss:Type="String"></ss:Data></ss:Cell>
    #end
    ##
    #set($rlshp = $rlshpDao.getRelationshipsForDocument($vDoc.document.id,true))
    #set ($down="")
    #if($rlshp.size() != 0)
    #set ($started = 0)
    #foreach ($r in $rlshp)
    #if ($started==1)
    #set ($down=$down+",")
    #end
    #set ($down=$down+"$r.toDocument.documentKey")
    #set ($started = 1)
    #end
    #end
    #if ($down)
    <ss:Cell><ss:Data ss:Type="String">$down</ss:Data></ss:Cell>
    #else
    <ss:Cell><ss:Data ss:Type="String"></ss:Data></ss:Cell>
    #end
    ## tag
    #set($tags = $tagDao.getAllTagsByDocumentId($vDoc.document.id))
    #set ($jtag="")
    #set ($started = 0)
    #foreach ( $tag in $tags )
    #if ($started==1)
    #set ($jtag=$jtag+",")
    #end
    #set ($jtag=$jtag+"$tag.tagName")
    #set ($started = 1)
    #end
    #if ($jtag)
    <ss:Cell><ss:Data ss:Type="String">$jtag</ss:Data></ss:Cell>
    #else
    <ss:Cell><ss:Data ss:Type="String"></ss:Data></ss:Cell>
    #end
    ## comment
    #set($comments = $commentDao.getComments($vDoc.document.id))
    #set ($jcom="")
    #set ($started = 0)
    #foreach ( $comment in $comments )
    #if ($started==1)
    #set ($jcom=$jcom+",")
    #end
    #set ($jcom=$jcom+"$comment.getCommentText()")
    #set ($started = 1)
    #end
    #if ($jcom)
    <ss:Cell><ss:Data ss:Type="String">$jcom</ss:Data></ss:Cell>
    #else
    <ss:Cell><ss:Data ss:Type="String"></ss:Data></ss:Cell>
    #end
    </ss:Row>
    #end
    #end
    </ss:Table>
    </ss:Worksheet>
    </ss:Workbook>

    ------------------------------
    Harald Hotz-Behofsits
    Frequentis AG
    ------------------------------